Customer success story

Global Infrastructure Maintenance and Support

  1. 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.

  2. The Client: One of the world's largest asset management and financial services institutions.

  3. 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.

  4. 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.

  5. Project: 

    1. Configured Goldengate components for unidirectional and bidirectional replications and maintained data synchronization.

    2. Supporting different OGG versions Ex. 12c,18c,19c

    3. Supporting Installation, configuration, upgrades, migration activities in Goldengate

    4. Performed activities like initial load, syncing source and target with real time data flow, XAG configuration

    5. Monitoring OGG processes using OEM and Shell script, created shell scripts to identify Goldengate errors

    6. Troubleshooting day in day out performance issues related to Goldengate

    7. Troubleshooting various Goldengate issues like Data mismatch,character set conversion,TCP/IP connection, etc

    8. Experience using defgen and Log dump utilities in-order to resolve the issues in Goldengate

    9. Documented all Oracle Goldengate installations, configurations

    10. Performed POCs on Goldengate Microservices

    11. Migration of Goldengate processes from ZFS file-system to ACFS file-system

    12. Configuration of Oracle ACFS Replication to ensure high availability of services

  6. Day to Day tasks:

    1. Process Creation

    2. Loading Existing data from source to target

    3. Synching up source and target with real time data flow

    4. Ensuring high availability for goldengate

  7. Monitoring

    1. Monitoring Using OEM (Oracle Enterprise Manager)

    2. Monitoring using shell scripting

  8. Goldengate Administration

    1. Installation of Goldengate

    2. Goldengate Upgrades

    3. Golden Gate Migrations

    4. Goldengate Patching

  9. Troubleshooting

    1. Performance Issues

    2. Troubleshooting OGG-Errors

More related stories

Wanna read more? See all Case Studies