SQL Developer with C#.Net

1 month ago51 views
Ad Saved to My List
View and manage your saved ads in your account.
Add to My List
Report Ad
General Details
Advertised By:Agency
Job Type:Contract
Description
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 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 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 g

Id Subtitle 1098408324
View More
WhatJobs
Selling for 6+ monthsActive Ads 34.29K
Professional Seller
Seller Stats
34.29KTotal Ads
19.04MTotal Views
View Profile
Contact WhatJobs
Message
(4021)
(Required)
Email Address
(Required)
Phone
(Required)
Upload CV(Optional)
DOC or PDF only max 2 MB file size
Send Message
By clicking "Send" you accept the Terms of Use and Privacy Notice and agree to receive newsletters and promo offers from us.