We provide IT Staff Augmentation Services!

Oracle Apps Dba Resume

St Louis, MO

SUMMARY

  • Over 7 Years of experience as Oracle DBA (12c, 11g, 10g, 9i, 8i ) & Oracle RAC DBA/Oracle Applications (R12, 11i) DBA on UNIX( Sun Solaris, AIX, Linux ).
  • Expertise in Installing, maintaining and administering Oracle Applications R12/11i
  • Expertise in Oracle DBA - Installation and configuration of Oracle Server, Designing & Testing of database, Administration, Backup & Recovery Strategy Implementation, Space Management, Create and manage Database Users, Performance Monitoring/Tuning & DB Security
  • Good experience in installation, configuration and maintenance of a large-scale Oracle 11g/10g/9i/8i database on Linux and Unix platforms.
  • Hands on experience of Oracle Apps DBA activities including implementation, support, development, performance tuning and disaster recovery management.
  • Extensive experience in Installation and Maintenance of Data Warehousing and business intelligence applications
  • Involved in creating users, user profiles, creating concurrent programs and registering new programs in concurrent manager.
  • Have hands on experience in resolving performance issues, extract files issues and replicate issues while working on multiple nodes.
  • Experienced in shell scripting and in installation, configuration, troubleshooting, backup/recovery, patching and performance monitoring and tuning of the database in EBS 11i or R12 environment.
  • A very good team player and communicator with excellent analytical knowledge and troubleshooting skills.
  • Have extensive knowledge of 12c architecture and have performed various operations like cloud management, life cycle management, tablespace management, self-service portal and automation of database using OEM tool.
  • Hands on experience working on Oracle Datagaurd.
  • Used oracle application tools for maintaining application like adpatch, adadmin, adctrl and admrgpch etc.
  • Maintained and customized ecommerce database for daily activities.
  • Provided 24x7 EBS (RAC and APPS) and oracle support.
  • Assisted network administrator with server administration and tuning.
  • Testing and implementing restore procedures for complete and incomplete recovery.
  • Checking logs to know about the issues recorded if any and finding ways to overcome them.
  • Migrating Non-RAC database to RAC database to maintain the security of each database.

TECHNICAL SKILLS

OPERATING SYSTEM: UNIX, Linux, Solaris 9, AIX 5.3, 6.1

RDBMS: Oracle 8i/9i/10g/11g/12c

DBA TOOLS: SQL PLUS, TOAD, SQL Developer, SQL DEVELOPER, OEM

TUNING TOOLS: Explain Plan, Stats Pack, Toad, OEM

APPLICATION TOOLS: SYSADMIN, AOL, Apps.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Oracle Apps DBA

RESPONSIBILITIES:

  • Maintenance, installed, validated database scripts and troubleshooting of Oracle Applications Release E-Biz 12.2.0.4 Suite, Oracle 11g and Data Warehousing
  • Cloned new development and testing instances from production using shell scripts having RMAN utility.
  • Hands on experience of working on RAC servers for transfer of data from one node to another.
  • Have hands on experience in SSO in 11g database.
  • Hands on Experience of working on Oracle EBS on performing upgrades.
  • Observe patch impact and applying Application patches including pre-req.
  • Resolving the invalid objects before upgrading the instances.
  • Maintained optimal database performance including systematic evaluation of indexing, statistics etc.
  • Monitoring the upgraded Instance for any errors and resolving them.
  • Rapid cloning and manual cloning.
  • Brought back a crashed server to its normal state.
  • Have experience working on OBIEE for publishing reports for the queries.
  • Have experience of allocating shared storage as per needs of client.
  • Regular shutdown and restarting database and application for proper functioning of the database.
  • Monitoring the growth of table space and taking proper actions.
  • Experienced in creating, modifying and altering shell scripts according to the requirements.
  • System administration functions like creating users, responsibilities, and menus.
  • Worked extensively in Performance Tuning at various levels including Query tuning, PL/SQL Stored Procedures, Functions and Database performance tuning as well as Performance tuning at the Applications level.
  • Archive log cleanup and RMAN backup scripts have been created and implemented.

ENVIRONMENT: Oracle Application R12, AP, AR, GL, FA, INV, OM, Oracle 11g, 12c.

Confidential, San Diego, CA

Oracle Apps DBA

