Oracle EBS DBA Job at Techcliff Group, Philadelphia, PA

Y2lWRE4zdEMxcGR3MGd3VjBzM3NaMkJ2UEE9PQ==
  • Techcliff Group
  • Philadelphia, PA

Job Description

Interview Process: Video interview then possibly an in person interview

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.

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.

Job Tags

Similar Jobs

Commonwealth motors

General Sales Manager Job at Commonwealth motors

We're Looking for an aggressive General Sales Manager to help our team grow!!The right applicant must have three years of current Automotive Sales Management experience and be able to lead a sales team with follow up, sales process and customer service skills. Detail... 

Pitisci & Associates

Network Security Architect 35828813 Job at Pitisci & Associates

 ...organizational objectives. Research and recommend innovative technologies and approaches for network and network security management,...  ...SevOne, SolarWinds, DataDog, Splunk) Familiarity with Information Security concepts, practices, and procedures, encompassing all... 

Etex Group

Trade Marketing Assistant Job at Etex Group

 ...Trade Marketing Assistant Location: Munro, ARAn introduction to EtexAt Etex, our purpose is to inspire new ways of living. By joining Etex, you wont just be joining an international leader, you will inspire people around the world to... 

Wells Fargo

Corporate Banking Associate Job at Wells Fargo

**About this role:**Wells Fargo is seeking a Corporate Banking Associate as part of the Technology, Media, and Technology (TMT) Corporate & Investment Banking team. Learn more about our career areas and lines of business at wellsfargojobs.com.The TMT Associate Corporate... 

MultiTech Systems

Full Time Data Entry Analyst - Remote Work From Home Job at MultiTech Systems

 ...looking for a detail-oriented Data Entry Analyst to join our dynamic team. In...  ...role, you will play a critical part in managing data related to...  ... Good organizational and time management skills. Ability...  ...preferred. Benefits: Full remote work opportunity. Be part...