Sign in

SQL Server Developer role in Raleigh NC

vTech Solution Inc
Raleigh, North Carolina, United States
August 12, 2019


Role: SQL Server Developer

Location: Raleigh NC

Duration: 12 Months(Till - 03/10/2020)

Interview: In-Person Only


Short Description:

Microsoft SQL Server Developer required to assist with ORBIT maintenance activities.

Complete Description:

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


• 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


Skills Required / Desired Amount of Experience Last Used Years Used

Microsoft SQL Server T-SQL (functions, stored procedures, etc Required 7 Years

Microsoft SQL Server Reporting Services Required 5 Years

Microsoft SQL Server Integration Services Required 5 Years

Data Modeling Highly desired 3 Years

Microsoft SQL Server Query Performance and Optimization Tuning Required 5 Years

PowerShell Desired 1 Year

Experience with Microsoft SQL Server 2016 Highly desired 18 Months