Postgres developer

JD :

An ideal candidate should have a Bachelor of Engineering degree with 10+ years of experience in Postgres database development. Candidate should have experience and should be able to demonstrate the below skills during the interview and while on the job.

Professional Summary :

• 10+ years of Postgres database development experience in various phases of software development including Analysis, Design, Development, Testing and Implementation.
• Experience of Postgres version 9 and above (Open Source version or EDB or Percona Postgres flavor)
• Candidate should be able to independently and implement data models.
• Solid Postgres SQL development experience using PL/pgSQL
• Knowledge and experience of database development using Oracle SQL PLSQL will be added advantages.
• Strong experience in creating Postgres database objects such as tables, nested tables, synonyms, triggers, indexes, stored procedures, functions etc. 
• Experience in scheduling scripts using a scheduler like pgAgent
• Strong experience in developing, debugging and understanding complex stored procedures and functions in PL/pgSQL
• Should be independently able to analyze Postgres SQL plans and apply fixes to the long running SQLs
• Performance tuning of postgres SQL queries and PL/pgSQL functions.
• Enforced data integrity using integrity constraint and database triggers.
• Experience in Stored procedure optimization and Performance Tuning.
• Very good experience in full software development life cycle of development, maintenance & enhancement projects in both Traditional and Agile environments.
• Experience with version control tool SVN and CVS, GitLab.
• Good experience in Unit Testing, Integration Testing and Performance Testing.
• Exposure and knowledge of designing logical and physical Data Model in Relational Database Management

System (RDBMS).

• Expertise in batch processing, Unix shell scripting or PowerShell scripting.
• Candidate should have a strong understanding of SQL (Oracle, MySQL, Postgres, SQL Server)  and NoSQL database  (MongoDB, Cassandra etc) , should be independently talk to the DBA’s and development team of other SQL and NoSQL databases

Desired Certification

• Postgres Associate developer / Oracle SQL/PLSQL Developer

Tools