Application Production Support – .NET, SSIS, SQL Server Deployment

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading tech solutions provider in Toronto is looking for an Application Production Support specialist with expertise in .NET and SQL Server. The role focuses on ensuring the availability and reliability of business-critical applications, emphasizing incident response and continuous operational improvements. Candidates should have 6-8 years of experience, with strong skills in ASP.NET and advanced TSQL. This full-time position offers a chance to contribute to vital IT infrastructure improvements.

Qualifications

• Experience: 6-8 years in application production support.
• Strong understanding of ASP.NET (MVC Core) and Web API.
• Expertise in SQL Server 2012 Development and maintenance tasks.

Responsibilities

• Ensure the availability, reliability, and performance of business-critical applications.
• Emphasize incident response and root-cause analysis.
• Support environment maintenance and release support.

Skills

Core .NET Technologies

Advanced TSQL

Incident response

IIS configuration

Job description

Application Production Support – .NET, SSIS, SQL Server Deployment

Location: Toronto

Experience: 6-8 years

Required Skills: Core .NET Technologies: SQL Server 2012 Development

Ensure the availability, reliability, and performance of business-critical applications built on .NET and Microsoft SQL Server. This role emphasizes incident response, root‑cause analysis, environment maintenance, release support, and continuous operational improvements rather than feature development.

.NET Stack (Support Focus)
Strong understanding of ASP.NET (MVC Core), Web API, Windows services.
Experience reading codelogs to pinpoint issues basic ability to provide hotfix guidance to dev teams.
Familiarity with IIS configuration (app pools, bindings, compression, request limits) and Windows Server basics.

SQL Server Expert Support
Advanced TSQL (queries, joins, temp tables), indexing strategies, execution plan analysis, blocking/deadlock troubleshooting.
Maintenance tasks: index rebuilds/reorg, update stats, job monitoring (SQL Agent), SSIS troubleshooting.

Seniority Level

• Mid‑Senior level

Employment Type

• Full‑time

Job Functions

• Information Technology
• IT Services and IT Consulting