DB2 Migration Consultant

Hierarch Soft Technologies, Inc.

United States

3 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Databases Data Migration IBM DB2 Oracle Databases Oracle (Applications) SQL Stored Procedures

Job description

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

Requirements

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com

Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

Moments

Explore playlists

1:22 min

Prerequisite steps for successful tool and data migration

Sérgio Sancho Pinto · Europe 2026 Virtual

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

3:49 min

Audience questions on database migration and data compliance

Jürgen Pilz · World Congress 2023

2:09 min

Slicing the core legacy database for safe migration

Steffen Heilmann · World Congress 2021

3:18 min

Executing background data migrations using AzCopy

Radu Vunvulea · World Congress 2022

4:01 min

Managing application isolation via pluggable database models

Wei Hu · World Congress 2022

Videos

See all

Swapping a Data Warehouse at Runtime: Zero-Downtime Migration Without Changing a Single Client thumbnail