Senior PostgreSQL Developer

Boardroom Appointments; Johannesburg; On-site; ZAR 700,000 - 1,000,000; Full time

Job summary

Boardroom Appointments is seeking a Senior PostgreSQL Developer to design and develop cloud-based database systems on AWS. The role focuses on data modelling, SQL performance tuning, and implementing robust SQL coding practices according to standards.

Applicants should have a strong background in relational databases, OLTP data modelling, and hands-on SQL development for Oracle or PostgreSQL, with Linux scripting experience.

Qualifications

• Bachelor's Degree in Computer Science or related field.
• Experience in working with relational databases.
• Data Modelling specifically related to OLTP.
• 6 years extensive hands-on SQL & database development experience on Oracle or PostgreSQL.
• Strong SQL programming and debugging skills.
• Experience with database development tools and technologies.

Responsibilities

• Design and develop database systems in the cloud on AWS.
• Assist in data modeling activities, SQL performance tuning, and implement robust SQL coding practices.

Skills

SQL programming

Data modelling

Performance tuning

AWS

Linux shell scripting

Education

Bachelor's degree in Computer Science

Tools

PL/SQL

PostgreSQL

Oracle

AWS RDS

Linux

Job description

About the job Senior PostgreSQL Developer

Job purpose:

As a Senior PostgreSQL Developer, you will be responsible for designing and developing database systems in the cloud on Amazon Web Services (AWS). The primary functions of this role include assisting in data modeling 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.

• Bachelors Degree in Computer Science or related field
• Experience in working with relational databases
• Data Modelling specifically related to OLTP
• PLSQL
• Dynamic SQL
• Database structures and standards
• PL/SQL or SQL Certification
• 6 years extensive hands-on SQL & database development experience on Oracle or PostgreSQL
• Strong SQL programming and debugging skills
• 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
• Data modelling and design of database structures
• Amazon Web Services (AWS) and RDS offering