Manager Oracle

P. Aravind kumar

Email: *******.*******@*****.***

Mobile No: +91-984*******

Objective

Seeking for a challenging position in the field of databases with a progressive company that will effectively

utilize my acquired expertise and experience.

Having 4 years of experience as a Oracle Application DBA, Oracle Core DBA and RAC knowledge and

giving Technical Support to the different application teams and end users.

Professional Summary

Well Experience on 11i and R12 Applications.

Proficiency in Cloning & Patching of Oracle Applications.

Performed research for patches for specific problems and downloaded patches. Done patch analysis,

applied patches and checked the patch impact.

Performed the Cloning of oracle applications instances from prod to test and dev using rapid clone utility.

Familiar with Oracle Applications AD utilities like AD Administration, AD Controller, AD Merge Patch,

AD Splice, AD Relink, Auto Patch etc.

Up gradation of Oracle Applications from 11i to R12.

Experienced in the Up gradation of Database from 9i to 10g and then 11g.

Monitoring the Concurrent Manager & its operations like starting, stopping the concurrent managers &

Troubleshooting problems.

Migrating the data or code using FNDLOAD.

Managing passwords of apps and Product passwords using FNDCPASS.

Good experience in backups and recoveries.

Managing backups of the apps instances & maintaining daily hot backups of database of dev/test and

involved in recovery of database.

Daily database checkups like listeners, processors, and archive logs, table spaces, Indexes, mount points.

ASM (Automatic Storage Management) knowledge

Supporting development teams, general troubleshooting & Support in administration of production & test

instances.

RMAN Backups and recoveries

Cloning Oracle Database using Cold backup, Hot backup & RMAN backup

Refreshing development/test database from production using Database Cloning Datapump.

Creation of Stand by Database (Data Guard)

Installation and configuration of Oracle 9i, 10g and creation of Database on Red hat 4 Linux.

Professional Working Experience

: Saxon Global Inc

Organization

Ø

Designation : Oracle Apps DBA

Ø

Period : August 2012 to Till date.

Ø

: Seal Infotech

Organization

Ø

Designation : Oracle core dba & Apps Database.

Ø

Period : August 2010 to July 2012.

Ø

: Solar IT Solutions

Organization

Ø

Designation : PHP Programmer

Ø

Period : March 2009 to May 2010.

Ø

Organization : Andhravsioin Infotek

Ø

Designation : System Administrator.

Ø

Period : December 2005 to February 2009

Ø

Education Qualification

Bsc(Computers) 2005.

Ø

Technical Skills

: Oracle E Business Suit 11i & R12

Applications

: Oracle 9i, 10g and 11g

RDBMS

Programming languages : SQL, PL/SQL

: Win 2000/NT/XP, Unix, Linux

Operating System

Database Tools : Oracle Enterprise Manager, Rman, Datapumps

Projects

Project#1

: Saxon Global Inc

1 Company

Rdbms : Oracle 10g, 11g

: Oracle APPS DBA

Role

Duration : August 2012 to till date.

Responsibilities:

Installation, configuration, and management of Oracle 10g/11g on Linux.

Ø

Ø Up gradation of Oracle Applications from 11i to R12.

Ensure database stability and performance.

Ø

Enforcing database security.

Ø

Used AD Controller to see the status of worker’s and restarted failed workers after

Ø

resolving the problems.

Ø Performed Cloning of the Oracle E Business Suite using Rapid Clone.

Ø Creating users and assign the responsibilities to the users.

Ø Troubleshooting the Application System, this includes troubleshooting login problems,

regenerating application components and file system (forms, reports, menus, java

classes, libraries and jar files), relinking executables and database problems.

Ø Managing concurrent managers, concurrent programs and defining Custom Managers to

run specific type of requests and enhance the performance.

Ø Resolved the view log/out files issues of concurrent requests.

Ø Monitoring the Apache log files, concurrent manager log files, patch log files for

application related issues.

Ø Used AD administration utilities (adpatch, adadmin, adctrl, adaimgr).

Ø Relinking Oracle applications programs and regeneration of Oracle Forms and Reports.

Ø Backup the Oracle Database using hot backup and RMAN backup methodologies

Project#2

Company : Seal Infotech

RDBMS : Oracle 9i, Oracle 10g

Role : Oracle APPS DBA / Core DBA

Duration : August 2010 to July 2012.

Responsibilities:

Core DBA activities for Oracle 9i & 10g.

Maintenance of Apps using AD Utilities.

Rapid Application Cloning.

Patching the Oracle Application using Adpatch and Database patch using opatch utility.

Monitoring the concurrent processing manager status.

Performing Day to Day activities, checking alert logs and scheduled tasks.

Ø

Creation and Maintenance of database storage structures such as Tablespaces.

Ø

Exporting & importing data into the databases, using Oracle utilities such as Datapump.

Ø

Performing Database backups using cold and Hot.

Ø

Monitoring and Supporting databases in a 24x7 environment.

Ø

March 2009 to April 2010.

Ø

Project#3

Company : Solar IT Solutions

Role : PHP Programmer

Duration : March 2009 to April 2010

Responsibilities: Creation and implementation of a wide variety of Web based products using PHP,

JavaScript, MySQL and AJAX. Develop, record and maintain cutting edge web based PHP applications on

portal plus premium service platforms.

Project#4

Company : Andhravision Infotek

Role : System Administrator

Duration : December 2005 to February 2009

Team Size: 3

Responsibilities:

Installation Operating System

Ø

Installation and Maintaining Local Area Network in the office.

Ø

Provided technical support to the entire organization on software and hardware’s.

Ø

Updating Operating System, Antivirus, Service and Packs.

Ø

Installation and up gradation of hardware and software.

Ø

Online Email Configuration and Outlook Configurations

Ø

Contact this candidate