Oracle DBA - Consultant
1.Around 3 to 6 years of good working experience with GoldenGate DBA activities like supporting Oracle GoldenGate implementations, Upgrades, ongoing maintenance for Oracle GoldenGate12c, 11g versions.
2.247 support in rotational shifts
3.DB health check monitoring. Knowledge of OEM, GGSCI, etc.
4.Good knowledge of EXPDP IMPDP / traditional export import
5.Experience in DB / GoldenGate issues troubleshooting.
6.Experience in database migrations, also migration using GoldenGate preferably large databases.
7.Performance tuning of GoldenGate Extract, Pump Replicate processes
8.Knowledge of database design and be responsible for integrity of physical database design.
9.Good understanding of Oracle Database Architecture.
10.Good understanding of HA, RAC, ASM etc.
11.Provide technical support to application development / support team.
12.Responsible for maintaining multiple development / test / prod environments.
13.Monitoring and optimizing system performance using index tuning, disk optimization, and other methods.
14.Providing tuning recommendations to developers related to PL / SQL, assisting them on expensive queries.
15.Allocating system storage and planning future storage requirements for all database systems.
16.Experience in BT projects would be an added advantage