SQL Server migrations and upgrades, years of experience in planning, documenting and execution, some of the many migrations from SQL 2000/ 2005/ 2008/ 2012/ 2014/ 2016/ 2017 to SQL 2005/ 2008/ 2012/ 2014/ 2016/ 2017(linux)/ 2019/ SQL Azure.

SQL Server Installations:

Performed many various types of (documented) installations and along with industries best  practices configurations of express/ standard and enterprise editions, on physical and virtualized  environment(s)  like VMware and Azure SQL including Standalone, Failover Clusters  with and without Always ON  with single/multi-subnet and Geo Replication and more.

Standardized Environments and Automation

Standardized environments for unified and easier management (jobs, alerts, backups, extended events, live alerts for security/ storage/ failover/ system configuration changes/ backup job changes/ job failures/ dead lock detection/ blocking detection/ High CPU usage detection/ Service down detection and more.

Azure Cloud :

Good knowledge and understanding of Virtualization

Experience with Azure SQL Server and Database.

Provisioned /created Microsoft Azure Storage (Blob, File, Queue and Tables), VMs, databases and database servers, virtual networks, VPNs, Linux (Red Hat, CentOS), web app deployments, Apache/ Tomcat /Nginx , Active directory, DNS, SQL Migration, Virtual/Physical migrations, backup/restore, DTU, eDTU, resource pools, elastic pools and more

LogShipping

Setup and maintained log-shipping in various organizations for multiple databases on multiple  instances i.e. one database to many instances for reporting and recovery.

Mirroring

Setup and maintained  mirroring along with database snapshots in various organizations.

Disaster Recovery

Plan, prepare, setup, test and execute SQL environment(s) in various organizations for disaster recovery along with documentation for every step of the process.

SQL Server Health Checks

Planned/ scheduled/ executed & actioned health checks on sql server from various prospective, recovery, configuration, security, performance, etc.

SQL Replication (snapshot, transaction, merge)

Implemented and maintained replication for all types.

Partitioning

Implemented Table partitioning along with filtered indexes.

Also experienced in distributed tables.

SQL Server Reporting Services (SSRS)

Installed, maintained and produced reports related to SQL security, performance, storage, troubleshooting and more.

SQL Server Performance Tuning,

worked on performance Tuning in various organizations  in design, application, memory, I/O etc.

VMware:

Worked very closely with sysadmins and have provisioned storage, VM, ESXi installations, data center operations (racking, cabling, etc), patching, setup and tested SRM.

Database Security

I have setup and prepare the Test Pre-Prod and Production environments for audit, SOX/HIPPA compliance to meet organizational standards

Others

Others include SAS,Power BI,ETL, SSIS, Automation, TDE, query store, temporal tables, data masking, always encrypted, service broker, row level security, extended events, trace, perfmon, resource governor, Sql agent alerts/job management, red gate, solar winds, spotlight and more