10+ Years of experience in managing high transaction volume on relational SQL - MS SQL Database Administrator and on Azure Cloud and AWS RDS Databases in Production and Non-Production Environments.
• Designing and Implementation of High Availability and Disaster Recovery solution (HADR - SQL Server Clustering , Always-ON , Database Mirroring , Log-shipping, Replication) for mission critical applications.
• Experience on MS Business Intelligence and Data Warehousing systems using SSAS, SSIS, SSRS and PowerBI.
• Experience in automating infrastructure as code (IaC) using DevOps tools - Ansible and Terraform.
• Experience on Microsoft Azure - Azure VMs, Azure SQL Databases, Managed Instance, SSIS SSAS - Azure Data Factory Services.
• Working in a role of Database Migration Engineer, to upgrade \ migrate the database
Physical to Virtual Server (P2V & V2V), On-premise DB to Cloud DB and onto Nutanix
Hyper-Conversed environment with proper proof of concept.
• Experience on SQL Server In-Place Upgrade and Side-by-Side migration of SQL Server version 2008R2\2012 to 2014\2016.
• Design and creation of database architecture and design - SQL objects like Tables, Views, Stored Procedures etc and writing T-SQL scripts.
• Hands-on experience on Powershell and Python scripting.