REMOTE - Senior VB.NET Programmer to optimize queries using SQL Server, do discovery and fix bugs on web application with strict security (IAM)
Job Type: Contract
Positions to fill: 1
Start Date: Jun 05, 2023
Job End Date: Dec 05, 2023
Pay Rate: Hourly: Negotiable
Job ID: 130059
Location: Calgary, Edmonton, Halifax, London, Montreal, Ottawa, Regina, Toronto, Vancouver, Victoria, Winnipeg
S.i. Systems client is seeking a Senior VB.NET Programmer to optimize queries using SQL Server, do discovery and fix bugs on web application with strict security (IAM).
Project Background:
The client has a complex VB.NET web application that hasn't been being maintained. They have no VB.NET programmers on staff. Tech debt / tickets are growing, and they need you to come in and, do discovery, fix bugs, and help them move it to a new data centre. Challenges include:
MUST HAVE SKILLS:
Project Background:
The client has a complex VB.NET web application that hasn't been being maintained. They have no VB.NET programmers on staff. Tech debt / tickets are growing, and they need you to come in and, do discovery, fix bugs, and help them move it to a new data centre. Challenges include:
- The app is highly parameterized and data-driven.
- They need someone who is someone used to dealing with SQL queries and a data driven application
- It’s a national application. What someone sees on their screen is different for different users. Identify and access management.
MUST HAVE SKILLS:
- 5+ years as a Web Programmer developing, and maintaining web applications in Visual Basic (VB.NET) programming language
- Solid understanding of relational databases, specifically MS SQL Server, writing SQL queries, including data modeling, query optimization, and stored procedures.
- Proven development with Identity and Access Management (IAM) concepts and their implementation in web applications
- You are a self-motivated problem solver that is good with dealing directly with customers
- Familiarity with Microsoft’s Power BI, Power Apps and Power Automate.
- Understanding of cloud platforms, such as Azure or AWS.
- Certification or training in Identity and Access Management (IAM) concepts
- Maintain existing web applications using Visual Basic (VB) programming language.
- Plan and execute complex web applications to a new data center, with new MS SQL Server and IIS Web Server.
- Ensure the web applications efficiently communicate with the MS SQL Server database.
- Collaborate with cross-functional teams to understand business requirements and create test plans for the data center migration.
- Analyze and maintain Identity and Access Management (IAM) concepts to ensure proper authentication, authorization, and data protection.
- Troubleshoot and resolve issues related to web application functionality, performance, and security.
- Recommend database optimization, indexing, and performance tuning to ensure optimal data retrieval and storage.
- Conduct thorough testing and debugging of web applications to identify and fix any issues or defects.