Snowflake Admin

Responsibilities

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)

Technical requirements

Primary skills:Domain->Snowflake admin

Additional responsibilities

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)

Education

MCA,MSc,MTech,Bachelor of Engineering,BCA,BSc,BTech