Description and Requirements
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 upgradeSQL Server (2016/2019/2022)instances in cloud/on-prem environments.
- ConfigureAlways On Availability Groups,Log Shipping,Replication, and other HA/DR solutions.
- Conduct performance tuning, query optimization, and implement indexing strategies.
- Automate administrative tasks usingT-SQLandPowerShell.
- Migrate databases toAWS RDSandEC2using best practices.
- Implement and managesecurity, including access control, encryption, and auditing.
Oracle 12c, 19c
- Install, configure, and administerOracle 19cdatabases (on-prem and AWS-hosted).
- Set up and manageOracle Data Guard,RMAN backups, andtuning/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 ofRDS SQL Server and Oracle 19cinstances.
- 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 experiencewith strong focus onMicrosoft SQL Server.
- 2+ years of hands-on experiencemanagingOracle 12c, 19cdatabases.
- Experience withAWS RDS(SQL Server and Oracle),and performance tuning in cloud environments.
- Strong scripting skills inT-SQL,PL/SQL, andPowerShell.
- Deep understanding ofHA/DR, backup/restore strategies, and cloud migration approaches.
- Experience withmonitoring, 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 ofMySQLandPostgreSQLin cloud environments (especially AWS RDS)
- Exposure toDevOps tools,Terraform,CloudFormation, or CI/CD pipelines
- Experience withmulti-region/multi-AZdeployments and cost optimization in AWS
- Exposure to WOG/GCC and GCC+ environments is a strong advantage
