Job Summary :
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).Candidates are willing to relocate to Malaysia are encouraged to apply