Lead- Snowflake Administrator

Sonata Software; Hyderabad; On-site; INR 1,500,000 - 2,000,000; Full time

Job summary

Sonata Software is seeking a Snowflake Administrator to manage, optimize, secure, and support our Snowflake Data Cloud platform in Hyderabad. The role spans administration, performance tuning, security, user management, data governance, and cloud integration with AWS.

You will handle RBAC, SSO, data sharing, and data migration initiatives while optimizing compute/storage and driving cost efficiency. Collaborative and DevOps-minded, you’ll engage across teams to deliver reliable data solutions.

Qualifications

• 6+ years of Snowflake Administration experience.
• Strong expertise in Snowflake architecture and administration.
• Proficiency in SQL and database concepts.
• Experience with Snowpipe, Streams, Tasks, Time Travel, and Zero-Copy Cloning.
• Experience with cloud platforms (AWS, Azure, or GCP).
• Knowledge of ETL/ELT tools such as Informatica, Matillion, Airflow, Talend, or Azure Data Factory.
• Experience with scripting languages (Python, Shell, PowerShell).

Responsibilities

• Install, configure, and maintain Snowflake environments.
• Manage Snowflake accounts, warehouses, databases, schemas, and data-sharing capabilities.
• Monitor system performance, resource utilization, and query execution.
• Configure virtual warehouses and optimize compute/storage usage.
• Implement RBAC, security policies, SSO/MFA.
• Manage users, roles, privileges, and security policies.
• Integrate Snowflake with cloud platforms (AWS/Azure/GCP).
• Data replication, cloning, failover, and disaster recovery tasks.
• Support data migration projects from legacy databases to Snowflake.
• Provide production support and incident resolution.
• Maintain operational documentation and runbooks.
• Develop automation scripts and CI/CD pipelines.
• Work with Infrastructure-as-Code tools such as Terraform.

Skills

Snowflake Administration

SQL

Cloud Platforms (AWS/Azure/GCP)

Scripting (Python/Shell)

ETL/ELT Tools

DevOps/CI-CD

Tools

Informatica

Matillion

Airflow

Talend

Azure Data Factory

Terraform

Job description

In today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers.

As a leading Modernization Engineering company, we aim to deliver modernization-driven hypergrowth for our clients based on the deep differentiation we have created in Modernization Engineering, powered by our Lightening suite and 16-step Platformation™ playbook. In addition, we bring agility and systems thinking to accelerate time to market for our clients.

Headquartered in Bengaluru, India, Sonata has a strong global presence, including key regions in the US, UK, Europe, APAC, and ANZ. We are a trusted partner of world-leading companies in BFSI (Banking, Financial Services, and Insurance), HLS (Healthcare and Lifesciences), TMT (Telecom, Media, and Technology), Retail & CPG, and Manufacturing space. Our bouquet of Modernization Engineering Services cuts across Cloud, Data, Dynamics, Contact Centers, and around newer technologies like Generative AI, MS Fabric, and other modernization platforms.

Position Title: Snowflake Administrator

Exp:6+ Years

Job Summary

We are seeking a skilled Snowflake Administrator to manage, optimize, secure, and support our Snowflake Data Cloud platform. The ideal candidate will be responsible for Snowflake administration, performance tuning, security implementation, user management, data governance, and integration with cloud environment AWS.

Key Responsibilities

# Snowflake Administration

• Install, configure, and maintain Snowflake environments.
• Manage Snowflake accounts, warehouses, databases, schemas, and data-sharing capabilities.
• Monitor system performance, resource utilization, and query execution.
• Configure virtual warehouses and optimize compute/storage usage.

# Security & Access Management

• Implement Role-Based Access Control (RBAC).
• Manage users, roles, privileges, and security policies.
• Configure Single Sign-On (SSO), MFA, and network security policies.
• Ensure compliance with data security and governance standards.

# Performance Optimization

• Analyze query performance and recommend improvements.
• Optimize warehouse sizing, clustering, partitioning, and caching strategies.
• Monitor workloads and tune Snowflake resources for cost efficiency.
• Implement resource monitors and usage controls.

# Data Management & Integration

• Support data ingestion using Snowpipe, SnowSQL, and ETL/ELT tools.
• Integrate Snowflake with cloud platforms (AWS/Azure/GCP).
• Manage data replication, cloning, failover, and disaster recovery.
• Support data migration projects from legacy databases to Snowflake.

# Monitoring & Troubleshooting

• Diagnose and resolve Snowflake performance issues.
• Monitor system health, storage usage, and warehouse activities.
• Provide production support and incident resolution.
• Maintain operational documentation and runbooks.

# Automation & DevOps

• Develop automation scripts using Python, Shell, or SQL.
• Support CI/CD implementation for Snowflake deployments.
• Work with Infrastructure-as-Code tools such as Terraform.
• Automate user provisioning, monitoring, and maintenance tasks.

Required Skills & Qualifications

# Technical Skills

• 6+ years of Snowflake Administration experience.
• Strong expertise in Snowflake architecture and administration.
• Proficiency in SQL and database concepts.
• Experience with Snowpipe, Streams, Tasks, Time Travel, and Zero-Copy Cloning.
• Experience with cloud platforms (AWS, Azure, or GCP).
• Knowledge of performance tuning and query optimization.
• Familiarity with ETL/ELT tools such as Informatica, Matillion, Airflow, Talend, or Azure Data Factory.
• Experience with scripting languages (Python, Shell, PowerShell).

# Database Knowledge

• Experience with SQL Server, Oracle, PostgreSQL, MySQL, or Teradata.
• Understanding of data warehousing concepts and dimensional modeling.
• Knowledge of backup, recovery, and disaster recovery strategies.

# Soft Skills

• Strong analytical and problem-solving abilities.
• Excellent communication and stakeholder management skills.
• Ability to work in Agile and DevOps environments.
• Strong documentation and knowledge-sharing practices.

Preferred Qualifications

• SnowPro Core Certification or SnowPro Advanced Certification.
• Experience with data governance and compliance frameworks.
• Experience implementing DataOps and CI/CD pipelines.
• Knowledge of business intelligence tools such as Power BI, Tableau, or Looker.

Nice-to-Have

• Terraform and Infrastructure-as-Code.
• Kubernetes and container platforms.
• Data Lake technologies.
• Cloud security and governance expertise.

Why join Sonata Software?

At Sonata, you´ll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of what´s possible. To build never seen before solutions to some of the world’s toughest problems. You´ll be challenged, but you will not be alone. You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next.

Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law.