123pun
- 1. A RAVINDHAR E-mail: aravinder91@gmail.com Mobile: +91-9704910602 PROFFESSIONAL SUMMARY  Around 2 years of IT experience as an Oracle APPS DBA  Having very good experience in Oracle databases from version 10g to 11gR2 and Oracle application 11i and R12 on various platforms like Solaris, Linux on RAC and non-RAC environments with ASM and Data guard.  Performed various types of clones (single to single, multi to single, RAC to non-RAC and RAC to RAC.  Installed Oracle 11g2 Grid and Configured ASM  Well versed in Rapid Install, adpatch, adadmin, adsplice, adlicmgr and adctrl utilities for Oracle Applications.  Cloning (Single/Multi node), patching monitoring and day to day Apps DBA work Application 11i/R12.  Configured ASM Instances and Migrated Non-ASM Databases to ASM databases Using RMAN  Implementation of Oracle Backup and Recovery strategies using RMAN and Data Guard in RAC environment  Experience in Oracle RAC setup and Cluster ware administration  Performed the backup and restoration of OCR & VOTING Disk  Troubleshooting general issues like DB connectivity issues, Users login issues, and database blocking session issues and database corruptions issues.  Cloning from production database to test database by using Hot Clone and RMAN cloning methods.  Install and configure Oracle 10g and 11g instances in both standalone, virtual and RAC environments  Strong database, operating system and networking concepts. Excellent shell scripting, batch programming, PL/SQL skills.  Automated several routine DBA tasks and schedule jobs in CRON and other scheduling agent like Appworx.  Excellent analytical, problem-solving and learning skills and understand new technologies as well as a keen interest in the emerging technologies.  Proficient in DBA tools like OEM
- 2. Professional Experience Organization Designation Duration KPIT (MUMBAI) Oracle Apps DBA June 2013-Till Date Project Client: BEAM(HYD&BANG) June 2013 to Till Date. Designation: Junior DBA. Job Responsibilities:  Built New Test, Development, UAT & Production Instances  Performed various types of clones (single to single, multi to single, RAC to non-RAC and RAC to RAC  Monitoring tablespaces running short of free space, resizing or add datafiles  Performed front end sysadmin activities like user management, profile management, configure managers, conc Requests, request groups etc  Performing patch analysis and application of patches for resolving performance and bug issues  Patching Application and database  Monitoring ASM diskgroup space  Database error monitoring  Purging unwanted request output and log files  Managing Concurrent Processing/Managers  Generating AWR and ADDM reports. Client/Project: HATHWAY(MUMBAI) June 2013 to Till Date. Designation: Junior Oracle Apps DBA Job Responsibilities:  Monitoring Reports Server, Forms Server, Concurrent Managers, Apache Listener  Refreshing instances as per as refresh schedule  Interacting with oracle support for technical assistance requests  Instance Refreshing/Cloning purging Concurrent Requests  Troubleshooting oracle application and patching problems  Configuring the Concurrent Managers.
- 3.  Sysadmin activities like creating users and responsibilities and managing Concurrent managers and concurrent programs.  Apply database and application patches.  Setting up new users, setting user profiles.  Managing Concurrent Processing/Managers.  Applying Patches, Use adpatch, adctlr, adadmin and other Ad utilities. Certification  Oracle 11g certified Associate from Oracle Corporation. Technical Profile  Operating Systems : Windows XP/7/8 Red Hat Linux/UNIX  Database: : Oracle 11g(RAC)  ERP: : Oracle APPS 11i &R12  Database Tools: : OEM  Web Technologies : HTML.  Languages : SQL, SQL*PLUS Oracle Skills Trained as an oracle Apps DBA During the academic year 2012 to 2013 and familiar with following 10g and 11g features.  Tablespace Management.  Undo Management.  Managing Redolog Files, Managing Control Files.  Administering the database security, creating users, granting roles, privileges to users, extending the database storage capacity.  Database Network Management.  Performing Logical backup using Export utility & recovering specific schema/object using Import utility.  Datapump (expdp/impdp).  Managing Backups and Recovery.  Recovery through RMAN and its enhancements in 11g.
- 4.  Data guard (Creating Physical Standby Database, Active Standby Database, Snapshot Standby Database)  RMAN Dataguard (Creating a Standby database from catalog database).  Cloning.  Cold cloning and hot cloning  RMAN Cloning (Cloning target database from catalog database).  Automatic Storage Management.  Real Application Testing using SQL performance Analyzer.  Upgradation of Oracle 10g database to 11g. Oracle RAC DBA  Installing & configuring Oracle clusterware & Database Software  Cloning(Hot and Cold).  RMAN Cloning  Automatic Storage Management.  Database Network Management.  Performing Logical backup using Export utility & recovering specific schema/object using Import utility.  Managing Backups and Recovery  Upgradation of Oracle 10g database to 11g and point upgrades. Completed 11i Oracle E-Business Suite Database Administration course, and familiar in  Compiling Forms, Reports  Applying Patches (Using options and various utilities to minimize the down time).  Troubleshooting while applying the patches.  Cloning Oracle eBusiness Suite Application.  Troubleshooting Rapid Clone Issues.  Upgradation of Oracle Applications from 11i to Release 12.
- 5. Educational Qualification B.Tech – Electronics & communication Engineering from JNTU Hyderabad, AP, India DECLARATION: I hereby declare that the above-mentioned information is true to my knowledge and belief. Place: Mumbai Date: A RAVINDHAR
- 6. Educational Qualification B.Tech – Electronics & communication Engineering from JNTU Hyderabad, AP, India DECLARATION: I hereby declare that the above-mentioned information is true to my knowledge and belief. Place: Mumbai Date: A RAVINDHAR