Key Responsibilities:
- Install,configure, and maintain database instances for different varieties of database
- 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 12c, 19c
- Install, configure, and administer Oracle 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:
- 5+ years of DBA experience with strong focus on Microsoft SQL Server.
- 2+ 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:
- 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