About:
I have 8+ years of experience in Microsoft SQL Server Database Administration and
and also Completed MCSA( Microsoft Certified Solutions Associated Associated) Certification
* Have good Logical thinking skills and also have very good experience in Analyze and Troubleshooting Performance issue
* Rich development experience in creating tables, views, triggers, stored procedures, user defined functions and other T- SQL statements.
* Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
* Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
* Identifying and resolving blocking and deadlock issues by using DMV, Activity Monitor, Sp_Who2, Extended Events and Profiler.
* Analyzing Execution plan(hash join, merge join) and re-arrange the query to avoid using hash join
* Identifying and resolving fragmentation and performance issues
* Design and monitor database maintenance activity.
* Strong experience in database installation, Log Shipping, Replication, Mirroring, implementing backup and recovery strategy for applications and databases
Reviews
: : : : :
No comments:
Post a Comment