Bhushan Bagde

About Bhushan Bagde

Experienced Oracle Database Administrator with a demonstrated history of working in…

Experience

1. Technical Lead

   Tata Consultancy Services

   Sep 2021 — Present · Pune, IN

   Oracle Core •Implemented Physical Standby Databases, enabling fast start failover with an observer. •Executed Incremental RMAN Backups, enhancing data protection measures. •Conducted Switchover/Switchback activities for Oracle Databases. •Installed & configured Oracle software & clients, ensuring a robust database environment. •Created database objects, including Tables, Indexes, Views, and Users. •Resized and added data files for optimal database performance. •Managed user roles and profiles, maintaining security standards for production databases on Windows and LINUX/AIX platforms. •Conducted daily Schema Backups using EXP/IMP and EXPDP/IMPDB methodologies. •Troubleshot connection issues and resolved performance bottlenecks. •Established logical Standby Databases and maintained synchronization with primary databases. •Executed the creation and synchronization of Physical Standby Databases. •Accomplished the addition and rebalancing of disks in ASM Diskgroups. •Implemented database cloning in the test environment from production databases. •Analyzed alert log errors and initiated corrective actions promptly. •Monitored and addressed high CPU/memory usage in database servers.Performance Tuning •Worked with Query plans (Execution plans) and analyzing performance issues. •Utilized SQL Plan Baselines for optimizing query plans & enhancing database performance. •Conducted Oracle database instance tuning and configured database memory parameters tuning for optimal performance. •Analyzed AWR, ADDM, & ASH reports, and resolved bottlenecks in database performance. •Leveraged in-depth knowledge of various DBA and v$ views to derive statistics at session and database levels for analyzing the database performance. •Analyzed different Oracle wait events and provided strategic solutions to minimize waits at the session level. •Resolved various locking issues at the session level, and delivered permanent solutions aligned with business logic.

Education

• Pillai institute of information technology mumbai university

  Bachelor of Engineering (BEng), Computer Engineering

  2010 — 2014

• Welingkar Institute of Management

  Master of Business Administration - MBA, Computer/Information Technology Administration and Management

  2017 — 2020

Skills

• Oracle Sql
• Javascript
• Html
• Microsoft Office
• Xml
• Css
• C
• Programming
• Oracle
• Sql
• Php
• Java
• C++
• Mysql