Haystack
← Back to Jobs
Remote
Other
HS

Senior DB2 Migration Consultant

Hierarch Soft Technologies, Inc.United States🇺🇸United StatesPosted 3 Sept 2026

Why This Role Stands Out

This remote role offers a unique opportunity to lead a critical data migration project, leveraging your expertise in DB2 and Oracle for a reputable company. You'll thrive here if you're a seasoned consultant eager to tackle complex technical challenges and deliver impactful results in a flexible work environment.

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

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

Browse related jobs

Apply now