Data Base Administrator - Junior

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

Job summary

Prodapt Solutions in Chennai seeks an experienced Oracle Database Administrator (DBA) to manage and optimize mission-critical Oracle environments across Production and Non-Production landscapes. The role emphasizes High Availability, Disaster Recovery, performance tuning, backups, and automation to keep complex systems running smoothly.

The ideal candidate will own incidents, implement RAC/ASM, Data Guard configurations, and partner with Infrastructure and Applications teams.

Qualifications

• 2+ years hands-on experience administering Oracle databases across environments.
• Proficient in Oracle RAC, Data Guard, RMAN, and GoldenGate.
• Strong troubleshooting and performance tuning skills.
• Experience in 24x7 Production support and on-call rotations.

Responsibilities

• Manage Oracle databases across Production and Non-Production landscapes.
• Install, configure, upgrade, patch, clone, migrate, and decommission databases.
• Administer RAC/ASM; manage cluster, rebalancing, and monitoring.
• Configure Data Guard; monitor switchover, failover, DR testing.
• Tune performance using AWR/ASH/ADDM and SQL Trace.
• Handle RMAN backups, restores, PITR, duplication, DR validation.
• Support 24x7 enterprise environments and on-call rotations.

Skills

Oracle DBA

High Availability

Disaster Recovery

Performance Tuning

Backup & Recovery

Automation

Shell Scripting

SQL/PLSQL

24x7 On-call

Tools

Oracle RAC

Data Guard

GoldenGate

RMAN

OPatch

AutoUpgrade

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