Maheshwar G [pic]

acwecl@r.postjobfree.com

Ph.: +91-772*******

Oracle Application DBA

Professional Summary:

Oracle Applications Database Administration

. Over 6 years of experience with in Information Technology as Oracle

APPS DBA (R12 /11i) and Oracle DBA (9i/10g/11g).

. Good knowledge of oracle database and instance architecture.

. Experience in Installation of Oracle Applications 11i /R12 in Single-

node and multi-node.

. Expertise in Installation, Upgrade & Performance tuning of Oracle

Applications 11i/R12 on SUN SOLARIS.

. Experience in full lifecycle implementations of client/server,

Database application project analysis, business analysis, development

as well as traditional software development methodologies.

. Oracle Applications CLONING from production to Test, Dev and Patch

instances using Rapid clone and manual cloning.

. Cloning of database for development teams, import and export of data.

. Administrating the oracle database and applications with the AD

utilities.

. Proficient Experience with Standby Database, Data guard, Installation

and implementing RAC (Real Application Cluster) Database with 2 nodes.

. Upgrade of Applications from 11.5.10.2 and R12.1.1 12.1.3 on test

server successfully.

. Setting up Standby Database/Data Guard to protect against failures.

Configured the Standby Database in such a way that the database is

kept synchronized with the Production Database by regularly

transferring archived log files from the Production Server to the

Standby Database Server.

. Recovery of database in case of database crash, disk/media failure,

etc.

. Good knowledge in creating function, procedure, package, and trigger.

. Proactive monitoring and performance tuning of production databases

using Oracle Enterprise Manager (OEM) and scripts.

. Expertise in performance tuning of large databases and SQL/PLSQL

programs.

. Installed and configured of Oracle 10g Application Server.

. Worked as a team member to provide 24x7 on-call production database

support.

. Implemented RAC and Converted Non RAC to RAC.

. Platform Migration from Solaris to AIX.

. Experience in OBIEE.

. Responsible for the installation, upgrades, and maintenance of all

phases of an Oracle Database Server on UNIX based environment.

. Responsible for providing support for production/Test/Development

databases.

. Install, upgrade and patch the database server and application tools.

. Monitor and optimize the database performance.

. Allocate system storage and plan for future storage requirements for

the database system.

. Provide technical resolution to Oracle database related problems.

. Create primary database storage structures and objects.

. Creating Oracle Instances on Production/Test/Development Environments.

. Develop and maintain database standards and conventions.

. Perform database cloning.

. Upgrading the Database to higher versions.

. Implement changes in production environment via change management

tickets.

. Worked with Oracle Support via Metalink to resolve DB issues

(including Severity 1 and 2 priority tickets).

. Implementation of Shared Application Tier file system.

. Implemented Golden Gate to replicate tables daily for reporting

purpose

. Reduced hardware cost by implementing external webtier without

investing in physical external web tier. Configured "Reverse proxy

with external Webtier" for such customers.

. Worked on Noetix Installation (6.0.1) and Implemented the Security

with Noetix Admin.

. Expert in Administration of Oracle Applications E-Business Suite (11i

& R12).

. Worked on Cross Platform Migration Project from Solaris to IBM AIX.

. Implemented DMZ with iSupplier Portal.

. Extensive Experience on Oracle Minimum Base Line patching activity and

upgraded Database from 9i to 10g, upgraded 10 production instances to

get extended support from oracle.

. Experience in E-biz Database upgrade from 10.2.0.4 to 11.2.0.3.

. Implementation experience on ASCP (Advance Supply Chain Planning) and

Demantra.

. Worked on PCP (Parallel Concurrent Processing) configuration.

. Hands-on Experience in Noetix Views installation, upgrade and support

activities.

. Worked with Functional team for implementing Role Based User Access.

. Created Daily/Monthly Health check reports from OEM.

. Configured MWA with two dispatchers and scheduled MWA bounce twice a

daily.

. Cloning from Standby Database.

. Reduced Patch downtime using Staged Appltop.

. Configured Active Dataguard for reporting purpose.

. Configured UPK.

