Oracle GoldenGate consultant

SOMERSET STAFFING; Richmond (VA); On-site; USD 110,000 - 170,000; Full time

Job summary

SOMERSET STAFFING is seeking an experienced Oracle Database Administrator (DBA) with deep Oracle GoldenGate expertise to support mission-critical enterprise applications and large-scale databases. The role covers RAC, Data Guard, Exadata, replication, DR planning and ensuring high availability across production, DR, UAT, and development environments.

The ideal candidate will manage Oracle databases in complex environments, implement GoldenGate replication, optimize performance, perform

Qualifications

• Minimum 5+ years in Oracle DB administration in enterprise environments.
• Experience with Oracle RAC, Data Guard, Exadata, and GoldenGate.
• Strong knowledge of RMAN, OEM, and performance tuning.

Responsibilities

• Administer, monitor, and maintain Oracle databases (Prod/DR/UAT/Dev).
• Install, patch, upgrade, and maintain Oracle environments.
• Manage RAC, ASM, Data Guard, Exadata platforms and capacity planning.

Skills

Strong customer-facing communication

Leadership in technical discussions

Troubleshooting and analytical skills

Tools

Oracle Database

Oracle RAC

Oracle Data Guard

Oracle ASM

RMAN

Oracle GoldenGate

GoldenGate Microservices

Replication Monitoring

Linux/Unix

Shell Scripting

OCI

GCP knowledge

OEM

Ansible

Automation Scripting

Control-M

Job description

Role Summary

We are seeking an experienced Oracle Database Administrator DBA with deep expertise in Oracle GoldenGate to support missioncritical enterprise applications and largescale database environments The role will be responsible for Oracle database administration GoldenGate replication architecture performance optimization disaster recovery planning database migrations and ensuring high availability of businesscritical systems

The ideal candidate should have strong experience managing Oracle databases in complex enterprise environments including Oracle RAC Data Guard Exadata and GoldenGate implementations supporting realtime data replication and migration initiatives

Key Responsibilities

• Oracle Database Administration
• Administer monitor and maintain Oracle Database environments 12c 19c and above
• Install configure patch upgrade and maintain Oracle databases across Production DR UAT and Development environments
• Manage Oracle RAC ASM Data Guard and Exadata platforms
• Perform capacity planning storage management and database health assessments
• Implement and manage RMAN backup restore and recovery strategies
• Ensure database security compliance and governance standards are maintained
• Oracle GoldenGate Administration
• Design implement configure and support Oracle GoldenGate replication solutions
• Manage Extract Pump and Replicat processes across heterogeneous environments
• Monitor replication performance and resolve latency synchronization and data consistency issues
• Configure bidirectional and unidirectional replication architectures
• Support zerodowntime database migration and cutover activities using GoldenGate
• Perform GoldenGate patching upgrades performance tuning and troubleshooting
• Lead replication testing validation and disaster recovery exercises
• High Availability Disaster Recovery
• Design and support High Availability HA and Disaster Recovery DR solutions
• Plan and execute Data Guard switchovers failovers and role transitions
• Ensure replication integrity and business continuity across primary and DR environments
• Conduct periodic DR drills and validate recovery processes
• Performance Incident Management
• Troubleshoot complex database and replication issues
• Perform Root Cause Analysis RCA and implement permanent corrective actions
• Analyze AWR ASH OEM and GoldenGate reports to optimize database performance
• Participate in critical incident Major Incident Review MIR and Post Incident Review PIR calls
• Provide proactive monitoring and preventive maintenance recommendations
• Migration Transformation Initiatives
• Support database migration projects involving Oracle DB2 Exadata cloud and hybrid environments
• Participate in application modernization and cloud migration programs
• Develop migration runbooks cutover plans and rollback strategies
• Ensure successful execution of database and replication migration activities with minimal downtime
• Stakeholder Management
• Act as the primary onsite DBA liaison for customer teams architects infrastructure teams and application owners
• Coordinate with offshore database and middleware teams
• Provide technical guidance mentoring and operational oversight
• Participate in governance architecture and operational review meetings

Required Technical Skills

• Oracle Database
• Oracle Database Administration 12c19c21c
• Oracle RAC
• Oracle Data Guard
• Oracle ASM
• Oracle Enterprise Manager OEM
• RMAN Backup Recovery
• Performance Tuning
• Database Security Auditing
• Database Upgrades and Patch Management
• Oracle GoldenGate
• Oracle GoldenGate Administration
• GoldenGate Microservices Architecture
• Replication Design Implementation
• ActiveActive and ActivePassive Replication
• Data Migration and Synchronization
• Replication Monitoring Troubleshooting
• Heterogeneous Database Replication
• Infrastructure Cloud
• Oracle Exadata
• LinuxUnix Administration
• Shell Scripting
• Oracle Cloud Infrastructure OCI
• Google Cloud Platform GCP knowledge preferred
• Networking concepts related to database replication
• Tools Automation
• OEM Monitoring
• Ansible
• Automation Scripting
• ITSM Tools ServiceNow preferred
• DevOps and CICD awareness

Preferred Experience

• Experience supporting large healthcare pharmaceutical supply chain or ERP environments
• Experience with JD Edwards JDE environments
• Experience with OracletoOracle and DB2toOracle migration projects
• Experience supporting Exadata and cloudhosted Oracle workloads
• Knowledge of ControlM and enterprise batch processing environments

Soft Skills

• Strong customerfacing communication skills
• Ability to lead technical discussions and architecture reviews
• Excellent troubleshooting and analytical skills

Required Skills :

Basic Qualification :

Additional Skills :

Background Check : No

Drug Screen : No