Senior SQL Server DBA

Zensar Technologies; Maharashtra; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Zensar Technologies is seeking a hands-on Senior Database Administrator to manage complex SQL Server estates, design and maintain replication and data movement solutions, and ensure reliability, performance, and scalability across customer environments.

You will lead initiatives in high availability, disaster recovery, and automation, while guiding junior DBAs and supporting cloud modernization efforts. Strong communication and problem-solving skills are essential.

Qualifications

• 6+ years of progressive experience in database administration within enterprise environments.
• Bachelor's degree in IT/CS or related discipline.
• Strong expertise in SQL Server or similar relational DBMS.
• Proven experience with high availability, disaster recovery, and replication technologies.
• Advanced skills in database performance tuning and query optimisation.
• Experience with automation and scripting (PowerShell, Bash, or Python).
• Exposure to cloud platforms and modern infrastructure environments.
• Solid understanding of security, compliance, and data governance practices.

Responsibilities

• 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 remediation strategies.
• Drive database automation initiatives using scripting and self-service tooling.
• Support infrastructure modernization projects, including cloud adoption and optimization 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.

Skills

Analytical thinking

Problem-solving

Communication

Team collaboration

Education

Bachelor's degree in IT/CS

Tools

SQL Server

Replication technologies

PowerShell

Python

Bash

ClickHouse

FoundationDB

LGTM stack (Loki, Grafana, Tempo, Mimir)

Rybbit

Valkey

Job description

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.

Responsibilities

• 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

Qualifications

• 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

About Us

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.