Intermediate SQL Developer

Key Responsibilities

Database Development & Maintenance:

• Develop, implement, and maintain database schemas, tables, views, stored procedures, functions, and triggers in Microsoft SQL Server (2016–2022).
• Work within established enterprise architectural standards and data governance policies.
• Develop and maintain reliable ETL processes using SSIS (or other relevant tools) for data integration and data warehousing.

Performance Tuning & Optimisation:

• Identify and resolve common database performance issues, focusing on query optimisation and indexing strategies.
• Analyse execution plans to improve query response times and overall system efficiency.
• Assist in monitoring database performance metrics and applying standard preventative measures.

Data Integrity, Security & Documentation:

• Implement and enforce data integrity constraints and referential integrity.
• Adhere to data security and compliance practices (e.g., POPIA) through appropriate access controls and standard auditing guidelines.
• Maintain clear database documentation, including data dictionaries, ERDs, and design specifications.

Collaboration & Code Quality:

• Collaborate effectively with cross-functional teams (developers, QAs, BAs) to understand requirements and deliver technical solutions.
• Participate in peer code reviews to ensure adherence to team coding standards, best practices, and performance guidelines.

Troubleshooting & Support:

• Provide regular support for database-related issues, performing root-cause analysis and timely incident resolution.
• Assist senior developers and DBAs in planning and executing database migrations, upgrades, or patching.

Required Skills & Experience

• Experience: Minimum 3–5 years of hands-on professional experience as a SQL Developer with a strong focus on Microsoft SQL Server.
• T-SQL: Strong proficiency in T-SQL development, including writing efficient queries, stored procedures, functions, and triggers.
• Database Design: Solid working knowledge of relational database design principles, normalisation, and basic data modelling.
• Performance Tuning: Good understanding of query optimisation techniques (e.g., basic execution plan analysis, standard indexing strategies, and statistics).
• ETL: Practical experience with SQL Server Integration Services (SSIS) for ETL development.
• Tooling: Experience using version control systems (e.g., Git, Azure DevOps) for database code.
• Methodology: Familiarity with Agile development methodologies.
• Soft Skills: Strong analytical, problem-solving, and collaborative communication skills.

Preferred Qualifications

• Bachelor’s degree in computer science, Information Technology, or a related field.
• Relevant Microsoft certifications advantageous (e.g., Azure Database Administrator Associate or legacy SQL Server certifications).
• Experience or exposure to SQL Server Reporting Services (SSRS) or Power BI.
• Basic exposure to other database technologies (e.g., PostgreSQL, MySQL, or NoSQL databases).

Work Location: In person