Snowflake Admin

Infosys

Primary skills:Domain->Snowflake admin

We are seeking an experienced Snowflake Administrator to manage, optimize, and secure enterprise data warehouse environments on Snowflake. The ideal candidate will be responsible for administration, performance tuning, cost optimization, and data security, ensuring reliable and efficient data operations. Key Responsibilities Snowflake Administration Administer Snowflake accounts, databases, schemas, and warehouses Configure and manage virtual warehouses (sizing, scaling, auto-suspend/resume) Handle user management, roles, and privileges (RBAC) Performance Optimization Monitor and optimize query performance and workload execution Analyze query plans and troubleshoot slow-running queries Implement best practices for partitioning, clustering, and indexing Cost Management Track and optimize Snowflake usage and costs Implement strategies like: Auto-scaling warehouses Resource monitors Query optimization Create usage reports and cost dashboards Security & Governance Implement role-based access control (RBAC) Configure: Data masking (dynamic masking) Row-level / column-level security Manage network policies and encryption settings Ensure compliance with organizational data policies Data Loading & Integration Manage data ingestion using: Snowpipe COPY commands Integrate with: Cloud platforms (AWS, Azure, GCP) ETL tools (Informatica, dbt, Airflow, Talend) Monitor ETL/ELT workflows Backup & Recovery Manage Time Travel and Fail-safe features Perform data recovery and retention management Define disaster recovery strategies Monitoring & Troubleshooting Monitor Snowflake performance and system health Troubleshoot: Query failures Data load issues Access problems Maintain audit logs and system usage reports Automation & DevOps Automate administrative tasks using SQL scripting / Python Integrate Snowflake with CI/CD pipelines (Git, Azure DevOps, Jenkins) Work with infrastructure automation tools (optional: Terraform)

Strong expertise in Snowflake architecture and features Advanced SQL skills (mandatory) Snowflake Expertise Virtual Warehouses Snowpipe Time Travel & Fail-safe Data Sharing Role-Based Access Control (RBAC) Technical Skills Experience with ETL/ELT tools Knowledge of data modeling (star/snowflake schemas) Familiarity with cloud platforms (AWS/Azure/GCP)