Detailed JD

* Should have minimum exp of 7+ years to 10+ years

>      • Requirement of good Postgres database engineer with 5+ years of experience on working with PostgreSQL database.

• Hands on experience in migration of On-Premises Database (preferably Mainframe DB2 on z/OS) to Azure PostgreSQL database

• Experience in DDL (create and manage tables) and DML statements in PostgreSQL (like functions, Sub queries, Joins).

• 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

• Optimizing SQL queries and database configurations for PostgreSQL

• Ability to write database queries and code while maintaining data quality, privacy, and security

Mandatory skills

• Postgres database engineer with 5+ years of experience on working with PostgreSQL database.

• On-Premises Database (preferably Mainframe DB2 on z/OS) to Azure PostgreSQL database

• Experience in DDL (create and manage tables) and DML statements in PostgreSQL (like functions, Sub queries, Joins).

• Migrating Mainframe DB2 database objects into PostgreSQL equivalent objects

• Converting DB2 Storage Procedures functionality into Postgres equivalent SQL code OR writing new Postgres Procedures / API’s

• Optimizing SQL queries and database configurations for PostgreSQL

Desired skills

Postgres database engineer

Domain

Financial and Wealth management