Hirak M.

Scripting: T-SQL, PowerShell SQL Server Tools & Techniques: SSMS, Profiler, PAL, PerfMon, SQLCMD/OSQL/PSSQL, DBCCs, DMOs, Data Collector, Extended Events, Performance Tuning (Database Tuning, Index Tuning, Data Compression, De-fragmentation), Optimization, Query Designer ETL Tools/Techniques: Data-warehousing, Data Modeling, OLTP & OLAP, SSIS, SSRS, SSAS High Availability & Disaster Recovery: AlwaysOn-AG, Clustering, Replication, Mirroring, Log Shipping Database & IT Operations: Capacity planning Design & Implementation of environments (Data Platforms & BI) Security planning HADR planning Deployment of new releases across various database platforms Managing incidents from low to high severity across the entire problem life-cycle in accordance to ITIL