Senior Sql Server Database Administrator And Azure(Iaas And Paas Databases)
Current• Orchestrated the seamless upgrade of databases from SQL Server 2008 R2/2012 to SQL Server 2016/2017/2019/2022, resulting in heightened system efficiency and performance.• Orchestrating the planning and setup of disaster recovery for SQL Managed Instance (PaaS).• Strategizing and implementing disaster recovery for SQL VM (IaaS) through Azure Site Recovery.• Executing migration of SQL Server Instances from On-Premises to Azure IaaS and vice versa.• Configuring backup settings on Azure Vaults and Storage accounts.• Executed routine database maintenance tasks including backup/restore, re-indexing, and log file management, leading to enhanced data security and accessibility.• Applying expertise in Log Shipping, Database Mirroring, SQL Server Clustering, and Always On.• Managing large databases, overseeing backup/recovery, security architecture, and HA solutions.• Installation and configuration of SSAS and SSIS.• Installation, configuration, migration, and upgradation of SSRS.• Managing and developing SSRS reports.• Developing SQL management and monitoring solutions using SQL Central Management Server (CMS).