RESPONSIBILITIES:

  • Maintenance, installed, validated database scripts and troubleshooting of Oracle Applications Release E-Biz 12.1.3 Suite, Oracle 11g and Data Warehousing
  • Cloned new development and testing instances from production using shell scripts having RMAN utility.
  • Hands on experience working on ETL environment to check proper functioning of extract and replicate using Golden Gate 12c.
  • Have hands on experience in SSO and SSL in 11g database.
  • Hands on Experience of working on Oracle EBS on performing upgrades.
  • Observe patch impact and applying Application patches including pre-req.
  • Migrating oracle database and application from AIX 5.3 to AIX 6.1.
  • Resolving the invalid objects before upgrading the instances.
  • Administered database security and maintained proper connectivity and also have provided two tier connectivity as per the need of the clients.
  • Hands on experience of performing Extract, Transfer and Loading operations on multiple nodes of database for transfer of data for future purposes.
  • Maintained optimal database performance including systematic evaluation of indexing, statistics etc.
  • Upgrading the application from 11.5.10.2 to 12.1.3
  • Planning and sizing the SGA and other parameters to get good performance in 11.1.0.7.
  • Upgrading oracle binaries from 10.2.0.5and later to 11.1.0.7.
  • Monitoring the upgraded Instance for any errors and resolving them.
  • Applied OPatch on the development and productivity instance.
  • Rapid cloning and manual cloning.
  • Brought back a crashed server to its normal state.
  • Rebuilding indexes for better performance.
  • Have experience working on OBIEE for publishing reports for the queries.
  • Have experience of allocating shared storage as per needs of client.
  • Regular shutdown and restarting database and application for proper functioning of the database.
  • Monitoring the growth of tablespace and taking proper actions.
  • Experienced in creating, modifying and altering shell scripts according to the requirements.
  • System administration functions like creating users, responsibilities, and menus.
  • Worked extensively in Performance Tuning at various levels including Query tuning, PL/SQL Stored Procedures, Functions and Database performance tuning as well as Performance tuning at the Applications level.
  • Responsible for setting up hot and cold back up and testing all backup and recovery scenarios.

ENVIRONMENT: Oracle Application R12, AP, INV, AR, GL, FA, DMZ, iStore, Oracle 11g, Golden Gate11g, 12c, BI Publisher

Confidential, Cleveland, OH

Oracle Apps DBA

RESPONSIBILITIES:

  • Worked on upgrade path from 12.0.4 to 12.1.1 and later created a document.
  • Installing Oracle 12.1.1 Binaries.
  • Hands on experience of working on a EBS environment.
  • Performing Upgrade and pre-upgrade task.
  • Running catupgrd.sql to start the upgrade process.
  • Performing Upgrade post-upgrade task.
  • Have experience of working on RAC environment as well as OBIEE for report generation of queries.
  • Applying patches on upgraded 12.1.1 instances using opatch/adpatch
  • Integrating oracle IPM with upgraded database.
  • Checking and compiling invalid objects.
  • Communication Oracle support for any issues faced during upgrade process.
  • Monitoring the upgraded instances for any errors and resolving them.
  • Performed 2 iterations of upgraded on Development and testing.
  • Performed upgrades on productivity.
  • Hands on exerience of working in OBIEEE.
  • Did redo log management by resizing existing redo log members and creating new redo log members as and when required.
  • Responsible for instance management and editing the initialization parameter file.
  • Responsible for cloning the oracle database from production to development and test environments.

ENVIRONMENT: Application 11i, OM, Oracle IPM frontend, OBIEEE, IBM AIX 5.3 and 6.1.

Confidential, San Jose, CA

Oracle Apps DBA

RESPONSIBILITIES:

  • Maintenance of installed Oracle Applications Release R12 suite and troubleshooting.
  • Rebuilding indexes for better performance.
  • Checking and compiling the invalid objects.
  • Monitoring the growth of Tablespace and taking proper actions.
  • Installation of printers at operating system and then defining in oracle application.
  • Applying patches in production, development and testing stages.
  • Managing physical backup.
  • Table reorganization and index rebuilding.
  • Monitoring archiving mount points and datafile mount points.
  • Testing and implementing restore procedure for complete and incomplete recovery.
  • Monitoring target instance.
  • Integrating front end application with upgraded database.

ENVIRONMENT: Maintenance of Oracle application 11i and database 10g.

Confidential, Kansas City, KS

Oracle Apps DBA

RESPONSIBILITIES:

  • Maintenance of installed Oracle Applications Release 11i suite and Troubleshooting.
  • Running autoconfig on all tiers.
  • Planning and creating directory structure for tablespaces at OS level
  • Database upgrading and patching using OPatch tool.
  • Rapid Cloning and manual cloning.
  • Database administration of production and test instances.
  • Observe patch impact and applying application patches including pre-req.
  • Monitoring the growth of Tablespace and taking proper actions.
  • Managing logical and physical backup.
  • Managing profiles as per the requirements.
  • Removing trace files and archive log files.
  • Refreshing database.
  • Adding and resizing the data files.

ENVIRONMENT: Oracle applications 11i and database 10g.

Confidential, Boston, MA

Oracle Apps DBA

RESPONSIBILITIES:

  • Complete in charge for the database administration.
  • Creating users, roles and assigning privileges to roles and granting to users according to security administration of applications.
  • Monitoring the databases usage and maintaining the servers.
  • Monitoring production servers by checking file systems, data files and table spaces on database level.
  • Database space management includes data file and table space size allocation when required.
  • Taking and logical and physical backups periodically.
  • Create and rebuild the indexes, primary keys and unique key indexes by checking the performance issues.
  • 24 X 7 Support to the Production database, which includes off-hour support also.

ENVIRONMENT: Oracle database 9i, 10g.

Hire Now