Overview
Skills
Job Details
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-)
Oracle database security (users, profiles, privs, roles, etc.)
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
Golden Gate:
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 / Replicate)
Alert resolution, HANDLECOLLISIONS, different stages of processes
Patch and upgrade of Golden Gate
Mapping error resolution and Defend 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