Service-Disabled Veteran-Owned Small Business (SDVOSB)

Senior TSQL Developer – IA583529

NationalTechJobs

This is a Contract position in Des Moines, IA posted January 21, 2019.

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

Package

Salary: $48/hr w-2 with benefits

Benefits: Health Insurance Stipend, Holiday Pay, Paid Time Off (PTO), Student Loan Repayment (Quarterly)

How to Apply

Complete Form Below