SQL SERVER DATABASE ADMINISTRATOR Resume

SUMMARY:

Highly analytical and results - driven IT professional with over 5 years of progressive experience in MSSQL SQL server database administration, and Microsoft Azure.
Proven success in deployment of effective IT roadmaps, processes, and procedures involving setting up high availability and disaster recovery solutions in SQL such as Always On availability groups, log shipping, mirroring, replication, and traditional fail over clustering.
Significant expertise in SQL server upgrade and database migration along with Azure Databases, elastic pools, and new instances installation.
Well versed in building and managing users in active directory, creating, and migrating VM in Azure.
Demonstrated history of successful execution of various processes comprising of disaster recovery solutions, performance tuning, and monitoring.
Excel at supporting mission-critical databases on both premise and Azure with the highest efficiency.

TECHNICAL SKILLS:

SQL Server |PowerShell | Microsoft Azure | Transparent Data Encryption |Always Encrypted VmWare | Hyper-V | T-SQL |IaaS | SaaS | PaaS

PROFESSIONAL EXPERIENCE:

SQL SERVER DATABASE ADMINISTRATOR

Confidential

Responsibilities:

Upgraded SQL Server from 2008 R2 to 2016 using both in place and side-by-side upgrade.
Migrated database using backup and restore, detached and attached, log shipping and database mirroring.
Maintained and achieved high-availability of database via coordinating with infrastructure teams to allocate system resources to database Server.
Troubleshoot and resolve SQL Server performance issues using both SQL Server inbuilt and 3rd party tools.
Automate SQL Server administrative tasks using Maintenance plans and Store procedures
Assess Databases for cloud Migration using the DMA tool, correct Migration blockers.
Migrate databases to Azure SQL, Azure managed instance
Build VMs in Azure for SQL installation

SQL SERVER DATABASE ADMINISTRATOR

Confidential

Responsibilities:

Acted as a subject matter expert while facilitating programmers and engineers to efficiently use database systems.
Created and integrated DB backup/restore and disaster recovery strategies on company’s SLA leveraging proven methodologies.
Utilized PowerShell scripting and removed local admin rights from all users and performed several monitoring tasks via PowerShell.
Mitigated downtime, fixed overall database access and performance issue, and uncovered anomalies while patching and upgrading database Servers and Windows Server.
Generated prompt response to tickets, resolved user request based-off priority, and ensured database configuration maintenance in the configuration repository.

SQL SERVER DATABASE ADMINISTRATOR

Confidential

Responsibilities:

Implemented change management process and resolved tickets with absolute precision in a timely manner.
Coordinated with customer and 3rd party vendors to manage and support the database system and operations.
Devised effective solutions for slow running queries, deadlock, and blocking issues to optimize overall productivity.
Developed testing, backup, and recovery plans employing both SQL Server level backups and Veeam backups.
Leveraged expertise regarding extended events and SQL profiler while supervising SQL server performance.
Accomplished on time upgrades and migrations from SQL server /R2