. Implemented SSL.

. Implemented several concurrent programs to automate tkprof generation,

jspfile compile, form generation, Bulk user creation, MWA bounce,

Compile Custom.pll, Assign Responsibility automatically.

. Integrated Mercury Object Migrator with EBS instance to migrate AOL's.

. Created Custom User defined metrics in OEM to monitor

Planning/Cost/Interface Managers & MWA status etc...

. Automated Clone of EbS instance daily.

. Experience in Demantra and SSO integration with ASCP setup.

. Experience in setting up iStore and iSupplier in DMZ.

. Implemented SSO between ASCP 11i Instance and Demantra application for

easy way of logging into both applications.

Technical Skills

Operating

Systems

Databases ORACLE 9i/10g/11g, Real Application Clusters (RAC

10g/11g)

Applications Oracle E-Business Suite R12/11i

Application Oracle Application Server 10gAS

Server

Tuning Tools: SQL Trace, TKPROF, explain plan, stats pack, AWR, and

ADDM

Tools SQL PLUS, SQL*Loader, SQL navigator, SQL*Report writer,

Data Pump, Export & Import utility, TOAD, RMAN, Opatch,

Oracle Diagnostics Pack, Discoverer, AD Utilities, Oracle

reports, OAM(Oracle Applications Manager),MS Office, Data

Guard &OEM.(Oracle Enterprise Manager).

Languages SQL, PLSQL, Shell Scripting

Education:

June 2003 - Mar 2006 Bachelor of Science in Electronics and Computers

with 79%.

June 2001 - May 2003 Board of Intermediate in MPC (Maths, Physics &

Chemistry) with 82%?

June 2000 - April 2001 S.S.C Board of Secondary School with 80.3%.

Professional Experience

Symantec

Apr'15 to till date.

Sr. Application Specialist

Project #1 (Apr'15 to till date)

Symantec

Responsibilities:

. 24x7 on-call production support for Oracle Applications Administration

with E-Business R12 and 11i.

. Working with more than 400 Production, Testing & Standby Database

Servers on different platforms.

. Database Administration for Oracle (8i/9i/10g/11g) responsibilities

includes daily maintenance review.

. Configuring, creating new instances for reporting purposes and

automating the process of refreshing instances

. Responsible for all technical matters related to the Oracle

Applications databases including upgrades, cloning, monitoring and

tuning the operating environment, coordinating/executing all code

migrations.

. Administer Oracle Server, manage database instances, and monitor

server performance.

. Installation & Management of Oracle Database on different platforms

(AIX/HP-UX/LINUX).

. Create and maintain database objects.

. Space Management, User Management & Schema Management.

. Taking Backups and recovery of data (user managed and using RMAN) and

automation of the same.

. Regular checking of trace, alert log file, all ORA errors & Trace

users using OEM.

. Checking tablespaces and allocate space to tablespaces time to time

when needed- addition & resizing of datafiles.

. Checking mount points on various servers (AIX/HP-UX/LINUX) like Oracle

Home/Logs and manage space time to time.

. Regular maintenance viz., archives monitoring, deleting backed up

archives, deleting old core files, cleaning up old trace and log

files.

. Preparing daily database health reports.

. Checking operations, locking, long operations, and resumed operations

time to time and taking action according to situation.

. Creation of new databases and users and other monitoring scripts.

. Creation of tablespaces, tables and addition of new partitions

according to the nature to tablespaces monthly and daily basis.

. Purging of old data which are not required according to the policy and

to release space for new data.

. Creation of RMAN backup scripts for full backup of database and also

for backup of archives only.

. Working on incidents like User creation/deletion incidents, backup

failed incidents, DB failover/down incidents, Listener down incidents,

and also some other incidents related errors or problems from DB end.

. Implementation of RFCs raised for required changes to databases time

to time.

. Data Guard Management- Checking lagging status, removing lagging of

archives, checking processes like RFS/MRP, Archives Management.

. PSU/GRID Patching.

. Creation of datafiles in case of UNNAMED datafiles due to space

problem on standby database and also moving datafiles through RMAN

