Snowflake DBA

Gemini Solutions Pvt Ltd; Newport Beach (CA); On-site; USD 120,000 - 150,000; Full time

Job summary

A leading cloud solutions provider is seeking a Senior Snowflake Administrator in Newport Beach, CA. The ideal candidate will manage Snowflake environments, optimize performance, and ensure security compliance. With 7+ years of experience required, this role focuses on advanced SQL, AWS services, and infrastructure automation using Terraform. Join our team to enhance our data warehouse capabilities and support mission-critical applications.

Qualifications

• 7+ years of experience in Data Warehousing or Cloud Platform Administration.
• Strong hands-on experience with Snowflake including architecture and performance tuning.
• Proficiency in AWS services including S3 and IAM.

Responsibilities

• Manage Snowflake warehouses and optimize compute usage.
• Develop advanced SQL scripts and implement Snowpipe for data ingestion.
• Ensure reliability and uptime for production OLAP environments.

Skills

Snowflake optimization

Workload management

AWS integration

Advanced SQL

Terraform

RBAC

Education

Bachelor's degree in Computer Engineering or related field

Tools

Git

Terraform

Job description

Position: Senior Snowflake Administrator

Job Location: Newport Beach, CA

Job Type: Full Time

Immediate Interview

Position Summary

We are seeking an experienced Senior Snowflake Administrator with strong expertise in managing large-scale data warehouse environments. The ideal candidate will have hands‑on experience in Snowflake optimization, workload management, security, and cross‑cloud integrations, specifically within AWS ecosystems. This role is critical for ensuring high performance, reliability, and scalability of our production OLAP workloads.

Position Responsibilities & Required Skillset

Snowflake Administration & Performance Optimization

• Manage Snowflake warehouses including sizing, scaling, clustering, and resource monitor configurations.
• Optimize compute usage to reduce queuing, resource spills, and concurrency issues.
• Implement and maintain replication across regions/accounts and manage failover groups for DR and business continuity.
• Oversee query performance tuning, caching strategies, pruning, and partitioning for complex analytical workloads.
• Monitor query history and execution plans to proactively address bottlenecks.
• Manage Snowflake objects including databases, schemas, roles, warehouses, tasks, streams, and integrations.

Advanced Data Features & SQL

• Develop advanced SQL scripts including views (regular/materialized), dynamic SQL, and automation tasks.
• Implement Snowpipe for continuous data ingestion and Streams/Tasks for CDC workflows.
• Handle schema design, data pipelines, versioning, and LOB management.
• Integrate Snowflake with AWS services such as S3, IAM, Lambda, Route53, and VPC Endpoints.
• Set up secure networking layers (subnets, private endpoints, access policies).
• Use Terraform to automate and provision Snowflake & supporting cloud infrastructure.
• Maintain version control using Git, and leverage Visual Studio/VS Code for development workflows.

Security, Governance & Compliance

• Implement RBAC, masking policies, data sharing privileges, and secure access controls.
• Manage user roles, permissions, auditing, and compliance with enterprise security standards.
• Work closely with InfoSec teams to ensure Snowflake security posture matches organizational requirements.

Production Management & Operational Excellence

• Ensure reliability and uptime for production and mission‑critical OLAP environments.
• Collaborate with data engineering teams to integrate pipelines into Snowflake.
• Troubleshoot incidents, perform root‑cause analysis, and apply preventive measures.
• Participate in on‑call rotations for high‑priority systems.

Required Skillsets

• 7+ years of experience in Data Warehousing / Cloud Platform Administration.
• Strong hands‑on experience with Snowflake including architecture, performance tuning, replication, and DR.
• Expertise in advanced SQL, Snowpipe, Streams, Tasks, and data ingestion workflows.
• Solid understanding of AWS platform: S3, IAM, Lambda, Route53, VPC, VPCE, subnets.
• Proficiency with Git, Terraform, and infrastructure‑as‑code practices.
• Experience supporting large‑scale OLAP workloads with high concurrency.
• Strong understanding of RBAC, masking policies, secure data sharing, and compliance.

Education

Bachelor’s degree in Computer Engineering, Computer Science, engineering or a similar technical field.