Data Base Administrator - Junior

Prodapt Solutions Private Limited; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Prodapt Solutions Private Limited in Chennai seeks an experienced Oracle Database Administrator to manage production and non-production Oracle environments, focusing on high availability, disaster recovery, tuning, backups, and automation. The role requires ownership of incidents and a readiness for 24x7 support.

Responsibilities include installation, upgrades, patching, migrations, RMAN backups, Data Guard operations, GoldenGate administration, and automated health checks.

Qualifications

• Experience in Oracle database installation, configuration, upgrades, migrations, patching, cloning, refreshes, and decommissioning.
• Proven expertise in Oracle RAC and ASM administration, including cluster management, instance/service administration, disk group management, rebalancing, and troubleshooting.

Responsibilities

• Install, configure, upgrade, migration, patching, cloning, refreshes, and decommissioning of Oracle databases in Production and Non‑Production environments.
• Manage Oracle RAC and ASM administration, including cluster management, instance/service administration, and disk group management.
• Configure and monitor Oracle Data Guard, perform switchover/failover and DR testing.
• Perform performance tuning using AWR/ASH/ADDM and SQL tracing.
• Handle RMAN backups/restores, point‑in‑time recovery, and DR validation.
• Administer Oracle GoldenGate, including Extract/Replicat and monitoring.
• Upgrade/migrate databases using AutoUpgrade, DBUA, Data Pump, OPatch, and OPatchAuto.
• Troubleshoot critical issues (ORA‑600s, startup failures) and coordinate 24x7 production support.

Skills

Troubleshooting

Incident handling

Communication

On-call support

Tools

Oracle RAC

Data Guard

RMAN

GoldenGate

AutoUpgrade

OPatch

Job description

Overview

We are seeking an experienced Oracle Database Administrator (DBA) to manage, optimize, and support mission‑critical Oracle database environments across Production and Non‑Production landscapes. The ideal candidate will have deep expertise in Oracle Database Administration, High Availability solutions, Disaster Recovery, Performance Tuning, Backup & Recovery, and Database Automation. The role requires strong troubleshooting skills, ownership of critical incidents, and the ability to support 24x7 enterprise environments.

Responsibilities

2+ years of hands‑on experience administering Oracle Databases (11g, 12c, 19c, 21c, and 23ai) across Production and Non‑Production environments.
Strong experience in Oracle database installation, configuration, upgrades, migrations, patching, cloning, refreshes, and decommissioning activities.
Proven expertise in Oracle RAC and ASM administration, including cluster management, instance/service administration, disk group management, rebalancing, and troubleshooting.
Extensive experience with Oracle Data Guard configuration, monitoring, switchover, failover, standby synchronization, and DR testing.
Strong performance tuning and diagnostics experience using AWR, ASH, ADDM, SQL Trace, Explain Plans, Wait Event Analysis, Optimizer Statistics, and SGA/PGA tuning.
Hands‑on experience with RMAN backup and recovery, including restores, point‑in‑time recovery, duplication, cloning, and DR validation exercises.
Experience with enterprise backup solutions such as Commvault.
Strong Oracle GoldenGate administration experience, including Extract, Data Pump, Replicat, Trail File Management, Replication Monitoring, and Troubleshooting.
Experience performing database upgrades and migrations using AutoUpgrade, DBUA, Data Pump, OPatch, and OPatchAuto.
Strong troubleshooting skills for critical Oracle database issues, including ORA‑00600, ORA‑04031, ORA‑01555, ORA‑00257, ORA‑01652, ORA‑07445, startup failures, and recovery scenarios.
Solid understanding of Oracle Security Administration, including Transparent Data Encryption (TDE), Wallets, Auditing, Roles, Privileges, Password Policies, and Least‑Privilege Access Management.
Proficiency in Shell/KSH scripting, SQL, and PL/SQL for automation, monitoring, reporting, health checks, and backup validation.
Experience with database monitoring, proactive issue identification, root cause analysis (RCA), and incident management.
Strong communication and stakeholder management skills with the ability to coordinate across Infrastructure, Application, Storage, and Network teams.
Willingness to participate in 24x7 Production support and on‑call rotations.

Requirements

Strong experience in Oracle database installation, configuration, upgrades, migrations, patching, cloning, refreshes, and decommissioning activities.
Proven expertise in Oracle RAC and ASM administration, including cluster management, instance/service administration, disk group management, rebalancing, and troubleshooting