Job ID :
8185
Company :
State of Iowa
Location :
DES MOINES, IA
Type :
Contract
Duration :
1 year
Salary :
Open
Status :
Active
Openings :
1
Posted :
24 Oct 2015
Job Seekers, Please send resumes to resumes@hireitpeople.com
Int. type- Either Web Cam or In Person Interview.

Short Description:  Please note this is a SQL Developer position with a focus on resources who have worked heavily in transaction systems.

Heavy concentration on performance tuning - queries, stored procs, SSIS packages, etc.

Complete Description:  The successful candidate will spend a good portion of their time working with front end (.Net)  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 2008 and SQL 2012.
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
Experience in building ETL processes using SQL Server Integration Services(SSIS)
Required
5
Years
Experience in working with large databases ( over 100 GB)
Required
5
Years
Experience with SDLC and Agile development practices
Required
5
Years
Knowledge of Crystal Reports and SQL Server Reporting Services(SSRS)
Highly desired