Oracle Apps DBA
Infosys
About the Role
Hands-on experience as an Oracle Applications DBA.
Key Responsibilities
- Apply CPUs, RUPs, and Oracle patches.
- Manage WebLogic Admin Server and Managed Servers (oacore, forms, oafm).
- Execute end-to-end multi-node EBS cloning.
- Troubleshoot cloning failures and AutoConfig issues.
- Administer Concurrent Managers and resolve queue bottlenecks.
- Analyze and resolve blocking sessions and performance issues.
- Perform Oracle Database administration activities.
- Manage RMAN backup and recovery validations.
- Conduct system health checks and production support activities.
- Participate in maintenance and on-call support.
- Conduct daily system health assessments.
- Troubleshoot service outages.
- Renew certificates.
- Participate in scheduled on-call production support rotations.
Requirements & Tech Stack
- EBS R12.2: In-depth working knowledge of Oracle EBS 12.2 architecture, ADOP patching phases, and WebLogic configuration.
- Cloning & Automation: Proven track record executing routine multi-node EBS cloning and shell scripts.
- Concurrent Processing: Demonstrated experience managing concurrent managers, resolving bottlenecked queues, and terminating hung blocker sessions.
- Database & OS Foundation: Practical proficiency with Oracle DB 12c/19c administration (storage, listener, RMAN) on Linux/Unix platforms.
- Oracle E-Business Suite R12.2 (12.2.4 to 12.2.15) - EBS 12.2 Lifecycle & Patching, Environment Refreshes & Cloning, Concurrent Program & Performance Support.
- Oracle Database 12c / 19c - Database Maintenance - Administer Oracle Database 12c/19c supporting EBS; perform planned database maintenance cycles and oversee RMAN backup validations.
- Experienced in 24x7 PROD environments.
- Linux / Unix Administration.
- Shell Scripting.
Qualifications
- Basic familiarity or operational awareness of the following is considered an added advantage:
- Operational exposure to OEM, Oracle Exadata, Oracle Goldengate (OGG) replication workflows.
- High-level familiarity with Oracle Fusion Middleware.
- Foundational awareness of Cloud environments.
Generic Requirements
- Flexible to work in extended hours, weekends/holidays/off hours.
- Ability to interact at all levels of clients’ organizations.
- Strong verbal, written, and interpersonal communication skills.
- Fluent in English language.
- Self-motivated and competent to work independently in a complex environment.
- Onshore/offshore coordination skills.
