Ashish Tiwari

8+ years of comprehensive experience in the IT industry, specializing in SQL Server administration, production support, database performance optimization, and high availability solutions. Having 7 plus years of experience as MS SQL Server DBA with organization. Extensive experience providing 24x7 production support for SQL Server environments, including versions 2005, 2008/2008R2, 2012, 2014, and 2016, 2019 & 2022 ensuring seamless database operations and minimizing downtime. Proficient in the installation and configuration of SQL Server across multiple versions, including 2008(R2), 2012, 2014, 2016, and 2017,2019,2022 ensuring optimal setup for performance and scalability. Hands-on experience in implementing deployments on production servers, ensuring smooth and efficient updates with minimal downtime and disruption to services. Skilled in resolving disk space issues, identifying root causes, and implementing permanent solutions to ensure optimal server performance and prevent future occurrences. Expert in identifying and resolving SQL Server blocking issues, thoroughly investigating root causes and implementing solutions to restore database performance and minimize disruptions. Conducting proactive health checks on SQL Server environments and providing detailed recommendations to the application team to enhance performance, stability, and overall system health. Creation and administration of all database objects, including tables, indexes, views, stored procedures, and constraints, ensuring data integrity, performance optimization, and efficient query execution. Performance tuning and monitoring database health using DMVs to optimize query execution, resource utilization, and overall system performance. Extensive hands-on experience in database and SQL Server migration, ensuring seamless data transfer, minimal downtime, and system integrity during version upgrades or environment transitions. Strong experience in refreshing databases across multiple environments, ensuring data consistency and environment stability during refresh cycles. Proficient in configuring and maintaining SQL Server high availability solutions, including Log Shipping and Mirroring, to ensure continuous uptime and disaster recovery capabilities. Strong knowledge of Always On high availability solutions, ensuring robust disaster recovery and minimal downtime for mission-critical applications. Responsible for ensuring the availability of 300+ production servers, proactively monitoring and maintaining system uptime for optimal performance. Extensive experience troubleshooting system failures, quickly identifying root causes and implementing effective solutions to restore normal operations. Hands-on experience troubleshooting server slowness issues, identifying performance bottlenecks, and optimizing system resources to improve server efficiency. In-depth knowledge of T-SQL, including query optimization, stored procedures (SP), triggers, and working with SSIS (SQL Server Integration Services) to automate and manage data workflows. Experience implementing SQL Server security and managing object permissions, including user creation, configuring permissions, and assigning roles to ensure secure access control and compliance. Establishing and managing regular maintenance plans, including weekly tasks like integrity checks, rebuilding indexes, and updating statistics, along with monthly tasks such as cleanup history to maintain optimal database performance. Extensive experience applying service packs and patches to both clustered and standalone servers, ensuring systems are up-to-date and secure with minimal disruption. Proficient in using Performance Monitor and SQL Profiler to optimize queries, trace long-running queries, and diagnose deadlocks, enhancing overall database performance and troubleshooting capabilities. Extensive experience using DBCC and DMV commands to perform database health checks, identify issues, and optimize performance. Proven experience collaborating with customers on bridge calls, providing real-time troubleshooting and resolving critical issues in high-pressure environments. Skilled in server-level tuning, performance monitoring, index tuning, and query optimization, ensuring databases are running at peak performance. Expert in database tuning and performance monitoring, consistently identifying opportunities to enhance database efficiency and reliability. Proven ability to manage multiple projects and tasks simultaneously, with a strong ability to prioritize effectively in fast-paced environments. Responsible for handling all ticket types, including Incident Management (IM), Request Management (RM), and Change Management (CM), ensuring timely resolution and maintaining service levels.

• Managed user and monitoring ticket systems, ensuring the team adhered to SLA (Service Level Agreements) while overseeing an inventory of approximately 300 servers, with 260 in production.
• Collaborated with application development and support teams to understand their requirements, providing timely solutions for both current and future projects, and aligning database support and performance tuning with operational needs.
• Configured replication and mirroring, and troubleshot issues to ensure seamless data synchronization and high availability.
• Reduced security threats by identifying users with SYSADMIN rights and reassigning appropriate privileges to mitigate risks.
• Planned phased implementation of security patches in coordination with the application team, minimizing downtime and ensuring minimal disruption for end users.
• Installed and configured MS SQL Server versions 2008R2, 2012, 2014, 2016, and 2017, ensuring optimal setup for production environments.
• Migrated databases from SQL Server 2008R2 to 2012 and from 2008 to 2014 in side-by-side migrations, ensuring data integrity and minimal downtime.
• Resolved tickets related to creating and maintaining databases, monitoring disk space, ensuring database integrity, identifying missing indexes, and addressing blocking issues.
• Maintained and monitored replication alerts and schedules, ensuring smooth operation and minimal replication delays.
• Ensured robust backup and recovery strategies, creating and enforcing policies to safeguard data and minimize the risk of data loss.
• Performed database performance monitoring and tuning based on application and business requirements, optimizing resources and resolving issues proactively.
• Developed and executed backup and restore strategies aligned with business requirements, ensuring data availability and integrity.
• Troubleshot blocking processes by identifying the root cause and resolving issues related to system resources.
• Executed scripts in the production environment to implement changes and perform regular maintenance tasks.
• Updated service packs and applied TLS 1.2 security patches to servers, ensuring compliance with security standards.
• Utilized Service-Now ticketing tool for efficient ticket management, tracking and resolving issues in a timely manner.
• Worked on SSAS database migration, providing privileges and ensuring smooth transition across environments.
• Managed and monitored Data Warehouse (DWH) servers with over 5 TB of data, including the largest database of 1.8 TB, ensuring high performance and uptime.
• Troubleshot SQL Server connectivity issues, resolving problems related to linked servers and other SQL Server objects.
• Configured Database Mail server and troubleshot issues related to mail sending/receiving slowness, ensuring seamless communication within the database environment.