Shivom Agarwal

Background

About Shivom Agarwal

Extensive experience in installation, configuration of MS SQL Server 2005, 2008, 2008 R2, 2012 and 2014 with Service packs. Major role is Performance tuning and optimization of SQL queries as well as troubleshoot. Experience in SQL Server Profiler, Server-Side trace, Execution Plan, Performance Monitor Using (DMV, Rate gate tool) Planning and Implementing MS SQL Server Security and Database permissions. Good Experience in handling Database Backup, Restore and Disaster Recovery more over detach / attach, fragmentation & re-indexing and blocking & deadlock issues. Extensive experience in MS SQL Server Automation, configuring jobs and automating them. Good exposure on creating Linked Servers b/w two servers as per user requirement. Successfully resolved Database failures like corruptions and suspect issues. Well experience in resolving disk space issues by releasing space from the SQL files. Experienced in database consistency checks using DBCC commands. Data migration and Import/export data, database refreshments and managing servers. Experience in high ability -Database Mirroring and Log shipping as well as always on high ability. Experience in implementing different types of Replication like Snapshot, Transactional and Transactional with updatable subscribers. Strong RDBMS concepts and Extensive backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions using SQL Server, T-SQL.