SQL Developer – C#.Net

Share and send to your friends !
SQL Developer - C#.Net
Location: Johannesburg, Randburg
Type: Permanent
Reference: #22196
Company: Datafin Recruitment

Create and maintain cutting-edge software solutions as your coding talents as a SQL developer with C#.Net is sought by a leading Business Process Outsourcer to join its Operational Dev team. You will be leaving 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. You will require 3 years' daily programming experience in C#.Net and SQL, 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, proficiency with SSIS, SSRS, Excel, HTML, CSS, JavaScript/TypeScript, RESTful APIs and SOAP Web Services.
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:
  • At least three of the most recent years using and programming in C#, .NET and SQL daily.
  • 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 understanding of SSIS, SSRS and Excel working with SQL Server over the past 3 years.
  • Experience optimising SQL Server queries and stored procs and the use of query analyzer for tuning code.
  • Very good general programming skills and a general interest in programming and development using primarily SQL Server and C# and the .Net platform.
  • 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.
  • 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.
  • Very logical with good understanding of basic Mathematics and Statistics.

Advantageous -
  • 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 work ethic - this is very important!
  • Accurate and precise approach with a strong sense of attention to detail.
  • The ability to work independently and as part of a team.
  • A willingness to learn about the existing business and systems enabling participation in the improvement and further development of these systems.
  • A willingness to keep learning and staying updated on modern development environments, techniques and trends like the latest ASP.Net developments as well as ML.Net
  • Very good verbal and written communication

Posted on 12 Jul 10:51, Closing date 11 Aug
Apply
stella Buley
[email protected]
000

Senior Full Stack C# Developer Remuneration: R800000 – R900000 per year cost-to-company  Location: Johannesburg Remote work: Only remote work Education level: Degree Job level: Senior Type: Permanent Reference: #FM53909 Company: E-Merge IT Recruitment…
Infrastructure Engineer Location: Johannesburg, Fourways Type: Permanent Reference: #22370 Company: Datafin Recruitment The technical expertise of a self-driven infrastructure engineer (Junior to Intermediate level) is sought by a fast-paced Data…
General Details Location: , MidrandJohannesburg Advertised By: Agency Company Name: WhatJobs Job Type: Contract Description Vacancy Details Employer:Network Finance Position:Financial Manager CASALocation:Johannesburg, GautengSalary:R 850 .- R 950 . Are you…
Senior C# Full Stack Developer Remuneration: R800000 – R850000 per year  Location: Pretoria Education level: Degree Job level: Senior Type: Permanent Reference: #NS55328 Company: E-Merge IT Recruitment This is a dev house…