Oracle Apps Database Administrator

Description :

Job Summary :

- Role Type : Freelancing Role.

There are three rotational shifts for the DBA track :

- 7 :00 AM - 4 :00 PM

- 3 :00 PM - 12 :00 AM

- 11 :00 PM - 8 :00 AM

We are looking for an experienced Oracle Applications DBA (APPS DBA) to manage, support, and optimize Oracle E-Business Suite (EBS) environments.

The role involves administration, performance tuning, patching, cloning, backup/recovery, and upgrades, along with support for Oracle Databases and Fusion Middleware components.

Key Responsibilities :

- Perform installation, configuration, and maintenance of Oracle E-Business Suite R12.x (11i/R12/R12.x).

- Administer and support Oracle Databases (11g/12c/19c) in multi-tier architectures.

- Perform EBS cloning, patching, upgrades, and environment refreshes across development, test, and production.

- Manage and troubleshoot concurrent managers, forms, reports, and workflow.

- Perform system performance tuning, space management, and monitoring.

- Administer WebLogic/OHS/Apache servers and troubleshoot application/middleware issues.

- Implement and maintain backup and recovery strategies (RMAN, data pump).

- Support EBS integration with OAM, OID, SSO, and external systems as needed.

- Collaborate with functional, development, and infrastructure teams to ensure system stability and performance.

- Document all changes, procedures, and configurations as per audit and compliance standards.

- Strong experience in Oracle EBS R12.x / R12.x administration.

- Expertise in Oracle Database administration (11g/12c/19c).

- Hands-on with AD/TXK utilities, patching tools (ADOP, ADPATCH).

- Experience with WebLogic Server, Forms/Reports, and Concurrent Manager.

- Knowledge of Linux/Unix shell scripting.

- Proficiency in RMAN, Data Pump, cloning, and backup/recovery processes.

- Familiarity with OAM/OID, SSL configuration, and Load Balancers.

- Working knowledge of OEM (Oracle Enterprise Manager) for monitoring and performance tuning.

Skillsets Required :

- Oracle Apps DBA

- Oracle EBS Architecture

- Oracle EBS File System

- EBS Backup, Refresh, and Cloning

- Autoconfigure

- Multinode Configuration

- Shared Application File System

- Workflow and Concurrent Manager Troubleshooting

- Knowledge of AD Utilities :

1. adpatch

2. adop

3. adadmin

- Oracle Core DBA

- Strong experience with Oracle 11g / 12c / 19c

- Backup & Recovery (RMAN, Data Pump)

- Performance Tuning and Optimization

- Patching and Upgrades

- Experience with RAC, ASM, and Data Guard

- Familiarity with Linux/Unix OS and Shell Scripting

- Understanding of Load Balancing and High Availability Setups