Adarsh G.

Work Experience : 5 year in IT company Database Development | Clustering | Performance Tuning | High Availability & DR | Database Design | Backup & Restore | SSIS | SSAS | SSRS | Always On | Log Shipping | Mirroring | Replication | Azure SQL Database | SQL Profiler | Extended Events | Migration | SQL Server Patching | Database Security | Automation | PowerShell HIGHLIGHTS • 5 years’ MS SQL Database Administrator, backup & restore, SQL tuning, database performance analyzing, and DR • Spearheaded team of 14 in solving real time issue in SQL server for 11 clients globally (insurance, medical, web services) • Managed 9000+ SQL Server Databases with 300+ SQL instances • Resolved 120+ real time incidents per month, task, change implementation, and GCR’s • Applied latest Service Packs i.e., patching in 300+ development and production servers • Managed 50+ servers of log shipping, mirroring, high availability & DR • Secured 2nd Rank out of 1200 Students in Intermediate Examination, A.N College Patna. KEY SKILLS • Detecting and Solving BUGs in SSMS operations and monitoring outcomes • Implementing DR solution, high availability of database servers using Database Mirroring and Log Shipping • SQL Server security and object permissions, database authentication modes, creation of users, and configuring permissions • Installation, configuration, maintenance and administration of SQL Server 2019/2017/2016/2012/2008R2/2008/2005 • Performing integrity checks; methods include configuring database maintenance plan wizard and DBCC utilities • Perform Full, Network and Transaction Log Backups and restore when necessary • Creating backup and restoring strategies and scheduling for execution as per client requirements • Creating Jobs, Alerts, SQL Mail Agent, and scheduling DTS and SSIS Packages. LANGUAGES & TECHNOLOGIES Languages: T-SQL, HTML, PowerShell Tools: SQL Server Management Studio, DPA i.e., Solar wind, Veritas NetBackup, Service Now, BMC Remedy, Office 365, Data Migration Assistance Cloud and Databases: Microsoft SQL Server, Azure SQL Database