Career Objective:
To associate myself with an organization that provides me an opportunity to show my technical and proficient skills, improve my knowledge and to be a part of the team that works dynamically towards the growth of the organization.

Profile:

• 4.2 Years of I.T Experience as an Oracle Applications Database Administrator and Oracle database.
• Administrator in RAC environment.
• Installation of APPS11i/R12 EBS single and multi-node environment.
• R12 Upgrade (11.5.10.2 to 12.1.3).
• Applying patches to test instances and performs rigorous Testing and subsequently applying to the Development and production instance.
• PCP configuration.
• Well versed in using AD utilities– adadmin, adpatch, adrelink, adctrl, adident, admrgpch.
• Configuring Test and Development Instances and cloned the entire Oracle Application
• Instance from production to test on a regular basis, across multiple tiers.
• Changing passwords for Oracle Application Users.
• Managing Concurrent Process, Concurrent Programs/Managers, Registering New Concurrent Programs, Concurrent Types, defining new Concurrent Managers.
• Configuration and installation of cluster ware on RAC environment.
• Performed upgradation of cluster ware from 10.2.0.1 to 10.2.0.4 and database from 10.2.0.1 to 10.2.0.4.
• Creating ASM database and taking backup using RMAN.
• Experience in Oracle Database Administration 9i/10g.
• Performed numerous Installation of various versions 9.2.0 and 10.2.0.
• Involved in backups and recovery.
• Creating database on RAC environment.
• Upgrading of database from one release to next release manually and usingDBUA.
• Good knowledge of cloning RAC as well as Non-RAC database and configuring ASM database.
• Knowledge on DMZ setup
• Creation and Management of Tablespaces, Users & Rols
• Good knowledge of Online, Offline and RMAN Backups and Recoveries.
• Managing Database Structures, Constraints, Database Access, Roles and Privileges.
• Managed ASM configuration and migration of database from clustered file system to ASM.
• Cloned the database using cold, hot backup manually and automated cloning process using RMAN as well for RAC database.

Responsibilities (on RAC Environment):

• Successfully installed and Configured10g RAC Database.
• Performed taking backups of OCR and CSS files.
• ASM configuration on RAC setup.
• Adding of node to existing cluster.
• Working with large number of production, development and test databases.
• Applied database patches, cluster Patches using Opatch Utility.
• Monitoring RAC database through SRVCTL.
• Cloned database from development to test using RMAN.
• Knowledge on migration of NON-ASM to ASM, ASM to NON-ASM databases.
• Successfully cloned Non-RAC database to RAC databases.
• Upgraded Cluster ware from 10.2.0.1 to 10.2.0.4.
• Taking Back-up of the Database using RMAN.
• Maintenance of Table spaces, Data files, Control files, Redo log files.
• Support for Development and production Databases.
• Cloning of production database to the test environment using Recovery Manager (RMAN).

Professional Experience:

Have 4 years of experience as Oracle Apps dba.

• Working on Oracle AppsDba in Confidential.(Jul 2011 – Till Date)
• Worked on Oracle AppsDba in Confidential (Jan 2009 –Jul 2011)

• Oracle Certified Associate 10G (OCA).

Qualification:

Degree

MCA

MCom

BCom

Intermediate

SSC

Technical Skills:

Oracle Applications-Oracle Applications 11i ,R12

RDBMS-Oracle 9i, 10g,11g.

Operating Systems-Oracle Enterprise Linux| Windows NT/2000/XP

Oracle Tools -Ad patch, Autoconfig , RapidClone , Oracle Enterprise Manager (OEM),Export/Import,Datapump,Oracle Application Manager(OAM),ADutilites

Skills-Software Installation,Upgradation, Troubleshooting , Patch Management , Cloning , Backups & Recovry

Assignments:

Domain : Road Transport
Client : Confidential
Duration : JUL2011 – Till Date
Role : Oracle Application DBA&Rac DBA
Environment : Oracle Applications 12.0.3, Oracle 10.2.0.5.
Responsibilities : As Apps DBA

Responsibilities (As Apps DBA):

