SQL developer JHB

Location: Gauteng, Johannesburg, South Africa
Date Posted: 05-03-2018
SQL developer 
Department: Information Systems
Reports to: Manager: Data Processing
Reportees: None
Main Purpose of Role
Responsible for both new and existing technology projects within the supply chains
Required Minimum Education / Training
  • Grade 12
  • Microsoft SQL Server Certification
Required Minimum Work Experience
  • 3 - 5 years SQL development experience
  • SQL Server 2000 – 2008 experience (2012-2014 optional)
  • Experience in SsRs, SSIS, SSAS packages
  • 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
  • Knowledge of BCP (Bulk Copy) advantageous
  • The ability to write optimal SQL codes accurately and timeously
  • The ability to automate procedures
Technical and Behavioural Competencies Required
Technical Behavioural
  • Business Acumen
  • Quality Assurance
  • Attention to detail
  • Planning &Prioritizing Skills
  • Problem solving & analytical skills
  • Results and deadline driven
  • Resilience
  • Team-player
  • Multi – tasking
Key Performance Areas
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
Developing Code
  • Develop SQL Scripts
  • Stored Procedures
  • Functions
  • ETL (Extract, Transform & Load) processes
  • Code automation
  • Test SQL Scripts, Stored Procedures, Functions and ETL (Extract, Transform & Load) processes to business requirement.
  • Monitoring and confirming of procedures and processes after implementation to ensure correctness
  • Efficient Testing, Minimum Errors and Bug Free
  • Deploy and Integrate SQL Scripts, Stored Procedures, Functions and ETL (Extract, Transform & Load)
  • Manage the physical implementation to conform with physical models and source data to target mapping
  • Complete change controls
  • Documenting of SQL processes
this job portal is powered by CATS