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 / APIs
Optimizing SQL queries and database configurations for PostgreSQL
Ability to write database queries and code while maintaining data quality, privacy, and security