We provide IT Staff Augmentation Services!

Oracle Dba Resume

New Jersey, NJ

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 using DBUA.
  • 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 SPA EnterPrises Plc.(Jul 2011 – Till Date)

- I have done the project in Abu dhabi (Darwish Bin Ahemad).

  • Worked on Oracle AppsDba in iGrid Technologies Pvt Ltd(Jan 2009 –Jul 2011)

Certification:

  • Oracle Certified Associate 10G (OCA).

Qualification:
MCA
Mcom
BCom

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:

Project # 3:

Domain : Confidential,
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.

Project # 2:

Domain : Confidential,
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.

Project # 1:

Domain : Confidential,
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.

Hire Now