I have over 10 years of solid experience with MSSQL covering all areas from database development with T-SQL and .NET, ETL with SSIS, Business Intelligence and reporting with SSAS and SSRS and database administration. This covers all versions of SQL Server from 7 - 2017.
I have a very high degree of proficiency in writing SQL and am able to make use of advanced features such as Analytic (Window) Functions, both recursive & non-recursive CTEs, Pivoting, Set operations, Row Constructors, .NET Custom Aggregates, etc. I am also very good at reading query plans and performing query optimization. In addition to relational database development, I have also designed and implemented OLAP cubes using SSAS, and can write MDX queries directly.
On the Database Architecture/DBA side, I have architected and maintained entire database environments, implementing systems for Backup/Recovery, DR/High availability, Standardized Builds, Monitoring, Replication, Provisioning of Staging/Test environments, SAN integration, etc., all with as much automation as possible.