Logo for The Legends Agency

SQL Developer

Roles & Responsibilities

  • 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 normalised and denormalised structures.
  • Experience with performance tuning, indexing strategies, and query optimisation.

Requirements:

  • 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.

Job description

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

Related jobs

Other jobs at The Legends Agency

We help you get seen. Not ignored.

We help you get seen faster — by the right people.

🚀

Auto-Apply

We apply for you — automatically and instantly.

Save time, skip forms, and stay on top of every opportunity. Because you can't get seen if you're not in the race.

AI Match Feedback

Know your real match before you apply.

Get a detailed AI assessment of your profile against each job posting. Because getting seen starts with passing the filters.

Upgrade to Premium. Apply smarter and get noticed.

Upgrade to Premium

Join thousands of professionals who got noticed and hired faster.