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.