Senior DB2 to Aurora PostgreSQL Migration Lead

iCrest Sdn Bhd; Kuala Lumpur; On-site; MYR 180,000 - 280,000; Full time

Job summary

iCrest Sdn Bhd in Kuala Lumpur seeks a Senior Database Developer with deep IBM DB2 expertise and proven migration experience to AWS RDS Aurora PostgreSQL. You will lead large-scale migrations, ensure data integrity, and optimize performance across the database stack.

The role requires designing schemas, implementing migration strategies, and collaborating with cloud architects, developers and DevOps to automate data conversion, validation, and rollback planning, while mentoring junior engineers.

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field.
• 7+ years of DB development and management experience.
• Proven DB2 architecture and AWS Aurora PostgreSQL migration experience.

Responsibilities

• Lead end-to-end migration of IBM DB2 to AWS RDS Aurora PostgreSQL.
• Design and optimize schemas and migration strategies for performance.
• Collaborate with cloud architects, developers, and DevOps for data transitions.
• Develop scripts to automate data conversion, transformation, and validation.
• Assess structures and align with AWS best practices and PostgreSQL standards.
• Monitor and tune performance after migration.
• Troubleshoot migration issues and data anomalies.
• Ensure security, compliance, and data governance during migration.
• Create detailed migration plans, data mappings, and rollback strategies.
• Provide mentorship to junior engineers.

Skills

PostgreSQL development

ETL & data transformation

Python / Shell scripting

Data modeling & normalization

Migration tooling expertise

SQL performance tuning

Communication skills

Education

Bachelor’s or Master’s degree in Computer Science or related field

Tools

IBM DB2

AWS RDS Aurora PostgreSQL

AWS DMS

Schema Conversion Tool

RDS/S3

Terraform

CloudFormation

Git

CI/CD tooling

Job description

iCrest Sdn Bhd in Kuala Lumpur seeks a Senior Database Developer with deep IBM DB2 expertise and proven migration experience to AWS RDS Aurora PostgreSQL. You will lead large-scale migrations, ensure data integrity, and optimize performance across the database stack.

The role requires designing schemas, implementing migration strategies, and collaborating with cloud architects, developers and DevOps to automate data conversion, validation, and rollback planning, while mentoring junior engineers.