Oracle-DB Administration

Oracle-DB Administration
Location - Tampa FL

Type - Fulltime

Job Description:

• Oracle DBA With Golden Gate
• Hands on experience on Oracle DBA
• Excellent understanding of Database concepts including Procedures, Triggers, Packages, Database Constraints, Indexes using Oracle 11g
• Configure and build Golden Gate Extracts/replicate for multiple databases.
• External certificate: Oracle Developer or golden gate
• Configure error handling for restart, logging, production support and status reporting in Golden Gate.
• Identify and produce documentation of best practices.
• Trouble shooting and performance tuning Golden Gate replications.
• Implementing necessary monitoring scripts for Golden Gate in UNIX/PERL scripting
• Deep understanding Oracle Golden Gate internal mechanism, OGG new features such as Integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicate
• Provide Golden Gate solutions
• Troubleshoot/resolve complex production data issues, Index Strategy (i.e. Fragmentation), Maintain Statistics (Update Statistics), Query Tuning (i.e. Execution Plans, Indexes), Performance Tuning (Server Config, WAIT Stats), Schema Design (i.e. Partitioning), DB Architecture (Table Design), HA Solutions, DR/COB Solutions, Application Entitlements, Security Review, Archiving/Historical Data