Description:
The RoleIn 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èles 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. Qualification and Skill Requirements
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. Behavioural Competencies
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. <
06 May 2025;
from:
gumtree.co.za