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)

• Primary skills:Domain->Snowflake admin

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

Preferred skills: Domain->Healthcare->Administrative tools,Technology->Data on Cloud-Data Store->Snowflake