Snowflake Admin

Job Summary Responsibilities

• 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 Professional Requirements

• Primary skills: Snowflake admin

Preferred Skills

• Technology->Database Administration->Sybase Admin
• Domain->Healthcare->Administrative tools
• Technology->Data on Cloud-DataStore->Snowflake