SQL Developer SSIS / SSRS
5 - 7 years experience • Education
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