Solution Architect

Project Description

• The Client maintains various computer systems that are used in all the courts and other state agencies throughout the State of Connecticut. The 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 Work:

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

• Assist Client 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.
• Mentoring of development staff.

Minimum Qualifications

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)
• Ability to write and debug complex queries
• SSIS & SSRS
• IIS (8.5 and up)
• Azure DevOps
• SQL Server Performance Tuning
  • Optimize SQL queries (Query Execution Plans, etc.)
  • Simplify Index analysis
  • Resolve SQL Server deadlocks
  • 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