4+ years of experience in SQL Server Database Administration across large and complex environments using SQL Server 2005 through 2019. Expertise in installing, configuring, upgrading, and maintaining SQL Server instances on-premises and in the cloud (AWS RDS & Azure SQL). Hands-on experience in managing backups, recovery, database design, security, performance tuning, and troubleshooting in production 24/7 environments.
Proficient in high availability and disaster recovery solutions including Clustering, Always On Availability Groups (AOAG), Database Mirroring, and Log Shipping. Experienced in monitoring database health, ensuring data integrity, and optimizing storage and performance. Skilled in developing and managing stored procedures, triggers, views, indexes, and user-defined functions.
Implemented automated tasks using PowerShell and SQL Agent jobs. Strong knowledge of performance tuning using SQL Profiler, Query Store, Extended Events, and Database Tuning Advisor (DTA).
Managed and provisioned Azure SQL databases, performed cost optimization in elastic pools, and migrated on-prem SQL databases to Azure. Configured and maintained SQL Server on AWS RDS, including monitoring, backups, and scaling operations.
Database Platforms:
Operating Systems:
Virtualization & Cloud Infrastructure:
SQL Server Tools:
Monitoring & ITSM Tools:
Productivity & Collaboration: