17 Database Design jobs in South Africa

Role purpose

The
SQL Developer
will be responsible for both new and existing technology projects within the supply chains.

Qualifications and Experience

• Grade 12
• Microsoft SQL Server Certification or higher
• Diploma or degree in line with job requirements will count highly in favor.
• 3 - 5 years SQL development experience – Intermediate
• 5 - 8 years or more SQL development experience – Senior
• SQL Server 2008 – 2017 experience
• Experience in SsRs and (SSIS – for senior requirement)
• Experience in SQL programming and an in-depth knowledge of the SQL Language including T-SQL
• Experience in the creation of stored procedures, views, triggers, cursors and functions
• The ability to read and understand existing SQL scripts, maintain them and enhance them if required
• Ability to create, schedule and monitor SQL jobs
• Knowledge of FTP (File Transfer Protocol) advantageous.(Senior requirement – FTP, sFTP, FTPs)
• The ability to write optimal SQL codes accurately and timeously
• The ability to automate procedures

Competencies

• Business acumen
• Quality assurance
• Attention to detail
• Planning & prioritizing skills
• Problem solving & analytical skills
• Results and deadline driven
• Resilience
• Team-player
• Multi – tasking
• Mentoring other team members (senior requirement)

Key Performance Areas

1.
Research and Design

• Researching system implications and solutions
• Researching latest technologies and methodologies
• Code profiling
• Providing input to the Business Analyst regarding the quality and accuracy of specifications in terms of the development requirements

2. Developing Code

• Develop SQL Scripts
• Stored Procedures
• Functions
• ETL (Extract, Transform & Load) processes
• Code automation

3. Testing

• Test SQL Scripts, Stored Procedures, Functions and ETL (Extract, Transform & Load) processes to business requirement
• Monitoring and confirming of procedures and processes after implementation to ensure correctness
• Efficient Testing, Minimum Errors and Bug Free

4. Implementation

• Deploy and Integrate SQL Scripts, Stored Procedures, Functions and ETL (Extract, Transform & Load)
• Manage the physical implementation to conform with physical models and source data to target mapping

5. Documentation

• Complete change controls
• Documenting of SQL processes

Sandton

Published Date: 26 September 2025

Closing Date: 10 October 2025

Job Title: SQL Developer
Location:
Remote (South Africa)

Level:
Intermediate (5 years experience)

About The Role
We are seeking an
Intermediate SQL Developer
who is passionate about database development and optimization. The ideal candidate will have strong hands-on SQL experience, excellent problem-solving skills, and a drive for building efficient, scalable, and reliable database solutions.

Key Responsibilities

• Design, develop, and maintain SQL scripts, queries, stored procedures, and functions.
• Optimize database performance, troubleshoot issues, and ensure data integrity.
• Collaborate with cross-functional teams to understand data requirements and deliver solutions.
• Maintain and support existing SQL databases, ensuring security and reliability.
• Document database processes, structures, and procedures.

Qualifications & Experience

• Bachelors degree in Computer Science, Information Technology, or related field (or equivalent experience).
• 5 years proven SQL development experience.
• Strong proficiency in writing complex queries, stored procedures, and database optimization.
• Experience with relational databases (e.g., MS SQL Server, MySQL, PostgreSQL).
• Solid understanding of database design principles and data modeling.
• Strong analytical and problem-solving skills.

Nice to Have

• Experience with BI/reporting tools (Power BI, SSRS, Tableau).
• Exposure to cloud database platforms (Azure SQL, AWS RDS).
• Knowledge of ETL processes and tools.

Join a Fintech corporation as an SQL developer.

The SQL Developer will be responsible for both new and existing technology projects within the supply chain environment.

Responsibilities:

• Systems implications, solutions, latest technologies and methodologies
• Providing input to the Business Analyst regarding the quality and accuracy of specifications, in terms of development requirements
• Developing SQL scripts, stored procedures and ETL processes
• Deploying and integrating SQL scripts, stored procedures, functions and ETL
• Managing the physical implementation to conform with physical models and source data to target mapping

Education & Experience:

• Microsoft SQL Server Certification or higher
• Diploma / Degree in Information Technology or related
• 3 - 5 years SQL development
• Experience in SQL Server , SSIS and SSRS
• Ability to read and understand existing SQL scripts, maintain them and enhance them
• In-depth experience in SQL programming

Apply

Monica De Wet

Senior Specialist Recruitment Consultant

Contract

5 to 20 years

Negotiable

04 September 2025

Senior SQL Developer – Data-Driven Excellence Meets Customer Impact

Are you a seasoned SQL Developer passionate about turning data into actionable insights that drive customer experience and operational efficiency? Join a dynamic team where your expertise in database development, ETL processes, and BI tools will directly influence business outcomes.

? What You'll Do

