SSIS SQL Lead Dev

Responsibilities8 years of experience with SSIS and MS SQL Server databases.2 years of experience with cloud technologies.Extensive working experience with MS SQL Server databases, including writing stored procedures, functions, and triggers, as well as troubleshooting database-related issues for production fixes and defects.Experience working with visualization teams using PowerBI to create trackers and dashboards.Troubleshoot ETL failures and provide temporary and permanent fixes.Implement performance optimization techniques for SQL queries, databases, and SSIS.Perform database tuning and troubleshoot performance issues related to SQL queries, indexes, and table structures.Monitor SSIS packages for performance and reliability, resolving any failures or issues.Record and document defects in an issue tracking system with resolution steps.Provide user management services, such as notifying users of ETL loads and status of issue resolution.Collaborate with other teams and stakeholders, including third-party vendors if applicable, to resolve defects originating outside of the environment.Identify bottlenecks or optimizations in production processes.Manage user and communication aspects of production systems.Coordinate daily with onsite and offshore teams.Skills and QualificationsStrong analytical, coordination, verbal, and written communication skills.