** 100% REMOTE, (Going to work as per EST / CST Time Zone) ***
- 10+ years of hands-on experience maintaining SQL databases, including expert level skills in SQL and T-SQL.
- Expert knowledge of MS SQL Architecture, including Azure SQL Cloud Architecture and Concepts with experience in Azure SQL Server / Managed Instances / Elastic pools.
- Hands-on experience designing and implementing ETL/ELT processes in support cloud-based data analytics environments.
- DDL/DML expertise, Optimizing and Performance Tuning using execution plans, Profiler and Database Tuning adviser.
- Ingest and aggregate data from both internal and external data sources to build data lake (ADLS gen2)
- Strong understanding of data modeling (i.e., conceptual, logical, and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
- Application development or PowerShell automation experience a plus.
SQL, T-SQL, MS SQL Architecture, Azure SQL, ETL, DDL, DML, Datalake, Data Modeling, Powershell, Data Warehouse, Data Marts, Performance Tuning