Job description

Details:

Role: SQL Database Consultant (Technical Specialist)

Job Id - 704247

Location: Remote

Mode: Contract

INTERVIEW DATES: Interviews will be conducted on [March 6 and 7]

Overview-

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.

Job Responsibilities

· 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.

Must Have Skills-

· 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.

· Experience integrating Okta and providing support for updates to AD.

· Experience in integrating event logging and auditing for applications.

· Experience in protecting data in the database and in transit.

· Ability to work under tight deadlines.

Tools/tech used at IVRS:

• C#

• ASP

• MVC

• JavaScript

• HTML

• SQL

• Web API (ASP.Net)

• SOAP

• REST

• .Net Framework

Skills:

• Experience integrating Okta and providing support for updates to AD

• 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

Job Type: Contract

Salary: $50.00 - $60.00 per hour

Experience level:

• 9 years

Schedule:

• 8 hour shift

Experience:

• Microsoft SQL Server: 7 years (Required)
• T-SQL: 7 years (Required)
• Okta: 7 years (Required)

Work Location: One location

Speak with the employer
+91 7325154099

gatheringourvoice.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, gatheringourvoice.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, gatheringourvoice.org is the ideal place to find your next job.