Oracle Apps Dba

Dasari Kumar Ganesh

Mobile: 099********

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

Career Objective:

To associate myself with an organization that provides me an opportunity to

show my technical and proficient skills, improve my knowledge and to be a part of the team that works

dynamically towards the growth of the organization.

Profile:

4.2 Years of I.T Experience as an Oracle Applications Database Administrator and Oracle database.

Administrator in RAC environment.

Installation of APPS11i/R12 EBS single and multi node environment.

R12 Upgrade (11.5.10.2 to 12.1.3).

Applying patches to test instances and performs rigorous Testing and subsequently applying to the

Development and production instance.

PCP configuration.

Well versed in using AD utilities – adadmin, adpatch, adrelink, adctrl, adident, admrgpch.

Configuring Test and Development Instances and cloned the entire Oracle Application

Instance from production to test on a regular basis, across multiple tiers.

Changing passwords for Oracle Application Users.

Managing Concurrent Process, Concurrent Programs/Managers, Registering New Concurrent

Programs, Concurrent Types, defining new Concurrent Managers.

Configuration and installation of cluster ware on RAC environment.

Performed upgradation of cluster ware from 10.2.0.1 to 10.2.0.4 and database from 10.2.0.1 to 10.2.0.4.

Creating ASM database and taking backup using RMAN.

Experience in Oracle Database Administration 9i/10g.

Performed numerous Installation of various versions 9.2.0 and 10.2.0.

Involved in backups and recovery.

Creating database on RAC environment.

Upgrading of database from one release to next release manually and using DBUA.

Good knowledge of cloning RAC as well as Non RAC database and configuring ASM database.

Knowledge on DMZ setup

Creation and Management of Tablespaces, Users & Rols

Good knowledge of Online, Offline and RMAN Backups and Recoveries.

Managing Database Structures, Constraints, Database Access, Roles and Privileges.

Managed ASM configuration and migration of database from clustered file system to ASM.

Cloned the database using cold, hot backup manually and automated cloning process using RMAN as

well for RAC database.

Responsibilities (on RAC Environment):

Successfully installed and Configured10g RAC Database.

Performed taking backups of OCR and CSS files.

ASM configuration on RAC setup.

Adding of node to existing cluster.

Working with large number of production, development and test databases.

Applied database patches, cluster Patches using Opatch Utility.

Monitoring RAC database through SRVCTL.

Cloned database from development to test using RMAN.

Knowledge on migration of NON ASM to ASM, ASM to NON ASM databases.

Successfully cloned Non RAC database to RAC databases.

Upgraded Cluster ware from 10.2.0.1 to 10.2.0.4.

Taking Back up of the Database using RMAN.

Maintenance of Table spaces, Data files, Control files, Redo log files.

Support for Development and production Databases.

Cloning of production database to the test environment using Recovery Manager (RMAN).

Knowledge on configuring Data Guard (Standby Database).

Professional Experience:

Have 4 years of experience as Oracle Apps dba.

• Working on Oracle AppsDba in SPA EnterPrises Plc.(Jul 2011 – Till Date)

I have done the project in Abu dhabi (Darwish Bin Ahemad).

• Worked on Oracle AppsDba in iGrid Technologies Pvt Ltd(Jan 2009 –Jul 2011)

Certification:

Oracle Certified Associate 10G (OCA).

Qualification:

Year of

Degree Institute Board/ University

Passing

VITAM College,

MCA JNTU University 2005-2008

Visakhapatnam

Andhra University,

MCom Andhra University 2003-2005

Visakhapatnam

V.S Krishna Govt Degree

BCom Andhra University 2000-2003

College, VSP

Mahathi Jr College,

Intermediate Board of Intermediate 1998-2000

Visakhapatnam

Z.P HIGH School, Board of Secondary

SSC 1997-1998

Visakhapatnam Education

Technical Skills:

Oracle

Oracle Applications 11i,R12

Applications

RDBMS Oracle 9i, 10g, 11g.

Operating

Oracle Enterprise Linux Windows NT/2000/XP,IBM AIS 6.1

Systems

Ad patch, Autoconfig, RapidClone, Oracle Enterprise Manager

Oracle Tools (OEM),Export/Import,Datapump,Oracle Application Manager(OAM),ADutilites

Software Installation, Upgradation, Troubleshooting, Patch

Skills

Management, Cloning, Backups & Recovery

Assignments:

Project # 3:

Road Transport

Domain :

Darwish Bin Ahemad

