Job ID :
10298
Company :
State of Iowa
Location :
DES MOINES, IA
Type :
Contract
Duration :
Approx.1 Yr
Salary :
Open
Status :
Active
Openings :
1
Posted :
03 Aug 2017
Job Seekers, Please send resumes to resumes@hireitpeople.com
Int. type - Either Web Cam or In Person Interview.

Short Description:  This position is for a SQL Developer with Transactional system development experience (.Net/C# Code Front-end using a SQL Server database).  - please read through the skills section and entire description for more detail.

Complete Description:  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 KinderTrack front end 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 candidate will also be responsible for system testing and working with the business users during acceptance testing.  

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.


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 with big databases ( over 100 GB)
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