Remote DB2/DataStage Consultant — SPC & EPR Modernization

Consult; Greater London; Hybrid; GBP 111,000 - 185,000; Part time

Job summary

Consult is seeking an experienced DB2 Consultant for a remote, one-year contract focused on IBM Db2/Db2 Warehouse, SQL Server, and data migration projects within complex enterprise environments.

You will redesign reporting and metrics processes, convert SQL Server logic to Db2-compatible solutions, and guide integration of historical data with a new Electronic Patient Record (EPR) platform.

Qualifications

• Strong hands-on experience with IBM Db2 and Db2 Warehouse.
• Advanced knowledge of Microsoft SQL Server and T-SQL scripting.
• Experience converting SQL Server-based solutions to Db2 environments.
• Strong ETL and data integration experience, ideally with IBM DataStage.

Responsibilities

• Review and analyse SQL Server script.
• Identify and document the core business and technical logic.
• Design and develop a modular replacement solution using DataStage and Db2.
• Convert SQL Server-specific functions and processes into Db2-compatible equivalents.
• Create intermediate data structures and temporary tables where appropriate.
• Conduct testing and validation to ensure accuracy and performance.
• Produce technical documentation and operational procedures.
• Deliver knowledge transfer and handover sessions to internal teams.

Skills

IBM Db2

Db2 Warehouse

Microsoft SQL Server

T-SQL scripting

DataStage

ETL

Data integration

Reporting solutions

Performance tuning

Stakeholder engagement

Tools

DataStage

Db2

SQL Server

Job description

Consult is seeking an experienced DB2 Consultant for a remote, one-year contract focused on IBM Db2/Db2 Warehouse, SQL Server, and data migration projects within complex enterprise environments.

You will redesign reporting and metrics processes, convert SQL Server logic to Db2-compatible solutions, and guide integration of historical data with a new Electronic Patient Record (EPR) platform.