Oracle EBS Database Administrator

Full Time Philadelphia PA CAI

Job ID Number

R5756

Employment Type

Full time

Worksite Flexibility

Onsite

Job Summary

As an Oracle E-Business Suite (EBS) DBA, you will lead the planning of an upgrade from Oracle EBS 12.1 to 12.2. The ideal candidate will have deep expertise in Oracle Database Administration, EBS architecture, and upgrade methodologies.

Job Description

We are seeking a highly skilled Oracle EBS Database Administrator to join our IT team. This position will be full-time, hybrid, and is a contract position.

What You’ll Do

  • Develop a comprehensive upgrade plan for Oracle EBS from 12.1 to the latest subversion of 12.2, including risk assessment and rollback strategies

  • Perform technical analysis, impact assessment, and design pre-upgrade validation to ensure a smooth transition

  • Determine impact to Basis2 customer information/water billing system and factor into upgrade plan

  • Plan installation and configuration of Oracle EBS 12.2, including WebLogic, Fusion Middleware, and Online Patching (ADOP)

  • Define optimization of the Oracle Database (if required) in alignment with EBS 12.2 compatibility

  • In collaboration with the Basis2 custom module’s vendor, define code customizations and retrofitting as needed to ensure compatibility with 12.2

  • Design cloning, backup, and recovery processes to safeguard data during the upgrade

  • Create plan for troubleshooting and resolving performance, patching, and configuration issues post upgrade

  • Work closely with functional consultants, developers, and business users to develop a comprehensive plan that ensures minimal disruption to business operation

  • Conduct training and documentation for internal teams on new features and best practices

What You’ll Need
Required:

  • 7+ years of hands-on experience as an Oracle EBS DBA with expertise in versions 12.1 and 12.2 on the Windows Server Operating System

  • Strong knowledge of Oracle Database (11g, 12c, 19c), including RMAN, Data Guard, and performance tuning

  • Experience with Oracle EBS 12.2 upgrade processes, including ADOP (Online Patching), WebLogic, and Fusion Middleware

  • Proficiency in cloning, backup/recovery, patching, and migration of EBS environments

  • Strong knowledge of Windows environments, scripting, and automation

  • Hands-on experience with Oracle Applications DBA (AD utilities, AutoConfig, ADOP, rapid clone, etc.)

  • Experience in customization impact assessment, and code remediation

  • Understanding of Oracle Security, Concurrent Processing, and Application Tier Architecture

Preferred:

  • Experience with Oracle performance monitoring, tuning, and optimization

  • Ability to provide technical guidance to business and executive audiences in clear, concise, understandable, and actionable terms

  • Certification in Oracle DBA or EBS is a plus

Physical Demands

  • Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards

  • Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

  • Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

The pay range for this position is $67.00 – $72.00 per hour (USD). Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages for this role includes medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role may also be entitled to paid sick leave as provided by applicable law.​ 

Reasonable Accommodation Statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.

Equal Employment Opportunity Policy Statement

CAI is committed to equal employment opportunity. We do not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability, or veteran status. All employment decisions are based on valid job requirements, including hiring, promotion, and compensation. Harassment and retaliation are prohibited.

To apply for this job please visit itjobpro.com.