Azure PAAS, IAAS & ITIL certified technocrat with 13+ years of progressive experience with key focuses on Database Administration focusing on MS SQL DBA, Azure SQL, Implemented Power BI solutions for data visualization, data modelling and Automation using Powershell, implement data warehousing platforms with SSIS and Azure cloud migration.
Hands on experience and SME in database administration and performance tuning using MS SQL Server 2016/2012/2008R2/2008. Experience with report development, dashboards, data modelling using DAX & visualization, data gateways using Microsoft Power BI. Adept at implementing SQL data warehouse solutions for clients using BI tools (SSIS/Power BI) and designing SSIS packages for dimensional and fact loads. Worked with SSRS Report administration and developing ARM templates for Azure VMS, Storage, Azure Key vault.
Prudent in migrating on-premises databases to SQL Azure Platform using Azure migration services(DMS), bacpac, replication. Successful in setting up infrastructure, PaaS & IaaS with different data centres for DR using Geo-replication, Azure Site recovery(ASR) while managing MS SQL Server Cluster Installation/upgrades, Migration, SQL Security(GDPR),
Back UP/Restore strategies, Capacity planning. DR Configurations like Clustering, ALWAYS ON, DB Mirroring, Log Shipping, and SQL Performance Tuning using DMVs, query tuning and T-SQL activities.
Successfully working with the cross-functional team environments, clients & employees from diversified backgrounds & geographies including USA