Muthiah

Email: acqj4o@r.postjobfree.com

Ph: 858-***-****

SPECIALIZATION:

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.

SKILL SET:

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.

EDUCATION DETAILS:

Bachelor of Engineering Anna University, Chennai, INDIA.

PROFESSIONAL EXPERIENCE:

USDA – RD, St. Louis, MO

Oracle Apps DBA

Nov 2014 to May 2015

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 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.

Archive log cleanup and RMAN backup scripts have been created and implemented.

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

Qualcomm, San Diego, CA

Oracle Apps DBA

May 2013 to Oct 2014

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, AR, GL, FA, DMZ, iStore, Oracle 11g, Golden Gate11g, 12c, BI Publisher

Key bank NA Cleveland, OH

July 2012 to May 2013

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, Oracle IPM frontend, OBIEEE, IBM AIX 5.3 and 6.1.

Calix (OFFSHORE), San Jose, CA

Oracle Apps DBA

June 2010 - June 2012

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.

Black & Veatch (OFFSHORE), Kansas City, KS

Oracle Apps DBA

Oct 2008 to June 2010

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.

Sprint (OFFSHORE), Boston, MA

Oracle Apps DBA

August 2007 to Sept 2008

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.

Contact this candidate