Senior Database Developer – DB2 to AWS Aurora PostgreSQL Migration

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

Senior Database Developer – DB2 to AWS Aurora PostgreSQL Migration

We are seeking an experienced Senior Database Developer with deep expertise in DB2 databases and proven experience in migrating on-premises databases to AWS RDS Aurora PostgreSQL. The ideal candidate will play a key role in modernizing our database infrastructure, leading large-scale migrations, and ensuring data integrity, performance, and scalability throughout the process.

Key Responsibilities:

• Lead the end-to-end migration of IBM DB2 databases from on-premises environments to AWS RDS Aurora PostgreSQL.
• Design, implement, and optimize database schemas and migration strategies for performance and reliability.
• Work closely with cloud architects, application developers, and DevOps teams to ensure smooth data transitions.
• Develop scripts and tools to automate data conversion, transformation, and validation processes.
• Assess existing database structures and suggest improvements to align with AWS best practices and PostgreSQL standards.
• Monitor and tune database performance post-migration.
• Troubleshoot complex migration issues and data anomalies.
• Ensure security, compliance, and data governance standards are met throughout the migration lifecycle.
• Create detailed documentation including migration plans, data mappings, and rollback strategies.
• Provide guidance and mentorship to junior database engineers as needed.

Required Qualifications:

• Bachelor’s or master’s degree in computer science, Information Systems, or related field.
• 7+ years of experience in database development and management.
• Strong hands-on experience with IBM DB2 database architecture and administration.
• Proven experience in migrating DB2 databases to AWS RDS Aurora PostgreSQL.
• Expertise in PostgreSQL development, including stored procedures, functions, indexing, and performance tuning.
• Proficient in ETL tools, data transformation, and scripting languages (Python, Shell, or equivalent).
• Familiarity with AWS services such as DMS (Database Migration Service), Schema Conversion Tool, RDS, and Aurora.
• Strong understanding of data modelling, normalization, and database optimization techniques.
• Excellent problem-solving skills and attention to detail.
• Strong verbal and written communication skills.

Preferred Qualifications:

• AWS Certification (e.g., AWS Certified Database – Specialty, AWS Certified Solutions Architect).
• Experience with CI/CD practices and infrastructure as code (Terraform, CloudFormation).
• Familiarity with DevOps tools and concepts (e.g., Git, Jenkins, Ansible).