FirstJobly.
JobsBlogAboutContact

Intermediate SQL Developer- Pretoria

Interfront SOC Ltd.•Permanent

Requirements

  • ✓Requirements:
  • ✓Relevant degree or diploma in computer information systems, computer science, data analytics, data management, engineering, mathematics or statistics
  • ✓Relevant Microsoft Certification (SQL developer/Azure) will be beneficial.
  • ✓5 years’ relevant experience as a SQL developer as part of a team in a software development environment, with the main focus of work being database development in SQL Server.
  • ✓Contributed to the development of software applications that are deployed to a working production environment.
  • ✓Ability to work in a team environment: Follow mentorship/provide team leader mentorship, collaborate on a common (UML) design model.
  • ✓A good understanding of the SDLC process, tools and techniques specifically as applied to software development methodology.
  • ✓Experience working with security sensitive data (beneficial)
  • ✓Skills and Knowledge Requirements
  • ✓Knowledge of security vulnerabilities and working impact on software solutions implemented to a working production environment.
  • ✓Experience of the following in Microsoft SQL Server:
  • ✓o Relational database design principles
  • ✓o Understanding of SQL Server Administration
  • ✓o SQL OLTP development
  • ✓o SQL Query optimization
  • ✓o SQL Query analysis
  • ✓o Database object design
  • ✓o XML and JSON structures (beneficial)
  • ✓o Good XML manipulation skills in XQuery (beneficial)
  • ✓Basic understanding of front-end languages like HTML5, CSS, JAVA script (Beneficial)
  • ✓Ability to deliver production quality software by e.g. paying attention to detail, doing extensive unit testing and supporting quality testing phases.
  • ✓Knowledge and experience of the following toolsets:
  • ✓o SQL Server Management Studio 2012 upwards
  • ✓o SQL profiler (beneficial)
  • ✓Knowledge on cloud services like Azure, AWS (Beneficial)
  • ✓Good understanding of data integrity and security best practices.
  • ✓Hands on experience in Exception Handling and Troubleshooting
  • ✓Troubleshooting slow running queries, Profiling Performance Issues (Beneficial)
  • ✓Personal Profile:
  • ✓Self-starter, self-motivated, team player
  • ✓Excellent communication, interpersonal and collaboration skills
  • ✓Strong attention to detail and accuracy.
  • ✓Able to work under pressure and meet deadlines
  • ✓Able to apply standards
  • ✓Strong sense of responsibility, not only for own scope of work but also for the entire solution and reputation of the company and clients.
  • ✓Analytical thinking.
  • ✓Quick learner and retainer of knowledge
  • ✓Fast to comprehend and solve complex problems
  • ✓Own transport for occasional in-office and team event collaborations
  • ✓Home office setup for remote working, including a reliable and uninterrupted internet connection, with a minimum of 50MBps up and down speeds

About This Role

To develop new processes and objects using Microsoft SQL Server as the primary platform, in the development of web-based solutions. All interactions with the Microsoft SQL Server database are done via specific queries and procedures developed using this platform. It also includes assisting with the day-to-day support, maintenance and administration of existing MS SQL Server environments.

Job Description:

Responsibilities/Tasks:

• Develop complex T-SQL queries, Stored Procedures and Triggers.

• Assist in the design of the relational database architecture for new development projects.

• Develop new / alter existing SQL objects based off a set of requirements.

• Troubleshoot SQL objects that fail.

• Support the development team in troubleshooting application performance using SQL profiler and optimizing SQL queries or tuning indexing.

• Service requests from business, which include changes to processes or ad hoc data requests.

• Develop according to set coding standards and processes.

• Collaborate with Business Analysts to define scope and goals, track milestones, decide priorities, and report regularly to PM’s, team leaders and BA’s.

• Work with Business Analysts to identify and understand source data systems.

• Contribute to all phases of the SDLC process extending from requirements gathering and design to development, testing and deployment.

• Investigate and fix production issues.

• Develop and test extraction, transformation and load processes.

• Work in a very data driven environment and use data analysis skills to anticipate and fix bugs.

• Support production databases.

• Monitor production databases regularly or respond to any database issues by bringing down the database or taking the database offline.

• Monitoring or optimizing the performance, security, backup, recovery or integrity of database management systems.

Closing date: 19th of December 2025

Ready to apply?

Apply directly on Interfront SOC Ltd.'s website.

Join Channel