Snowflake SME

We are looking for a Snowflake Operations SME with strong hands-on experience in Snowflake administration, production operations, deployment support, performance optimization, and cost management.The ideal candidate should be a Snowflake SME rather than a pure Snowflake Administrator, with end-to-end in Snowflake operations, including platform management, code reviews, release/deployment activities , and production support. The candidate should also possess strong data analysis capabilities.

Key Responsibilities

Own day-to-day Snowflake production operations and provide SME-level support.Monitor and manage Snowflake warehouses, including sizing, scaling, auto-suspend/resume, workload management, and concurrency.Troubleshoot and resolve production deployment and operational issues with minimal downtime.Support production releases/deployments, including validation, troubleshooting, rollback coordination, and post-deployment checks.Analyze and optimize Snowflake compute and storage costs.Identify cost optimization opportunities across warehouses, workloads, queries, and environments.Monitor warehouse utilization and performance and recommend appropriate warehouse sizing and configuration.Troubleshoot query performance, resource contention, failed queries, timeouts, and workload-related issues.Manage and troubleshoot Snowflake roles, users, privileges, databases, schemas, warehouses, integrations, and security configurations.Work closely with Data Engineering, DevOps, Application, and Security teams to resolve cross-functional production issues.Establish and maintain production monitoring, operational checks, and incident response procedures.Perform root-cause analysis (RCA) for recurring production issues and drive corrective actions.Handle production incidents, prioritize issues based on business impact, and provide timely status updates to stakeholders.Support environment management across Development, QA/UAT, and Production.Maintain operational documentation, deployment procedures, troubleshooting guides, and runbooks.Participate in on-call / production support activities when required.Must-Have Skills:Strong hands-on experience with Snowflake administration and production operations.Excellent understanding of Snowflake Virtual Warehouses and workload management.Strong experience in Snowflake cost monitoring and optimization.Proven experience handling production deployments and critical production issues.Strong troubleshooting and problem-solving skills.Good understanding of Snowflake performance optimization and Query Profile.Experience with RBAC, roles, privileges, users, databases, and schemas.Good understanding of Snowflake resource monitors, auto-suspend, auto-resume, scalingpolicies, and warehouse sizing.Experience with CI/CD or deployment processes for Snowflake objects.Strong SQL skills.Experience working with production support / incident management processes.Critical Requirement – CommunicationThe candidate should be able to:Communicate confidently with customers and senior stakeholders.Clearly explain production issues, impact, root cause, and resolution.Lead technical discussions and incident calls.Provide concise and structured status updates during production incidents.Translate complex Snowflake/technical problems into language understandable by businessstakeholders.Coordinate effectively across multiple engineering and application teams.Demonstrate strong ownership rather than simply escalating issues.