Intermediate Sql Developer

Pretoria, GP, ZA, South Africa

Job Description

Job Reference Number:

Recruit136


Department:

Tax


Business Unit:




Industry:

Information Technology


Job Type:

Permanent


Positions Available:

1


Salary:

Market Related
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.





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





Position type:

Permanent




Job 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: + Relational database design principles
+ Understanding of SQL Server Administration
+ SQL OLTP development
+ SQL Query optimization
+ SQL Query analysis
+ Database object design
+ XML and JSON structures (beneficial)
+ 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: + SQL Server Management Studio 2012 upwards
+ 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

Beware of fraud agents! do not pay money to get a job

MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD1600983
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Pretoria, GP, ZA, South Africa
  • Education
    Not mentioned