What are the responsibilities and job description for the Oracle E-Business Database Administrator Consultant position at Smart IMS?
This project will encompass planning for the upgrade of the Oracle E-Business System (EBS) from version 12.1 to version 12.2.
Develop a comprehensive upgrade plan for Oracle EBS from 12.1 to the latest subversion of 12.2, including risk assessment and rollback strategies.
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.
- 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.
- 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.
