ENVIRONMENT:

A dynamic Business Process Outsourcer based in Joburg seeks the coding talents of a SQL & C#.Net Developer who will directly support its call centre while creating and maintaining solutions leaning heavily on SQL Server to query or manipulate data for the in-house developed systems and reports. You will also utilize C# to create simple ASP.NET SPAs using MVC, Razor and Blazor. The ideal candidate must have at least 5 years work experience with C#.Net and SQL with 3 years using this tech daily. You need 3 years SSIS, SSRS, SQL Server & Excel, RESTful APIs, SOAP Web Services and knowledge of T-SQL including the use of stored procedures, triggers, views, data types, keys indexes, constraints, foreign keys, relational design and the related tools and development environments.

DUTIES:

• Solve business problems alone and as part of the team by applying good reasoning and logic to use one or more of the following technologies: ASP.NET, C#, Web Services, Web APIs and SQL programming. ML.Net would be an advantage and part of the role moving forward. 
• Support the deployment of new IT systems and infrastructure.
• Diagnose problems using a logical approach and understanding of the underlying systems.
• Work individually or as part of a team on small to medium sized SQL projects to solve operational business requirements as well as data manipulation when needed.
• Create ad-hoc queries or SQL Server stored procedures, views and jobs based on user requests or to maintain, troubleshoot or improve existing SQL functionality.
• Work on large data sets in a live transactional environment with an awareness of the impact of running demanding queries and the side effects on a busy operational call centre.
• Create and maintain constraints, keys and indexes to improve performance and maintain database integrity and business rules.
• Design and maintain Excel and SSRS reports using stored procedures and views.
• Maintain or improve existing Excel reports using VBA for extended functionality.
• Query and summarise data across multiple servers and databases using linked servers.
• Work with dynamic SQL to solve difficult cross-server and cross-database queries and summaries. 

REQUIREMENTS:

• A minimum of 5 years using and programming in C#, .NET and SQL - At least 3 of the most recent years using and programming in C#, .NET and SQL daily.
• 3 Years experience working with SSIS, SSRS, Excel with SQL Server.
• Experience optimising SQL Server queries and stored procs and the use of query analyser for tuning code.
• Solid understanding of relational databases and database design.
• Excellent knowledge of the T-SQL language including use of stored procedures, triggers, views, data types, keys indexes, constraints, foreign keys, relational design and the related tools and development environments.
• A good working knowledge of VBA programming in Excel.
• Sound knowledge of secure development principles. 
• Knowledge of SQL environment using tracing tools.
• Web Development experience using MVC and the following technologies: ASP.NET / .Net Core / Razor pages / Blazor.
• Knowledge and experience working with HTML, CSS and JavaScript/TypeScript.
• Web Service development using .Net.
• Use of and RESTful APIs and SOAP Web Services.
• A good understanding of basic Mathematics and Statistics.

Advantageous -

• Experience with other SQL databases like MySQL and PostgreSQL.
• CLR development for SQL Server using C#.
• Experience with Node Red.
• Some Linux and Asterisk experience.

ATTRIBUTES:

• A strong sense of responsibility and ownership and a solid