Junior SQL Developer

Sable International; Cape Town; On-site; ZAR 300,000 - 500,000; Full time

Benefits offered by this job

Dynamic work environment

Professional development opportunities

Job summary

A professional services firm in Cape Town is looking for a proactive Junior SQL Developer to join their IT department. The ideal candidate will have a strong background in database development and troubleshooting, with at least five years of experience. Responsibilities include optimizing SQL queries, maintaining data quality, and providing support for critical production systems. This role promises a dynamic work environment with opportunities for professional growth and development in a collaborative team setting.

Qualifications

• Minimum five years of experience in database development using SSMS.
• Excellent problem-solving skills and performance tuning experience.
• Strong understanding of database server security and user roles.

Responsibilities

• Ensure high levels of performance, availability, sustainability, and security.
• Analyze and solve issues in real time.
• Assist developers with query tuning and schema refinement.

Skills

Database development

Performance tuning

Problem-solving

Advanced T-SQL

Support for .NET applications

Database security

Software Development Life Cycle understanding

Clear communication

Education

Microsoft Certification

Tools

Microsoft SQL Server 2014

SSMS

Job description

Sable International offers innovative professional services to international citizens. We create tailor-made solutions to meet the accounting, wealth, financial, currency, and nationality needs of our clients. We pride ourselves on providing solutions that suit our client’s unique individual circumstances; our employees are key in achieving this goal.

The staff in our Abuja, Cape Town, Durban, Harare, Johannesburg, Kampala, London, Lagos, Lusaka, Melbourne, and Monte Estoril offices are passionate about their areas of expertise and take pride in helping our clients achieve their goals. As a result, we have an energised and fun company culture, something that sets us apart from other professional services firms.

Job Overview:

Are you energetic, ambitious, and looking to develop your career? Our IT department is looking to add a Junior SQL Developer to their team. We offer a dynamic and challenging environment where we achieve our business objectives and have fun doing it.

We’re looking for an experienced SQL Developer who thrives in a collaborative environment and enjoys solving real-time business and application challenges. The ideal candidate is proactive, detail-oriented, takes ownership of tasks, and is eager to improve systems and processes while supporting end users effectively.

You’re perfect for this position if you:

• Have proven experience (minimum five years) in database development using SSMS (Microsoft SQL Server 2014 onwards).
• Demonstrate performance tuning and exceptional trouble shooting and problem-solving skills
• Manage and create stored procedures, functions, and triggers to support data-driven application dependencies (advanced T-SQL skills).
• Have hands-on experience supporting .NET (C#, VB, ASP) and VBA applications.
• Possess a strong understanding of database server security, user roles, and permissions.
• Design and develop SQL Databases.
• Demonstrate a solid understanding of the Software Development Life Cycle.
• Hold a Microsoft Certification (highly regarded).
• Work effectively both independently and as part of a team.
• Communicate clearly and effectively (both written and verbal).

Additional requirements:

• Hold a valid driver’s license and have access to reliable transport.
• Availability for occasional after-hours support and infrequent overnight assignments.

Personal attributes:

• Exceptional customer service and communication skills.
• Strong problem-solving and analytical abilities.
• Self-motivated, proactive learner with the ability to manage changing priorities.
• Ability to work both independently and collaboratively within a team.
• Excellent documentation and organisational skills.
• Well organised, punctual and reliable.

Your role and responsibilities:

Among other tasks, your main responsibilities will include:

• Ensuring high levels of performance, availability, sustainability, and security.
• Analysing, solving, and correcting issues in real time.
• Refining and automating regular processes.
• Assisting developers with query tuning and schema refinement.
• Providing support for critical production systems.
• Creating views, functions, and stored procedures.
• Writing optimised SQL queries for integration with other applications.
• Maintaining data quality and overseeing database security.
• Understanding issues related to network performance and security.
• Reporting using Microsoft SQL Server Reporting Services.
• Supporting various applications and identifying bugs (mainly VBA and .NET).
• Ensuring good performance of the applications across various platforms and terminals.
• Providing support to the business units or end users.
• Modifying existing code to correct errors, adapt it to new hardware, upgrade interfaces, and improve performance.
• Designing and developing new features.
• Consulting with staff to evaluate interface, develop specifications and performance requirements, and resolve bugs.
• Reading, analysing and interpreting user/business requirements.
• Testing and debugging, identifying errors, and resolving them within testing protocols and standards ensuring the code performs to specification.
• Assisting in creating detailed RDs that outline problems, opportunities, and solutions for the business.