Job Description & How to Apply Below
We are looking for a technically strong Snowflake Database Administrator to own end-to-end administration, performance engineering, security governance, and cost optimization of our Snowflake cloud data platform. This role requires deep hands-on expertise across account/object administration, RBAC and security architecture, warehouse and query performance tuning, Python-based automation, and Snowflake's native AI stack (Cortex AI, Streamlit-in-Snowflake). The candidate will act as the platform SME, partnering with data engineering, BI, security, and application teams to keep the platform performant, secure, cost-efficient, and audit ready.
Key Responsibilities
Platform Administration & Operations
Administer Snowflake accounts, databases, schemas, warehouses, resource monitors, and integrations across DEV/QA/UAT/PROD environments.
Manage account-level and object-level parameters, network policies, and multi-region / multi-account topology.
Configure and maintain storage integrations, external stages, external tables, and Snowpipe / Snowpipe Streaming for continuous data ingestion.
Manage Time Travel, Fail-safe, zero-copy cloning, and data retention policies; validate and troubleshoot storage vs. Fail-safe billing anomalies.
Security, RBAC & Governance
Design and maintain a hierarchical RBAC model (functional roles → technical roles → system roles) aligned to least-privilege principles.
Own object ownership, grants management, future grants, and role inheritance across databases, schemas, and warehouses.
Configure authentication mechanisms — SSO/SAML, RSA key-pair, MFA — and manage service account lifecycle and key rotation.
Implement data governance controls: row access policies, column-level masking policies, tags/tag-based masking, and object tagging for classification.
Maintain audit readiness via , , , and _ROLES monitoring, and support SOX/compliance audits.
Performance Engineering & Cost Optimization
Tune virtual warehouse sizing, multi-cluster scaling policies, and auto-suspend/resume settings to balance performance vs. spend.
Analyze and optimize query performance using , clustering keys, search optimization service, and materialized views.
Monitor credit consumption via / views; build automated cost/usage dashboards and threshold-based alerting.
Diagnose storage anomalies (active vs. billed storage gaps, stuck Fail-safe, table clone bloat) and drive resolution with Snowflake support.
Own hybrid table, Snowpark-optimized warehouse, and serverless feature (Snowpipe, tasks, dynamic tables) cost/performance trade-off decisions.
Automation, AI & Application Enablement
Build and maintain Python-based automation for RBAC provisioning, environment setup, health checks, and operational runbooks (mandatory).
Develop and maintain stored procedures / tasks for scheduled monitoring, alerting (e.g., cost or usage threshold alerts), and self-healing operations.
Implement and support Snowflake Cortex AI capabilities — Cortex Analyst, Cortex Search, Cortex Functions (COMPLETE, SUMMARIZE, SENTIMENT, TRANSLATE) — for GenAI-driven use cases (mandatory).
Design, deploy, and maintain Streamlit-in-Snowflake applications for internal tooling, dashboards, and self-service data/AI access (mandatory).
Manage Cortex AI cost governance: token/spend monitoring by user/service account, tiered alerting, and chargeback reporting.
Collaboration, CI/CD & Documentation
Support CI/CD pipelines for Snowflake object deployment (schema change scripts, version control, release gating).
Partner with data engineering teams to troubleshoot ETL/ELT pipeline failures, connectivity issues, and data load errors.
Maintain naming conventions, architecture diagrams, runbooks, and platform documentation for onboarding and knowledge…
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×