job description - Senior PostgreSQL Developer
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.
THE SUCCESSFUL APPLICANT
In order to be shortlisted for the vacancy, the successful candidate will have the following skills and competencies, but not limited to:-
Technical Competencies
- Data Modelling specifically related to OLTP
- PLSQL
- SQL
- Dynamic SQL
- SQL and PLSQL performance tuning
- Report writing
- Database structures and standards
Education and Experience:
- BSc Computer Science or equivalent IT qualification
- PL/SQL or SQL Certification
JOB DESCRIPTION
The role responsibilities will include, but are 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 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 modeling best practices
REQUIRED
- Must be fully vaccinated.
- 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 relational database systems including the use of tables, indexes, triggers, stored procedures, and functions.
At EQ8 Recruit we are passionate about sourcing talent across a variety of industries We specialize in permanent recruitment services from Accounting & Finance, Marketing & Sales, O&G and Supply Chain