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.