Senior Postgres Developer

12 Month Contract

Job Location: Sandton, South Africa

Position Purpose:

The Snr. PostgreSQL Developer will be a part of a dynamic and diverse Database Operation Team. The primary functions of this role include assisting in data modelling activities, SQL performance tuning, and the implementation robust, scalable and optimal SQL coding practices according to provided specifications, standards and procedures, while ensuring compliance with the architectural standards and guidelines laid out by the Client.

Education and Experience:

Qualifications:

BSc Computer Science or equivalent IT qualification PL/SQL or SQL Certification

Required:

At least 6 years extensive hands-on SQL & database development experience on Oracle or PostgreSQL.

Strong SQL programming and debugging skills.

Source code version control tools example, Gerrit, GIT.

Experience with database development tools and technologies.

Linux/Unix shell scripting experience.

Query optimization and performance tuning experience, including execution plan analysis.

Solid understanding of relation database systems including the use of tables, indexes, trigger, stored procedures and functions.

Knowledge:

RDBMS database architecture

Data modelling and design of database structures

Data analysis and processing Versioning and source control standards

Amazon Web Services (AWS) and RDS offering

Personal Attributes and Skills:

Technical Skills:

Data Modelling specifically related to OLTP

PLSQL

SQL

Dynamic SQL

SQL and PLSQL performance tuning

Report writing

Database structures and standards

Responsibility:

Provide expertise in SQL coding standards and best practices of DB structures and optimization.

Consolidate and optimize client reports for performance and re-usability.

Monitor database query performance and tune reoccurring unoptimized queries.

Work as a team member with DBAs to ensure database availability, data integrity and industry reporting standards.

Develop high quality stored procedures, triggers, functions, and views according to the high standards expected of this developer position.

Identify and resolve database design issues using data modelling best practices.