Oracle Golden Gate Database Administrator

Yochana; Plano (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology services company based in Texas is seeking an expert in Oracle database administration. The role focuses on database installation, performance tuning, and Golden Gate configuration. Ideal candidates will have deep knowledge of Oracle environments, backup strategies, and alert management. This is a key role requiring strong problem-solving and technical skills.

Qualifications

• Understanding of Oracle architecture and database administration.
• Experience with performance tuning and logical backup strategies.
• Knowledge of Golden Gate configuration and troubleshooting.

Responsibilities

• Manage Oracle database installation, upgrades, and patching.
• Perform OEM monitoring and alert resolution related to databases.
• Execute backup and recovery strategies effectively.

Skills

Oracle architecture understanding

Database administration

Performance tuning

Shell scripting

Backup and recovery knowledge

Tools

Oracle

Golden Gate

RMAN

Job description

Responsibilities

• Oracle architecture understanding and database administration
• Oracle software installation, upgrades, patching, database creation & configuration knowledge
• Performance tuning
• Logical backup strategy (Like Data Pump or exp, expdp)
• Managing schemas, creation of schemas and objects
• OEM monitoring of DB
• Alert resolution related to DB like (ORA-)
• Shell scripting and space management
• Backup and recovery (Online / Offline) knowledge
• Knowledge of report generation AWR/ADDM/ASH
• Data Guard configuration Knowledge
• Knowledge of logical and physical DB configuration like db parameters
• RMAN backup and restore
• Installation, Golden Gate configuration and troubleshooting
• Monitoring LAG and RBA, Log Dump; knowledge of discard and report file parameter
• Well knowledge of GG processes like (Mgr/ extract / Pump / Replicat)
• Alert resolution, HANDLECOLLISIONS, Different stage of Processes
• Patch and upgrade of Golden Gate
• Mapping error resolution and Defgent creation
• Well knowledge of table addition in Golden Gate and syncing table
• Stop and start of GG process in standalone or RAC based GG DB server