Job Title

Iowa Vocational Rehabilitation Services is recruiting a technical specialist/developer to enhance the Iowa Rehabilitation Services System (IRSS) for case management. Iowa Vocational Rehabilitation Services is recruiting a technical specialist/developer to enhance the Iowa Rehabilitation Services System (IRSS) for case management. This project work will ensure compliance with federal and state security requirements and draw on industry best practices. Ideal candidate is a Full stack developer with a strong security background. Preference for candidates with experience developing on security projects. The project work will focus on security enhancements and other feature development for IRSS. Security enhancements will include integrating new identity access management solutions, enhancing encryption of data at rest and in transit, and ensure compliance with Federal Regulation regarding audit logging. This project is in the early discovery phase and the contractor will assist in development, along with requirements refinement. This project will require updating web applications, SQL databases, web forms, and other applications as needed. IVRS IRSS development team consists of four developers, a project manager, and three analysts that represent different parts of the business. The contractor will augment the team as they complete business operations for federal compliance. Skillset: C# ASP MVC JavaScript HTML SQL Web API (ASP.Net) SOAP REST .Net Framework Job requirement: Experience in developing ASP.NET Experience in integrating event logging and auditing for applications Experience in protecting data in the database and in transit Database programming; developing business application processes; writing complex T-SQL queries against SQL Server database Ability to translate business requirements into technical specifications T-SQL development including the views, stored procedures, functions and indexing techniques Dynamic SQL stored procedure coding and troubleshooting Designing and developing ETL routines using T-SQL & SQL Server Integration Services (SSIS); Proven analytical problem solving and debugging skills Developing data visualizations (Reporting Services (SSRS); SQL Profiler, Database Engine Tuning Advisor, Execution Plans; Team foundation Server (TFS), SDLC, Business Intelligence Development Studio (BIDS), Visual Studio Experience creating test data and thoroughly testing T-SQL Code Ability to work under tight deadlines Required/Desired Skills SkillRequired /DesiredAmountof ExperienceDatabase programming; developing business application processes; writing complex T-SQL queries against SQL Server databaseRequired8YearsAbility to translate business requirements into technical specificationsRequired8YearsT-SQL development including the views, stored procedures, functions and indexing techniquesRequired8YearsDynamic SQL stored procedure coding and troubleshootingRequired8YearsExperience integrating Okta and providing support for updates to ADRequired8YearsExperience in integrating event logging and auditing for applicationsRequired8YearsExperience in protecting data in the database and in transitRequired8YearsExperience in developing ASP.NETRequired8Years Questions No.QuestionQuestion1The Contractor must report any disciplinary action, misdemeanor or felony convictions to the State for any temporary IT staff provided. Do you agree to this requirement?Question2Absences greater than two weeks MUST be approved by CAI Management in advance, and contact information must be provided to CAI so that a resource can be reached during his or her absence. The client has the right to dismiss the resource if she or he does not return to work by the agreed upon date. Do you accept this requirement?Question3This requirement falls under the E-RTR process. The candidate MUST submit their Right to Represent electronically following the process to be considered. Do you accept this requirement?Question4Please list candidate's email address.Question5The Vendor Rate for this position is $87.35. Do you accept this requirement?Question6PROVIDE CANDIDIDATES CURRENT LOCATION (CITY/STATE) HERE [REQUIRED] Question7SHOW YOUR WORK - In the summary of qualifications field under the details tab of the candidate's profile, you should explain why your candidate is the best fit for this position. Please confirm that you have thoroughly validated and attested to the accuracy of the credentials listed throughout this candidate's VectorVMS profile and resume according to Section 5.2.5 of ITS-009440. Do you confirm? Candidates will get rejected if an agency cuts and pastes the candidates' resumes into this field [REQUIRED]Question8DOM DoIT contractor personnel are now required to undergo additional background check investigations (run by DOM DoIT) before starting, requiring the completion of several waiver forms & fingerprint processes. The selected candidate will be responsible for completing all the necessary waiver forms, scheduling and completing the fingerprinting process, and returning all completed items to DOM DoIT for processing. Please confirm you have discussed this with your candidate, and he/she will comply if selected. Question9PROVIDE CANDIDATES FULL PHYSICAL ADDRESS where DOM DoIT Background Check form and Fingerprint cards are to be mailed [REQUIRED]