- 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
Domain->Healthcare->Administrative tools,Technology->Data on Cloud-DataStore->Snowflake
