Snowflake Administrator

Role & responsibilities

Sonata Software Overview

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, youll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of whats possible. To build never seen before solutions to some of the world’s toughest problems. Youll be challenged, but you will not be alone. Youll 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.