Senior PostgreSQL Developer at Blue Pearl (Pty) Ltd

Job Description

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

Areas of responsibility may include but not limited to

• 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 un-optimized 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.

Requirements

• BSc computer science or IT relevant qualification
• PL/SQL or SQL certification