Pratik Bhole Email and Phone Number

SQL DBAConducted daily maintenance tasks, including backup management, disk space management, andupkeep of database objects, jobs, maintenance plans, and database mails. Resolved daily errors and bugs assigned by developers and implementers, providing assistance todevelopers with MS SQL Server issues and inquiries, as well as addressing user support requests.Supported database administration tasks such as configuration management, backup/recovery,restoration/truncation, performance optimization, and space management. Executed database recoveryfrom backups during disasters and implemented Point-In-Time Recovery solutions.Spearheaded the establishment of new environments and set up cloning of non-production environmentsfrom production.Proficiently managed batch processes, import/export operations, backups, database monitoring tools,and application support. Implemented index rebuilding/monitoring strategies to enhance performanceand utilized SQL Server Profiler and SQL Server Agent for efficient database management.Conducted troubleshooting of performance issues, fine-tuned databases, and performed index analysisto optimize performance.Managed database deployments, build processes, server transfers, and provided support for applicationreleases.Collaborated with the Web Infrastructure team to debug web/database issues.Monitored and addressed database capacity and performance issues, ensuring adherence to establishedSLAs (Service Level Agreements).Participated in weekend builds, resolving issues post-verification by QA.Demonstrated proficiency in high availability methods such as log shipping, mirroring, replication, andAlways On.AWS:Created RDS instances, configured backups on S3 buckets, and restored databases on RDS.Azure:Established PAAS instances and Azure SQL databases, configured backups on recovery vaults andstorage accounts, and executed database restoration in PAAS and Azure SQL databases