The Role
We are seeking a highly skilled PostgreSQL Developer with extensive experience in DB2 to PostgreSQL migration, AWS-based ETL development, and data modernization initiatives. The ideal candidate will have strong expertise in PostgreSQL development, schema rationalization, data modelling, ETL frameworks, and AWS migration services such as AWS DMS and AWS Glue.
Your responsibilities:
The role will be responsible for transforming legacy DB2 databases into optimized PostgreSQL solutions on AWS while ensuring data integrity, performance, scalability, and compliance with enterprise architecture standards.
Your Profile
Key Responsibilities
• Lead end-to-end DB2 to PostgreSQL migration activities including assessment, schema conversion, data migration, validation, and cutover planning.
• Design, develop, and support PostgreSQL databases, including tables, views, indexes, functions, triggers, and stored procedures.
• Perform table rationalization, normalization, and schema optimization to improve data quality, performance, and maintainability.
• Support conceptual, logical, and physical data modelling activities in collaboration with architects and business stakeholders.
• Develop and maintain ETL pipelines using AWS Glue and implement Change Data Capture (CDC) solutions using AWS DMS.
• Analyze and transform source DB2 data structures into optimized target PostgreSQL data models.
• Convert and optimize DB2 Stored Procedures, SQL PL scripts, triggers, and batch processing logic into PostgreSQL PL/pgSQL.
• Conduct data mapping, reconciliation, and validation activities to ensure migration completeness and data integrity.
• Perform query tuning, database performance optimization, indexing, and capacity planning for PostgreSQL environments.
• Collaborate with application, data, and infrastructure teams to resolve migration and integration challenges.
• Support SIT, UAT, and Production deployment activities, including defect resolution and post-migration stabilization.
• Create technical documentation, migration runbooks, design specifications, and operational procedures.
• Ensure adherence to enterprise architecture, security, governance, and data management standards.
• Mentor junior developers and provide technical leadership throughout migration and modernization initiatives.
Essential skills/knowledge/experience:
Core Database Skills
• Strong PostgreSQL Development (PL/pgSQL, Views, Functions, Triggers, Stored Procedures)
• Database Performance Tuning and Query Optimization
• PostgreSQL on AWS RDS/Aurora PostgreSQL
• Database Design, Indexing, Partitioning, and High Availability
Migration Expertise
• DB2 to PostgreSQL Migration experience (preferred)
• Schema Assessment and Conversion
• Data Migration Planning, Validation, and Reconciliation
• Legacy Database Modernization
• Stored Procedure and SQL PL Conversion to PostgreSQL
AWS Data Engineering Skills
• AWS DMS (Database Migration Service)
• AWS Glue ETL Development
• AWS Schema Conversion Tool (SCT)
• Amazon S3, Lambda, IAM, CloudWatch
• Change Data Capture (CDC) implementation
Data Modelling & Transformation
• Data Modelling (Conceptual, Logical, Physical)
• Table Rationalization and Data Normalization (3NF/BCNF)
• Data Mapping and Transformation
• Source-to-Target Data Design
• DB2 Data Transformation to Target PostgreSQL Structures
ETL & Data Integration
• ETL Design and Development
• Data Cleansing and Transformation
• Data Quality and Data Validation
• Batch Processing and Data Reconciliation
• Large-scale Data Migration Frameworks
Programming & Scripting
• Advanced SQL
• PL/pgSQL
• Python (preferred)
• Shell Scripting
• Git/Version Control
