Senior SQL Developer

SUMMARY:
My client is a leading South African financial services provider with a strong reputation for delivering innovative insurance and investment solutions directly to individual customers.
They are seeking a skilled SQL Developer to join their dynamic team, responsible for designing, developing, and maintaining robust SQL databases that support critical business operations.

POSITION INFO:
The Role
In this role, you will write and optimise complex SQL queries, ensure database performance and security, and collaborate closely with development and business teams to deliver efficient data solutions.
The ideal candidate will have strong expertise in SQL programming, experience with relational database management systems, and a proven ability to troubleshoot and optimise database processes to drive data accuracy and reliability.

Key Responsibilities

• Collaborate within a project team, reporting to an IT Manager.
• Work closely with business and technical teams to ensure solutions align with Clientèle’s standards and enterprise architecture.
• Define and manage non-functional requirements, ensuring they are met.
• Organise and accurately estimate development tasks.
• Design, build, test, implement, and support SQL-based applications and processes.
• Ensure software design and implementation meet architectural goals and quality standards.
• Support business analysts and project team members in defining functional requirements and ensuring technical feasibility.
• Identify and manage technical project risks and issues, including mitigation and resolution.
• Mentor junior developers and act as a focal point of expertise on SQL and related technologies.
• Proactively seek opportunities to improve applications and processes.
• Perform additional duties as directed by management.

• Degree, diploma, or certification in Computer Science or a related technical field.
• At least 8 years’ experience in development, covering the full software development lifecycle.
• Experience working in agile environments (Scrum/Kanban).
• Advanced working knowledge of SQL (DDL, DML, JSON, XML).
• Extensive experience with large datasets and incremental batch loading methodologies.
• Advanced understanding of relational data structures, including keys, constraints, and triggers.
• Skilled in performance tuning and optimisation of relational databases (RDBMS).
• Experience designing and implementing conceptual, logical, and physical data models.
• Solid understanding of data modelling, management, and governance methodologies.
• Ability to develop unit tests for code components.
• Advantageous: Experience with Microsoft stack (SSIS, SSRS, SSAS, Power BI, SQL Server), DevOps automation, and the insurance industry.

• Strong planning, organisational, and time management skills.
• Excellent collaboration, communication, and interpersonal abilities.
• Effective people management, problem-solving, and decision-making skills.
• Ability to prioritise and work under pressure.
• High attention to quality and detail.
• Process- and practices-oriented.
• An analytical and methodical approach to problem-solving.