Database Architect

Adecco Portugal; Polska; A distancia; PLN 180.000 - 260.000; Jornada completa

Descripción de la vacante

Adecco Portugal is seeking a senior Database Architect / Mainframe Database SME for a 12-month B2B engagement in Poland (remote). The role focuses on designing target data architecture, leading complex migrations from legacy mainframe databases to PostgreSQL, and ensuring data integrity, performance, and quality throughout the modernization journey.

The candidate will helm end-to-end migration strategies, model data, and establish governance, with deep expertise in DB2, VSAM, IMS, and enterprise

Formación

• Total Experience: 10+ years.
• Relevant Experience: 5+ years in Database Architecture, Data Migration, or Mainframe Modernization.
• Strong experience in Database Architecture and Enterprise Data Modeling.
• Proven expertise in Data Migration Design and execution.
• Experience developing Data Quality Strategies and governance frameworks.
• Hands-on with DB2-to-PostgreSQL conversions.
• Experience migrating VSAM datasets to relational databases.
• Knowledge of IMS hierarchical databases and conversion methodologies.
• Strong Data Lineage, metadata management, and governance understanding.
• Expertise in Index Design, tuning, and performance optimization.
• Experience in large-scale legacy modernization or mainframe transformation initiatives.

Responsabilidades

• Define and govern the target data architecture for modernization programs.
• Design logical and physical data models aligned with business and technical requirements.
• Develop end-to-end data migration strategies and conversion approaches.
• Lead migration activities from legacy mainframe databases to PostgreSQL.
• Design and implement data quality frameworks, validation processes, and reconciliation strategies.
• Collaborate with application, infrastructure, and business teams throughout the migration lifecycle.

Conocimientos

Database Architecture

Data Migration

Mainframe Modernization

DB2 to PostgreSQL

PostgreSQL

Data Modeling

Data Quality

Data Lineage

Index Design

Performance Tuning

Herramientas

DB2

VSAM

IMS

PostgreSQL

Descripción del empleo

For our client we are looking for a specialist of Database Architect / Mainframe Database Subject Matter Expert (SME)

Location: Poland (remote)

Employment Type: Full-time

Experience Level: senior

Contract type: B2B Contract

Contract duration: 12 months with a strong possibility of later extension. The client is looking for long-term cooperation.

About the Role

We are seeking an experienced Database Architect / Mainframe Database Subject Matter Expert (SME) to play a key role in a large-scale data modernization initiative. The successful candidate will be responsible for designing the target data architecture and leading complex database migration activities from legacy mainframe platforms to modern PostgreSQL environments.

This role requires deep expertise in data architecture, data modeling, migration strategies, and legacy database conversion, with a strong focus on ensuring data integrity, performance, and quality throughout the transformation journey.

Key Responsibilities

• Define and govern the target data architecture for modernization programs.
• Design logical and physical data models aligned with business and technical requirements.
• Develop end-to-end data migration strategies and conversion approaches.
• Lead migration activities from legacy mainframe databases to PostgreSQL.
• Design and implement data quality frameworks, validation processes, and reconciliation strategies.
• Support conversion of:
• DB2 databases to PostgreSQL
• VSAM files to PostgreSQL
• IMS hierarchical databases to PostgreSQL
• Establish and maintain data lineage documentation and governance standards.
• Design indexing strategies and database optimization approaches to ensure scalability and performance.
• Collaborate with application, infrastructure, and business teams throughout the migration lifecycle.
• Identify migration risks and recommend mitigation strategies.

Required Skills & Experience:

• Total Experience: 10+ years
• Relevant Experience: 5+ years in Database Architecture, Data Migration, or Mainframe Modernization
• Strong experience in Database Architecture and Enterprise Data Modeling.
• Proven expertise in Data Migration Design and execution.
• Experience developing Data Quality Strategies and governance frameworks.
• Hands-on experience with DB2-to-PostgreSQL conversion projects.
• Experience migrating VSAM datasets to relational database platforms.
• Knowledge of IMS hierarchical databases and conversion methodologies.
• Strong understanding of Data Lineage, metadata management, and governance practices.
• Expertise in Index Design, database tuning, and performance optimization.
• Experience working on large-scale legacy modernization or mainframe transformation initiatives.