Shahan Vohra

About Shahan Vohra

10+ years IT experience. Expertise in SQL Server 2022/2019/2016/2014/2012/2008 and Azure SQL. Proficient in cloud platforms like Azure (IaaS/PaaS) and AWS. Skilled in High Availability solutions including AlwaysOn AG, Failover Clustering, Log Shipping, Replication, and Mirroring. Strong in Backup & Recovery strategies—Full, Differential, and Transaction Log. Adept in Security & Auditing using TDE, Row-Level Security, and Role-based access. Performance tuning using SQL Profiler, Extended Events, and monitoring tools like SolarWinds and Redgate. 🧪 Troubleshooting long-running queries, deadlocks, and connectivity issues. Automation via PowerShell, T-SQL, and SQL Agent Jobs. Business Intelligence development with SSIS, SSRS, and SSAS. Regular maintenance including Indexing, DBCC CHECKDB, and Statistics Updates. Experience with Migrations and Upgrades using DBATools, Log Shipping, and Restore methods. Knowledge of networking components: TCP/IP, DNS, Firewall rules, and Linked Servers. 🧱 Database design using ER models and normalization standards. Familiar with DevOps, Git, CI/CD, and version control tools. Replication strategies across environments. Collaborative in Agile environments using JIRA, Confluence, and ServiceNow. Strong documentation skills with SOPs, RCA reports, and Runbooks. US Citizen

Experience

1. Senior Sql Database Engineer Administrator

   UnitedHealth Group

   Feb 2021 — Present · Minnetonka, MN, US

   Led automation of routine DBA tasks across 750+ SQL Server instances (2016, 2019, 2022) using PowerShell, T-SQL, and SQL Agent, cutting manual workload by 60% and boosting efficiency. Created PowerShell scripts for index maintenance, health checks, backups, restores, and alerts, speeding incident response. Implemented and maintained Always On Availability Groups in hybrid cloud (on-prem and Azure), ensuring high availability and disaster recovery with minimal downtime. Optimized database performance via monitoring tools like SolarWinds DPA, SQL Sentry, and DMVs, reducing blocking, deadlocks, and CPU spikes. Tuned long-running queries and stored procedures using SQL Profiler and Query Store, applying filtered indexes, indexed views, and partitioning to improve large data handling. Led automation of SSIS deployments using CI/CD pipelines integrated with Azure DevOps, enabling faster, reliable data flows. Monitored performance baselines with Extended Events and Performance Monitor to detect memory, I/O, and CPU issues. Configured SQL Server 2022 features like Query Store hints and Accelerated Database Recovery to enhance resiliency and performance. Designed automated policies for roles, permissions, and audits to meet HIPAA and compliance standards. Collaborated with data engineers to automate ETL with SSIS and Python, improving healthcare data ingestion. Performed monthly failover and patch testing in non-prod to validate HA/DR and reduce risks. Standardized backups with customized Ola Hallengren scripts, including differential, log, and offsite backups, with automated reporting. Maintained SSRS and Power BI dashboards for analytics. Supported 275+ TB healthcare data with zero data loss, meeting RTO/RPO. Documented automation and tuning for team use and audits. Recognized for excellence and nominated for the “SuperHero Award” in 2023.

Education

• University of the Potomac

  Master of Business Administration - MBA, Business Administration and Management, General

  2015 — 2017

• A D Patel Institute of Technology, CVM University

  Bachelor's degree, Computer Science

  2011 — 2015

• VP & RPTP Science College, Vallabh Vidyanagar, Gujarat, India

  High School, Science

  2009 — 2011