
Senior SQL Server Database Administrator with 6+ years of experience managing enterprise Microsoft SQL Server environments supporting mission-critical applications across Production, QA, UAT, and Development. Expertise in SQL Server installation, configuration, administration, performance tuning, backup and recovery, High Availability (Always On Availability Groups, Log Shipping, Replication), Disaster Recovery, database migrations, security, and automation using PowerShell and dbatools. Experienced in administering SQL Server 2012–2022 in both on-premises and Azure environments while ensuring high availability, optimal performance, and data integrity. Proven ability to troubleshoot complex production issues, optimize database performance, automate administrative tasks, and collaborate with cross-functional teams to deliver reliable, scalable, and secure database solutions.
Databases: SQL Server 2012–2022, Azure SQL Database, Azure SQL Managed Instance
Database Administration: Installation & Configuration, Upgrades & Migrations, Database Refresh, Patch Management, Capacity Planning, Production Support
Backup & Recovery: Full, Differential & Transaction Log Backups, Point-in-Time Recovery, Disaster Recovery, Restore & Recovery Validation
High Availability: Always On Availability Groups, Failover Cluster Instances (FCI), Log Shipping, Replication, Database Mirroring
Performance Tuning: Query Optimization, Execution Plans, Indexing, Statistics, Query Store, Blocking & Deadlocks, TempDB Optimization
T-SQL: Stored Procedures, Functions, Views, Triggers, CTEs, Joins, Dynamic SQL
Security: Logins & Permissions, TDE, Dynamic Data Masking, Always Encrypted, SQL Server Auditing
Monitoring & Automation: SQL Server Agent, Extended Events, DMVs, PowerShell, dbatools
Cloud & Tools: Microsoft Azure, Azure Virtual Machines, Azure Monitor, SSMS, Azure Data Studio, Redgate SQL Monitor, Git, Jira