Oracle Dba Apps

Bhushan Patil

922*******

**********@*****.***

Dombivli, Mumbai

Maharashtra, India

PROFESSIONAL SUMMARY

Results-driven Total 18+ years of overall experience. In Oracle DBA, Oracle RAC (5+ Years) and 9+ years specifically in Oracle E-Business Suite (EBS) and Oracle Apps DBA (4+ Years)

SUMMARY OF SKILLS

• Oracle DBA • SQL

• Oracle Apps dba • Linux

• Oracle Rac • Datapump

• Asm • Auditing

• Grid • Upgrade

• Oracle E-Business Suit • Installation

• Technical dr Drill • Ticketing Tool

• Performance Tuning • Import and Export

• Troubleshooting • Shell Script

• Purging • Table Partition

• Cloning • Job Automation

• RMAN • DB Link

• Patching • User and Space Managing

• MSSQL • Team Management

• Solaris • Vendor Management

• Dataguard • Upgrade DB

WORK HISTORY

Team Leader - Nov'20 – Jan’25

Clover Infotech - Mumbai, Maharashtra

HIGHLIGHTS:

• Cloning using Snap Clone, RMAN Clone, Cold Backup

• Applied Patches and compiled invalid objects (procedures, packages)

• Monitored and managed ASM Disk groups, Dataguard

• Performed Technical DR Drill

• Daily monitoring and Troubleshooting Oracle databases

• Implemented Export and Import by Data Pump

• Run Analyzer in Ebiz, Execute DML Statement

• Index Rebuild

• Code Deployment

• Provided Support for the Multiple Clients.{Hdfc Bank,Bajaj Electricals ltd.,Tata Toyo and others also).

Assistant Manager Oracle DBA - Mar’11 - May’20

Bajaj Electricals Limited – Mumbai,Maharashtra

MAJOR ROLE:

• Managed Oracle Databases and Oracle E-Business Suits

• Achieved targets through performance tuning of various reports and queries

• Lead and coordinated teams, interacted with BU Heads, Vendors, Developers, and Users across India

HIGHLIGHTS

• Maintained Production, Development & Test, and UAT databases and applications

• Provided ongoing performance monitoring and debugging

• Upgrade databases from 10g to 11g and 12c

• Managed vendor teams

• Oversaw database space management and monitoring

• Assisted developers in query tuning and problem resolution

• Ensured compliance with audit protocols

• Collaborated with managed service providers, internal development teams, consultants, and Oracle Support

• Created and executed scripts

• Provided technical support for Oracle Applications, including database and application server management

• Worked with development teams and 3rd party vendors

• Interacted with application owners/developers and technical staff

• Exported/Imported tables and created DB links

• Made recommendations for process improvements

• Installed Oracle Client 11.2.0.1

• Independently handled Foglight Tool for tuning purpose.

• Downloaded/Applied patches from Metalink as per Oracle's suggestions

• Worked on Oracle APPS/ERP applications like Ebiz, Siebel, and Demantra

• Created users, Password Reset in Ebiz and Siebel

• Monitored invalid objects,Compilation

• Assigned responsibilities to users in EBS and Siebel

• Provided operational support for Oracle databases running Oracle-based applications.

• Performed applications and database administration functions, including administration, patch upgrade, monitoring, and troubleshooting

• Managed concurrent managers, Workflow,Forms/Report Servers, and Web Servers

• Identified root causes of application/database performance issues

• Deployed approved changes to production systems

• Managed tickets with Oracle Support

Database Administrator (Oracle DBA) - Nov’08 – Aug’10

Sopitel Solution - Belapur Navi-Mumbai, India

CLIENT OVERVIEW: T-Mobile (US-Client)

MAJOR ROLE:

• Worked with a US client

• Monitored and Troubleshot Oracle Databases

• Assessed the health of Oracle Databases

HIGHLIGHTS

Monitoring Space on Server side.

Checking whether database is running.

Adding Data file in Table space.

Checking free space In Data files.

Killing Session.

Checking Export Backup

Database Administrator (Oracle DBA) - Aug’06 – Nov’08

CMS Computers Limited – Mumba, Maharashtra i

ROLE:

• Worked on Oracle RAC with Sun Solaris

• Worked on Oracle 8x, 9i, and 10G, Standby DB

• Monitored and troubleshot databases

• Experienced in backup, import, and export

• Worked on Oracle banking applications

CLIENT OVERVIEW:

A)Tata Aig Life Insurance India co. limited Head Office, Powai Mumbai

HIGHLIGHT:

• Monitored server-side space

• Managed tablespace and free space

• Created database users and assigned roles

• Performed export and import

• Managed archive logs

• Generated STATSPACK reports

• Installed Oracle 10g server

• Killed inactive sessions

• Created different tablespaces for indexes

• Monitored databases for better performance

• Worked in a data center

• Handled SQL Server 2000/2005

• Backup of SQL database using Lagato

2) Saraswat Infotech Limited, Vashi Navi-Mumbai.

HIGHLIGHT: -

Added data files, performed database backup through RMAN to tape, export and import, daily NT backup of Lotus, created database users and assigned roles.

3) Maharashtra state co-op bank limited (MSCB),Fort Mumbai

HIGHLIGHT: Backup (cold), export and import, installation of Oracle 10g server and 10g Client on Windows, checked datafile size, managed archive logs, alert files, and trace files, extended database storage capacity, prepared operational manuals and technical documentation.

EDUCATION SUMMARY

• Diploma in Electronics & Telecommunication Engineering from Mumbai University in Jan-2001 (59.24%)

• B.Com in Jun-2004 (56%)

• Post Diploma in Fiber Optics Communication Engineering from Govt. College, Pune University in Aug-2005 (58%)

• HSC from Nasik University in 1997

• SSC from Nasik University in 1995 (75%)

• OCP (Oracle Certified Professional) in Oracle DBA 9i, 12c

• Successfully completed Oracle DBA Course from Soft Origin, Dadar in 2006

ACCOMPLISHMENT

• Participated in the Bajaj Cricket Premier League - 3

• Participated in the Mumbai Marathon-2012, 2013, 2014, 2017 for social causes

• Contributed to various CSR activities, including tree planting, book donations, laptop donations, and teaching etc

• Received the Long Service Award for completing 6 years at Bajaj Electricals

• Awarded as an Achiever for Q1 in 2018 by Mr. Shekhar Bajaj

• Completed Oracle Certified Professional 9i, 11g, 12c

• Worked as COE in Bajaj Electricals Ltd.

PERSONAL INFORMATION

Address : Dombivli, Mumbai. Maharashtra

Languages : English, Hindi, Marathi

Contact : 922*******

Mail id : **********@*****.**.**

Contact this candidate