DB2 Migration Engineer - Azure Data
Core
Assessing, converting, and migrating IBM DB2 databases and workloads to Microsoft Azure platforms.
Role type
Senior DB2 Migration Engineer
Builds
Migrated data workloads on Azure SQL Managed Instance, Azure SQL Database, Azure Synapse, and Azure Databricks
Domain
Cloud Data Engineering / Database Migration
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
DB2 LUW, DB2 z/OS, DB2 for i, SQL development, DB2 SQL, T-SQL, Azure SQL Managed Instance, Azure SQL Database, Azure Synapse, SQL Server Migration Assistant for Db2, Azure Data Factory, Synapse Pipelines, data validation, reconciliation, cutover planning, schema conversion, data type mapping, stored procedure remediation, application dependency analysis, full loads, incremental loads, change data capture
Preferred skills
COBOL, JCL, VSAM, CICS, batch jobs, mainframe integration, Azure Databricks, ADLS Gen2, Q Replication, IBM CDC, Kafka, Event Hubs, ETL tools (DataStage, Informatica, SSIS, Control-M, Autosys), shell scripting, Azure security, encryption, RBAC, private networking, Key Vault, Managed Identity, regulated enterprise environments (banking, insurance, healthcare, telecom)
Technologies
Azure Cloud, COBOL, Databricks, ETL, IBM, IBM Db2, Informatica, Kafka, RBAC, SQL, Security, SSIS
Responsibilities
Assess DB2 environments including schemas, tables, indexes, views, stored procedures, functions, triggers, and dependencies; Identify workload types such as transactional, analytical, reporting, and application-dependent workloads; Support migration planning including target architecture, wave sequencing, remediation backlog, testing, and cutover strategy; Use tools like 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 gaps between DB2 and Azure platforms; Build and maintain pipelines for full, incremental, and CDC-based loads; Validate migrated data using reconciliation queries, row counts, and business-rule checks; Optimize Azure performance through indexing, statistics, partitioning, and query tuning; Collaborate with application teams to evaluate dependencies, integrations, and potential impacts; Support testing phases including integration testing, performance testing, UAT, cutover, and post-production stabilization; Document migration designs, technical decisions, validation outcomes, and operational runbooks
