Global Infrastructure Maintenance and Support
Executive Summary / Key Highlights:
- The DBA and SA On-Call support team works in shifts a
- Provide Exadata, Netezza, OS, Hardware and Database support to all the business environments
- Including Production, DR, BUAT, UAT and DEV.
The Client: One of the world's largest asset management and financial services institutions.
Problem Statement: Our client needed 24/7/365 M&S for their critical databases. Maxima was selected as the sole support provider after a previous big name vendor was unable to meet our client expectations.
Solution: For over 10 years Maxima is proud to support one of the most critical database infrastructures for our client as well as for the financial services industry. Utilizing our onshore/offshore capabilities we've been successful in delivering a follow the sun model support plan with 0 escalations til date.
Configured Goldengate components for unidirectional and bidirectional replications and maintained data synchronization.
Supporting different OGG versions Ex. 12c,18c,19c
Supporting Installation, configuration, upgrades, migration activities in Goldengate
Performed activities like initial load, syncing source and target with real time data flow, XAG configuration
Monitoring OGG processes using OEM and Shell script, created shell scripts to identify Goldengate errors
Troubleshooting day in day out performance issues related to Goldengate
Troubleshooting various Goldengate issues like Data mismatch,character set conversion,TCP/IP connection, etc
Experience using defgen and Log dump utilities in-order to resolve the issues in Goldengate
Documented all Oracle Goldengate installations, configurations
Performed POCs on Goldengate Microservices
Migration of Goldengate processes from ZFS file-system to ACFS file-system
Configuration of Oracle ACFS Replication to ensure high availability of services
Day to Day tasks:
Loading Existing data from source to target
Synching up source and target with real time data flow
Ensuring high availability for goldengate
Monitoring Using OEM (Oracle Enterprise Manager)
Monitoring using shell scripting
Installation of Goldengate
Golden Gate Migrations