Oracle Apps DBA

Role: Oracle Apps DBA Type: Full Time Experience: 6–10 years Location: Remote Availability: Immediate joiner preferred Work Time: 6PM to 2 AM IST Role Overview We are looking for a strong Oracle Applications DBA to support, maintain, and optimize Oracle E-Business Suite (EBS) environments. The resource will work closely with internal and client teams to ensure high-quality support, timely ticket resolution, proactive monitoring, and adherence to SLAs.

The candidate must be reliable, highly accountable, and able to communicate effectively across teams.

Key Responsibilities

Manage, administer, and support Oracle E-Business Suite (R12 / 12.2.x) environments. Perform cloning, patching, upgrades, and environment refreshes. Troubleshoot issues related to application, database, concurrent managers, workflow, and performance. Monitor and resolve production issues within SLA timelines. Manage and update support tickets regularly with clear communication.

Perform backup & recovery, system monitoring, and performance tuning. Ensure availability, reliability, and scalability of Oracle Apps environments. Apply patches (CPU, PSU, AD, TXK, etc.) and coordinate scheduled maintenance. Support RAC / Data Guard environments if applicable. Work closely with functional, development, and infrastructure teams for issue resolution.

Participate in daily stand-ups, client meetings, and provide timely updates. Document procedures, root cause analyses (RCA), and environment changes. Support basic development-related tasks when needed (forms/reports deployment, file movements, etc.)

Requirements

Required Skills Strong hands-on experience as an Oracle Apps DBA. Expertise in EBS R12.1 / R12.2 administration. Solid experience in cloning, patching, and upgrades of EBS environments. Good understanding of Oracle Database 12c/19c architecture. Experience with Unix/Linux platforms and shell scripting. Good knowledge of WebLogic Server, application tier components, and concurrent processing.

Strong analytical, troubleshooting, and performance tuning skills. Excellent communication skills and professional reliability. Ability to work under pressure and meet timelines. Nice-to-Have Skills Exposure to OEM (Oracle Enterprise Manager). Knowledge of Cloud (OCI/AWS) migration or hosting of EBS. Experience supporting third-party integrations.

Understanding of 12.2 Online Patching (ADOP). Soft Skills Strong time management and accountability. Ability to work independently and manage priorities. Consistent participation in stand-ups and client calls. Proactive communication and timely ticket updates.

Benefits

Skill Area Skill Description Candidate Self-Rating (1–5) EBS Administration Managing Oracle EBS R12.1/R12.2 environments, application tier, concurrent managers Cloning & Refresh Performing full cycle cloning, environment refreshes, and post-clone fixes Patching (AD, TXK, CPU, PSU) Applying patches, online patching (ADOP), downtime planning Oracle DB Administration Database management (12c/19c), monitoring, health checks, backups Performance Tuning Tuning database, applications, SQL, JVM, and concurrent programs Troubleshooting Diagnosing EBS, DB, WebLogic, workflow, and performance issues Backup & Recovery (RMAN) Managing RMAN backups, recovery scenarios WebLogic Administration Managing WebLogic, OHS, JVM tuning Linux/Unix & Shell Scripting Working on Linux platforms, writing shell scripts Automation & Monitoring OEM usage, proactive monitoring, alerting Ticketing & SLA Management Timely updates, SLA adherence, RCA preparation Communication & Reliability Participation in stand-ups, responsiveness, professionalism Time Management Meeting deadlines, managing workloads, prioritization Documentation Maintaining SOPs, change logs, patching and clone runbooks Basic Dev Support Deployments of forms/reports, file moves, compiling