Tech Stack

Description

You will manage, support, and optimize Oracle Database environments with a focus on JD Edwards (EnterpriseOne) data structures, replication, and high availability, performing day-to-day DBA tasks and supporting JDE-specific operations.

Requirements

• Expertise in Oracle Database GoldenGate.
• Direct experience with JD Edwards EnterpriseOne architecture, including Central Objects and Business Data schemas.
• Proven ability to perform JDE Data Refreshes using RMAN or Export/Import (Data Pump).
• Understanding of JDE OCM and how it maps to Oracle Database schemas/Data Sources.
• Experience with JDE on Oracle Cloud Infrastructure (OCI) is a significant advantage.
• Ability to act as a Subject Matter Expert (SME) in Managed Services.

Responsibilities

• Install, configure, upgrade, and patch Oracle Databases supporting JD Edwards EnterpriseOne.
• Manage JDE-specific database schemas (System, Server Map, Data Dictionary, and Business Data).
• Perform JDE environment refreshes ensuring data consistency and OCM alignment.
• Optimize performance for JDE-specific workloads, focusing on long-running UBEs and interactive application queries.
• Monitor and troubleshoot JDE-specific locking issues and temp tablespace growth during batch processing.
• Design and implement GoldenGate for JDE data replication to ODS or data warehouses.
• Manage near-zero downtime migrations for JDE databases during platform migrations or version upgrades.
• Configure Extract/Replicate processes for JDE tables, handling unique constraints and LOB data types.
• Monitor replication lag to ensure real-time reporting availability.
• Support JDE database migrations (On-prem to OCI/AWS/Azure).
• Implement Data Guard for JDE High Availability, ensuring seamless failover.