$99,999 yearly
ESR Healthcare
Newport Beach, CA, USA
Senior Database Admin Newport Beach, CA | Austin, Tx On-site
Contract-to-Hire
Client Note: This is primarily a database administration role focused on performance tuning and optimization in snowflake
Key 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 (single/multi-cluster, scaling policy), Resource Monitors, Query Acceleration Service, caching, and workload isolation. - Tune queries and data design: micro-partition optimization, clustering keys, Search Optimization Service, materialized views, Dynamic Tables. - Apply modern 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...
