Responsibilities/Tasks:
• Develop and maintain SQL queries, stored procedures, triggers and database objects.
• Contribute to database design and relational architecture for new and existing systems.
• Develop new / modify existing SQL objects based on business requirements.
• Troubleshoot SQL objects and resolve database-related issues.
• Support application performance troubleshooting using SQL profiling and query optimisation.
• Service business requests, including data extraction and process changes.
• Collaborate with Business Analysts to understand requirements and data sources.
• Participate in all phases of the SDLC, including development, testing and deployment.
• Investigate and resolve production issues and support database environments.
• Develop and test ETL processes.
• Monitor and maintain database performance, security, and integrity.
• Contribute to team standards and, where applicable, mentor junior developers.
Requirements:
• Relevant tertiary qualification in Information Technology or Computer/Engineering/Mathematical Sciences and/ or Matric with at least 5-10 years relevant experience as a SQL developer as part of a team in a software development environment
• Relevant Microsoft Certification (SQL developer/Azure) will be beneficial.
• 5-10 years relevant experience as a SQL developer as part of a team in a software development environment, including the role of leading Developer within a team.
• 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 solutions.
• Experience of the following in Microsoft SQL Server:
o Understanding of SQL Server Administration
o SQL OLTP development
o SQL Query optimisation
o SQL Query analysis
o Database object design
o Database design principles
o XML and JSON structures (beneficial)
o Good XML manipulation skills in XQuery. (beneficial)
• Basic understanding of front-end languages like HTML, CSS, JavaScript (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
• Some knowledge of cloud services like Azure, AWS (Beneficial)
• Solid understanding of data integrity and security best practices.
• Hands-on experience in Exception Handling and Troubleshooting
• Troubleshooting slow-running queries, Profiling Performance Issues
• Ability to stay within the scope, timelines and constraints of the project and, if not possible, to raise/negotiate alternatives.
Personal Profile:
• Self-starter and highly self-motivated, with a strong sense of ownership and the ability to drive tasks and initiatives to completion.
• Resilient and emotionally mature, able to receive feedback constructively and not easily offended, maintaining professionalism in all interactions.
• Calm and composed under pressure, with the ability to work effectively in high-stress environments while delivering consistent results.
• Strong team player, with experience collaborating across cross-functional teams; prior experience in leading or mentoring development teams is advantageous.
• Excellent written and verbal communication skills, with strong interpersonal abilities suited to both technical and non-technical stakeholders.
• High attention to detail, with a strong commitment to producing clean, maintainable, and high-quality code.
• Proven ability to conduct root cause analysis in complex, integrated environments, especially under severe operational pressures.
• Strong analytical and problem-solving skills, with the ability to multitask and manage multiple priorities simultaneously.
• Lifelong learner, committed to ongoing professional development and staying current with evolving technologies and best practices.