DIRECT CLIENT // SQL Server Developer

[Sunny Roy]

Very urgent DIRECT CLIENT Opening.  Please send the resumes at Su...@cncconsulting.com 

Job Title: SQL Server Developer

Location: Raleigh, NC

Duration: 1 year

This position is for a Senior SQL Server developer with in-depth development experience with recent versions of SQL Server; specifically, with 2014, 2016 and or 2017. Responsibilities will include developing new systems containing complex stored procedures, writing SSIS packages along with performance tuning and enhancements of existing system. Duties may also include developing data models, performing data analysis, assisting application developers with complex query tuning and schema refinement. Our ideal candidate will have a passion for programming, learning new technologies and be a motivated analytical problem-solver.

Essential Functions:

Develop complex queries and stored procedures using T-SQL

Design and development systems that meet defined business requirements

Independently analyze and solve complex problems

Evaluate large and complex data sets

Write and maintain technical documentation

Manage source code versioning and deployments

Write and maintain SSIS Packages

Assist application developers in refining complex queues and performance tuning

Assist with the debugging and optimization of SQL queries, stored procedures and overall database programming

Participate in design and code reviews and ensure adherence to best practices

Qualifications:

Bachelor’s Degree in Computer Science or related field preferred

6+ years development experience with Microsoft SQL Server including recent experience with 2014, 2016 and or 2017

Experience in SSIS and SSRS

Proficient in SQL development (complex queries, stored procedures and user defined functions) and performance tuning

Familiarity with source code management systems (Git, Subversion, TFS)

Knowledge of tracking software such as Jira and Confluence

Excellent communication skills (written and verbal)

Specific Skills/Attributes:

6+ Years’ experience coding T-SQL including the use of dynamic SQL

Skill in building application that combine database technologies with applications to produce best of breed solutions

Team oriented

Attention to detail

Microsoft SQL Server T-SQL (functions, stored procedures, etc...)

Required7Years

Microsoft SQL Server Reporting Services

Required5Years

Microsoft SQL Server Integration Services

Required3Years

Data Modeling

Highly desired3Years

Microsoft SQL Server Query Performance and Optimization Tuning

Required5Years

PowerShell

Desired1Years

Experience with Microsoft SQL Server 2016

Highly desired18Months

Thanks,

Sunny Roy
Su...@cncconsulting.com