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

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