Mangesh Abnave

at WS Foods Pvt. Ltd

• My current job since December 2013

Oracle Database 11gr2, Linux 5.4

at Green Lumen Pvt. Ltd

• My current job since June 2015

Oracle RAC DBA Experience
• Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
• Installing and configuring Oracle clusterware and Database Software (Troubleshooting using cluvfy and handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation and cleanup of clusterware)
• Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.
• Worked with customer for different RAC related issue: \[hangcheck timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss and so on\]
• Troubleshoot performance issues for the RAC instances (GC events)
• Resolved/Diagnose Node Eviction.
• Upgrade of 10g R2 RAC to 11g R2 RAC.
• Add or Remove Node from RAC.
Oracle DBA Experience
• Migrated Non-ASM Single Instance to ASM RAC Instance
• Manage RAC environment for Day to Day Database administrator, Performance Tuning
• Excellent experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
• Experience with databases running on UNIX (HP-US, Sun Solaris, AIX)/Linux (RedHat)
• In-depth knowledge of Oracle internals and architecture.

• Experience in installation, configuration and administration of Oracle Databases.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, AWR, Statspack and TKPROF.

Experience: Vinsys IT services

Senior at echno apps pvt. ltd

• April 2010 to January 2015

Project Name: Deployment of High Availability with RAC11gr2

Senior Oracle DBA at Saudi Aramco Mobil Refinery Co. Ltd

• June 2012 to December 2013

Oracle Database 10g/11g, Sun OS, Linux 5.4

Oracle DBA at Shire Pharmaceuticals INHS Asvini

• June 2011 to May 2012

Responsibilities:
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Supporting more than 20 instances.
• Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS.
• Involved in DATAGUARD (Standby) setup for high availability and disaster recovery purpose.
• Managed disks and disk groups using ASM.
• SQL tuning using SQL Trace and TKPROF, Explain Plan and SQL Analyze.

• Install and configure necessary Oracle Software for the client in Linux, AIX and Solaris environment.
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) and OS monitoring using SAR, VMSTAT, TOP, PRSTAT
• Used SQL TRACE, TKPROF, EXPLAIN PLAN, AUTOTRACE, STATSPACK, AWR and ADDM reports for performance issues resolution.
• Partitioning Strategies for very large tables.
• Import and Export of database objects to copy from one database to another database.
•Contact to the development team to solve the issues with the new enhancement releases

• April 2010 to May 2011

Responsibilities:
• Supporting more than 10 instances.
• Maintenance of production database which includes tablespace space management, user creation, privileges, roles etc.
• Database installation and Instance creation, patching and upgrading.
• Tracing, troubleshooting with database performance and tuning issues.
• Monitored the database growth, forecasted the database growth and increased the tablespace size.
• Taking weekly cold backup.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Creating and dropping of users, granting and revoking rights as and when required

Tech. Support Engineer at VCustomer Services India Pvt. Ltd

• May 2006 to March 2010

Oracle Database 10gR2, Linux 5.0

Shift In charge at Linksys

• December 2002 to April 2006

• Providing Technical Support for wired and wireless LAN equipment’s, such as Broadband Routers, Access Points, Range Expanders, Network Bridges, Network Adapters for the Desktop and Notebook PC and Hubs and Switches.

• Initial Configuration, troubleshooting and Up-gradation of the SOHO routers.
• Handling different wireless encryption methods such as WEP, WPA etc.
• Configuration of advanced wireless devices such as Wireless network Camera, Media adapter, Network Storage link.
• Configuration of VPN set-up, Installation of the Print Servers.
The Vision enterprises