Principal / Lead Data Migration Architect

ikas international (asia) pte. ltd.; Singapore; On-site; SGD 180,000 - 240,000; Full time

Job summary

iKas International (Asia) Pte Ltd is seeking a Principal / Lead Data Migration Architect to drive the data migration strategy for a large-scale enterprise platform transformation, leading complex legacy migrations to a cloud-native platform and ensuring data integrity and business continuity.

You will partner with Architects, engineering, product managers, and stakeholders to define strategies, modernise data models, and establish a scalable data foundation for future capabilities, with a focus

Qualifications

• 10+ years in enterprise database architecture or data migration on large platforms.
• Proven track record delivering legacy modernisation or platform transformations.
• Expert SQL and database performance optimisation experience.
• Strong enterprise data modelling and normalised transactional models.
• Hands-on ETL/ELT design and migration framework experience.
• Data validation, reconciliation, and migration QA expertise.
• Familiarity with CDC, replication, and incremental migration strategies.
• Experience with cloud databases (RDS/Aurora) and multi-terabyte migrations.

Responsibilities

• Define and own end-to-end data migration strategy for a large-scale platform modernisation.
• Analyse and reverse-engineer legacy schemas, data models, and business rules.
• Design target data models aligned with cloud-native architectures.
• Develop phased migration approaches minimising disruption and risk.
• Lead data mapping, transformation, validation, reconciliation, and migration.
• Ensure data quality, lineage, and traceability throughout the lifecycle.
• Design and implement migration tooling, ETL/ELT pipelines, and reconciliation frameworks.
• Establish data governance for master/reference/historical data.
• Drive database optimisation, readiness, performance tuning, and cutover planning.
• Partner with cross-functional teams to transition processes to the new platform.

Skills

Data migration

Enterprise architecture

SQL performance

Cloud DB

Data modelling

CDC

ETL/ELT

Tools

Oracle

PostgreSQL

SQL Server

DB2

Amazon RDS

Aurora PostgreSQL

Job description

About the Role

We are looking for a Principal / Lead Data Migration Architect to drive the data migration strategy for a large-scale enterprise platform transformation. This role will lead the migration of complex legacy systems to a modern cloud-native platform, ensuring data integrity, business continuity, and seamless delivery throughout the transformation journey.

Working closely with architects, engineering teams, product managers, and business stakeholders, you will define migration strategies, modernise legacy data models, and establish a scalable data foundation for future business capabilities.

Key Responsibilities

• Define and own the end-to-end data migration strategy for a large-scale enterprise platform modernisation.
• Analyse and reverse-engineer legacy database schemas, data models, and business rules built over many years.
• Design target data models aligned with modern cloud-native architectures.
• Develop phased migration approaches that minimise business disruption and operational risk.
• Lead data mapping, transformation, validation, reconciliation, and migration activities between legacy and target platforms.
• Ensure data quality, integrity, lineage, consistency, and traceability throughout the migration lifecycle.
• Design and implement migration tooling, ETL/ELT pipelines, and automated reconciliation frameworks.
• Establish data governance practices covering master data, reference data, and historical data management.
• Drive database optimisation, migration readiness, performance tuning, and cutover planning.
• Partner with cross-functional teams to ensure business processes and operational workflows are successfully transitioned to the new platform.

Requirements

• 10+ years of experience in enterprise database architecture, large-scale data migration, or data platform engineering.
• Proven track record delivering complex legacy modernisation or platform transformation initiatives.
• Strong expertise with relational databases such as Oracle, PostgreSQL, SQL Server, DB2, or equivalent.
• Expert-level SQL skills and database performance optimisation experience.
• Strong knowledge of enterprise data modelling, including highly normalised transactional models.
• Hands-on experience designing ETL/ELT pipelines and migration frameworks.
• Experience with data validation, reconciliation, and migration quality assurance.
• Familiarity with Change Data Capture (CDC), replication technologies, and incremental migration strategies.
• Experience with cloud database platforms such as Amazon RDS, Aurora PostgreSQL, or similar managed database services.
• Experience migrating large-scale transactional databases (multi-terabyte or larger).
• Strong understanding of operational systems supporting high-volume business transactions.

Preferred Experience

• Experience delivering complex enterprise platform transformation programmes.
• Knowledge of high-availability database architecture and disaster recovery strategies.
• Experience with event-driven architectures and streaming technologies such as Kafka.
• Understanding of microservices architectures and distributed data management.
• Experience delivering zero- or near-zero-downtime migrations.
• Familiarity with enterprise data governance, auditability, and compliance best practices.

For more information you can contactNorean Tan at [e-mail]

We regret to inform you that only shortlisted candidates will be notified / contacted.

EA Registration No.: R1434118- Tan Lee Ying, Norean

iKas International (Asia) Pte Ltd

ROC No.: 200914065E | EA License No.: 16S8086