AffluentTEK

Professional IT SOLUTION

IT staffing

AffluentTEK staffing practice delivers high-quality staffing services built on industry best practices. We work with our clients to recruit and retain the best information technology talent possible read more

Services

AffluentTEK developed a comprehensive approach to consulting that moves clients  read more

Solutions

Our business solutions can help you increase sales, better manage cash flow and enable you to spend quality time. We craft a unique solution that help you better run your business.

Copyright © AffluentTEK
Phone # : 585.568.7445
Fax # : 585.568.7209
FaceBook
Twitter
LinkedIN
NEXT
Previous

Title: SQL Developer

No. of Openings: 3

Work Location: Des Moines, IA

Interview Type: In Person Only

Pay: 100K to 110K (DOE) on W2

 

 

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.

 

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.

 

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.

 

Required Skill

Experience in working with SQL Server 2008 R2, 2012, & 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