SQL Developer

SUMMARY:
Are you a skilled SQL Developer passionate about building robust, efficient data solutions? Do you thrive in a supply chain environment where your work directly impacts business efficiency? If so, we have an exciting opportunity for you to join a dynamic IT team.

Our client is seeking both Intermediate and Senior SQL Developers to play a key role in developing and enhancing their data processing technologies. You will be responsible for the entire lifecycle of projects, from research and design to implementation, ensuring our supply chain systems run seamlessly and intelligently.

POSITION INFO:
Key Responsibilities:

• Design & Development: Develop, maintain, and optimize complex T-SQL scripts, stored procedures, functions, views, and ETL processes using SSIS.
• System Implementation: Deploy and integrate database solutions, managing the physical implementation to conform with data models.
• Testing & Quality Assurance: Conduct thorough testing of all code to ensure it is efficient, bug-free, and meets business requirements. Monitor post-implementation processes for correctness.
• Automation: Create, schedule, and monitor SQL Server Agent jobs to automate procedures and workflows.
• Research & Innovation: Research system implications, latest technologies, and methodologies to drive continuous improvement. (Senior role: Provide input on business specifications to ensure development feasibility).
• Documentation: Complete change controls and meticulously document all SQL processes for knowledge sharing and compliance.

• Grade 12 / Matric certificate.
• Microsoft SQL Server Certification or higher.
• A relevant diploma or degree will be highly advantageous.

• 3 - 5 years of hands-on SQL development experience.
• Proven experience with SQL Server 2008 – 2017.
• Strong skills in T-SQL, including creating stored procedures, views, triggers, and functions.
• Experience with SQL Server Reporting Services (SSRS).
• Ability to read, understand, maintain, and enhance existing SQL scripts.
• Experience in creating, scheduling, and monitoring SQL jobs.
• Knowledge of FTP is advantageous.

• 5 - 8+ years of advanced SQL development experience.
• All intermediate requirements, plus:
• Expert-level experience with SSIS (SQL Server Integration Services) for building ETL packages.
• Extensive experience with secure file transfer protocols (FTP, sFTP, FTPs).
• A proven ability to mentor and guide other team members.
• Experience in providing technical input on business specifications to ensure accuracy and quality.

• Technical: Strong business acumen, unwavering attention to detail, and a commitment to quality.
• Behavioural: Excellent problem-solving and analytical skills. You are results-driven, resilient, and able to meet tight deadlines.
• Collaborative: A true team-player who can also work independently, with strong planning and multi-tasking abilities.