Zensar is a leading digital solutions and technology services company that specialises in partnering with global organisations across industries in their Digital Transformation journey. Zensars Return on Digital strategy has enabled customers to look beyond current investments towards realising visible business benefits in their digital transformation journey.

If youre looking for a workplace where associates realise and contribute to their full potential, are recognised for the impact they make, and enjoy the company of the people they work with, then youve come to the right place!

As a Lead Database administrator, you are expected to manage and support enterprise-scale database platforms supporting critical business applications. This role requires strong hands-on expertise across traditional and modern database technologies, along with the ability to drive automation, resiliency, and operational excellence.

The ideal candidate will have extensive experience working in high-availability production environments, supporting multiple database engines across on-premises and cloud platforms, and collaborating closely with DevOps, application, and cloud engineering teams.

Duties and Responsibilities

• Own the administration and day-to-day operations of enterprise database platforms including PostgreSQL, Microsoft SQL Server, SingleStore, Netezza, and distributed databases such as YugabyteDB.
• Design, implement, and maintain High Availability (HA) and Disaster Recovery (DR) solutions such as SQL Server Always On, log shipping, failover clustering, PostgreSQL replication, and distributed database clusters.
• Plan and execute robust backup and recovery strategies, including point-in-time recovery, cross-region DR, and business continuity solutions.
• Perform database performance tuning by analysing execution plans, identifying bottlenecks, optimizing queries, indexes, and stored procedures, and improving I/O efficiency.
• Lead capacity planning and forecasting by tracking growth trends, system utilization, and transaction volumes to ensure scalability and SLA compliance.
• Strengthen database security through RBAC implementation, auditing, vulnerability assessments, and compliance controls.
• Provide 24x7 production support, including incident management, root cause analysis, change management, and release coordination.
• Work closely with vendors and internal teams to resolve critical incidents, support upgrades, and minimize downtime.
• Mentor junior DBAs and contribute to technical standards, documentation, and operational best practices.

Technical Skills Required

• 10+ years of experience in database administration supporting mission-critical systems.
• Strong hands-on experience with PostgreSQL and Microsoft SQL Server in enterprise environments.
• Exposure to modern and distributed databases such as SingleStore, Netezza, and YugabyteDB.
• Solid experience in HA/DR architecture, performance tuning, security, and capacity planning.
• Hands-on experience with AWS and/or GCP managed database services.
• Strong automation and scripting skills using Python, Shell, SQL, or similar languages.
• Experience working in ITIL/SLA-driven production environments.
• Excellent troubleshooting, analytical, and communication skills.
• Excellent communication and interpersonal skills, with the ability to build rapport and trust with clients.
• Strategic thinker with the ability to develop and execute innovative solutions.
• Strong understanding of technology trends and market developments.
• Ability to work collaboratively with cross-functional teams.

Qualification:

• Must be educated to at least degree level or equivalent.