from one location to other location in some scenarios on standby

database.

. Developed some Unix Shell Scripts, Batch Scripts & SQL scripts to

automate database operations & database monitoring.

. Provided 24*7 supports.

. Upgraded RAC GRID Infrastructure (Cluster) from 11.2.0.3 to

11.2.0.4.4.

. Upgraded ERP Database from 10g to 11g.

. Providing Production support (24*7) and troubleshooting the incidents

in production, Pre-Production and UAT instances.

. Day-to-day business database support and management of the production

databases.

. Regular monitoring of OEM12c for blocking sessions, high CPU, high

I/O, and other metric alerts to keep track of database performance.

. Database space management.

. Cloning Oracle Apps from PROD to TEST, DEV, UAT Instances

. Responsible for the Patching, Cloning and scheduled maintenance

activities.

. Responsible for patch analysis and impact for all kinds of patches.

. Monitoring and following up with Oracle SR's.

. SSL Upgrade from SHA-1 to SHA-2.

. Patching on PATCH, DEV, UAT and PROD Instances

. Sysadmin activities like creating users and responsibilities and

managing Concurrent managers and concurrent programs.

. Handling issues related to Apache, Forms and CM as well as related to

Database.

. Cloning the instances using different methodologies as per client's

requirement.

. Alert monitoring on tablespace issues, blocking and locking sessions,

and long-running concurrent jobs from corns.

. Maintaining different kind of backups like RMAN, Active database

duplication.

. Experienced in new schemas creation and roles and privileges

maintenance as per request from tech team

. Troubleshooting user related issues and coordinating with the users

from different time zones.

. Familiar with all kind of ad-utilities like adpatch, adadmin,

adsplice, adlicmgr, adctrl, adident, adrelink, etc.

. Checking database locks and clearing the blocking sessions.

. Interacting with oracle support for technical assistance requests.

KPIT Technologies.

Jul' 10 to April 15

Sr. Oracle Applications DBA

Project #1 (Mar 2014 to till date)

Oracle India Pvt Ltd.

Responsibilities:

Major Clients: WELCHS Foods/Warner Chilcott/ OSG/Bacardi

Providing 24/7 11i Remote Support for PROD (OLTP) 2 node RAC on AIX, 6

Application Tiers and R12 along with all Non-Prod Databases and Oracle

Applications E-Business Suite, Demantra.

Responsibilities include:

. 24x7 on-call production support for Oracle Applications Administration

with E-Business R12 and 11i.

. Providing 24/7 Production and Non-Production Database and Application

support.

. Patching Database and Applications, HRMS, Vertex updates.

. Cloning/Refreshing instances (scheduled / Requested)

. Backing up Database and Applications using Common Vault and RMAN disc

backups.

. Resolving Application issues, supporting users with their requests.

. Performing code migrations through ITG.

. Maintaining standby databases for PROD and planning instances.

. Scheduling backups and applying patches during weekend maintenance

window.

. Troubleshooting user/database/application issues.

. 24x7 on-call production support for Oracle Applications Administration

with E-Business R12 and 11i.

. Upgraded RAC GRID Infrastructure (Cluster) from 11.2.0.3 to

11.2.0.4.4.

. Upgraded Database from 10g to 11g.

. Successfully upgraded Oracle Applications database 9i (9.2.0.4) to 10g

(10.2.0.4) on Solaris.

. Setup, configuration and maintenance of standby databases (Oracle Data

Guard) to ensure disaster recovery, high availability and data

protection.

. Conducted pre patch analysis for the patching of the Oracle E-Business

Suite 11i.

. Developed automated RMAN scripts for both cloning and backup of Oracle

Databases.

. Used RMAN in scheduled recovery, hot and cold backup of Oracle10g

database.

. Database monitoring and performance tuning using OEM (Oracle

Enterprise Manager), AWR and ADDM

. Created Users, Groups, Roles, Profiles and assigned users to groups

and granted privileges, permissions to appropriate groups.

. Planning Backup/Restoration Strategy, Scheduling Backups, Schema

