Why This Role Stands Out
This remote Senior DB2 Consultant role offers a significant opportunity to lead a large-scale data migration, showcasing your expertise and driving impactful project outcomes. If you possess strong DB2 and Oracle migration skills, thrive in independent, remote environments, and are looking to apply your talents to a critical project, this is an excellent chance to contribute.
Quick Overview
Seniority
Mid Senior
Work mode
Remote
Location
United States
Posted
6 days ago
Oracle
Job Description
Position: Senior DB2 resource
Location: Remote
Duration:3-6 months
Must have Security Clearence
Requirement
Migrate 600GB of data from Oracle to Db2 supporting Maximo, residing in each of 4 environments (dev/test/preprod/prod).
Scope Assumptions
-
That Maximo uses exactly the same set of tables and directly equivalent table structure in both Oracle and Db2.
-
Standard Db2 Maximo tables will be created as part of the Maximo Db2 installation
-
Any custom objects (tables, indexes, triggers, views, synonyms, functions and stored procedures) that are not created as part of the Maximo Db2 installation, but that are required to be migrated will be identified by the customer.
-
All in scope tables will be truncated and contents fully replaced with the data from the Oracle tables.
-
Any tables to be excluded from the data migration will be identified by the customer.
-
A Maximo SME will validate the data migration design, ensuring that the correct set of data is in scope for migration.
-
Legacy Oracle database will be local enough to the DB2 database to allow direct connection (firewalls can be opened).
Pre-requisites
-
Maximo installed on Db2 at the same version/patch level as the existing Maximo Oracle installations.
Similar jobs
- SG
Lab Tech Ops - Central Weigh - 2nd Shift
NewSoftware Guidance & Assistance
Branchburg, NJ🇺🇸HybridYesterdayComplianceContinuous ImprovementInventory Management+2 - SG
Oligonucleotide Scientist II
NewSoftware Guidance & Assistance
South San Francisco, CA🇺🇸HybridYesterday - TI
Third-Party Relationship Management
TIAA
Frisco, TX🇺🇸$124k - $174k/yrOn-site3 days agoBusiness DevelopmentLESS - TI
Third-Party Relationship Management
TIAA
Chicago, IL🇺🇸$124k - $174k/yrOn-site3 days agoBusiness DevelopmentLESS - CM
Automated Data Processing Equipment Custodian
NewChenega MIOS
Wright-Patterson Air Force Base, OH🇺🇸HybridYesterdayComplianceInventory ControlTalent Acquisition - AG
Low Voltage Technician - Onsite
NewApTask Global Workforce
Orlando, FL🇺🇸$46/hrOn-siteYesterdayFiber