DATABASES-Engineering-MySQL

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
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

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.

---