SQL Developer SSIS / SSRS

Your Role

Develop, maintain, and update SQL Server stored procedures, views, SSIS packages, and SSRS reports

Identify opportunities to make improvements and implement solutions

Complete SSRS Report writing, which includes an understanding of the underlying data, data structure and business terminology

Optimize the reports and underlying stored procedures that take longer to run

Troubleshooting data issues, validating result sets, performing unit testing

Help write and optimize in-application SQL statements

Collaborate withother team members and stakeholders

Requirements

6+ years of experience in Microsoft SQL Server environment with SSRS and Stored Procedure development

Very strong skills in T-SQL development, including query optimization, building and modifying stored procedures, functions, and creating tables and views

Advanced knowledge of T-SQL, including transactions, (begin..try, merge, common table expressions, ROW_NUMBER/OVER, bulk insert, filtering and covering indexes, computed columns)

Experience in version control software, such as Microsoft TFS

Experiencewith Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools

Strong experience in providing ownership, management, design, development and support to OLTP systems

Ability to navigate and understand large complex database structures for sourcing data

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server

Experience in Agile development environment

Experiencewith backups, restores and recovery models

Strong verbal and written communication skills, with an ability to express complex technical concepts in business terms and complex business concepts in technical terms.

Ability to multi-task and context-switch effectively between different activities and teams