Oracle Golden Gate DBA

Role: Oracle Golden Gate DBA

Location: Plano, TX

The pay range for this role is $110,000 - $120,000 per annum

Oracle

1) Oracle architecture understanding and database administration

2) Oracle software installation, upgrades, patching, database creation & configuration Knowledge.

3) performance tuning,

4) Logical backup strategy ( Like Data Pump or exp,expdp)

5) managing schemas, creation of schemas and objects.

6) OEM monitoring of DB.

7) Alert resolution related to DB like (ORA-)

8) Oracle database security (users, profiles, privs, roles etc)

9) shell Scripting and Space management

10) back-up and recovery (Online / Offline ) knowledge.

11) knowledge of report generation AWR/ADDM/ASH .

12) Datagaurd configuration Knowledge

13) knowledge of logical and physical DB configuration like db parameters.

14) RMAN backup and restore .

Golden Gate

1) installation, Golden Gate configuration and troubleshooting.

2) Monitoring LAG and RBA , Log Dump. knowledge of discard and report file parameter

3) well knowledge of GG processes like (Mgr/ extract / Pump / Replicat)

4) Alert resolution, HANDLECOLLISIONS, Different stage of Processes

5) Patch and upgrade of golden gate.

6) Mapping error resolution and Defgent creation

7) Well knowledge of table addition in golden gate and syncing table.

8) stop and start of GG process in standalone or RAC based GG DB server