SQL Developer

Datavail - Broomfield, CO (30+ days ago)2.7


LOCATION: Anywhere USA

Job Description:
The SQL Developer will focus on T-SQL coding, code optimization, revision, and tuning, SSIS & SSRS development, issue remediation, and providing development support for application developers at a project level. The SQL Developer will work on performance tuning, production bug fixes, and help to guide process improvement within the DBA group. An ideal candidate will have at least five years of experience in SQL Server development, SSIS, will possess an expert understanding of the SQL Server architecture, and will demonstrate a solid grasp of advanced T-SQL coding techniques focusing on performance. Responsibilities will include developing new systems containing complex stored procedures, writing SSIS packages along with performance tuning and enhancements of existing system. Experience with Business Intelligence development and troubleshooting required.

Job Responsibilities:
Develop, design and implement advanced T-SQL queries to improve database performance, reduce costs and meet the business needs.
Proficient in T-SQL performance tuning techniques.
Independently analyze and solve complex problems
Identify bottlenecks in OLTP, warehouse and SSIS
Responsible for ETL, data conversion and data migration projects using SQL Server Integration Services (SSIS)
Assist end-users with reporting needs using SQL Server Reporting Services (SSRS)
Evaluate large and complex data sets
Develop and maintain SSIS Packages
Ensure performance, security, and availability of databases
Work with deadlock scenarios and finding resolutions
Assist with custom deployment projects as needed
Knowledge of best practices when dealing with relational databases

Skills Required:
Must have 5+ years of experience with Microsoft SQL Server, SSRS and SSIS
Expert in T-SQL and performance tuning
Ability to analyze, design, develop and evaluate complex databases and stored procedures
Ability to analyze, evaluate and optimize data structure
Ability to quickly grasp complex jobs and routines
Excellent background in producing high quality, structured, and production ready code, including workflow and data driven applications
Experience in PowerShell and VBScript
Experience working with Agile Methodologies
Experience with Cloud databases such as AWS RDS and Azure SQL Databases