SQL Developer

The Legends Agency; Remote; ZAR 300 000 - 400 000; Full time

Job summary

A technology firm is seeking an experienced SQL Developer to design and optimize high-performance data systems for large-scale retail environments. The ideal candidate will have strong T-SQL skills and experience in database performance tuning. Responsibilities include building efficient queries and resolving performance bottlenecks. This remote position is open to candidates outside South Africa and offers a competitive salary of R45,000 to R55,000 per month.

Qualifications

• Strong experience developing and optimizing complex T-SQL queries and database objects.
• Proven ability to work with high-volume transactional databases and performance-critical systems.
• Solid understanding of database design principles, including normalized and denormalized structures.
• Experience with performance tuning, indexing strategies, and query optimization.

Responsibilities

• Design, build, and maintain efficient and scalable T-SQL code.
• Solve high-performance challenges in high-volume environments.
• Develop and optimize indexed views for reporting performance.
• Identify and resolve database performance bottlenecks.

Skills

T-SQL optimization

Database performance tuning

Collaborative problem-solving

Tools

Sage 200

Sage 300

SYSPRO

Palladium

Job description

Overview

SQL Developer Build and optimise high-performance data systems for large-scale retail and distribution environments. Remote | Open to candidates outside South Africa | Salary: R45 000 – R55 000 per month

About Our Client

Our client is a technology company delivering integrated software and data solutions to the retail and distribution sector. They focus on building scalable, high-performance systems that connect POS, ERP, and eCommerce platforms. The business values precision, collaboration, and continuous improvement, with a strong emphasis on real-world operational impact.

The Role: SQL Developer

The SQL Developer role focuses on designing, developing, and maintaining high-performance SQL code and database structures that support complex transactional systems. The position plays a critical role in ensuring speed, reliability, and scalability across large datasets used in retail and enterprise operations. This role is well suited to someone who enjoys deep problem-solving, performance optimisation, and working closely with technical and operational teams.

Key Responsibilities

• Design, build, and maintain efficient and 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 high-volume read and write environments, maintaining transaction write speeds under 100 milliseconds
• Develop and optimise indexed views to improve reporting performance and query efficiency
• Identify, troubleshoot, and resolve database performance bottlenecks using best-practice tuning techniques
• Collaborate with developers, analysts, and implementation teams across multiple projects
• Support data integrations between POS, eCommerce, and ERP systems including Sage 200, Sage 300, SYSPRO, and Palladium

About You

• Strong experience developing and optimising complex T-SQL queries and database objects
• Proven ability to work with high-volume transactional databases and performance-critical systems
• Solid understanding of database design principles, including normalised and denormalised structures
• Experience with performance tuning, indexing strategies, and query optimisation
• Comfortable working in collaborative, cross-functional technical teams
• Detail-oriented, analytical, and driven to deliver reliable, efficient data solutions