Recruitment Room Team
SQL & C#.Net Developer (JHB Hybrid)
Job Description
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 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 skills with the ability to adapt to communicating with senior technical team, management and non-technical Call Centre Agents.
- Very good problem-solving skills and an aptitude for applying critical reasoning and logic to solve challenging business problems.
- Organised and task driven with a need to complete tasks well.