Client :

JUL2011 – Till Date

Duration :

Oracle Application DBA&Rac DBA

Role :

Oracle Applications 12.0.3, Oracle 10.2.0.5.

Environment :

Responsibilities : As Apps DBA

Responsibilities (As Apps DBA):

Installation of Oracle Application 11i & R12

Good Knowledge on Oracle Application R12.

Oracle Application and database refresh and cloning.

User account management creating users, disabling users, responsibility management.

Managing concurrent managers ensure system is running smooth, monitoring throughput, watch

for long runners.

System Administration for Oracle Apps which includes creation and maintenance of Users,

Responsibilities, Menus, Profiles, Concurrent Programs, Request Sets, Request Groups etc.

Application of Patches.

Good knowledge on AD utilities and their usage.

Performed adadmin tasks basing on requirements

Relinking & Compiling the Oracle application objects

Performed sysadmin tasks as per the requirement

Resolved the configuration issues raised by development teams.

Proactive issue resolution and troubleshooting the issues raised by users

Applied number of Patch applications Including pre req's investigation.

Copying new forms, reports, custom code to production environment.

Generate form files, generate report files, and generate graphics files using adadmin utility, create

applications environment file

Shift Coordination, which include assigning roles and responsibilities to the team members and

interacting with Online Support team for handling Tars.

Participating in team lead meeting, weekend plan meeting and process meetings.

Project # 2:

Construction

Domain :

Saif Bin Ahemad (SBD)

Client :

JUL2011 – Till Date

Duration :

ORACLE Application DBA

Role :

Oracle Applications 11.5.10, Oracle 9.2.0.3

Environment :

Responsibilities : As Apps DBA

Responsibilities:

Oracle Architectural Components and installation of 9i & 10g versions

Oracle 9i Installation on Red Hat Enterprise Linux AS Release 3.0

Application patching analysis & applying patches on test instances.

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

& Troubleshooting problems, resolved the view log/out files issues of concurrent requests.

Validating & Creating grants & synonyms on Apps schema, Performed jar file/forms generation as

a post patch step, relinking the Oracle apps programs.

Managed and troubleshooting apps components like apache/forms etc.

Extensive use of ad utilities like adpatch, adctrl, adrelink, adadmin, aderelink.sh, LicenseMgr,

adident, adautoconfig for maintenance of Oracle application.

Cloning the Database using Hot, Cold and Rman backups

Managing Data Tablespace, Undo Tablespace, Temporary Tablespace

Taking Hot and Cold Backups with incremental and full Options

Monitoring the Alert log files and verify database health proactively

Used export and imports at tablesapce,Schema and database level

Maintain the RMAN scripts for getting scheduled backups by using recovery catalog.

Project # 1:

Construction

Domain :

Gate Gourment

Client :

JAN 2009 – JUL 2011

Duration :

ORACLE Application DBA

Role :

Oracle Applications 11.5.10, Oracle 9.2.0.3

Environment :

Responsibilities : As Apps DBA

Responsibilities:

Applied Patching on Test, Dev, Stage and Production Instances.

Instances comprised of Multi Node Environments. (Multi Tiers).

Knowledge of Troubleshooting.

Worked with the ADADMIN Utilities.

Performing Pre Patch Analysis (PPA)

Bouncing the Application services and database services for test and prod instances.

Performing Code promotion as requested by customer

Performing the Health Checks for the instances

Managed and troubleshooting apps components like apache/forms etc.

Extensive use of ad utilities like adpatch, adctrl, adrelink, adadmin, aderelink.sh, LicenseMgr,

adident, adautoconfig for maintenance of Oracle application.

Cloning the Database using Hot, Cold and Rman backups

Troubleshooted the middle tier (Apache server) issues

Troubleshooting the concurrent manager requests.

Taking Hot and Cold Backups with incremental and full Options

Monitoring the Alert log files and verify database health proactively

Used export and imports at tablesapce,Schema and database level

Responsibilities (on RAC Environment):

Successfully installed and Configured10g RAC Database.

Performed taking backups of OCR and CSS files.

Adding of node to existing cluster.

Working with large number of production, development and test databases.

Applied database patches, cluster Patches using Opatch Utility.

Monitoring RAC database through SRVCTL.

Upgraded Cluster ware from 10.2.0.1 to 10.2.0.4.

Database Maintenance for Archive logging.

Maintenance of Table spaces, Data files, Control files, Redo log files.

Contact this candidate