Skills
Database Administration: SQL Server 2008–2022 (standalone & cluster), stored procedures, functions, triggers, complex query development, database design & normalization, SSMS, SSDT, SQLCMD
Performance & Query Optimization: Query Store, Plan Cache Management, MAXDOP, Extended Events, Wait Statistics, TempDB Optimization, execution plan analysis
Backup, Recovery & HA/DR: Backup & recovery strategy, Always On Availability Groups, Log Shipping, Replication, Azure Geo-Replication, WSFC
Database Security: TDE, Always Encrypted, DDM, RBAC, Key Vault, HIPAA compliance
Production Support: Incident and change management, root-cause troubleshooting, failed-job analysis and prevention, capacity planning for very large databases (VLDB)
ETL & Data Integration: SSIS, ETL pipeline design and troubleshooting, Data Lakes, OLAP/OLTP, Power BI, Tableau
Cloud & Migration: Azure SQL Database, Azure Managed Instance, Azure Data Factory
Monitoring Tools: SolarWinds DPA, SentryOne, Redgate Toolbelt, Azure Monitor, Veeam, Commvault
Additional Platforms: Working knowledge of Oracle, DB2, Cassandra
Analytics (secondary): MS in Data Science and Analytics; Python and statistical analysis applied to capacity forecasting
About
Senior SQL Server Database Administrator with 10+ years of enterprise production experience across highly regulated, performance-critical environments including banking and healthcare. Deep hands-on expertise designing and maintaining SQL Server databases, stored procedures, functions, triggers, and complex queries, with a strong track record of performance tuning, query optimization, and resolving production incidents under pressure. Skilled in backup and recovery, indexing, patching, database security, and HA/DR architecture (Always On Availability Groups, WSFC, Replication, log shipping, geo-replication). Experienced supporting database migration and modernization initiatives to Azure SQL Database, Azure Managed Instance, and Azure Data Factory, and collaborating with development teams in Agile/DevOps environments using Git and Azure DevOps for source control and deployment. Strong background in ETL processes and data integration, technical documentation, and maintaining data integrity and compliance with HIPAA, SOX, and other regulatory standards. Master of Science in Data Science and Analytics adds an added edge in statistical analysis and predictive capacity planning for proactive database management.