Connecting...

W1siziisinrozw1lx2fzc2v0cy9wzw9wbgvzb2x2zwqvanbnl2jhbm5lci1kzwzhdwx0lmpwzyjdxq

SQL Developer

SQL Developer

Job Title: SQL Developer
Location: Gauteng
Industry:
Salary: 540000.00
Reference: JN -022017-7748
Job Published: October 03, 2017 07:18

Job Description

Job Profile SQL DEVELOPER
 
 JOB TITLE SQL Developer
DEPARTMENT Information Technology
MAIN PURPOSE OF ROLE Responsible for both new and existing technology projects within the supply chains
ORGANISATIONAL STRUCTURE
ULTIMATELY ACCOUNTABLE TO
REPORTEES
Data Processing Manager
None
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
Detail of the extent to which this experience is required is provided on the following page.
 
 
 
 
 
 
 
 
 
2 SQL Developer
DESCRIPTION OF TASKS
NO. KEY PERFORMANCE AREAS INPUT (METHODS USED) OUTPUT (EXPECTED RESULTS) TECHNICAL and BEHAVIOURAL COMPETENCIES
REQUIRED
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
 Technical:
  • Business Acumen
  • Quality Assurance
  • Attention to detail
  • Planning & Prioritising Skills
  • Problem solving & analytical skills
 
Behavioural:
  • Results and deadline driven
  • Resilience
  • Team-player
  • Multi – tasking
 
 
 
 
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 (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
 
4 Implementation
  • 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
 
5 Documentation 
  • Complete change controls
  • Documenting of SQL processes