Experienced in MSSQL database management across cloud and on-premise environments, skilled in Always-On High Availability, backup, restoration, access provisioning, and troubleshooting. Proficient in AWS and Azure, expertise in database migration for optimal performance.
-
Mssql Dba @AccentureAccentureMumbai, Mh, In -
Cloud Engineer Aws || Mssql Dba || Aurora Postgresql @AccentureAccenture Nov 2024 - PresentMumbai, Maharashtra, India -
Ms Sql DbaLtimindtree Jun 2022 - Oct 2024Navi Mumbai, Maharashtra, IndiaSQL 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
Pratik Bhole Education Details
-
Electrical Engineering -
Electrical Engineering
Frequently Asked Questions about Pratik Bhole
What company does Pratik Bhole work for?
Pratik Bhole works for Accenture
What is Pratik Bhole's role at the current company?
Pratik Bhole's current role is MSSQL DBA @Accenture.
What schools did Pratik Bhole attend?
Pratik Bhole attended Fr C Rodrigues Institute Of Technology, Fr. Conceicao Rodrigues Institute Of Technology.
Who are Pratik Bhole's colleagues?
Pratik Bhole's colleagues are Maria Grazia Pescina, Ashok Belwal, Akshay Dubey, Kavita Rawat, Teng Heng Liang, Dhruv Raina, Deepsikha Hazarika.
Not the Pratik Bhole you were looking for?
-
Pratik Bhole
Engineeer - Dws @ Brillio | Cisco Certified Network Associate | Juniper Certified Network Engineer | Servicenow | Crestron Certified Av Technician | Intunes | Jamf | Vendor Management | Project ManagementMaharashtra, India -
-
-
1dbs.com
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial