Senior Software Developer (.NET / Azure / SQL Server)
Posted Updated 5
views
Description
Position Overview
We are seeking a highly skilled Senior Software Developer with strong expertise in Microsoft .NET, C#, , Microsoft Azure, and SQL Server to design, develop, test, deploy, and maintain enterprise-grade web applications.
The successful candidate will translate business and technical requirements into secure, scalable, and maintainable software solutions. This role requires hands-on experience across the full Software Development Life Cycle (SDLC), database design and optimization, cloud application development, web services integration, application deployment, troubleshooting, and production support.
The candidate must be comfortable working onsite with developers, architects, quality assurance professionals, and business stakeholders in a structured enterprise environment.
Key Responsibilities
- Design, develop, test, debug, deploy, and maintain enterprise-grade web applications using Microsoft .NET technologies, including C#, , .NET Framework, .NET Core, and Web APIs.
- Translate business and technical requirements into well-structured, scalable, secure, and maintainable application solutions.
- Develop detailed programming specifications, write and generate code, compile data-driven programs, and conduct unit testing.
- Develop, configure, deploy, monitor, and maintain cloud-based solutions using Microsoft Azure services, including Azure App Services, Azure SQL, Azure Storage, and Azure DevOps.
- Design, develop, and optimize SQL Server databases, including relational data models, advanced SQL queries, stored procedures, triggers, functions, and views.
- Perform database performance tuning, query optimization, and troubleshooting.
- Design and implement RESTful APIs, web services, service-based architectures, and secure application integrations.
- Develop server-side components and data access layers using Microsoft Entity Framework and WCF services where applicable.
- Apply object-oriented programming principles, modern design patterns, custom frameworks, and enterprise application design standards.
- Participate in requirements gathering, systems analysis, solution design, technical documentation, and design walkthroughs with business stakeholders and subject matter experts.
- Conduct code reviews, debugging, testing, and technical assessments to maintain application quality, security, and performance.
- Use version control, build processes, and CI/CD pipelines to support reliable software delivery.
- Troubleshoot application, web server, network, deployment, and production issues, including issues involving DNS, load balancers, and network routing.
- Support application releases, upgrades, installation scripts, data conversions, migrations, and transitions between on-premises and cloud environments.
- Deploy and maintain applications on Windows Server using Internet Information Services (IIS).
- Collaborate with IT professionals throughout the SDLC and work within structured Agile and/or Waterfall development methodologies.
- Ensure applications comply with applicable security, accessibility, enterprise architecture, and Accessibility for Ontarians with Disabilities Act (AODA) requirements.
- Prepare technical, system, and user documentation and provide knowledge transfer and post-implementation support.
- Manage competing priorities, meet project deadlines, and contribute to continuous improvement of development practices.
Mandatory Technical Skills
Candidates must demonstrate strong, hands-on experience in the following areas:
- Microsoft .NET Development: Strong experience developing web applications using C#, , .NET Framework, .NET Core, and Web APIs.
- Microsoft Azure: Hands-on experience with Azure services, including App Services, Azure SQL, Azure Storage, and Azure DevOps, covering application configuration, hosting, deployment, and monitoring.
- SQL Server and Database Design: Strong experience with SQL Server, relational database design, advanced SQL queries, stored procedures, functions, views, performance tuning, and query optimization.
- Full SDLC: Experience across application design, development, testing, debugging, deployment, maintenance, and production support.
- Object-Oriented Design: Proficiency in object-oriented design principles, modern design patterns, and enterprise application architecture.
- Version Control and CI/CD: Experience with source control, build processes, and continuous integration/continuous deployment pipelines, preferably Azure DevOps.
- Web Services and Integration: Experience with RESTful services, Web APIs, integration patterns, and secure data exchange.
- Application Development and Documentation: Demonstrated ability to design, code, test, debug, and document applications.
Detailed Technical Evaluation Criteria
Candidates should be prepared to demonstrate the following competencies, which are specifically identified in the requisition's evaluation criteria.
1. Software Design and Development
- Expertise in .NET design and development across all application tiers.
- Strong understanding of the complete SDLC.
- Hands-on application of design patterns.
- Experience designing custom frameworks for enterprise solutions.
- Wireframing and UI/UX experience, including intuitive and responsive design.
2. Database Design and SQL
- Database design and relational data modelling.
- Advanced SQL query writing.
- SQL stored procedures, triggers, functions, and views.
- Advanced search engine design.
- Familiarity with SQL Server 2005, 2008, 2012, and later versions.
3. Server, Network, and Azure
- Server and network troubleshooting.
- Web server technologies and implementations.
- Knowledge of DNS, load balancers, and network routing.
- Troubleshooting physical and network-related issues.
- Practical Microsoft Azure experience.
4. Systems Analysis
- Experience conducting systems analysis.
- Client-facing requirements gathering.
- Ability to understand business needs and translate them into technical solutions.
- Effective communication with business stakeholders and technical teams.
5. Front-End Web Application Development
- Experience developing front-end applications using .
- Knowledge of Microsoft .NET Framework 3.5, 4.0, 4.5, and .NET Core 2 and later versions.
6. Web Technologies, UI Design, and Accessibility – 10 Points
- Hands-on experience with HTML/XHTML, JavaScript, CSS 2, and AJAX.
- jQuery experience is an advantage.
- Ability to build and apply controls.
- UI design and web accessibility knowledge.
7. Server-Side Components and Data Access – 15 Points
- Experience developing server-side application components.
- Ability to develop and integrate WCF web services.
- Experience developing data access components using Microsoft Entity Framework.
- Ability to integrate WCF services with Entity Framework objects.
- Knowledge of T-SQL, database design, stored procedures, views, functions, and related database technologies.
8. Windows Server Application Deployment – 5 Points
- Hands-on experience deploying applications on Windows Server.
- Experience with IIS 7.0 or later.
- Familiarity with Visual Studio 2008/2010 and later development tools.
General and Professional Skills
- Strong programming, analytical, problem-solving, and decision-making abilities.
- Experience working with structured software development methodologies.
- Ability to collaborate with developers, architects, QA teams, product teams, and business stakeholders.
- Strong written and verbal communication and interpersonal skills.
- Ability to elicit, interpret, and document information from diverse stakeholders and subject matter experts.
- Ability to prepare clear technical designs, solution documentation, and system implementation records.
- Strong troubleshooting, debugging, and technical investigation capabilities.
- Demonstrated ability to work effectively in a team environment and meet deadlines.
Desirable Skills
- Experience developing Internet-facing applications and cloud-native solutions.
- Knowledge of rapid application development (RAD) methodologies.
- Familiarity with CI/CD automation and DevOps practices.
- Knowledge of application security, performance optimization, and operational monitoring.
- Experience with middleware and gateways.
- Experience reviewing, analyzing, modifying, encoding, testing, and debugging product installation scripts.
- Experience conducting technical design walkthroughs and peer reviews.
- Ability to provide post-implementation support and resolve production issues.
- Knowledge of Information Management principles, concepts, policies, and practices.
- Knowledge of AODA and related accessibility regulations and standards.
- Experience preparing user, system, and technical documentation.
Additional Oracle-Specific Skills Listed in the Requisition
The source requisition also contains a separate set of Oracle Software Developer skills. Candidates with relevant Oracle E-Business Suite experience may have additional value where these competencies apply to the assignment:
- Experience conducting impact assessments of Oracle E-Business application customizations and extensions.
- Strong conversion experience in Accounts Receivable and Collections modules.
- Strong programming skills in Oracle Database, PL/SQL, SQL, XML, Unix shell scripting, and Oracle Data Integrator (ODI).
- Business knowledge of General Ledger (GL), Accounts Receivable (AR), Collections, Accounts Payable (AP), and Inventory (INV) modules within Oracle E-Business Suite.
- Strong knowledge of Oracle E-Business Suite table structures relating to GL, AR, Collections, AP, INV, and FND.
- Strong SQL tuning skills and experience working with partitioned tables.
- Experience with data warehousing, ETL methodologies, and OBIEE.
- Java and Oracle Application Development Framework (ADF) experience is an asset.
- Strong written and verbal communication skills and the leadership ability to oversee technical quality assurance.
Note: The requisition's principal technical requirements are .NET, Azure, and SQL Server. The Oracle-specific competencies are listed separately in the source and should be validated with the client if their applicability to this assignment is uncertain.
Work Environment and Contract Conditions
- The position is 100% onsite at 222 Jarvis Street, Toronto, Ontario.
- The resource must work onsite five days per week, Monday through Friday.
- The expected working time is 7.25 hours per calendar day, excluding lunch, scheduled within standard working hours of 8:00 AM to 5:00 PM.
- The assignment is with the Ontario Public Service's Central Agencies Cluster under the Ministry of Treasury Board Secretariat.
- CRJMC security clearance is specified for the position.
- The supplier may submit only one candidate.
- All submissions must be completed by November 3, 2026, at 12:00 PM EST.
Ideal Candidate Profile
The ideal candidate is a senior-level software developer with demonstrable enterprise application development experience, strong hands-on .NET and Azure capabilities, advanced SQL Server knowledge, and a track record of delivering secure, scalable web solutions. The candidate should also be comfortable with systems analysis, technical documentation, application deployment, server troubleshooting, and stakeholder collaboration in an onsite public-sector environment.
Skills
- Accessibility
- Accounts Payable
- Accounts Receivable
- Agile
- AJAX
- API
- Automation
- Azure
- Azure DevOps
- Bash
- CI/CD
- Cloud
- Cloud Native
- C#
- CSS
- Data Modeling
- Data Warehousing
- Design Patterns
- DevOps
- DNS
- .NET
- ETL
- General Ledger
- HTML
- Iis
- Java
- JavaScript
- jQuery
- OOP
- Oracle
- PL/SQL
- RDBMS
- Requirements Gathering
- REST
- SDLC
- Solution Design
- SQL
- SQL Server
- Unit Testing
- Unix
- Version Control
- Visual Studio
- WCF
- Windows Server
- Wireframing
- XML