Sql And .Net Developer

Details of the offer

Duties and responsibilities include, but are not limited to: - 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. - Working 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. - Creating ad-hoc queries or SQL Server stored procedures, views and jobs based on user requests or to maintain, troubleshoot or improve existing SQL functionality. - Working 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. - Querying and summarising data across multiple servers and databases using linked servers. - Working with dynamic SQL to solve difficult cross-server and cross-database queries and summaries. Experience and 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. - 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 environment - 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. - 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. Skills and abilities: - 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. - Very logical with good understanding of basic mathematics and statistics. - Organised and task driven with a need to complete tasks well


Nominal Salary: To be agreed

Source: Adzuna_Ppc

Requirements

Head Infrastructure & Enterprise Architecture

Position summaryIndustry: Scientific, Research & Development Job category: IT-Architecture Location: Randburg Contract: Permanent Remuneration: Market Relate...


Mintek Pty Ltd. - Gauteng

Published 18 days ago

Workday Data Analyst

Line of Service Advisory Industry/Sector Not Applicable Specialism Workday Management Level Manager Job Description & Summary A career within Workday Consult...


Pwc Remchannel (Pty) Ltd - Gauteng

Published 18 days ago

Junior-Mid C#.Net Developer (Jhb Hybrid)

ENVIRONMENT: A Boutique Software company seeks the coding talents of a highly ambitious Junior-Mid C#.Net Developer to join its Joburg team who will help des...


Datafin - Gauteng

Published 18 days ago

Merit Theft Desktop Assessor (Jg 9)

Santam's Merit Claims department has a position available for a Merit Theft Desktop Assessor who will be based in Parktown, Gauteng. PURPOSE OF THE ROLEThe p...


Santam Insurance - Gauteng

Published 18 days ago

Built at: 2024-12-29T01:00:53.476Z