Cape Town City Centre: SQL Developer

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