Data Base Administrator - Junior

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

Job summary

Prodapt is seeking an experienced Oracle Database Administrator (DBA) to manage mission-critical Oracle databases across production and non-production landscapes in Chennai. The role emphasizes high availability, disaster recovery, performance tuning, and automation.

You will work with RAC, Data Guard, RMAN, and GoldenGate, own critical incidents, and participate in 24x7 on-call rotations. Strong Scripting (shell/SQL/PLSQL) and problem-solving skills are essential.

Qualifications

• 2+ years hands-on Oracle DBA experience across 11g–23c.
• Strong RAC and ASM administration with cluster management.
• Experience with Data Guard, RMAN, and GoldenGate.
• Proficiency in Shell scripting, SQL, and PL/SQL for automation.

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.

Skills

Oracle RAC

Data Guard

RMAN backup

GoldenGate

Performance tuning

SQL/PLSQL

Shell scripting

Troubleshooting

Monitoring

Incident management

Root Cause Analysis

AutoUpgrade/DBUA

Tools

OPatch

Data Pump

DBUA

Oracle Enterprise Manager

RMAN

Job description

Overview

We are seeking an experienced

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