Job Description :
Title: SQL Server Developer (SSRS, SSIS, ETL)
Location: Raleigh, NC, United States
Length: Long term
Description:
Interview Type: Skype
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
* 8 years SQL Server
* Experience with Microsoft SQL Server 2016
* versioning
* best practices
* data modeling
* query performance tuning
* powershell
* 6+ years development experience with Microsoft SQL Server including recent experience with 2014, 2016 and or 2017
* 5 years 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)