backups, taking Logical Backups (with Export/Import Data Pump

utilities).

. Setup crontab for production environment to receive alerts related to

TS issues and OS level space issues, locking issues etc.

. Cloning UAT and DEV instances from production for testing.

. Implemented shared APPL_TOP, PCP, and DMZ.

. Administration of Oracle ERP applications version 11.5.10.2 and R12

. Taking care of the performance issues both at the database level and

applications level.

. Participated in disaster recovery (DR) plan development.

. Worked with oracle support on resolution of SRs.

. Assisted developers with PL/SQL coding and also performed SQL tuning.

. Implementation, Upgrade and Support of Oracle 10g Database and

Application Server.

. Creating Development, Testing and production Environments.

. Install and maintain Oracle Applications in complex environments such

as Single-node and multi-node installations on SOLARIS 8 and LINUX AS

5.0.

. Error handling from databases to applications and rectifications.

. Planning and Administration of backups and recoveries strategies.

. Expert in PL/SQL with ability to tune complex queries.

. Cloning instances from production to Test, Development instance to

test with Rapid Clone and Autoconfig.

. Involved in Database Backup strategies & recovery scenarios and

implemented Backups using RMAN.

. Experience in implementing hot, cold and RMAN scheduled backups and

performance tuning of SQL statements.

. Reorganizing the database to reduce disk contention, migration and

chaining.

. Monitoring the instance statistics and tuning the database to improve

performance.

. Monitoring user sessions, maintaining, administrating and

troubleshooting database issues for OLTP -Oracle databases on Solaris

and Red hat Linux.

. Monitoring and handling Concurrent Managers related issues.

. Created new concurrent managers, Purged concurrent requests table.

. Registration of Printers, Printer Types, Printer Styles.

. Taking periodic backup of Applications & Databases.

. Enabled Auditing feature for tables such as FND_USER etc.

. Monitoring DB processes activities at OS level using top, glance, w

command etc.

. Script writing and execution on LINUX and Windows environments.

. Registered customized applications, created responsibilities,

customized menus, attached menus to responsibilities and assigning to

users.

. Oracle Applications 11i INSTALLATIONS, MANAGING CONFIGURATION,

CLONING, SECURITY, PATCHING, UPGRADES, MAINTENANCE USING AD and other

utilities

. Responsible for managing production, development & test databases and

applications.

. Performed database and application cloning of Production database on

TEST environment to provide users the live data for testing purposes.

. Automation of tasks like backup/refresh and other jobs.

. Applying Oracle Applications patches (Maintenance Pack,

Interoperability patch, Family pack, one of Patches etc.).

. Oracle Applications Systems Administration. RMAN used in recovery, hot

and cold backup of Oracle 10G databases.

. Registered customized applications, Apps. Users, created

responsibilities, customized menus, attached menus to responsibilities

and finally this to users.

. Planning and Administration of backup and recovery strategies.

. Creating Application Users, Profiles, Responsibilities, Menus,

Functions for the user

. Created new concurrent managers, Purged concurrent requests table.

. Wrote stored procedures, packages, triggers and functions using

PL/SQL.

. 24x7 Production Oracle Applications Administration.

. Provided application support to users and created a log of all the

problems with solutions for future reference.

. Installed and maintained oracle applications 11i.

. Performed upgrades from Oracle 10g (10.2.0.4) to 11g (11.2.0.3)

. Applied patches using adpatch, adctrl utilities.

. Application user creation, responsibilities assignment, applying

minipacks, Maintenance pack, family pack and one-off patches.

. Installed and created 11g databases

. Database upgrade & application upgrade.

. Refresh schema-using Export/Import. Creating the database, table

spaces, tables, indexes, setting privileges and user logins.

. Created & Managed Jobs using Appworx Job Scheduler.

. Concurrent manager/requests maintenance & tuning.

. Extensive UNIX Shell scripting.

. Preparation of technical documents, writing shell, sql scripts for

Apps and Core DBA activities.

. Remedy and ticket resolving.

. Handling Production Database and ERP issues and database changes/fix.

. Refresh process automated.

