Data Base Administrator - Junior
Prodapt
- Location
- Chennai - Guindy, India
- Work model
- On-Site
- Level
- Entry
- Posted
- 55m ago
Skills
About this role
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