Presentation
• Extensive expertise in SQL Server performance tuning, including query optimization, execution plan analysis, indexing strategies, and workload optimization.
• Proven experience in identifying CPU, memory, I/O, TempDB, and wait-stat bottlenecks using DMVs, Query Store, Extended Events, and performance counters.
• Strong expertise in diagnosing and resolving query slowness, CPU/memory pressure, I/O bottlenecks, locking, blocking, deadlocks.
• Implementing, Troubleshooting HA technologies like Always on, Log Shipping, Replication, Mirroring (High Safety, High Availability, High Performance).
• Experienced with Configuring SQL databases in Amazon AWS Cloud and Azure Environment.
• Creating Disaster Recovery Setup for SQL databases as per the client’s requirements.
• Experienced with In place and Parallel migration from various SQL versions.
• Managing all activities of SQL Server like Installation and configuration and backups, recovery and Administering SQL Server High Availability and Disaster Recovery strategies.
• Proficient with scheduling jobs with SQL Server Agent, SQL Profiler and point in time recovery for databases.
• Implementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user support.
• Handled DC (Data Center)- DR (Disaster Recovery) and SQL audit activities.
• Good experience in Linux Commands.
Background
• Extensive expertise in SQL Server performance tuning, including query optimization, execution plan analysis, indexing strategies, and workload optimization.
• Proven experience in identifying CPU, memory, I/O, TempDB, and wait-stat bottlenecks using DMVs, Query Store, Extended Events, and performance counters.
• Strong expertise in diagnosing and resolving query slowness, CPU/memory pressure, I/O bottlenecks, locking, blocking, deadlocks.
• Implementing, Troubleshooting HA technologies like Always on, Log Shipping, Replication, Mirroring (High Safety, High Availability, High Performance).
• Experienced with Configuring SQL databases in Amazon AWS Cloud and Azure Environment.
• Creating Disaster Recovery Setup for SQL databases as per the client’s requirements.
• Experienced with In place and Parallel migration from various SQL versions.
• Managing all activities of SQL Server like Installation and configuration and backups, recovery and Administering SQL Server High Availability and Disaster Recovery strategies.
• Proficient with scheduling jobs with SQL Server Agent, SQL Profiler and point in time recovery for databases.
• Implementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user support.
• Handled DC (Data Center)- DR (Disaster Recovery) and SQL audit activities.
• Good experience in Linux Commands.

