Senior PostgreSQL Developer to support the finetuning of multiple databases within the public sector

Job Type: Contract
Positions to fill: 1
Start Date: Jun 01, 2023
Job End Date: Oct 31, 2023
Pay Rate: Daily: Negotiable
Job ID: 130184
Location: Ottawa
Our Valued public sector client is seeking Senior PostgreSQL Developer to support the finetuning of multiple databases.

The successful candidate will have a solid technical foundation, and a strong focus on growing their development skills. They will be required to deliver small to medium-sized well-defined tasks, by working individually or pairing with others. 

• Identify and resolve performance bottlenecks at DB and session /program/Application level
• Create and execute performance testing strategy
• Analyze query performance using query plans and tune query performance wherever required
• Develop, document, and maintain the technical and conceptual specifications in support of the database designs
• Build a complete plan of how to test the whole database load and get the baseline before and after prod releases, database upgrades and migrations.
• Mitigate any performance related issues after the prod releases
• Support the design, development and ongoing operations of database applications, tools, and environments.
• Work closely with other DBAs, application administrators, developers, and testers to improve Database and Query performance

Must haves:
8+ years of experience optimizing / homogenizing the performance of a database.
8+ Years of supporting PostgreSQL Databases.
Active Secret Clearance