Oracle E-Business Database Administrator Consultant
Oracle E-Business Database Administrator Consultant
Posted on :
18-07-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Jobs by Experience
5years
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
18-07-2025
Job Description
Job Title: Oracle E-Business Database Administrator Consultant
Duration: 06 Months
Client: City of Philadelphia
Location: Philadelphia PA
NOTE: This is a hybrid role with an in-person interview only.
Position overview:
- The Office of Innovation and Technology and the Department of Revenue IT unit are 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 tools and designing an upgrade strategy that will ensure post-upgrade stability and
- performance optimization.
Job Description:
- 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 modules 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 a 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 and target Operating System) and a feasibility assessment there of.
- Conduct training and documentation for internal teams on new features and best practices.
Work Activities and Essential Functions:
1. Pre-Upgrade Planning & Assessment
a. Conduct a system assessment to analyze the existing EBS 12.1 architecture including database application tier and customizations.
b. Evaluate system compatibility with EBS 12.2 including database versions third-party software (including basis2 water billing system) and hardware.
c. Perform a custom code impact analysis of basis2.
d. Identify deprecated features unsupported objects and necessary modifications.
e. Develop an upgrade strategy including timelines rollback plans and resource requirements.
2. Environment Preparation & Cloning
a. Define test environments (development test and UAT) required for the upgrade process.
b. Create plan for cloning of the production EBS 12.1 environment to create a sandbox for dry runs.
c. Create plan for upgrading the database to a certified version (e.g. Oracle Database 19c) as per EBS 12.2 requirements.
d. Define required patches to prepare for the upgrade.
e. Define a test plan to prepare for the upgrade.
3. Plan the components of executing the Upgrade Process
a. Follow Oracle s 12.2 upgrade roadmap including:
b. Running Rapid Install for 12.2
c. Applying Release Update Pack (RUP) patches
d. Enabling Online Patching (ADOP framework)
e. Execute data migration scripts and update metadata as required.
f. Verify integrity of concurrent manager processes workflow mailers and business-critical integrations.
g. Work with developers to define how to retrofit and remediate customizations impacted by the new architecture.
4. Plan Post-Upgrade Validation & Optimization to include but not limited to:
a. Conduct thorough functional and performance testing to ensure system stability.
b. Optimize database and application performance including SQL tuning indexing and JVM tuning.
c. Validate patching functionality using Oracle s AD Online Patching (ADOP) feature.
d. Perform cutover planning and execution for the final upgrade to production.
e. Provide end-user support documentation and knowledge transfer to stakeholders.
Required 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 Auto Config 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.
About Us:
Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nations fastest-growing companies.
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.
Education
Bachelor s degree in IT, Computer Science or closely related field
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
