SQL Developer (CPT/PTA)

SUMMARY:
Our client is looking for a SQL Developer for a permanent role based in their Pretoria Office or Somerset West - Hybrid.

POSITION INFO:
Responsibilities\/Tasks: Develop and maintain SQL queries, stored procedures, triggers and database objects. Contribute to database design and relational architecture for new and existing systems. Develop new \/ modify existing SQL objects based on business requirements. Troubleshoot SQL objects and resolve database-related issues. Support application performance troubleshooting using SQL profiling and query optimisation. Service business requests, including data extraction and process changes. Collaborate with Business Analysts to understand requirements and data sources. Participate in all phases of the SDLC, including development, testing and deployment. Investigate and resolve production issues and support database environments. Develop and test ETL processes. Monitor and maintain database performance, security, and integrity. Contribute to team standards and, where applicable, mentor junior developers. Requirements: Relevant tertiary qualification in Information Technology or Computer\/Engineering\/Mathematical Sciences and\/ or Matric with at least 5-10 years relevant experience as a SQL developer as part of a team in a software development environment Relevant Microsoft Certification (SQL developer\/Azure) will be beneficial. 5-10 years relevant experience as a SQL developer as part of a team in a software development environment, including the role of leading Developer within a team. Ability to work in a team environment: Follow mentorship\/provide team leader mentorship, collaborate on a common (UML) design model. A good understanding of the SDLC process, tools and techniques specifically as applied to software development methodology. Experience working with security-sensitive data. (beneficial) Skills and Knowledge Requirements: Knowledge of security vulnerabilities and working impact on solutions. Experience of the following in Microsoft SQL Server: Understanding of SQL Server Administration SQL OLTP development SQL Query optimisation SQL Query analysis Database object design Database design principles XML and JSON structures (beneficial) Good XML manipulation skills in XQuery. (beneficial) Basic understanding of front-end languages like HTML, CSS, JavaScript (Beneficial) Ability to deliver production quality software by e.g. paying attention to detail, doing extensive unit testing and supporting quality testing phases. Knowledge and experience of the following toolsets: SQL Server Management Studio 2012 upwards SQL profiler Some knowledge of cloud services like Azure, AWS (Beneficial) Solid understanding of data integrity and security best practices. Hands-on experience in Exception Handling and Troubleshooting Troubleshooting slow-running queries, Profiling Performance Issues Ability to stay within the scope, timelines and constraints of the project and, if not possible, to raise\/negotiate alternatives. Personal Profile: Self-starter and highly self-motivated, with a strong sense of ownership and the ability to drive tasks and initiatives to completion. Resilient and emotionally mature, able to receive feedback constructively and not easily offended, maintaining professionalism in all interactions. Calm and composed under pressure, with the ability to work effectively in high-stress environments while delivering consistent results. Strong team player, with experience collaborating across cross-functional teams; prior experience in leading or mentoring development teams is advantageous. Excellent written and verbal communication skills, with strong interpersonal abilities suited to both technical and non-technical stakeholders. High attention to detail, with a strong commitment to producing clean, maintainable, and high-quality code. Proven ability to conduct root cause analysis in complex, integrated environments, especially under severe operational pressures. Strong analytical and problem-solving skills, with the ability to multitask and manage multiple priorities simultaneously. Lifelong learner, committed to ongoing professional development and staying current with evolving technologies and best practices.