Oracle Database Administrator (IND171458)

ADP; Hyderabad; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

ADP is seeking an experienced MSSQL & Oracle DBA with 5-6 years of hands-on experience in SQL Server and Oracle administration, automation, and cloud platform support. You will manage installations, upgrades, migrations, patching, and high-availability configurations.

The ideal candidate will design and implement HA/DR, security, and automation using Ansible, Terraform, PowerShell, and YAML, while supporting AWS and Azure environments and collaborating with cross-functional teams.

Qualifications

• 5-6 years of experience in Microsoft SQL Server and Oracle Database Administration.
• Hands-on experience with installation, configuration, patching, and upgrades.
• Experience with Always On Availability Groups (AG), DAGs, backup/DR, and performance tuning.
• Proficiency with Ansible Controller/AWX for automation.
• Cloud exposure to AWS and Azure; Terraform deployments.
• Scripting skills in PowerShell and YAML.
• Familiarity with ServiceNow or SolveIT for monitoring/ITSM.

Responsibilities

• Perform SQL Server installations, upgrades, migrations, and patching.
• Configure AG/DAG clustering, DR, backup, and restore solutions.
• Implement least-privilege security models and access controls.
• Install, configure, patch, upgrade, and maintain Oracle databases.
• Design HA/DR using Oracle RAC and Data Guard.
• Configure and manage Oracle RMAN backups.
• Monitor and alert database health; troubleshoot outages.
• Automate workflows using Ansible Controller; monitor job templates.
• Support cloud-hosted DBs in AWS and Azure; analyze Terraform deployments.
• Collaborate with infra, app, and cloud teams to improve automation.

Skills

SQL Server Administration

Oracle Database Administration

Automation & Scripting

Cloud Platforms (AWS, Azure)

Ansible/AWX

Terraform

PowerShell

YAML

Monitoring & Incident Troubleshooting

Tools

Ansible Controller/AWX

Terraform

PowerShell

YAML

AWS

Azure

ServiceNow

SolveIT

Job description

MSSQL & Oracle DBA (5-6 Years Experience)

We are seeking an experienced Microsoft SQL Server and Oracle DBA with 5-6 years of hands‑on experience in SQL Server/Oracle administration, automation, and cloud platform support. The ideal candidate should possess strong technical expertise across database administration, infrastructure automation, and cloud environments.

Key Responsibilities

• Perform SQL Server installations, upgrades, migrations, and patching activities, including both in-place and side-by-side upgrade methodologies.
• Configure, administer, and troubleshoot SQL Server Always on Availability Groups (AON AG), Distributed Availability Groups (DAGs), clustering, disaster recovery, backup, and restore solutions.
• Implement and maintain least-privilege security models, user access controls, and SQL Server security best practices.
• Install, configure, patch, upgrade, and maintain Oracle databases.
• Design and maintain HA/DR solutions using technologies such as Oracle RAC and Data Guard.
• Configure and manage Oracle RMAN backup and recovery processes.
• Apply Oracle Release Updates and security patches within organizational SLAs.
• Configure proactive database monitoring and alerting. Troubleshoot database outages and production incidents.
• Execute and validate automation workflows through Ansible Controller, including running and monitoring job templates.
• Support cloud-hosted database environments across AWS and Azure, with the ability to identify and work with:
• AWS EC2 instances
• Amazon RDS databases
• Trigger and troubleshoot Terraform deployments, with the ability to analyze deployment failures and coordinate resolution.
• Develop, enhance, debug, and test automation scripts using PowerShell and YAML.
• Collaborate with infrastructure, application, and cloud teams to implement automation and operational improvements.
• Utilize monitoring and observability platforms such as ServiceNow, SolveIT, and related operational tools for incident management, alerting, and troubleshooting.

Required Skills

• 5-6 years of experience in Microsoft SQL Server and Oracle Database Administration.
• Strong experience with:
• SQL Server
• Installation, Configuration, Patching, and Upgrades
• SQL Server 2016/2017/2019/2022
• Always On Availability Groups (AG)
• Backup, Restore, DR, and Performance Tuning
• SQL Security and Permission Management
• Oracle
• Database Administration
• High Availability & DR
• Backup and recovery
• Patching & Upgrades
• Hands‑on experience with Ansible Controller/AWX.
• Basic to Intermediate knowledge of AWS and Microsoft Azure services.
• Working knowledge of Terraform deployments and troubleshooting.
• Strong scripting capabilities in PowerShell and YAML.
• Experience with ServiceNow, SolveIT, or equivalent monitoring and ITSM platforms.
• Excellent troubleshooting, automation, and documentation skills.

Preferred Qualifications

• Experience supporting enterprise-scale, highly available SQL Server & Oracle environments.
• Exposure to Infrastructure-as-Code (IaC) and DevOps practices.
• Knowledge of CI/CD pipelines and cloud automation frameworks.
• Cloud certifications (AWS or Azure) and Microsoft SQL/Oracle certifications are a plus.