Oracle Apps DBA Resume Samples

Description :

1. Installed and Configured the Oracle Databases 11gR2 and 12c from the scratch on UNIX and LINUX environments.
2. Administered and Monitored the Oracle Database 10g and 11g databases using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
3. Experienced in using Data pump.
4. Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.
5. Implemented the Data Guard i.e., setting the logical and physical standby database and setting the migration from primary to standby databases.
6. Worked on RAC 11g on OEL 5.5.
7. Experienced in Cloning and configuring ASM to ASM.

Experience

7-10 Years

Level

Management

Education

Bachelor Of Science

Description :

1. Supported the development and Test teams with data refresh using exp/imp, Data Pump and scripts execution.
2. Worked on Oracle application upgrade from R12.1.3 to R12.2.0 and R12.2.0 to 12.2.3.
3. Worked on Oracle Database upgrade from 11g to 12c using DBUA and Manual upgrade.
4. Responsible for Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
5. Installed and supported OEM 10g on Windows and Linux.
6. Created table spaces, tables, and users for custom applications.
7. Performed Schema/Tables/Databases export using Data Pump, Export and Import utilities.

Experience

2-5 Years

Level

Junior

Education

Bachelors Of Engineering

Description :

1. Established Oracle Data Integrator (ODI) Connections between Oracle to MS SQL Server for replication of data.
2. Tested different Journalizing Knowledge Modules to ensure better performance.
3. Refreshed Cloning of Database and Oracle Applications R12 for development and testing Performance Tuning of the database.
4. Created Menus, Functions, Personalizations, Concurrent Programs, Responsibilities and registered Custom Top Applications in 11i/R12 Troubleshooted Long Running Concurrent Requests, Forms, Reports and Blank Page issues.
5. Cloned and Patched Oracle Applications 11i/R12 Monitored and Managed Oracle Applications 11i/R12 through SOPs.
6. Performed System Administration and Security of Oracle e-Business Suite 11i/R12 Used RMAN for backup and recovery.
7. Performed backup validations using RMAN.

Experience

2-5 Years

Level

Junior

Education

Bachelors Of Engineering

Description :

1. Installed and supported OEM 10g on Windows and Linux.
2. Created table spaces, tables, and users for custom applications.
3. Performed Schema/Tables/Databases export using Data Pump, Export and Import utilities.
4. Created Menus, Functions, Personalizations, Concurrent Programs.
5. Registered Custom Top Applications in 11i/R12 Troubleshooted Long Running Concurrent Requests, Forms, Reports and Blank Page issues.
6. Monitored and Managed Oracle Applications 11i/R12 through SOPs Performed System Administration and Security of Oracle e-Business Suite 11i/R12 Used RMAN for backup and recovery.
7. Performed backup validations using RMAN.

Experience

7-10 Years

Level

Management

Education

Bachelor Of Engineering

Description :

1. Responsible for Creating and maintaining users.
2. Involved in alert monitoring, space management issues and user management.
3. Implemented the migration of 17 PROD servers and 30 DEV servers in less than 3 months with a team strength of 3 members.
4. Performed Data Centre Migration of Application and Databases.
5. Gathered requirements for storage, kernel parameters, backup policies, space required for backup and performed capacity planning for building new application and database.
6. Prepared status updates and regularly tracking project milestones and updating share point folders with project related documents.
7. Experienced in working with different versions of database from 9i to and RAC.

Experience

7-10 Years

Level

Management

Education

Bachelor Of Technology

Description :

1. Extensively worked on application modules like Oracle HRMS, Oracle Supply Chain Management modules like VCP on R12.
2. Installed and configured Oracle Application stack on both single node and multi node environments.
3. Worked with one of the biggest client of TCS (General Electric) with the latest Tools and Technology along with Oracle Support on Oracle Apps .
4. Experienced in working with different versions of database from 9i to and RAC.
5. Installed and configured OTM with load balancer and HA.
6. Configured EBS and RAC instance.
7. Implemented Oracle Golden gate for Oracle OTM database along with Oracle Data Guard.

Experience

7-10 Years

Level

Management

Education

Bachelor Of Technology

Description :

1. Extensive experienced on new implementations and migration projects.
2. Provided support for various retail applications like RMS, SIM, ReIM, RDW, Allocations.
3. Extensively worked on application modules like Oracle HRMS, Oracle Supply Chain Management modules like VCP on R12.
4. Installed and configured Oracle Application stack on both single node and multi node environments.
5. Responsible for performance tuning and design the logical and physical model for all modules.
6. Interacting with functional and the technical teams and with the oracle support and raising SR's in resolving the issues.
7. Responsible for Administering workflow mailer notification issues.

Experience

2-5 Years

Level

Entry Level

Education

Bachelor Of Technology

Description :

1. Tracked invalid objects, compiling and validating the invalid objects using adadmin.
2. Checked the status of important services like concurrent manager, form server, web server, application listener and database listener.
3. Checked the status of important services like concurrent managers, form server, web server, application listener and database listener etc.
4. Ran the ASH, AWR and ADDM reports to analyze the performance issues.
5. Maintained Oracle applications using AD utilities like adadmin, adctrl, adpatch, admrgpch, adrelink and adident.
6. Monitored tablespaces and adding data files or resizing data files.
7. Responsible for Excellent working skills in 24x7 Oracle Production Database and Data Warehouse Systems.

Experience

2-5 Years

Level

Junior

Education

Bachelors Of Engineering

Description :

1. Responsible for 24x 7 Production database administrations support all Production of Oracle Applications 11i and monitoring to ensure a proactive problem recognition and resolution of multi-terabyte database issues.
2. Configured and Installed Oracle Application 11i using Rapid Install.
3. Monitored the Applications and Database using OEM and OAM.
4. Set up of printers In the Apps.
5. Maintained concurrent processing requests and concurrent managers.
6. Tuned concurrent managers using Oracle Enterprise Manager (OEM).
7. Used AD Utilities like ADADMIN, ADIAMGR, ADPATCH, and ADCTRL.

Experience

2-5 Years

Level

Junior

Education

Bachelor Of Technology

Description :

1. Scheduled RMAN backup of database using catalog DB and TDPO tape backup.
2. Performed refresh of Oracle 10g Database and 11i EBS using Rapid Clone.
3. Created Shell script for daily refreshing an instance from Oracle Apps 11i Production instance.
4. Created the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and passwords.
5. Installed and Configured the Oracle Databases 11gR2 and 12c from the scratch on UNIX and LINUX environments.
6. Administered and Monitored the Oracle Database 10g and 11g databases using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
7. Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.

Experience

7-10 Years

Level

Management

Education

Bachelor Of Science