NationalTechJobs
Location: Des Moines, IA
Pay Rate: $48/hr w-2 with benefits
Duration: 6 months with extensions
Start Date: ASAP
Position ID: IA585529
IN-PERSON INTERVIEWS ONLY
Senior TSQL Developer with strong coding skills and extensive experience designing, developing and maintaining complex TSQL stored procedures, SSRS reports, and database schemas.
Project Detail:
Federal reporting requirements are changing after the first of the calendar year. These new reporting requirements will require modifications to existing, complex SQL stored procedures that generate data files for quarterly submission to the Rehabilitation Services Administration (RSA).
Several SSRS reports are near completion but require additional code modifications and testing to validate the accuracy of calculations and data presented on each report.
The person in this role will be working primarily with a Business Analyst and a Case Management Systems Project Manager. Much of the technical T-SQL programming and SSRS development will be the sole responsibility of this position. There are, however, staff that does have limited technical knowledge who will be able to assist with introducing the Case Management database and related stored procedures.
• Tools used will be Microsoft SQL Server 2008 R2, Microsoft Team Foundation Server 2017, Microsoft SQL Server Reporting Services 2008 R2, Microsoft SharePoint 2010.
• Day to day duties will include developing and maintaining T-SQL code and using SSRS to design and create new reports and maintain existing reports.
• There will be situations where database schema changes and additions will be necessary to satisfy the business rule requirements.
• Testing all approved changes before user acceptance testing will be required for all code additions and changes planned for migration to the production environment.
SKILL | AMOUNT OF EXPERIENCE | REQUIREMENT | |
In-depth experience using Microsoft SQL Server with SQL Server 2008+ | 5 Years | Required | |
Complex T-SQL stored procedure design, coding, troubleshooting and performance tuning | 5 Years | Required | |
Dynamic SQL stored procedure coding and troubleshooting | 5 Years | Required | |
Proven analytical problem solving and debugging skills | 5 Years | Required | |
Effective written and verbal communication skills | 5 Years | Required | |
Ability to translate business requirements into technical specifications | 5 Years | Required | |
T-SQL development including the use of views, stored procedures and indexing techniques | 5 Years | Required | |
Strong experience creating test data and thoroughly testing T-SQL code | 5 Years | Required | |
Critical thinking skills | 5 Years | Required | |
Experience working under tight deadlines. | 5 Years | Required | |
Experience maintaining and administering of development, staging and production SQL Server database server environment | 5 Years | Desired | |
Experience with performance tune existing stored procedures, tables, triggers and indexes | 5 Years | Desired | |
Experience with Microsoft SharePoint | 3 Years | Nice to have | |
Strong Microsoft SQL Server Reporting Services experience | 5 Years | Required | |
Experience with maintaining and managing changes and additions to database schemas | 5 Years | Required | |
Experience with Team Foundation Server (TFS) | Nice to have |
20190121
Salary: $48/hr w-2 with benefits
Benefits: Health Insurance Stipend, Holiday Pay, Paid Time Off (PTO), Student Loan Repayment (Quarterly)
Complete Form Below