Source description
About the role
Should have minimum exp of 6+ years to 10+ years> • Requirement of good Postgres Senior Developer/ Architect with 6+ years of experience on working with PostgreSQL.Excellent understanding of RDBMS Concepts, PL/SQL, Data Modelling and Data design. Hands on experience in query optimization Working knowledge of PostgresSQL is a must Experienced in ETL and ELT processing via tools like Azure Data Factory (ADF) Good knowledge of Azure environment, containerization concepts, cloud native development practices, Azure Wizard etc.Excellent understanding of DevOps and CI/CD concepts (GitLab, TeamCity, Automated Testing, Pipelines, Ansible, Rex, Maven, IntelliJ, SONAR)Excellent understanding of Agile methodologies and hands-on delivery experience in a pod setup • Hands on experience in Database migration projects from Mainframe DB2 (on z/OS) to Azure PostgreSQL database • Migration hands on experience of at least 1 project from DB2 database objects like Schemas, Data, Stores Procedures and Constraints• Good to Have exposure in migrating Mainframe DB2 database objects into PostgreSQL equivalent objects (like Schemas, Tables, Constraints, Views, Indexes, Triggers, Sequence, Usage Lists) • Experience in converting DB2 Storage Procedures functionality into Postgres equivalent SQL code OR writing new Postgres Procedures / API’s
More at Logic Planet