Senior Database Developer – DB2 to AWS Aurora PostgreSQL Migration

iCrest sdn bhd

Kuala Lumpur

On-site

MYR 180,000 - 280,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

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).
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior DB2 to Aurora PostgreSQL Migration Lead
Senior DB2 to Aurora PostgreSQL Migration Lead

iCrest sdn bhd • Kuala Lumpur

On-site
MYR 180,000 - 280,000
DB2 to AWS Aurora PostgreSQL Architect (Contract)
DB2 to AWS Aurora PostgreSQL Architect (Contract)

Figulus Solutions Private Ltd • Kuala Lumpur

On-site
MYR 120,000 - 180,000
Database Solution Architect – DB2 to AWS Aurora PostgreSQL (Contract) | Kuala Lumpur
Database Solution Architect – DB2 to AWS Aurora PostgreSQL (Contract) | Kuala Lumpur

Figulus Solutions Private Ltd • Kuala Lumpur

On-site
MYR 120,000 - 180,000
Database Engineer / Data Platform Engineer (AWS, PostgreSQL & NoSQL)
Database Engineer / Data Platform Engineer (AWS, PostgreSQL & NoSQL)

techstreet • Kuala Lumpur

On-site
MYR 150,000 - 230,000
Database Engineer: AWS, PostgreSQL & NoSQL for AI-Ready Data
Database Engineer: AWS, PostgreSQL & NoSQL for AI-Ready Data

techstreet • Kuala Lumpur

On-site
MYR 150,000 - 230,000
AWS CLOUD DBA
AWS CLOUD DBA

Randstad Malaysia • Petaling Jaya

On-site
MYR 102,000 - 122,000
Senior Database Engineer - Banking / Fintech
Senior Database Engineer - Banking / Fintech

Capcon Asia • Kuala Lumpur

Hybrid
MYR 180,000 - 240,000
Hybrid work arrangement (1 day WFH)
Senior Database Administrator | Cloud, HA/DR & Performance
Senior Database Administrator | Cloud, HA/DR & Performance

iBroad Solutions • Petaling Jaya

On-site
MYR 120,000 - 180,000
Senior Database Administrator
Senior Database Administrator

BTSE • Kuala Lumpur

On-site
MYR 120,000 - 180,000
Competitive compensation package
Team-building programs
Company events
Sr. Delivery Consultant - Migrations and Modernization, AWS Professional Services, ASEAN
Sr. Delivery Consultant - Migrations and Modernization, AWS Professional Services, ASEAN

Amazon Inc. • Kuala Lumpur

On-site
MYR 180,000 - 300,000