[Remote] DB2 Migration Engineer - Azure Data Platform
Note: The job is a remote job and is open to candidates in USA. Kforce Inc is looking for a hands-on DB2 Migration Engineer to assist in migrating DB2 databases and data workloads to Microsoft Azure. The role involves assessing source environments, converting database objects, migrating data, and supporting production cutover to Azure platforms.ResponsibilitiesAssess DB2 environments, including schemas, tables, indexes, views, stored procedures, functions, triggers, dependencies, and data volumesIdentify workload types (transactional, analytical, reporting, or application-dependent)Support migration planning, including target architecture, wave strategy, remediation backlog, testing, and cutover approachUse tools such as SQL Server Migration Assistant for Db2, Azure Data Factory, and Synapse Pipelines for schema conversion and data movementConvert DB2 SQL, data types, and database objects into Azure-compatible structuresIdentify and resolve compatibility issues between DB2 and Azure platformsBuild and support pipelines for full, incremental, and change data capture (CDC) loadsValidate migrated data using reconciliation queries, row counts, and business-rule testingOptimize Azure performance through indexing, statistics, partitioning, and query tuningCollaborate with application teams to assess dependencies, integrations, and impactsSupport testing phases (integration, performance, UAT), cutover, and post-production stabilizationDocument migration designs, decisions, validation results, and operational runbooksSkillsStrong hands-on experience with IBM DB2, preferably DB2 LUW, DB2 z/OS, or DB2 for iStrong SQL development experience, including DB2 SQL and T-SQLExperience migrating DB2 databases to Azure SQL Managed Instance, Azure SQL Database, SQL Server, Azure Synapse, or equivalent cloud data platformsExperience with SQL Server Migration Assistant for Db2 or similar migration assessment/conversion toolingExperience with Azure Data Factory, Synapse Pipelines, or other enterprise data movement toolsStrong understanding of DB2 database objects, including schemas, tables, indexes, views, stored procedures, functions, triggers, packages, and constraintsExperience with DB2 data type mapping, SQL conversion, stored procedure remediation, and application dependency analysisExperience with full load, incremental load, and CDC/change data capture strategiesStrong data validation and reconciliation experienceAbility to support production cutover planning and post-migration issue resolutionStrong communication skills and ability to work across database, application, infrastructure, and business teamsExperience with DB2 z/OS and mainframe-connected applicationsExperience with COBOL, JCL, VSAM, CICS, batch jobs, or mainframe integration pointsExperience with Azure SQL Managed Instance, Azure SQL Database, Azure Synapse Analytics, Azure Databricks, and ADLS Gen2Experience with Q Replication, IBM CDC, Kafka, Event Hubs, or other CDC technologiesExperience with ETL tools such as IBM DataStage, Informatica, SSIS, Control-M, Autosys, or shell scriptingExperience with security, encryption, RBAC, private networking, Key Vault, Managed Identity, and audit requirements in AzureExperience in regulated enterprise environments such as banking, insurance, healthcare, or telecomBenefitsMedical/dental/vision insuranceHSAFSA401(k)Life, disability & ADD insurance to eligible employeesSalaried personnel receive paid time offHourly employees are not eligible for paid time off unless required by lawHourly employees on a Service Contract Act project are eligible for paid sick leaveCompany OverviewKforce is a solutions firm specializing in technology, finance and accounting, and professional staffing services. It was founded in 1962, and is headquartered in Tampa, Florida, USA, with a workforce of 1001-5000 employees. Its website is https://www.kforce.com/.Company H1B SponsorshipKforce Inc has a track record of offering H1B sponsorships, with 134 in 2026, 792 in 2025, 667 in 2024, 734 in 2023, 843 in 2022, 1197 in 2021, 858 in 2020. Please note that this does not guarantee sponsorship for this specific role.