Interview Process: Video interview then possibly an in person interview
Key Responsibilities:
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.
Skills/experience of the assigned staff:
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.
...88 and has over 750 rooms, cottages and villas with 65,000 square feet of banquet space, and 10 food and beverage outlets\. This includes 4 restaurants, 2 bars, a food truck, marketplace, ice cream shop, and in\-room dining\.Marking the continued expansion of The Del's...
...bringing to life a new, innovative, and exclusive fine-dining supper club located in Old Towns Entertainment District that blends... ...House, CAKE, Cottontail Lounge / Living Room / WET Deck, Maya Day+Night, Shiv Supper Club, Kauboi, Allegra, and F/Sixteen. Our...
...Title: Safety Coordinator/Residential Aide Salary: $21.98 to $24.73( approximately$40,000 to $45,000 annually) Reports to: Program Director, Community Navigation Status: Full Time; Regular Non-Exempt Location: Bronx, NY 10451 Days/Hours: Monday-Friday,...
Private Driver Boston, MA An executive couple in Boston is seeking an experienced and dependable Private Driver to provide safe, discreet, and efficient transportation for business, personal, and occasional family needs. The ideal candidate is polished, punctual, and deeply...
...grants and contracts in addition to various commercial entities. CDD is currently seeking to grow its federal and commercial computational chemistry offerings, which creates the need for a Computational Chemist to join our team of established researchers Ideally, you will...