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:

- Bachelors or masters 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).