at Pegasus Knowledge Solutions Inc. in Schaumburg, Illinois, United States
Job Description
REQUIRED SKILLS Must have minimum 5 years of working experience with :1. Oracle GoldenGate; including large scale DDL and DML replication
2. Oracle RAC and ASM
3. Oracle RMAN
4. Shell scripting Nice to Have 1. Using GoldenGate for production database migration, Deploy GoldenGate using micro-service architecture
2. Oracle Exadata
3. Oracle multi-tenant architecture
Description : Administer and maintain the security and integrity of the databases. Implement data models and database designs, data access and table maintenance codes. Resolve database performance issues, database capacity issues, replication, and other distributed data issues. Lead the efforts of installing and maintaining database management software.
Responsibilities
• Work with the Information / Data Architect and Database Designer / Modeler to help implement the physical data model for the development and / or production environments
• Help develop and validate the database implementation plan
• Support the data loads into the databases
• Create database objects and maintain their physical organization / relationships • Develop and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities • Manage the on-site backup and recovery process and / or support of the off-site backup and recovery teams
• Plan for and execute any required database upgrades and migration (patches, etc.)
