DB2 Migration Engineer - Azure Data Platform

About this role

RESPONSIBILITIES:


Kforce has a client in Armonk, NY that is seeking a hands-on DB2 Migration Engineer to support the migration of DB2 databases and data workloads to Microsoft Azure. This role is responsible for assessing source environments, converting database objects, migrating data, resolving compatibility issues, validating outputs, and supporting production cutover to Azure platforms.


The ideal candidate has experience with DB2 LUW, DB2 z/OS, or DB2 for i, along with migrations to Azure SQL Managed Instance, Azure SQL Database, Azure Synapse Analytics, Azure Data Factory, or Azure Data Lake Storage Gen2.


Key Responsibilities:

• Assess DB2 environments, including schemas, tables, indexes, views, stored procedures, functions, triggers, dependencies, and data volumes
• Identify workload types (transactional, analytical, reporting, or application-dependent)
• Support migration planning, including target architecture, wave strategy, remediation backlog, testing, and cutover approach
• Use tools such as SQL Server Migration Assistant for Db2, Azure Data Factory, and Synapse Pipelines for schema conversion and data movement
• Convert DB2 SQL, data types, and database objects into Azure-compatible structures
• Identify and resolve compatibility issues between DB2 and Azure platforms
• Build and support pipelines for full, incremental, and change data capture (CDC) loads
• Validate migrated data using reconciliation queries, row counts, and business-rule testing
• Optimize Azure performance through indexing, statistics, partitioning, and query tuning
• Collaborate with application teams to assess dependencies, integrations, and impacts
• Support testing phases (integration, performance, UAT), cutover, and post-production stabilization
• Document migration designs, decisions, validation results, and operational runbooks

REQUIREMENTS:

• Strong hands-on experience with IBM DB2, preferably DB2 LUW, DB2 z/OS, or DB2 for i
• Strong SQL develo...