Production Support Engineer- Snowflake

Production Support Engineer / Snowflake DBA responsible for the administration, monitoring, performance optimization, and operational support of Snowflake Data Warehouse environments. The candidate will provide 24x7 production support, ensure platform availability, troubleshoot incidents, optimize workloads, and work closely with data engineering, cloud, and application teams.

The ideal candidate should possess strong expertise inSnowflake,AWS/Azure Cloud,SQL,Data Warehousing, andITIL-based Production Support processes.

Key Responsibilities

Snowflake Administration & Support

• Manage and administer Snowflake accounts, databases, schemas, warehouses, roles, and users.
• Monitor Snowflake platform health, performance, storage consumption, and workload execution.
• Perform capacity planning and warehouse sizing recommendations.
• Implement and maintain RBAC (Role-Based Access Control) and data security policies.
• Support Snowflake account setup, environment provisioning, and onboarding activities.
• Manage resource monitors and budget controls to optimize Snowflake costs.
• Configure Snowflake shares, data replication, and failover groups.

Production Support Activities

• Provide L2/L3 production support for Snowflake environments.
• Handle incident, problem, and change management activities as per ITIL processes.
• Troubleshoot production issues related to:
  • Query failures
  • Data load failures
  • User access issues
  • Performance bottlenecks
  • Warehouse outages
  • Integration failures
• Perform root cause analysis (RCA) and implement preventive measures.
• Participate in on-call rotation and support critical business applications.
• Prepare and track support metrics, SLAs, and operational dashboards.

Performance Tuning & Optimization

• Analyze slow-running queries using Query Profile and Query History.
• Optimize warehouse utilization and query performance.
• Identify inefficient SQL queries and provide tuning recommendations.
• Monitor clustering effectiveness and data pruning efficiency.
• Optimize storage and compute utilization.
• Implement performance improvement initiatives to reduce warehouse costs.

Security & Compliance

• Implement access governance and security best practices.
• Manage users, roles, grants, and network policies.
• Support audit requirements and compliance reviews.

Data Loading & Integration Support

• Support data ingestion pipelines using:
  • Snowpipe
  • COPY Commands

Disaster Recovery & Business Continuity

• Support Snowflake Time Travel and Fail-safe capabilities.
• Manage cross-region replication and failover strategies.
• Participate in DR drills and recovery testing exercises.
• Ensure platform resiliency and availability objectives are achieved.

Required Technical Skills

Snowflake

• Snowflake Architecture
• Virtual Warehouses
• Databases & Schemas
• Roles & Security

Database Skills

• SQL
• Data Modeling
• Data Warehousing Concepts
• Performance Tuning

Cloud Platforms

• AWS (Preferred)