Senior SQL Developer

ATS Client; Pretoria; On-site; ZAR 900,000 - 1,300,000; Full time

Job summary

ATS Client in Pretoria is seeking a Senior SQL Developer to optimise performance of tax systems and build robust database solutions in a financial services environment. You will develop complex T-SQL queries, procedures and triggers and help design relational database architecture.

You will troubleshoot production issues, support the development team, monitor databases, and ensure data integrity. Hybrid working model; collaborate with BAs, follow SDLC standards to deliver high-value, data-driven

Qualifications

• Relevant tertiary qualification and 8-10 years SQL dev experience in a software environment.
• Experience with security sensitive data (beneficial).
• Ability to lead within a team and mentor juniors.

Responsibilities

• Develop complex T-SQL queries, stored procedures and triggers.
• Assist in relational DB design for new projects.
• Troubleshoot and optimise SQL objects and performance.
• Support production databases and monitor for issues.
• Collaborate with BAs to define scope and priorities.
• Contribute to SDLC from requirements to deployment.
• Investigate and fix production issues and data requests.

Skills

SQL development

T-SQL

Database design

SDLC

Troubleshooting

Education

Relevant IT/Engineering/Math degree or Matric with 8-10 years SQL dev experience

Tools

Microsoft Certification (SQL Developer/Azure)

Job description

Job Description

Are you a data-driven problem solver who thrives on optimising performance, unlocking insights, and building robust database solutions? We're looking for a Senior SQL Developer to join a high-impact team within a financial services environment, where your expertise will directly support critical tax systems and data operations. This is an opportunity to work on complex, enterprise-level systems, collaborate with top-tier professionals, and play a key role in shaping data-driven decision-making. If you enjoy working in a fast-paced, highly analytical environment where precision and performance matter this role is for you.

Responsibilities

• Develop complex T-SQL queries, Stored Procedures and Triggers.
• Assist in the design of the relational database architecture for new development projects.
• Develop new / alter existing SQL objects based off a set of requirements.
• Troubleshoot SQL objects that fail.
• Support the development team in troubleshooting application performance using SQL profiler and optimizing SQL queries or tuning indexing.
• Service requests from business, which include changes to processes or ad hoc data requests.
• Develop according to set coding standards and processes.
• Collaborate with Business Analysts to define scope and goals, track milestones, decide priorities, and report regularly to team leaders and BA's.
• Work with Business Analysts to identify and understand source data systems.
• Contribute to all phases of the SDLC process extending from requirements gathering and design to development, testing and deployment.
• Investigate and fix production issues.
• Develop and test extraction, transformation and load processes.
• Work in a very data driven environment and use data analysis skills to anticipate and fix bugs.
• Supporting production databases.
• Monitor production databases regularly or respond to any database issues by bringing down the database or taking the database offline.
• Monitoring or optimizing the performance, security, backup, recovery or integrity of database management systems.

Requirements

• Relevant tertiary qualification in Information Technology or Computer/Engineering/Mathematical Sciences and/ or Matric with at least 8 - 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 years relevant experience as a Senior SQL developer as part of a team in a software development environment, including the role as 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)

Work in a mission-critical environment where your SQL expertise directly impacts financial systems and decision-making. Enjoy a hybrid working model, collaborate with experienced professionals, and take ownership of high-value, data-intensive solutions. Apply Now!