• Collaborate closely with business stakeholders to understand data needs and deliver impactful solutions.
• Design and implement high-quality ETL processes using SSIS or similar tools.
• Build and maintain data warehouses and dimensional models to support analytics.
• Create intuitive dashboards and reports using Power BI, SSRS, and other BI tools.
• Integrate external APIs (REST/SOAP) into SQL and ETL workflows.
• Champion CI/CD practices and source control (Git) for data solutions.
• Contribute to Agile/Scrum ceremonies and deliver in iterative cycles.

? What You Bring

• 5–7+ years of hands-on experience in SQL Server development (T-SQL).
• Proven track record in ETL design and development (SSIS or similar).
• Strong experience in data warehouse architecture and dimensional modeling.
• BI development expertise with Power BI, SSRS, and related tools.
• Solid understanding of Git and CI/CD pipelines for data engineering.
• Excellent problem-solving skills and performance tuning capabilities.
• Experience integrating APIs into SQL/ETL processes is a strong plus.
• Exposure to cloud data platforms like Azure Synapse, Azure Data Factory, or similar.
• Bonus: Experience with Snowflake or IBM Cloud Pak for Data.
• Background in financial services or investment platforms is highly advantageous.

? Why Join Us?

• Work on high-impact projects that shape customer experience and business efficiency.
• Be part of a collaborative, Agile team that values innovation and continuous improvement.
• Access to cutting-edge tools and cloud technologies.
• Flexible work arrangements and a supportive culture.
• In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent

Not heard from us

"If you have not heard from us in two weeks, please note that you were unsuccessful for the role. However, we will keep your resume on file and reach out if any other suitable opportunity arises in the future".

Azure DatabricksData ModelingSQL ServerSQL Server Integration Services (SSIS)Power BIExtract Transform Load (ETL)APIsData Analysis

InvestmentsBankingInsurance

Join our client’s dynamic Fintech team as they revolutionize the delivery of financial insights. They are in search of a skilled SQL Developer in Cape Town to craft robust data frameworks and innovative services, driving actionable insights for their global clientele.

Embrace a culture of innovation and collaboration, where your creativity flourishes amidst technical challenges. Dive into a world that values authenticity, responsibility, and the thrill of pushing boundaries and shape the future of online betting and gaming.

Your key job responsibilities as the SQL Developer in Cape Town will include:

Requirements for this SQL Developer job in Cape Town:

Don't miss this opportunity to elevate your career with a globally recognized brand. Make an impact, redefine data engineering possibilities, and shape the future of online betting and gaming. Apply now and be part of our exciting journey!

automation, Azure DevOps, Betting, C#, CI/CD, Databricks, DevOps principles, Docker, Event Hubs, Fintech, Gaming, Git, infrastructure management, K8 (Kubernetes), PowerShell, Python, SQL Developer, SQL Server, SSIS/SSAS/SSRS, TSQL

Our client is seeking a seasoned Senior SQL Developer/Bi Analyst to join their operational development team, supporting a large-scale call centre. This role demands not only advanced SQL Server expertise but also the ability to deliver end-to-end solutions that drive business performance.

The environment is fast-paced, high-demand, and technology-driven, offering the opportunity to work with modern tools and a collaborative IT team of professionals. This position is suited to candidates with stable, progressive career paths who have developed deep knowledge through years of consistent, hands-on work, rather than short-term roles. This role requires stability, depth of knowledge, and the ability to design and deliver solutions across the whole system.

Qualifications & Experience:

• Minimum 8–10 years' SQL development experience with proven senior-level capability.
• Strong T-SQL mastery with expertise in relational database design, optimisation, and performance tuning.
• Demonstrated end-to-end development exposure beyond siloed environments.
• Working knowledge of SSRS, Excel (including VBA), and query optimisation techniques.
• Evidence of long-term career stability and progression in prior roles.

Key Responsibilities:

• Architect, develop, and optimise SQL Server stored procedures, views, triggers, and queries for high-volume transactional systems.
• Deliver advanced data analysis and reporting (SSRS, Excel, VBA) to support operational and management requirements.
• Ensure database performance, integrity, and scalability by utilising indexing, constraints, and effective relational design.
• Apply end-to-end development expertise, understanding system-wide data flow and interactions.
• Manage large datasets in live production environments, balancing performance and operational continuity.
• Diagnose and resolve technical issues logically and efficiently, supporting business-critical systems.

Job Description
SQL

Development

Responsibilities
Job Responsibilities:

• Database Design

• Ensure Database design is robust, scalable and operating optimally.

