Complete Description:
DHS seeks an IT Consultant to provide performance enhancements and optimization for our Customer Assessment, Tracking and Case History (CATCH) system. CATCH is Microsoft .Net 2010 C# application with a SQL server backend.
DHS is in its third year of operating the CATCH application. Initially the application had very few database records and the performance was adequate. There are now hundreds of thousands of rows and the current stored procedures and queries are very slow and inefficient. The resource obtained through this procurement will analyze the database and application for inefficiencies and identify areas for improvement. Analysis includes but not limited to batch and real time stored procedures, views, application database queries, indexes, functions, reports and overall architecture. The resource will provide resolutions to meet predetermined performance requirement as well as address all issues discovered during the analysis.
• Bachelor's degree in Computer Science, Software Engineering or a related area
• Microsoft certifications are a plus
Skills:
Skill
Required / Desired
Amount
of Experience
Expertise Rating
Application design and development based on business requirements
Required
12
Years
3 - Expert
Deep knowledge of the .NET 3.5/4.0 Framework, including Visual Studio 2010, VB.NET, ASP.NET
Required
12
Years
3 - Expert
Intimate knowledge of SQL Server 2008 or higher and T-SQL
Required
12
Years
3 - Expert
Knowledge of SQL Server 2008 performance tuning and monitoring
Required
12
Years
3 - Expert
SQL Server Report Builder
Required
12
Years
2 - Proficient
Bachelor's degree in Computer Science, Software Engineering or a related area
Required
Microsoft Certifications are a plus
Highly desired