Oracle Golden Gate Engineer

Oracle Golden Gate Engineer

23 Dec 2024
California, Pleasanton, 94566 Pleasanton USA

Oracle Golden Gate Engineer

Vacancy expired!

Location- Pleasanton CA, 94588
Industry- Groceries
Duration-Full Time
,GC-EAD will be considered
Implementation Partner/Client:
Client is a part of largest multinational business groups in North America.
And Client offers a consulting-led, cognitive powered, integrated portfolio of business, technology and engineering services and solutions.
End Client:
Client is an American grocery company and is the second-largest supermarket chain in North America.
Job Description:
Relevant Experience (in Yrs): 8-10 Years
Technical/Functional Skills:
Oracle Golden Gate (19c)
Configuring Source and target Oracle Golden Gate (19c) Agents, including collision resolution configuration for bi-directional replication.
Configure OGG for initial data load for configured tables in test as well as in production environment.
Roles & Responsibilities:
Configuring Source and target Oracle Golden Gate (19c) Agents, including collision resolution configuration for bi-directional replication.
In same table SELECT, INSERT, UPDATE and DELETE operation will happen on same tables, same row and same attributes in both database instances (DB2 & Azure).
Configure OGG for initial data load for configured tables in test as well as in production environment.
Execution of Test scenarios and Validation. Following activities involved in this step
Preparation create tables and load data in source DB2 tables. Table & data can be imported from existing SIMS test environments. Similarly, tables to be created in Azure SQL.
Execution There are DML scripts to be executed to simulate the user / batch operations on both database (DB2 and Azure SQL). This DML scripts will create bulk records.
Data transfer volume is expected to be high with high concurrency transactions.
Validation Once test execution completes, some data validation queries ("SELECT ") to be executed to validate if data is replicated correctly.
Analyze and report the latency/lag time based on volume of replication between mainframe and Azure DB.
As we progress with application migrations phases, number of tables to be replicated will gets increased.
Based on the performance feedback OGG configuration tuning (performance tuning) to be done.
The expectation is to extract/generate the reports from OGG to get replication statistics on performance, bottlenecks, collisions details, replication rates etc.
Analysis of existing mainframe application, data analysis as required
Generic Managerial Skills:
Good Communicator
Strong leadership
Interpersonal and Communication Skills.
Decision-Making Skills.
Education: Engineering or equivalent
Prescreening Questionnaire:
Have you worked on Oracle Golden Gate (19c)?
Have you handled the Bi-directional, Uni-directional,Collision, kind of use cases between the on Prem and Cloud?
Any retail domain exp and application solution experience?
Migration and Modernization exp. (Mainframe migration to Azure )?
Any Use cases experience?
How you handle the escalations?
Mainframe knowledge updates ?
Thanks & Regards

Victor Harris
Recruiter, Vedainfo Inc
P| E:

Related jobs

Job Details

  • ID
    JC7265317
  • State
  • City
  • Job type
    Permanent
  • Salary
    $130K/Annum
  • Hiring Company
    Vedainfo Inc.
  • Date
    2020-12-23
  • Deadline
    2021-02-21
  • Category

Jocancy Online Job Portal by jobSearchi.