Senior SQL Server DBA

Zensar; Pune District; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

Zensar is seeking a hands-on SQL Server DBA to manage large estates, ensure reliability, implement HA/DR, and design data movement and replication solutions across customer landscapes.

You will optimize performance, automate operations with scripting (PowerShell, Python), monitor incidents, and mentor junior DBAs while supporting cloud modernization and security governance.

6+ years of enterprise DBA experience, IT/CS degree, and strong communication are required.

Qualifications

• 6+ years of progressive experience in database administration.
• Strong expertise in SQL Server and related relational DBMS.
• Experience with high availability, disaster recovery, and replication technologies.
• Automation and scripting with PowerShell, Bash, or Python.
• Exposure to cloud platforms and modern infrastructure environments.
• Solid understanding of security, compliance, and data governance practices.
• Excellent problem-solving and cross-functional communication.

Responsibilities

• Design, implement, and maintain HA/DR solutions and replication frameworks.
• Develop and manage data movement architectures across large estates.
• Monitor, tune, and address performance and reliability issues.
• Investigate incidents and conduct root-cause analysis.
• Mentor junior DBAs and provide technical guidance.
• Participate in after-hours support and critical incident response.

Skills

SQL Server expertise

Replication

Performance tuning

Automation scripting

Cloud exposure

Security governance

Problem solving

Cross-functional communication

Education

Bachelors in IT/CS

Tools

ClickHouse

FoundationDB

LGTM stack (Loki, Grafana, Tempo, Mimir)

Rybbit

Valkey

Job description

This is a hands-on specialist role where you’ll work with complex SQL Server estates, design and maintain replication and data movement solutions, and play a key role in ensuring database reliability, performance, and scalability across customer's technology landscape.

Design, implement, and maintain high availability and disaster recovery solutions (e.g. clustering, availability groups, replication frameworks)

Develop and manage complex data movement and replication architectures across large database estates

Monitor database environments and proactively address performance, stability, and reliability issues

Perform advanced performance tuning using execution plans, wait statistics, and profiling tools

Investigate incidents, conduct root cause analysis, and implement effective remediation strategies

Drive database automation initiatives using scripting and self-service tooling to improve operational efficiency

Support infrastructure modernisation projects, including cloud adoption and optimisation initiatives

Ensure database security, compliance, and governance through controls such as encryption, auditing, and access management

Create and maintain technical documentation, runbooks, and operational standards

Provide technical mentorship and guidance to junior database administrators

Participate in critical incident response and provide after-hours support when required

6+ years of progressive experience in database administration within enterprise environments

A relevant degree in Information Technology, Computer Science, or a related discipline

Strong expertise in SQL Server or similar relational database management systems

Proven experience with high availability, disaster recovery, and replication technologies

Advanced skills in database performance tuning and query optimisation

Experience with automation and scripting (e.g. PowerShell, Bash, or Python)

Experience with technologies such as ClickHouse, FoundationDB, LGTM stack (Loki, Grafana, Tempo, Mimir), Rybbit, or Valkey

Exposure to cloud platforms and modern infrastructure environments

Solid understanding of security, compliance, and data governance practices

Strong problem-solving skills and the ability to manage critical incidents independently

Excellent communication skills with the ability to work across technical and business stakeholders

A collaborative team player who values knowledge sharing and continuous improvement

At Zensar, we’re
“experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose:
Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is
ONE with Client - a set of four core values that reflect who we are and how we work:
One Zensar, Nurturing, Empowering, and Client Focus.
Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.