Lead a team of DBAs in the team resourcing and work plans, technical mentoring & support.
Drive the standardization of database maintenance activities in terms of process, procedures, automation for all clients to drive efficient operations.
Install, configure, and maintain database instances for different varieties of database when required.
Monitor database performance, analyze resource utilization, and optimize SQL queries.
Design and implement high availability solutions such as Log Shipping, Mirroring, Replication, Clustering, and Always On Availability Groups.
Perform database backups, restores, and support disaster recovery processes.
Apply security patches and updates to ensure security compliance.
Troubleshoot and resolve issues across the database stack, including software, hardware, OS, and network layers.
Implement database security measures to protect data integrity and confidentiality.
Support application development teams by analyzing database requirements and optimizing database-related code.
Address system vulnerabilities, apply fixes, and support legacy systems.
Develop and maintain scripts for automation of routine tasks such as backups, monitoring, health checks, housekeeping and reporting.
Create, maintain and update comprehensive documentation related to configurations, procedures, and issue resolution.
Provide regular reports on database health, patch level, back as per requirements.
Work collaboratively across teams to ensure database reliability, scalability, and performance.
Participate in 24x7 on-call rotation, ensuring timely response to incidents as per SLAs.
Collaborate with DevOps, Security, and Application teams to support change releases and service transitions.
Apply ITIL-aligned incident, change, and problem management practices in daily operations.
Requirements:
At least 8 years of DBA experience with strong focus on Microsoft SQL Server.
5+ years of hands-on experience managing Oracle 12c, 19c databases.
Experience with AWS RDS (SQL Server and Oracle), and performance tuning in cloud environments.
Strong scripting skills in T-SQL, PL/SQL, and PowerShell.
Deep understanding of HA/DR, backup/restore strategies, and cloud migration approaches.
Experience with monitoring, alerting, and automation tools including CloudWatch, Azure Monitor.
