- Manage Snowflake accounts, warehouses, databases, schemas, and roles.
- Configure and maintain virtual warehouses (compute layers).
- Handle user access, RBAC, and security policies.
- Monitor system usage and ensure platform stability.
- Optimize Snowflake queries, warehouse sizing, and auto-scaling.
- Identify and resolve performance bottlenecks.
- Implement clustering, partitioning, and caching strategies.
- Monitor query performance using Query Profile and History.
- Track and optimize Snowflake credit usage.
- Implement cost-saving strategies: auto suspend/resume; right-sizing warehouses; query optimization.
- Generate usage reports and cost dashboards.
- Implement data security best practices.
- Role-based access control (RBAC).
- Row-level and column-level security.
- Manage data encryption and masking policies.
- Ensure compliance with organizational security standards.
- Data Integration Pipeline Support: support data loading using Snowpipe, bulk loads (COPY INTO), external stages (S3, Azure Blob).
- Collaborate with ETL teams (Informatica, Airflow, dbt, etc.).
- Troubleshoot data ingestion and transformation issues.
- Backup and Recovery: utilize Time Travel and Fail-safe features; perform data recovery and disaster recovery planning; ensure data availability and integrity.
- Monitoring and Troubleshooting: monitor system health, workloads, and query activity; troubleshoot query failures, data load issues, and performance degradation; handle incident management, RCA, and SLA adherence.
Technical and Qualified Requirements
- Primary skills: Snowflake admin