Senior Oracle GoldenGate Migration Lead (OCI Cloud)

9th Way Insignia; Washington; On-site; USD 98,000 - 120,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401(k)

Life Insurance

PTO

Telehealth

HSA

Job summary

9th Way Insignia is seeking a Senior Oracle GoldenGate Migration Engineer to lead the upgrade of the VA Enterprise Data Warehouse from on-premises Oracle to Oracle Cloud Infrastructure (OCI) and move GoldenGate to a Microservices architecture.

You will document configurations, design and deploy Microservices components in OCI, and ensure secure hybrid connectivity with on-prem systems while validating data replication throughout migration and stabilization.

Qualifications

• Minimum 10 years of hands-on Oracle GoldenGate administration, configuration, deployment, troubleshooting, and production support.
• Direct experience migrating Oracle GoldenGate from Classic Architecture to Microservices Architecture.
• Hands-on OCI implementation experience including provisioning, configuration, deployment, or hybrid connectivity support.
• Experience supporting Oracle Database 19c environments.
• Strong SQL skills and understanding of Oracle transaction processing and replication behavior.
• Experience with migration testing, data validation, cutover planning, and rollback planning.
• Strong troubleshooting, documentation, and communication skills.
• Ability to obtain and maintain required VA suitability/access authorization.

Responsibilities

• Lead migration of Oracle GoldenGate to Microservices Architecture in OCI.
• Assess and document existing GoldenGate configurations (Extract, Pump, Replicat, trails, credentials, parameter-files, monitoring).
• Design, deploy, and troubleshoot GoldenGate Microservices components in OCI.
• Establish secure hybrid connectivity between OCI services and on-premises systems.
• Configure and maintain GoldenGate processes, endpoints, credentials, trails, monitoring, and replication parameters.
• Execute migration testing, replication validation, cutover rehearsals, deployment, rollback, and stabilization activities.
• Monitor and troubleshoot replication lag, failures, network interruptions, data inconsistencies, and performance issues.
• Collaborate with OCI infrastructure, network/security, Oracle DBA, Informatica, and EDW teams to resolve dependencies.

Skills

Oracle GoldenGate

OCI (Oracle Cloud Infrastructure)

SQL

Troubleshooting

Documentation

Security connectivity

Data replication

Stakeholder collaboration

Tools

Informatica PowerCenter

Oracle RAC

Data Guard

RMAN

ASM

Oracle Enterprise Manager

Job description

9th Way Insignia is seeking a Senior Oracle GoldenGate Migration Engineer to lead the upgrade of the VA Enterprise Data Warehouse from on-premises Oracle to Oracle Cloud Infrastructure (OCI) and move GoldenGate to a Microservices architecture.

You will document configurations, design and deploy Microservices components in OCI, and ensure secure hybrid connectivity with on-prem systems while validating data replication throughout migration and stabilization.