Nilesh Gupta
Mumbai, India
Nilesh Gupta
SQL Server Database Administrator
Category : Data base
• Having 10 years of experience in administration, development, Installation, Configuration and Maintenance of SQL Servers 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, 2017, 2019, 2022 for multiple Banking, Manufacturing and Oil & Gas clients in Production and Development Environment.
• 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.
• 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.
Working hours
- Monday:08h00 To 18h00
- Tuesday:08h00 To 18h00
- Wednesday:08h00 To 18h00
- Thursday:08h00 To 18h00
- Friday:08h00 To 18h00
- Saturday:00h00 To 00h00
- Sunday:00h00 To 00h00
• Having 10 years of experience in administration, development, Installation, Configuration and Maintenance of SQL Servers 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, 2017, 2019, 2022 for multiple Banking, Manufacturing and Oil & Gas clients in Production and Development Environment.
• 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.
• 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.
- 🇬🇧 English
Please sign in as a customer to give your feedback
Need a service ?
Do you want to hire the services of this Professional ?
Post your need and you will receive dozens of proposals from the Professionals of the community.
