NET Solution Architect

Client maintains various computer systems that are used in all the courts and other state agencies throughout the State of Connecticut. Client is seeking a Solution Architect to assist with system development, enhancement, integration, and documentation. Applications comprise of windows and web based .Net applications with a SQL Server database backend.

Scope of Services

The ideal candidate will be able to contribute immediately in the following areas:

· Assist ITD in reconciliation of current business requirements and modern information technology standards.

· Identification of risks and system constraints.

· Estimation of development timeline.

· Software development, testing and release management tasks.

· Ensuring code quality standards.

In addition to the standard skills and experience for the job class, the ideal candidate should be prepared to discuss the following:

General Experience:

· Minimum ten (10) years of experience in the design, development, testing and deployment of software solutions to manage complex business requirements.

· Previous software architecture experience.

Technical Competencies:

· .NET 6 & 8

· .NET MVC, Razor Pages

· .NET Entity Framework

· .NET WEB API

· Azure Authentication (Microsoft Entra)

· SQL Server (2016 and up)

o Ability to write and debug complex queries

· SSIS & SSRS

· IIS (8.5 and up)

· Azure DevOps

· SQL Server Performance Tuning

o Optimize SQL queries (Query Execution Plans, etc.)

o Simplify Index analysis

o Resolve SQL Server deadlocks

o Identify the root cause of SQL Server blocking problems

· Bootstrap, JQuery and various other front-end frameworks

· Messaging APIs (e.g., Service Broker, SignalR)

· Understanding and implementation of common OOP design patterns