Database Migration Engineer - DB2/Python

Description :

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.

- Ensure security, compliance, and data governance standards are met throughout the migration lifecycle.

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.