Snowflake Administrator

Experience: 512 Years
Location: PAN India
Role: Snowflake Administrator
Employment Type: Full-Time

Job Summary

We are looking for an experienced Snowflake Administrator with 5–12 years of experience in administering, configuring, monitoring, securing, and optimizing enterprise Snowflake environments. The candidate will be responsible for platform administration, user and access management, performance optimization, security, data loading, monitoring, and production support.

Key Responsibilities

• Administer and manage Snowflake environments across Development, QA, UAT, and Production.
• Create and manage databases, schemas, warehouses, roles, users, and access privileges.
• Implement Role-Based Access Control (RBAC) and Snowflake security policies.
• Manage user authentication, authorization, and access controls.
• Monitor virtual warehouses, queries, storage, and overall platform performance.
• Perform query and warehouse performance tuning and optimize resource utilization.
• Manage warehouse sizing, auto-suspend, auto-resume, and workload optimization.
• Configure and monitor data loading and unloading processes.
• Support Snowflake integrations with cloud storage such as AWS S3, Azure Blob, or GCP Cloud Storage.
• Monitor failed queries, data loads, tasks, and other Snowflake activities.
• Troubleshoot performance, connectivity, security, and data-access issues.
• Implement Snowflake backup, recovery, and disaster-recovery strategies.
• Work with Time Travel, Fail-safe, cloning, and replication features.
• Manage Snowflake upgrades, releases, configurations, and environment changes.
• Support data migration and deployment activities across environments.
• Automate administrative activities using SQL, SnowSQL, Python, or scripting.
• Collaborate with Data Engineers, Developers, Architects, Security, and Infrastructure teams.
• Maintain documentation for Snowflake architecture, configurations, security, and operational procedures.

Required Skills

• 5–12 years of experience in database/cloud data platform administration.
• Strong hands-on experience with Snowflake Administration.
• Strong knowledge of Snowflake architecture and cloud data warehousing.
• Experience with RBAC, roles, users, privileges, and security.
• Strong knowledge of Snowflake Virtual Warehouses and resource management.
• Experience with performance monitoring and query optimization.
• Good knowledge of SQL.
• Experience with data loading/unloading and external stages.
• Knowledge of cloud storage platforms such as AWS S3, Azure Blob, or GCP Cloud Storage.
• Experience with Snowflake monitoring and troubleshooting.
• Knowledge of Time Travel, Fail-safe, cloning, replication, and recovery.
• Experience working in production environments.
• Strong troubleshooting and problem-solving skills.