Pragyan Sahoo Email & Phone Number

• Overall 10+ years of experience in SQL Server Database Administration of MSSQL Servers• Experience in MS SQL Server2019, 2017, 2016, 2014, 2012, 2008R2, 2008 Installation, configuration and administration• Certified in [70-462]Administering Microsoft SQL Server 2012 Databases which assesses installing, configuring, and maintaining SQL Server 2012 databases• Created User databases with appropriate Initial Size and defining relevant file growth mechanism for the mdf, ldf and ndf(if any) files and filegroups(if required) according to the specifications required.• Monitoring Always On Availability groups, their replicas, databases and Always On health sessions and sequence of events • Creating Databases, Tables,StoredProcedures and Views for operational activitiesthrough T-SQL commands• Worked on various types of Backups and Restoration of databases • Handled issues pertaining to databases configured with various types of Recovery Models• Up-gradation/Migration of SQL Servers from 2005 to 2008/2008R2 and 2008R2 to 2012 in different machines • Planning and migrating databases between Instances and higher versions of SQL Server • Detaching and re-attaching databases for up-gradation of databases• Configuring, implementing, managing Log shipping and monitoring Alerts • Configuring, implementing, managing Database Mirroring and monitoring Alerts • Troubleshooting Log shipping, database mirroring issues and fixing them • Creating database snapshots for accessing/reading the mirror/secondary database data • Troubleshooting Failover Cluster resourcesandanalyzing cluster logs• Checking fragmentation of indexes and perform maintenance (Index reorganize and rebuild based on average fragmentation results) • Managing alerts, SQL server agent job failures and maintenance of DBA jobs • Experience in Data Base Tuning using Database Engine Tuning Advisor, identify and troubleshoot using profiler, SQL log and Trace Files • Experience in Production, Pre-production and Test environments for data migration/data availability using backups and restore and import and export wizards • Shrinking Files and Databases for releasing unused space• Monitoring Query Performance using DMV and DMF (Dynamic Management Views and Functions) and SQL Server Profiler

• 

  The Techno School

  Electronics And Instrumentation