You Will:
- 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.
Technical Skillsets Requirements
MS SQL Server
- Install, configure, maintain, and upgrade SQL Server (2016/2019/2022) instances in cloud/on-prem environments.
- Configure Always On Availability Groups, Log Shipping, Replication, and other HA/DR solutions.
- Conduct performance tuning, query optimization, and implement indexing strategies.
- Automate administrative tasks using T-SQL and PowerShell.
- Migrate databases to AWS RDS and EC2 using best practices.
- Implement and manage security, including access control, encryption, and auditing.
Oracle Database
- Install, configure, and administer Oracle 12c, 19c databases (on-prem and AWS-hosted).
- Set up and manage Oracle Data Guard, RMAN backups, and tuning/diagnostics.
- Perform routine health checks, patching, schema changes, and space management.
AWS RDS (SQL Server & Oracle 19c), NoSQL databases (e.g. DynamoDB, MongoDB)
- Manage provisioning, configuration, and maintenance of RDS SQL Server and Oracle 19c instances.
- Monitor RDS performance, configure backup retention, parameter groups, and apply patches.
- Handle snapshots, restore operations, and troubleshoot RDS-related issues.
Required Skills and Experience:
- 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.
Mandatory Certifications:
- Microsoft Certified: SQL Server DBA or Azure Administrator Associate
- AWS Certified Database Specialty or AWS Certified Solution Architect Associate
- Oracle Database 12c, 19c Administrator Certified Professional
Soft Skills:
- Experienced in leading a team and ability to motivate, coach, and develop team members.
- Excellent communication, problem-solving, and documentation skills
- Ability to work independently and collaboratively in a remote or hybrid environment
- Flexible to support critical issues and on-call rotations if required
Good to Have:
- Working knowledge of MySQL and PostgreSQL in cloud environments (especially AWS RDS)
- Exposure to DevOps tools, Terraform, CloudFormation, or CI/CD pipelines
- Experience with multi-region/multi-AZ deployments and cost optimization in AWS
- Exposure to WOG/GCC and GCC+ environments is a strong advantage
