COBOL to PostgreSQL Migration Specialist

We are seeking an experienced COBOL to PostgreSQL Migration Specialist to lead and execute the transition of a COBOL-based application to a PostgreSQL environment. This role requires expertise in COBOL programming, database migration, and SQL transformation, ensuring a smooth transition while maintaining data integrity and system performance.ResponsibilitiesAnalyze COBOL Code. Review and understand existing COBOL programs, including embedded SQL statements and data structures.Develop an equivalent PostgreSQL schema that accurately represents the COBOL data structures.Map COBOL data types (e.g., PIC 9(5)) to appropriate PostgreSQL types (e.g., INTEGER, NUMERIC) while considering precision and scale.Rewrite COBOL-embedded SQL statements to conform with PostgreSQL syntax for SELECT, INSERT, UPDATE, and DELETE operations.Convert intricate COBOL data structures like REDEFINES and nested records into PostgreSQL tables or use JSON types where appropriate.Implement best practices for query optimization and indexing in PostgreSQL.Conduct thorough testing to ensure data accuracy and system functionality after conversion.Leverage COBOL modernization tools and database migration utilities to streamline the transition process.Work closely with stakeholders to gather requirements, provide updates, and document the entire migration process.