• Installation of Oracle Application 11i & R12
• Good Knowledge on Oracle Application R12.
• Oracle Application and database refresh and cloning.
• User account management - creating users, disabling users, responsibility management.
• Managing concurrent managers -ensure system is running smooth, monitoring throughput, watch for long runners.
• System Administration for Oracle Apps which includes creation and maintenance of Users, Responsibilities, Menus, Profiles, Concurrent Programs, Request Sets, Request Groups etc. Application of Patches.
• Good knowledge on AD utilities and their usage.
• Performed adadmin tasks basing on requirements
• Relinking & Compiling the Oracle application objects
• Performed sysadmin tasks as per the requirement
• Resolved the configuration issues raised by development teams.
• Proactive issue resolution and troubleshooting the issues raised by users
• Applied number of Patch applications - Including pre-req\'s investigation.
• Copying new forms, reports, custom code to production environment.
• Generate form files, generate report files, and generate graphics files using adadmin utility, create applications environment file
• Shift Coordination, which include assigning roles and responsibilities to the team members and interacting with Online Support team for handling Tars.
• Participating in team lead meeting, weekend plan meeting and process meetings.

Domain : Construction
Client : Confidential 
Duration : JUL2011 – Till Date
Role : ORACLE Application DBA
Environment : Oracle Applications 11.5.10, Oracle 9.2.0.3
Responsibilities : As Apps DBA

Responsibilities:

• Oracle Architectural Components and installation of 9i & 10g versions
• Oracle 9i Installation on Red Hat Enterprise Linux AS Release 3.0
• Application patching analysis & applying patches on test instances.
• Monitoring Concurrent Manager & its operations like starting, stopping the concurrent managers & Troubleshooting problems, resolved the view log/out files issues of concurrent requests.
• Validating & Creating grants & synonyms on Apps schema, Performed jar file/forms generation as a post patch step, relinking the Oracle apps programs.
• Managed and troubleshooting apps components like apache/forms etc.
• Extensive use of ad utilities like adpatch, adctrl, adrelink, adadmin, aderelink.sh, LicenseMgr, adident, adautoconfig for maintenance of Oracle application.
• Cloning the Database using Hot, Cold and Rman backups
• Managing Data Tablespace, Undo Tablespace, Temporary Tablespace
• Taking Hot and Cold Backups with incremental and full Options
• Monitoring the Alert log files and verify database health proactively
• Used export and imports at tablesapce,Schema and database level
• Maintain the RMAN scripts for getting scheduled backups by using recovery catalog.

Domain : Construction
Client : Confidential 
Duration : JAN 2009 – JUL 2011
Role : ORACLE Application DBA
Environment : Oracle Applications 11.5.10, Oracle 9.2.0.3
Responsibilities : As Apps DBA

Responsibilities:

• Applied Patching on Test, Dev, Stage and Production Instances.
• Instances comprised of Multi Node Environments. (Multi Tiers).
• Knowledge of Troubleshooting.
• Worked with the ADADMIN Utilities.
• Performing Pre Patch Analysis (PPA)
• Bouncing the Application services and database services for test and prod instances.
• Performing Code promotion as requested by customer
• Performing the Health Checks for the instances
• Managed and troubleshooting apps components like apache/forms etc.
• Extensive use of ad utilities like adpatch, adctrl, adrelink, adadmin, aderelink.sh, LicenseMgr, adident, adautoconfig for maintenance of Oracle application.
• Cloning the Database using Hot, Cold and Rman backups
• Troubleshooted the middle tier (Apache server) issues
• Troubleshooting the concurrent manager requests.
• Taking Hot and Cold Backups with incremental and full Options
• Monitoring the Alert log files and verify database health proactively
• Used export and imports at tablesapce,Schema and database level

Responsibilities (on RAC Environment):

• Successfully installed and Configured10g RAC Database.
• Performed taking backups of OCR and CSS files.
• Adding of node to existing cluster.
• Working with large number of production, development and test databases.
• Applied database patches, cluster Patches using Opatch Utility.
• Monitoring RAC database through SRVCTL.
• Upgraded Cluster ware from 10.2.0.1 to 10.2.0.4.
• Database Maintenance for Archive logging.
• Maintenance of Table spaces, Data files, Control files, Redo log files.