REMOTE - Senior VB.NET Programmer to optimize queries using SQL Server, do discovery and fix bugs on web application with strict security (IAM)

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:

• 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.

Initially a 6-months contract with possibilities of extensions and/or full time hire. REMOTE across Canada in PST time zone.

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

Nice to Have:

• 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

Responsibilities:

• 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.