Badges
Certifications
hpanchbhai has not earned any certificates yet.
Work Experience
Software Engineer
accenture•  August 2014 - July 2019
• Resolved diverse issues in over 150 databases on several platforms including Oracle 11g (RAC and stand-alone), Microsoft SQL server 2008 and SAP MaxDB to ensure continual availability of systems in Agile and fast paced environment. • Improved analytical and reporting processes by using Excel and Tableau for collecting DBMS metadata and monthly progress reports to management in form of KPI dashboards • Developed shell scripts and scheduled by cronjobs to send automated alerts using SMTP reducing monitoring to 20% from 60% • Automated monitoring and manual tasks for critical database servers by implementing SQL and Unix Shell scripts saving 80 hours monthly • Analyzed metadata using SQL scripts and recommended optimization which freed up to 1.5 TB disk space in database resulting in increased savings reduction of cost • Mentored and trained four new hires to expand awareness of project technologies and process, and improved proficiency in database administration • As a key point of contact for clients, ensured successful execution of quarterly disaster recovery drills and database patching to keep databases at the latest patch level • Led cross-functional team of 5 to upgrade 80 Oracle databases of AES; functioned as POC between client and implementation team • Experienced on working with HPSM ticketing tool with SLAs based on ITIL framework • Ensured 24/7 availability of all Oracle as well as SQL server database systems by proactively identifying and resolving database related issues along with Windows and Linux server administration. • Liaised with SAP Basis application team for infrastructure maintenance, upgrade and enhancement in Production environment within strict time constraints • Provided client with test environment by performing database refresh from production system in Oracle and SQL server 2008 within tight time frames • Recovered databases from regularly taken full as well as incremental backups to re-establish continuity in business operation minimizing the down time to 1 hour • Successfully performed Disaster recovery drill from a standby database to primary after unforeseen circumstances impacted production systems halting other team’s operation, saved valuable time and data for client • Contributed activity-related documents to enable access to historical process details and ensure continuity within business operations
Education
Santa Clara University