Senior Cloud Support Engineer - Sql

Senior Cloud Support Engineer – Sql

Bachelor’s or Master’s degree in Computer Science or equivalent discipline
5+ years experience in a Technical Support environment or a similar technical function in a customer-facing role
Excellent writing and communication skills in English with attention to detail
Ability to work in a highly collaborative environment across global teams
Strong knowledge of at least one major RDBMS
In-depth understanding of SQL data types, aggregations, and advanced functions including analytical/window functions
Proven experience with query lifecycle, profiles, and execution/explain plans
Demonstrated ability to analyze and tune query performance and provide detailed recommendations for performance improvement
Advanced skills in interpreting SQL queries and execution workflow logic
Proven ability with rewriting joins for optimization while maintaining logical consistency
Proficiency with JSON, XML, and other semi-structured data formats
Experience with querying and transforming semi-structured data
In-depth Knowledge of data warehousing resource allocation and optimization
Expertise in identifying scenarios for scaling up and scaling out of cloud resources
Expertise in managing schedules of jobs and tasks for maximum throughput
A deep understanding of resource locks and experience with managing concurrent transactions

Drive technical solutions to complex problems providing in-depth analysis and guidance to Snowflake customers and partners using the following methods of communication: email, web, and phone
Adhere to response and resolution SLAs and escalation processes in order to ensure fast resolution of customer issues that exceed expectations
Demonstrate good problem-solving skills and be process-oriented
Utilize the Snowflake environment, connectors, 3rd party partner software, and tools to investigate issues
Document known solutions to the internal and external knowledge base
Report well-documented bugs and feature requests arising from customer-submitted requests
Partner with engineering teams in prioritizing and resolving customer requests
Participate in a variety of Support initiatives
Provide support coverage during holidays and weekends based on business needs

Experience working with a distributed database i.e. big data and/or MPP (massively parallel processing) databases
Database migration and ETL experience
Ability to monitor and optimize cloud spending using cost management tools and strategies
Scripting/coding experience in any programming language
Understanding of cloud computing security concepts