ORACLE APPS AND ORACLE DATABASE ADMINISTRATOR

Shubha KE

+91-916*******

adqadc@r.postjobfree.com

PROFESSIONAL SUMMARY

Around 8.5+ years of experience in oracle application and oracle database administration by providing 24/7 support for production, development environments on various platforms.

Good understanding and work experience with different unix and windows platforms,

Strong experience in installation, configuration, maintenance and administration, customization of oracle ebs11i, r12 application and oracle database.

Experience in database and application cloning, patching, upgradation.

Experience in single node and multi-node erp installation and administration of RAC database.

Expertise in setup, administration of data guard for disaster recovery.

Good in Performance tuning at database and application level.

Good in cloning, refreshing ebs11i, r12 and database using different backup methods.

Sizing, planning the database storage and experience in troubleshooting backup and restore.

Experience in database security and management.

Used AD utilities like adpatch, adadmin, adclone, adident, adctrl, admrgpch for application activities

Mongo database administration and weblogic application administration, patching.

Good understanding and administration of oracle cloud environments.

Have good analytical and problem solving and excellent communication and interpersonal Skills, ability to understand and adapt to new technologies and environments faster.

TECHNICAL SKILLS

Operating System

Unix (AIX 5.3, Red hat Linux, Sun Solaris 2.x/8, HP-UX 11i, 10.x), Windows XP/8/9/10

ERP

oracle ebs 11i, R12 (12.1.3, 12.2.4, 12.2.5)

RDBMS

oracle database 9i,10g,11g,12c,13c dataguard, RAC, oracle clod database

Languages

sql,c, unix shell, plsql

Tools

Toad, sqldeveloper, tkprof, sqlprofiler, opatch, oracle diagnostics pack, AD utilities, oam, application desktop integrator (ADI), web ADI, oracle Enterprise manager (OEM), recovery manager (RMAN), discoverer

Other

OBIEE 10g, OID, SSO, fusion middleware 11g, apache, UPK, ringmaster, kintana, appworx, oracle cloud, mongodb, cassandra, aws

ACADEMIC QUALIFICATION

BCA from Sahyadri Science College Shimoga.

MCA from Bangalore Institute of Technologies, Bangalore

Oracle Certified Foundations Associate from Oracle University

PROFESSIONAL EXPERIENCE

1.Employer: Tata Consultancy Services

Client: Cisco Systems India Pvt Ltd

Duration: Feb 2016 to Jan 2017

Client: Arris India Pvt Ltd.

Duration: Feb 2017 till date

Role: Oracle apps dba

Environment: oracle ebs 11i, r12.1.3, 12.2.5 database 10g and 11g, 12c, data guard, RAC, OEM13c,

oracle cloud database (paas), fusion middleware 11g, oracle weblogic server.

2.Employer: VeriFone India Technology Private Ltd

Duration: Feb 2014 to Jan 2016

Role: Oracle apps dba

Environment: oracle ebs 11.5.10.2, R12.1.3, R12.2.4, database 10g and 11g, 12C,

dataguard, fusion middleware 11g, SSO, OBIEE, BPEL, hyperion, amdocs, agile.

3.Employer: Soham Renewable Energy India Pvt Ltd

Duration: Feb 2012 to Jan 2014

Role: Oracle apps dba

Environment: oracle ebs 11.5.10.2, R12.1.3, database 10g and 11g, oracle modules ap, ar, gl

4.Employer: Cooperp Software solutions

Client: Wipro Technologies

Duration: Nov 2010 to Aug 2011

Role: Oracle apps dba

Environment: oracle ebs 11.5.10.2, 12.1.3, oracle database 11g,

discoverer 10g & 11g, dataguard, RAC, oracle 10gAS, fusion middleware 11g, OID, SSO

ROLES AND RESPONSIBILITIES

Administration and monitoring of production, development, test, staging and uat Instances.

Setup disaster recovery environment and performing routine DR-test

Single-node and multi-node install of ebs r12 as part of upgradation.

Scheduling and administration of backups and recovery strategies.

Database, application patching (opatch, adpatch, adop), cloning and monitoring automated cloning jobs.

Debugging issues related to apache, forms, concurrent managers, use, workflow and setup parallel concurrent processing as per the business requirements.

Logical backup and migrating database objects using oracle datapump

Creating database and application users, responsibilities and adding application printers.

Reorganizing the database to reduce disk contention, migration and chaining.

Monitoring the instance statistics and tuning the database to improve performance.

Organizing table spaces, data files and other database objects as per ofa standards.

Compiling, registering forms using f60gen, frmcmp and compiling invalid objects in the database.

Configured oracle internet directory (OID) and oracle single sign-on.

SSL Certificate upgrade in oracle wallet, keystore.

Custom top creation and its registration.

Periodic cleaning of Log, output files.

Involved in ebs11i to r12 upgrade and database upgrade from 10g to 11g.

Installing oem agents, adding and monitoring oem13c alerts.

SSL implementation for oracle web and forms server.

Monitoring cluster services and filesystem space management, creation of user, roles, db link, dba_directories and other db objects and solving browser java launch for ebs forms.

Performance tuning of the database like memory allocation tuning, i/o tuning and tuning contentions. Used tkprof, explain plan, hints, and SQL trace utilities for sql tuning.

Weblogic administration, bouncing services and applying patches to weblogic home

Supported Mongo database administration, maintenance and monitoring

Experience in handling Incidents, request and change management process

DECLARATION

I hereby declare that the above written particulars are true to the best of my knowledge and belief.

Place: Bangalore Signature

Date: 18-02-22 Shubha KE

Contact this candidate