Software Developer Senior

Maarut; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading tech consulting firm based in Toronto is looking for a skilled developer proficient in C#, ASP.NET MVC, SQL Server, and Python. The role requires translating specifications into tested applications, building SQL scripts for data migration, and implementing best practices in Agile methodologies. Strong problem-solving skills and experience with Azure technologies are essential. This full-time position offers a dynamic working environment and opportunities to contribute to significant projects.

Qualifications

• Strong proficiency in C#, ASP.NET MVC, Python and JavaScript.
• Extensive experience with SQL Server, including stored procedures and performance tuning.
• Ability to create reports using SQL Server Reporting Services.

Responsibilities

• Translate technical specifications into tested applications and maintain them.
• Resolve technical problems arising during software operation.
• Build SQL scripts for migrating data to new multitenant databases.

Skills

C#

ASP.NET MVC

Python

JavaScript

SQL Server

Agile methodologies

Azure DevOps

Job description

Must Haves:

• Strong proficiency in C#, ASP.NET MVC, Python and JavaScript
• Extensive experience with SQL Server – designing stored procedures, queries, indexing, and performance tuning
• Ability to create reports using SQL Server Reporting Services or equivalent.

Responsibilities:

• Translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
• Resolve and troubleshoot technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

Basic Skills:

• Expertise in the complete software development cycle using Agile methodologies. The responsibility ranges from understanding requirements (User Stories) and application design to coding, debugging, and deployment using Azure DevOps pipelines.
• Strong problem-solving and communication skills with a proven ability to work in team environments and meet project plan timelines.
• Full Stack Skills:
• Proficient with both front end and back-end development, including any associated areas such as database design/management and DevOps.
• Extensive knowledge in SQL Server to help in writing complex stored procedures, and queries. Also, reverse engineering and optimizing queries to fine tune the database performance.
• Knowledge and experience with programming MVC .NET Web applications using C#.
• Knowledge and experience in application development methodologies.

Desired Skills:

• Implement Azure PaaS services such as Azure Functions, App Services, Logic Apps, Storage, Key Vault, and Azure SQL Database.
• Stay updated on new Microsoft technologies, cloud innovations, and industry best practices.
• Demonstrated ability to write clean and maintainable code in Python.

Required Experience / Evaluation Criteria:

• [Technical] Evidence of direct project working experience with the following technologies or close equivalents: 30 Points
  • C#, ASP.NET 4.8 or later, MVC,
  • Entity Framework & Web Forms
  • JavaScript/jQuery, HTML, CSS, Bootstrap
• [Technical] Evidence of direct project working experience with the following technologies: 30 Points
  • SQL Server and database development techniques
  • Writing advance level stored procedures/SQL queries
• [Technical] Evidence of direct project working experience with the following technologies or close equivalents: 10 Points
  • Azure Cloud technologies (App Services, Managed Instance, Functions, API Management)
  • Azure DevOps build, CI/CD workflows and GIT
• [Technical] Evidence of direct project working experience with the following technology or close equivalents: 15 Points
  • SQL Server Reporting Service: building new or maintaining existing Reports
  • Python programming
• [Soft/Process] Evidence of direct project working experience that demonstrates the following skills: 15 Points
  • Practical knowledge of iterative development (such as Agile)
  • Collaboration skills to analyze information and available documentation and build a common understanding of the target state of the system.
  • Practical knowledge creating technical design documents, deployment guides and configuration guides where applicable

Requirements Deliverables

Supporting eClaims expansion project

• Build SQL scripts that would be migrating data from legacy database to new multitenant database using the mapping provided.
• Validation and data massaging would be part of the scripts.
• Optimize existing complex queries to use modern SQL commands.
• Build tabular SSRS reports and SQL stored procedures.
• Create MVC pages to support the web application using the Entity framework.

Providing developmental support to the Provincial Genomics data platform

• Writing high quality code in Python and SQL Server.
• Provide technical documentation and support to fix security vulnerabilities.
• Provide technical input during vendor evaluation phase.

Nice to Have:

• Ability to create reports using SQL Server Reporting Services or equivalent.