Database Administration Advisor

Responsibilities:

Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments

Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.

Performance Tuning OGG in extremely high data volume environments, Knowledge of logdump utility

Identify data synchronization issues

Remediate Data synchronization issues

Trouble shooting and performance tuning Golden Gate replications

Configure error handling for restart, logging, production support and status reporting in Golden Gate

Physical standby, Data Guard configuration, Maintenance and support for DR activities

Requirements:

Minimum 5 years Installing and configuring OGG heterogeneous environments

Minimum 5 years’ experience in Oracle Golden Gate replication, database server configuration, installation and troubleshooting Golden Gate extract and replicate issues

Minimum 5 years working knowledge of Oracle GoldenGate internal mechanism, OGG new features such as Integrated capture, native DDL capture, coordinate apply mode, multi-threaded replication

5 years demonstrate experience with Oracle 11g and 12c administrating RAC environment, knowledge of backup and restore techniques for medium to very large databases.

Preferences:

First hand experiences in setting up Oracle Golden Gate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions

Expertise in writing OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM (Oracle Enterprise Manager) 12c/ Golden gate management pack

You may return to your current search results by clicking here.

Latest Job Listings