Project #2 (Oct 2013 - Feb 2014)

Fleetguard:

. Database Administration (Space, Distribution, Recovery).

. Monitoring the alert logs regularly.

. Creating, checking, extending table space.

. Administered database security, created users, granted/revoked roles &

privileges.

. Extended databases storage capacity, monitored and reduced database

fragmentation.

. Managed data files, rollback segments, extents, segments, indexes.

. Implemented sound backup, recover and restore policies.

. Created users, roles etc.

. Daily activities include monitoring batch application for performance

and space requirements and tuning the system to optimize space and

performance.

. Extensively used SQL Loader to load data from flat files to the Oracle

Database.

. Testing the GUI with substantial input data.

. Used RMAN to restore and recover database.

. Used Flashback, Export/Import and data pump utilities.

. Provide technical assistance to developers in all matters concerning

performance, application related issues.

. Used EXPLAIN PLAN, TKPROF, and SQL TRACE for performance tuning.

. Database Backup Strategy and Archive log mode.

. User Administration. (Creating users, roles and profiles)

. Writing the triggers and stored procedures.

. Helped senior DBA'S in backup operations.

. Implemented ILM which provides the ability to create lifecycle

definitions, which are assigned to tables in the database. Then based

on the lifecycle policy, the ILM Assistant advises when it is time to

move, archive or delete data. It will also illustrate the storage

requirements and cost savings associated with moving the data. Other

capabilities include the ability to show how to partition a table

based on a lifecycle definition and to simulate the events on a table

if it were partitioned.

. Successfully upgraded Oracle Applications from 11.5.10.2 to R12

(12.1.3).

Environment: Oracle 9i, Solaris, AD Utilities, OEM, SQL, PL/SQL.

Project #2 (Jul 2010 - Oct 2013)

Cummins:

Responsibilities:

. Database Administration (Space, Distribution, Recovery).

. Monitoring the alert logs regularly.

. Creating, checking, extending table space.

. Administered database security, created users, granted/revoked roles &

privileges.

. Extended databases storage capacity, monitored and reduced database

fragmentation.

. Managed data files, rollback segments, extents, segments, indexes.

. Implemented sound backup, recover and restore policies.

. Created users, roles etc.

. Daily activities include monitoring batch application for performance

and space requirements and tuning the system to optimize space and

performance.

. Extensively used SQL Loader to load data from flat files to the Oracle

Database.

. Testing the GUI with substantial input data.

. Used RMAN to restore and recover database.

. Used Flashback, Export/Import and data pump utilities.

. Provide technical assistance to developers in all matters concerning

performance, application related issues.

. Monitoring and handling Concurrent Managers related issues.

. Registration of Printers, Printer Types, Printer Styles.

. Interacted with Functional & Technical experts, system administrators,

security analysts and other members of the project team to ensure

optimum operation of the database.

. Performed Database and SQL tuning by using various tools like

STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN and Optimizer hints.

. Script writing and execution on LINUX and Windows environments

. Partitioning tables by determining the suitable methodology to improve

performance and manageability.

. Performed database CLONING to setup test and development database.

. 24X7 support for databases and production operations teams.

. Supported Oracle 11g, 10g and 9i databases.

. Cloning of oracle database and application.

. Used EXPLAIN PLAN, TKPROF, SQL TRACE for performance tuning.

. Database Backup Strategy and Archive log mode.

. User Administration. (Creating users, roles and profiles)

. Writing the triggers and stored procedures.

. Helped senior DBA'S in backup operations.

. Involved in Up gradation of Oracle 11i applications version from

11.5.9 to 11.5.10.2

. Export and Import of database objects to copy from one database to

another database between different environments.

. Installation and configuration of 10gAS

. Applying Oracle Applications patches Maintenance Pack,

Interoperability patch, Family packs, and CPU patches, Patch Sets.

. Database Tuning using AWR, STATSPACK utility.

. Successfully implemented 2 node RAC setup and made the environment

stable.

Environment: Oracle 9i, Solaris, AD Utilities, OEM, SQL, PL/SQL.

Contact this candidate