SQL Developer

Client Transaction Capital Recoveries
Published 27/02/2017
Contract Type Permanent
Location Hyde Park, Gauteng, South Africa
Introduction
Responsible for both new and existing technology projects within the supply chains.
Job Functions Information Technology
Industries Financial Services
Specification
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

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.

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

Documentation
Complete change controls
Documenting of SQL processes

Technical
Business Acumen
Quality Assurance
Attention to detail
Planning & Prioritizing Skills
Problem solving & analytical skills

Behavioral
Results and deadline driven
Resilience
Team-player
Multi – tasking




Requirements
Grade 12
Microsoft SQL Server Certification

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
Job Closing Date 31/03/2017
Share on