• Find preferred job with Jobstinger
  • ID
    #7265317
  • Job type
    Permanent
  • Salary
    USD $130K/Annum 130K/Annum
  • Source
    Vedainfo Inc.
  • Date
    2020-12-23
  • Deadline
    2021-02-21
 
Permanent

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:

Report job

Related Jobs

Jobstinger