Senior Oracle GoldenGate Migration Engineer

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 a service-disabled, veteran-owned small business bringing transformative technology to our government customers so they can achieve their missions. Our specialties include cybersecurity, cloud modernization, software development, data analytics, enterprise architecture, enterprise IT, analytics, process automation, and artificial intelligence. Learn more about 9th Way Insignia at https://9thwayinsignia.com/.

Application password: Niner

Team (Project) Introduction

The Office of Performance Analysis and Integritymanagesand enhances the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) whichresideson one Oracle M8 Supercluster database and thirteen application servers. Our team provides the technical servicesrequiredto sustain EDW applications to include Project Management, Data Warehouse Management, Advanced Analytics, Tableau Server Administration/Tableau Desktop Administration, Technical Collaboration Support, Lessons Learned, Executive Orders and Special Projects, Architectural Enhancement, and Cloud Migration. We also provide management, enhancement, integration, implementation, maintenance, modernization, and infrastructure support for EDW applications as well as enhancement and maintenance of business intelligence capabilities and predictive analytics. 9thWay Insignia is looking for a Senior Oracle GoldenGate Migration Engineer to join and lead this team.

We are seeking a hands-on Senior Oracle GoldenGate Migration Engineerto support migration of the VA Enterprise Data Warehouse (EDW) from an on-premises Oracle environment to Oracle Cloud Infrastructure (OCI) within the VA Enterprise Cloud environment. The selected candidate will lead the migration of Oracle GoldenGate from Classic Architecture to Microservices Architecture, configure secure connectivity between OCI-hosted GoldenGate services and on-premises source systems, and validate reliable, accurate data replication throughout the migration and stabilization period.

Responsibilities:

• Lead the migration of Oracle GoldenGate from Classic Architecture to Microservices Architecture in OCI.
• Assess and document existing GoldenGate Extract, Pump, Replicat, trail, checkpoint, credential, parameter-file, and monitoring configurations.
• Design, configure, deploy, and troubleshoot GoldenGate Microservices components in the target OCI environment.
• Establish and validate secure hybrid connectivity between OCI-hosted GoldenGate services and on-premises source systems.
• Configure and maintain GoldenGate processes, endpoints, credentials, trails, monitoring, and replication parameters.
• Execute migration testing, replication validation, cutover rehearsals, deployment, rollback, and post-implementation stabilization activities.
• Monitor and troubleshoot replication lag, Extract/Replicat failures, network interruptions, data inconsistencies, mapping conflicts, duplicate transactions, and performance issues.
• Collaborate with OCI infrastructure, network/security, Oracle DBA, Informatica, and EDW technical teams to resolve dependencies and support migration readiness.
• Support OCI setup, configuration, provisioning, access/privilege planning, capacity planning, monitoring, and operational-readiness activities.
• Create and maintain technical designs, configuration documentation, test plans, validation evidence, cutover procedures, rollback procedures, and operations runbooks.
• Support change control, issue management, root-cause analysis, knowledge transfer, and production-readiness reviews.
• Follow applicable VA security, architecture, configuration-management, and change-control processes.

Requirements:

• Minimum 10yearsof relevant experience inhands-on Oracle GoldenGate administration, configuration, deployment, troubleshooting, and production support experience.
• Direct experience migrating or upgrading 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 practical understanding of Oracle transaction processing and replication behavior.
• Experience with migration testing, data validation/reconciliation, cutover planning, and rollback planning.
• Strong troubleshooting, documentation, and communication skills.
• Ability to obtain and maintain required VA suitability/access authorization.

Preferred Qualifications:

• Direct experience deploying OCI GoldenGate while maintaining connectivity to on-premises Oracle source systems.
• Oracle RAC, Data Guard, RMAN, ASM, Oracle Enterprise Manager, and Oracle performance-tuning experience.
• OCI networking, IAM, vault/secrets management, logging/monitoring, compute, storage, and private/hybrid connectivity experience.
• Experience supporting high-volume data warehouses or other mission-critical enterprise data platforms.
• Informatica PowerCenter, ETL/ELT, automated data reconciliation, or test-automation experience.

  Salary Range

  $98,153.18—$120,000 USD

  9thWay Insignia’s range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.

  Clearance/Background Investigation

  Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information.

  Benefits

  Eligible employees will have access to our comprehensive benefits package which includes Medical, Dental, Vision, Voluntary Life Insurance, 401(k), Basic Life A&D, STD, LTD, PTO, Telehealth, paid holidays, FSA, HSA. Additional resources include our Employee Assistance Program (EAP) and Traveling Assistance.

  Legal

  We’re an equal employment opportunity employer that empowers our people to fearlessly drive change – no matter their race, color, religion, sex (including pregnancy, childbirth, lactation, or related medical conditions), national origin, age, marital status, sexual orientation, gender identity, disability, veteran status, military or uniformed service member status, genetic information, or any other status protected by applicable federal, state, or local law.

  Equal Employment Opportunity Notice

  Applicants have the right to be free from unlawful workplace discrimination. Please review the EEOC’s Know Your Rights: Workplace Discrimination is Illegal notice. Accessible formats and translations are also available from the EEOC.

  Application Accommodations

  If you require a reasonable accommodation to complete this application or participate in the hiring process, please contact [e-mail]. Requests will be considered individually.