SQL Database Developer // IA

Location: Des Moines, IA
Date Posted: 01-04-2018
SQL Database Developer
12 Months
Des Moines, IA
 
Short Description:
This position is for a SQL Database Developer with Transactional system development , ETL, Analytical Reporting experience  - 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 IS NOT FOR A DATA WAREHOUSE DEVELOPER, WE WANT TO FOCUS ON DATABASE DESIGN AND DEVELOPMENT following a relational model with normalized table.  Understand where we need to de-normalize the database as needed to increase performance. 
This person will need to obtain the requirements and work independently.  Guidance and feedback would be surrounding the business rules and operations, not how to perform the technical duties.
Resource will be responsible for evaluating business requirements and designing an optimal database structure.  They will design an efficient database structure that will ensure optimal performance from a query and data access perspective.
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 Care, 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 business requirements. 
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.
 
Skills:      
  • 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 (scaler and table functions). Required 5 Years
  • Database modelling 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
 
Regards,
Swami
Key Business Solutions, Inc.
|| Email: recruiter8@keybusinessglobal.com || Office: 916 646 2080 Ext 215 || Fax: 916 646 2081
 Note: This email is not intended to be a solicitation.  Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list
 
or
this job portal is powered by CATS