Menu Close

SQL and .Net Developer

SQL and .Net Developer

Equity ~ Non Equity
Johannesburg North – Gauteng

Reporting to the Head of IT, you will be part of the operational development team directly supporting the call centre, reporting to the IT Manager with a dotted line reporting to the IT Director. The role involves creating and maintaining solutions leaning heavily on SQL Server to query or manipulate data for the in-house developed systems and reports as well as using C# to create simple ASP.NET SPAs using MVC, Razor and Blazor. The systems used are T-SQL for most business and processes logic, so SQL is used as a programming language along with C#. You will be operating on a mainly Microsoft stack with some specific uses of Linux and Asterisk.
 
Skills and Experience
  • At least 3 of the most recent years using and programming in SQL daily as well as regular use of C#, NET.
  • A good understanding of SSIS, SSRS and Excel working with SQL Server over the past 3 years.
  • Solid understanding of relational databases and database design.
  • Excellent knowledge of the T-SQL language including the use of stored procedures, triggers, views, data types, keys indexes, constraints, foreign keys, relational design and the related tools and development environments
  • Very good general programming skills and a general interest in programming and development using a database first design approach primarily in T-SQL and C#.
  • Experience with other SQL databases like MySQL and PostgreSQL would be an advantage.
  • Very good Excel skills as well as a good working knowledge of VBA programming in Excel.
  • Experience optimising SQL Server queries and stored procs and the use of query analyzer for tuning code.
  • 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.
  • Use of SOAP Web Services.
  • CLR development for SQL Server using C# would be an advantage.
  • Experience with Node-Red would be an advantage.
  • Some Linux and Asterisk experience would be an advantage