Oracle E-Business Database Administrator Consultant

Job Title: Oracle E-Business Database Administrator Consultant

Duration - 5 months

Work Location - Philadelphia, PA ( Hybrid)

Statement of Work- Innovee's Public Sector is seeking an experienced Oracle E-Business Suite (EBS) DBA to 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. This role involves analyzing the existing environment, the ability to clone the system with standard EBS tool and designing an upgrade strategy that will ensure post-upgrade stability and performance optimization.

Key Responsibilities:

• 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 operations. The plan to include detailed technical choices (source constraints, target Database, target Operating System) and a feasibility assessment thereof.
• Conduct training and documentation for internal teams on new features and best practices.

Required Skills & Experience:

Technical Skills:

• 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.

Highly Desired/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

Soft Skills & Other Requirements:

• Ability to lead and execute complex upgrade projects with minimal supervision.
• Strong problem-solving and troubleshooting skills.
• Excellent communication skills to collaborate with cross-functional teams.
• Ability to work in high-pressure, dynamic environments with tight deadlines.
• Certification in Oracle DBA or EBS is a plus.