Requirements

• 3 - 5 years SQL development experience
• SQL Server 2000 – 2008 experience (2012-2014 optional)
• Experience in SsRs, SSIS
• 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
• The ability to write optimal SQL codes accurately and timeously
• The ability to automate procedures

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

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

Ref: 9363 | Published: 05 Jul 2019