• Work with other Developers, Support and Production DBA's to make sure that the solutions meet application requirements and performance goals.
• Actively contribute to planning meetings, documentation and testing.
• Determine, drive and document database policies, procedures and standards within BET.
• Set and maintain database standards including coding standards.
• Designs, codes, tests, debugs, and documents database artifacts;
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Responsible for completion of development projects;
• Works with support teams to investigate operational problems/system requirements;
• Develops business cases, requirements and performance metrics as necessary;

• Prepares detailed technical specifications documents;

• Database Performance

• Minimize database downtime and manage parameters to provide fast query responses.

• Perform tests and evaluations regularly to ensure data security, privacy and integrity
• Develop processes for optimizing database security.
• Performance tuning of database systems and queries.
• Create automation for repeated database tasks.
• Be available for on-call support as needed.

• Proactively find and resolve long running queries and other Database performance bottle-necks

• Initiative and Innovation

• Recommend and implement emerging database technologies.

• Implement improved processes that have a positive effect on the team's performance and company bottom line.
• Take an active involvement in problem resolution and where necessary works after hours to ensure that problems are resolved
• Shows foresight to prevent errors or delays in projects.
• Demonstrate initiative by understanding, acquiring and implementing new knowledge and skills both within team and to the wider group
• Incorporates the new abilities into the day to day operational activities to improve performance of products and systems

• Ensure techniques, technologies, tools and processes used are in line with industry best practices

• Knowledge Share

• Identify team members requiring a specific knowledge, skill or understanding and seek ways to impart or upskill the team members through coaching and mentorship

• Verify the knowledge has been imparted successfully and if not, take steps to rectify gaps in transfer of the knowledge
• Provide technical guidance to the team through collaboration sessions and knowledge sharing initiatives

Qualifications
Job Specification:

• Completed BSc Computer Science or National Diploma in IT. (LS1)
• -7 years' experience in a commercial environment utilizing a high transaction database.
• 5+years' experience in MSSQL-all aspects.
• Advanced SQL skills and query writing skills.
• Advanced troubleshooting SQL skills.
• Experience in designing/optimizing MSSQL Databases.
• Proven experience in mentoring of other DBAs.

Living Our Spirit

• Engages in cross-functional collaboration and problem solving whilst encourages a culture of inclusivity.
• Actively drives a culture of versatility and adaptability by modelling and encouraging team members to support each other not only within the department, but within BET Software as a whole.
• Shows up in an authentic manner and leverages off the team's diversity to achieve deliverables.
• Views challenges as opportunities to expand on their knowledge base and takes a creative approach to overcoming the challenges.

Hi there

We're looking for a hands-on SQL Developer with 2–3 years of experience to join our Data team. You'll help build and maintain reliable data pipelines, optimize complex T SQL, and turn raw operational data into accurate, actionable insights for our contact centre and collections lines of business.

If you've worked with high volume BPO/collections datasets, care about performance and data quality, and enjoy partnering with stakeholders to solve problems fast, we'd love to meet you.

Skills & Knowledge:

• Design & Develop SQL Solutions: Write clean, well-documented T SQL (stored procedures, functions, views, triggers) for data processing and reporting.
• ETL / Data Pipelines: Build and maintain ingestion and transformation jobs (e.g., SSIS, SQL Agent jobs, Azure Data Factory advantageous).
• Performance Tuning: Analyze execution plans, index strategies, and query patterns to improve reliability and speed.
• Data Quality & Governance: Implement validation, reconciliation, lineage, and auditing aligned to POPIA and internal controls.
• Operational Support: Monitor daily loads, troubleshoot failures, and resolve data issues with urgency and root cause mindset.
• Reporting Enablement: Prepare curated tables/views for BI (e.g., Power BI) and ensure semantic consistency across teams.
• Collaboration: Work closely with Ops, Finance, and Client Services to understand requirements and deliver pragmatic solutions.

Qualifications:

• 2–3 years in an SQL Developer / Data Engineer role with Microsoft SQL Server preferred).
• Strong T-SQL skills: complex joins, window functions, CTEs, pivots, dynamic SQL, error handling.
• Experience creating and optimizing stored procedures, views, functions, and indexes.
• Working knowledge of ETL (SSIS or equivalent) and scheduling (SQL Agent).
• Solid understanding of data modelling (OLTP vs. reporting), normalization/denormalization, and query optimization.
• Comfortable with source control (Git) and basic CI/CD concepts.
• Attention to detail, ownership mindset, and clear communication with non-technical stakeholders.

The ideal candidate should possess:

• Industry experience in BPO / Contact Centre / Debt Collections (dialer data, agent performance, campaigns, dispositions, promise-to-pay, etc.).
• Exposure to Azure SQL / Azure Data Factory / Synapse.
• Familiarity with Power BI data modelling and DAX fundamentals.
• Experience with data privacy & compliance (POPIA/GDPR) and secure data handling.
• Conduct weekly room audits and ensure training facilities are ready

Does this vacancy appeal to you? Apply now