Senior MS SQL Database administrator & ETL Expert (m/w/d)

The Adastra Group is an international IT consulting company with 23 international offices and headquartered in Toronto, Canada. Adastra provides leading companies with the full range of consulting services in information management - from conception to implementation and application of innovative and efficient solutions in the areas of Data Warehousing, Business Intelligence, Big Data Analytics, and Cloud solutions. With over 2000 experts worldwide we bridge the gap between business departments and IT to increase the operational efficiency of our customers. For more information, please check [login to view URL] Your responsibilities: Continuous analysis of customer ETL processes and MS SQL Queries to identify improvement opportunities Refactoring of existing queries and DWH data models to improve logic and performance Development of an in-depth view of customer landscape and suggesting further topics to optimize the infrastructure, query, architecture, reporting, maintenance and change management processes of the customer’s ODS and DWH landscape As an expert you would develop better ETL processes for the customer to cater to new requirements Adequate knowledge of SSIS and SSAS development and analysis skills Required Skills, Knowledge and Experience: SQL Server performance optimization T-SQL Query optimization skills Analysis of execution plans, statistics, indexes ETL processes development/optimization Fluent in English Nice-to-have: DWH data modeling knowledge Experience with SSIS development/analysis SSAS skills (multidimensional), cube development/analysis (MDX) Working knowledge of the Azure Platform is a big plus Open to work in US time zone is a Must