SQL Developer

The Legends Agency; Durban; On-site; ZAR 300 000 - 400 000; Full time

Job summary

A leading technology company in Durban is seeking an experienced SQL Developer to design and maintain high-performance SQL code that supports critical operations. The ideal candidate will have over 3 years of SQL development experience and advanced T-SQL skills. Responsibilities include building efficient code, troubleshooting performance issues, and collaborating with cross-functional teams to integrate data systems. This role offers a competitive salary ranging from R50,000 to R60,000 per month.

Qualifications

• 3+ years of hands-on SQL development experience.
• Strong understanding of relational database design and optimisation techniques.
• Proven experience with transactional systems.

Responsibilities

• Design, build, and maintain efficient, scalable T-SQL code.
• Troubleshoot performance bottlenecks and implement tuning strategies.
• Collaborate with cross-functional teams on data integrations.

Skills

Advanced T-SQL proficiency

Performance troubleshooting

Database indexing strategies

Working with large datasets

Analytical skills

Job description

SQL Developer
Durban | R50 000 -R60 000 per month

About Our Client
Our client is a forward-thinking technology company providing integrated software and data solutions to the retail and distribution sector. They specialize in delivering scalable, high-performance systems that connect POS, ERP, and eCommerce environments. The team values precision, collaboration, and continuous improvement offering a space where technical skill meets real-world business impact.

The Role: SQL Developer
As a SQL Developer, you will design, develop, and maintain high-performance SQL code and database structures that support critical retail and enterprise operations. You'll work on complex transactional systems, ensuring speed, reliability, and scalability across large datasets. This role is ideal for someone who enjoys problem-solving, optimization, and translating data challenges into streamlined, efficient solutions.

Key Responsibilities

• Design, build, and maintain efficient, scalable T-SQL code including stored procedures, triggers, views, and functions.
• Work with both normalised and denormalised database structures to support diverse system requirements.

Solve high-performance challenges in read/write operations, maintaining transaction write speeds under 100 milliseconds.

Develop and optimise indexed views for enhanced reporting and query efficiency.

Troubleshoot performance bottlenecks and implement best-practice tuning strategies.

Collaborate with cross-functional teams, including developers, analysts, and implementation specialists.

Support data integrations between POS, eCommerce, and ERP systems such as Sage 200, Sage 300, SYSPRO, and Palladium.

About You

3+ years of hands-on SQL development experience with advanced T-SQL proficiency.

Strong understanding of relational database design, indexing strategies, and optimisation techniques.

Proven experience working with large datasets, complex joins, and transactional systems.

Skilled in diagnosing and resolving performance-critical queries.

Familiarity with ERP data structures and integration processes.

Bonus: Experience with retail POS environments and eCommerce data integration.

Analytical, detail-oriented, and driven to build high-quality, reliable systems.