SQL Developer

SUMMARY:
Build and optimise high-performance data systems for large-scale retail and distribution environments

POSITION INFO:

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