Senior Snowflake DBA - Cloud Performance & Tuning (On-site)

Esrhealthcare And Exec Staff Recruiters; Newport Beach (CA); On-site; USD 120,000 - 160,000; Full time

Job summary

Esrhealthcare And Exec Staff Recruiters seeks a Senior Database Admin to lead Snowflake operations in an on-site, cloud-centric role. You will optimize performance, manage warehouses, and implement robust security and DR strategies for a data-intensive environment.

Candidates should bring 5+ years in database engineering with Snowflake at scale, strong SQL and Python skills, and deep AWS integration experience. This is a contract-to-hire, on-site position in Newport Beach/Austin.

Qualifications

• 5+ years in database engineering/development; 3+ years hands-on, production Snowflake at scale.
• 2+ years as a cloud database engineer; 2+ years in public cloud (AWS preferred).
• Expert Snowflake performance engineering: profiling, pruning effectiveness, clustering, Search Optimization, Dynamic Tables, Streams & Tasks.
• Proven AWS integration: S3, IAM/KMS, VPC/PrivateLink, CloudWatch, Lambda/events.
• Strong SQL and Python; Snowpark experience preferred.
• Security/compliance: RBAC, masking/row policies, object tagging, SSO/SAML/OAuth; knowledge of controls.

Responsibilities

• Architect and operate a cloud-native Snowflake platform on AWS (account/region strategy, security, networking, environment topology).
• Own workload performance and spend: warehouse sizing, multi-cluster, scaling policy, Resource Monitors, Query Acceleration Service, caching, workload isolation.
• Tune queries and data design: micro-partition optimization, clustering keys, Search Optimization Service, materialized views, Dynamic Tables.
• Apply storage patterns: permanent/transient/temporary tables, External/Iceberg Tables; leverage zero-copy cloning for dev/test.
• Implement security and governance: RBAC, tag-based policies, column masking/row access, SSO/SAML/OAuth, network policies/PrivateLink, KMS integration.
• Monitor and alert using ACCOUNT_USAGE, INFORMATION_SCHEMA, Event Tables; integrate with CloudWatch/Slack/PagerDuty; define SLAs/SLOs.
• Deliver DR/backup strategies: Time Travel, Fail-safe, cross-region replication, and failover/failback.

Skills

Snowflake performance tuning

SQL

Python

AWS

CI/CD

Terraform

SnowSQL

Data warehousing

Tools

Snowflake

S3

VPC/PrivateLink

CloudWatch

SnowSQL

Terraform

Job description

Esrhealthcare And Exec Staff Recruiters seeks a Senior Database Admin to lead Snowflake operations in an on-site, cloud-centric role. You will optimize performance, manage warehouses, and implement robust security and DR strategies for a data-intensive environment.

Candidates should bring 5+ years in database engineering with Snowflake at scale, strong SQL and Python skills, and deep AWS integration experience. This is a contract-to-hire, on-site position in Newport Beach/Austin.