DATABASES-Engineering-MySQL

Zensar Technologies

Job Description

We are seeking a highly skilled L3 Database Administrator with strong expertise in SQL Server and PostgreSQL to manage, support, and optimize critical database systems. The role involves advanced troubleshooting, performance tuning, cloud database management, and ensuring high availability and disaster recovery for production environments.

Responsibilities

Key Responsibilities

Database Management

Administer and maintain SQL Server (IaaS SQL Instance, Azure SQL Managed Instance, Azure SQL DB) and PostgreSQL databases

Perform installations, upgrades, patching, and migrations

Manage database provisioning and environment setup

Performance Tuning & Optimization

Analyze and optimize slow queries and execution plans

Design and maintain indexing strategies

Troubleshoot blocking, deadlocks, and performance bottlenecks

Backup, Restore & Disaster Recovery

Design and manage backup strategies (Full, Differential, Log)

Perform database restores and point-in-time recovery

Implement and validate DR strategies

High Availability

Configure And Manage

SQL Server Always On Availability Groups

Failover clustering

PostgreSQL replication (streaming/logical)

Monitoring & Automation

Implement monitoring and alerting solutions

Automate routine DBA tasks using scripting (PowerShell, Bash, Python)

Work with monitoring tools (Azure Monitor, Grafana, etc.)

Security & Compliance

Manage database security (logins, roles, permissions)

Implement encryption and auditing policies

Ensure compliance with organizational standards

Qualifications

Database Management

Administer and maintain SQL Server (IaaS SQL Instance, Azure SQL Managed Instance, Azure SQL DB) and PostgreSQL databases

Perform installations, upgrades, patching, and migrations

Manage database provisioning and environment setup

Performance Tuning & Optimization

Analyze and optimize slow queries and execution plans

Design and maintain indexing strategies

Troubleshoot blocking, deadlocks, and performance bottlenecks

Backup, Restore & Disaster Recovery

Design and manage backup strategies (Full, Differential, Log)

Perform database restores and point-in-time recovery

Implement and validate DR strategies

High Availability

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.

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.