Snowflake Performance Engineer

Immediate need for a talented Snowflake Performance Engineer . This is a 02 Months Contract opportunity with long-term potential and is located in Sunnyvale, CA (Hybrid) . Please review the job description below and contact me ASAP if you are interested.

Job ID : 25-91327

Pay Range : $78 - $80 / hour.  Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Responsibilities :

• Familiar with zero copy cloning and using time travel features to clone table
• Familiar in understanding Snowflake query profile and what each step does and identifying performance bottlenecks from query profile
• Understanding of when a table needs to be clustered
• Choosing the right cluster key as a part of table design to help query optimization
• Working with materialized views and benefits vs cost scenario
• How Client micro partitions are maintained and what are the performance implications wrt micro partitions / pruning etc
• Horizontal vs vertical scaling. When to do what. Concept of multi cluster warehouse and autoscaling
• Advanced SQL knowledge including window functions, recursive queries and ability to understand and rewrite complex SQLs as a part of performance optimization

Key Requirements and Technology Experience :

Our client is a leading IT Industry and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy  here .