What are the responsibilities and job description for the Oracle DBA position at ApTask?
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
SQL Server DBA
Made4net LLC. -
Teaneck, NJ
Senior Database Administrator (DBA) – SaaS Production Environment
Own Company -
Englewood, NJ
Oracle Cloud Finance - Director
Jooble -
Arlington, NJ
