Job Description :
SQL Architect for state of Colorado
Duration: 6 Months
Location: Denver, Colorado

This role will be part of the development team for the Unemployment Insurance Modernization (UIM) project Phase 2. All development and work will be executed in accordance with the approved solution architecture and the existing enterprise application UFacts. This role will work and collaborate with the Solution Architect (OIT), other Agencies and Contractors. This position may also transition to Operations and Maintenance of the system once UFacts is live.
The candidate should have experience working with:
Good understanding of batch architecture.
Experience writing and scheduling jobs using either cron or quartz.
Proficient at scripting using shell / python / perl.
Proficient with Automic.
Proficient with Spring Batch, Java Timers and related processes.
Proficient at writing complex SQL and Stored Procedures. (Reports)
Development and maintenance of code to facilitate integration of web applications to backend systems.
Development and maintenance of code to enable effective identity and authentication and its management.
Strong development experience with Object Oriented Programming concepts and principles with .NET technologies and Java.
5 years of experience in both creating and maintaining complex T-SQL queries, views, and stored procedures in a multi-database environment.
Experience using source control to manage tasks and maintain developed solutions (MS Visual Studio and TFS) preferred.
Experience with web services include REST and SOAP.
It would be a plus if the developer has experience working with Crystal Reports.
The Developer will use appropriate development tools and approaches and leverage best practices in coding, security and documentation.
The role will work directly with agency staff, as well as vendors and, when necessary, other state agencies in fulfilling and carrying out the requirements of assigned IT projects.
This work shall be performed in a way aligned with the business needs, contract requirements, end users and with the approved technical architecture.

Client : State of Colorado