Monitor platform health, investigate incidents, perform root cause analysis, and implement preventative measures to improve reliability.
Manage database objects and platform hygiene, including schemas, tables, views, retention settings, and obsolete resource cleanup.
Support data integration and connectivity with AWS services, including S3, IAM, and relevant data ingestion and processing tools.
Automate administrative tasks and operational processes using SQL, Python, scripting, and APIs.
Develop operational dashboards, documentation, and procedures for platform monitoring, incident response, access reviews, and cost reporting.
Collaborate with engineering teams on platform architecture, upgrades, new capabilities, and enterprise data initiatives.
Experience Requirements
Extensive hands-on experience administering and supporting Snowflake in a production enterprise environment.
Strong knowledge of Snowflake architecture, virtual warehouses, micro-partitions, caching, query execution, and resource consumption.
Advanced SQL skills with experience diagnosing and resolving query performance issues.
Practical experience implementing Snowflake RBAC, role hierarchies, grants, access policies, and secure access patterns.
Experience with warehouse sizing, workload management, cost monitoring, and compute optimization.
Experience troubleshooting production incidents and improving platform reliability.
Understanding of database administration, data governance, and enterprise security practices.
Ability to work independently, communicate effectively, and produce clear technical documentation.
Preferred: Integration with AWS S3, IAM, Glue, and enterprise data pipelines.
Preferred: Python or shell scripting for automation and administrative tasks.
Preferred: Terraform or other Infrastructure as Code tools.
Preferred: Familiarity with resource monitors, ACCOUNT_USAGE, ORGANIZATION_USAGE, and query history analysis.
Preferred: Experience with masking policies, row access policies, network policies, and authentication integrations.
Preferred: Workload management, multi-cluster warehouses, replication, failover, and business continuity.
Preferred: SnowPro Core or Advanced certification.
Preferred: Experience in financial services or another regulated enterprise environment.
