Key Responsibilities:
- Analyze existing DB2 database schemas, stored procedures, functions, and application code dependencies.
- Assist in migration planning and execution for DB2 → PostgreSQL during the on-premises to cloud transition.
- Rewrite/convert DB2 SQL queries, triggers, stored procedures, and functions into PostgreSQL equivalents.
- Collaborate with DBAs, architects, and application teams to ensure smooth migration.
- 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.
- Validate data integrity and reconcile migrated data between DB2 and PostgreSQL.
- Optimize PostgreSQL code and queries for performance and scalability in the target cloud environment.
- 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.
- Strong hands-on development experience with DB2 SQL and PL/SQL.
- Proven experience in migrating/rewriting code from DB2 to PostgreSQL.
- Good understanding of PostgreSQL-specific features (PL/pgSQL, JSON support, indexing, partitioning).
- 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).
- Familiarity with DevOps tools and concepts (e.g., Git, Jenkins, Ansible).