Sql Developer

Trending Talent Solutions; Gauteng; On-site; ZAR 250 000 - 350 000; Full time

Job summary

A technology solutions company in Gauteng is looking for an SQL Developer to manage both new and existing technology projects within supply chains. Candidates should have 3-8 years of experience with SQL programming, including developing scripts and procedures. This role requires a solid background in SQL Server and a relevant diploma or degree. Apply by October 10 for this exciting opportunity.

Qualifications

• Grade 12 certification required.
• 3 - 5 years intermediate SQL development experience.
• 5 - 8 years or more for senior positions.

Responsibilities

• Develop SQL scripts, stored procedures, and functions.
• Test SQL scripts and processes for correctness.
• Deploy and integrate SQL scripts into existing systems.

Skills

SQL programming

SSRS

T-SQL

Stored Procedures

ETL processes

Problem solving

Education

Microsoft SQL Server Certification

Diploma or degree in relevant field

Job description

Role purpose The SQL Developer will be responsible for both new and existing technology projects within the supply chains.

Qualifications and Experience: Grade 12. Microsoft SQL Server Certification or higher. Diploma or degree in line with job requirements will count highly in favor. 3 - 5 years SQL development experience – Intermediate. 5 - 8 years or more SQL development experience – Senior. SQL Server.

• Experience in SSRS and (SSIS – for senior requirement).
• Experience in SQL programming and an in-depth knowledge of the SQL Language including T‑SQL.
• Experience in the creation of stored procedures, views, triggers, cursors and functions.
• The ability to read and understand existing SQL scripts, maintain them and enhance them if required.
• Ability to create, schedule and monitor SQL jobs.
• Knowledge of FTP (File Transfer Protocol) advantageous.
• Senior requirement – FTP, sFTP, FTPs.
• The ability to write optimal SQL codes accurately and timeously.
• The ability to automate procedures.

Competencies: Business acumen, Quality assurance, Attention to detail, Planning & prioritizing skills, Problem solving & analytical skills, Results and deadline driven, Resilience, Team-player, Multi‑tasking, Mentoring other team members (senior requirement).

Key Performance Areas

1. Research and Design: Researching system implications and solutions, researching latest technologies and methodologies, code profiling, providing input to the Business Analyst regarding the quality and accuracy of specifications in terms of the development requirements.
2. Developing Code: Develop SQL Scripts, Stored Procedures, Functions, ETL (Extract, Transform & Load) processes, code automation.
3. Testing: Test SQL Scripts, Stored Procedures, Functions and ETL processes to business requirement, monitoring and confirming of procedures and processes after implementation to ensure correctness, efficient testing, minimum errors and bug free.
4. Implementation: Deploy and integrate SQL Scripts, Stored Procedures, Functions and ETL processes, manage the physical implementation to conform with physical models and source data to target mapping.
5. Documentation: Complete change controls, documenting of SQL processes.

Published Date: 26 September

Closing Date: 10 October