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. [URL Removed] 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 [URL Removed] 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.
While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.
COMMENTS:
When applying for jobs, ensure that you have the minimum job requirements. OnlySA Citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence. Apply here [URL Removed] e-mail a Word copy of your CV to [Email Address Removed] and mention the reference number of the job.
Desired Skills:
- SQL
- C
- Net