Previous Job
Previous
IA - DHS - DBA 5 - SQL Developer
Ref No.: 17-28439
Location: Des Moines,, Iowa
This position is for a SQL Developer with Transnational system development , ETL, Analytical Reporting experience - please read through the skills section and entire description for more detail.

NOTE: THIS IS A DEVELOPER ROLE WHERE THE RESOURCE SPECIALIZES IN CODING AGAINST A SQL BACKEND DATABASE. IT IS NOT A DBA POSITION WHERE THE RESOURCE IS DOING MAINTENANCE, UPGRADES, STORAGE ALLOCATION OR BACKUP.

This position has the potential to extend past the initial first year.

The successful candidate will spend a good portion of their time working with the Systems that support Child Welfare, Medicaid, TANF, and SNAP Systems and expected to work in concert with Front End developers developer(s) troubleshooting system problem reports and processing enhancement requests.
While working on system enhancements the successful candidate is expected to propose, design, and develop solutions in concert with the front end developer(s) to fulfill the requirements of the request.
The successful candidate will be required to follow standard practices for migrating changes to the test and production environments and provide post production support. When not working on enhancement requests or problem reports, the candidate would concentrate on performance tuning.

Preference will be given to those with Child Welfare, Medicaid, TANF or SNAP

Individual should work well in a team and independently as needed.
Skill
Required / Desired
Amount
of Experience
Experience in working with SQL Server 2008 R2, 2012, and 2016
Required
5
Years
Expert knowledge of T-SQL
Required
5
Years
Experience in developing and optimizing complex stored procedures
Required
5
Years
Experience in working with user defined functions and triggers
Required
5
Years
Database modeling and design
Required
5
Years
Execution of SQL best practices in regards to security and privacy
Required
5
Years
Experience in building ETL processes using SQL Server Integration Services(SSIS)
Required
5
Years
Experience in working closely with .Net development team
Required
5
Years
Knowledge of Crystal Reports and SQL Server Reporting Services(SSRS) is a plus
Required
5
Years
Experience with SDLC and Agile development practices
Required
5
Years
Experience in working with big databases ( over 1 TB)
Required
5
Years