Oracle Manager
Resume:
RESUME
Bhargavi
Mobile: +**
Email:*************@*****.***
PROFESSIONAL SUMMARY:
A competitive professional having a total of 3+ years of experience as
both Oracle DBA and Oracle Applications DBA.
PROFESSIONAL EXPERIENCE : (over 3 + Years):
1
2 ORACLE DBA SKILLS:
24x7 production support for critical systems, which utilize multiple
Oracle 9i, 10g, and 11g databases.
Highly proficient in Installation and configuration of Oracle 10g and
11g in Linux and Windows environment.
. Proficient in using export/import for schema, table and database
refresh.
. Experience in Design, implementation and generating documentation of
Oracle Data guard physical standby databases in high availability
mode.
. Experience in management of tablespaces such as dropping/creation and
modification of storage parameters and analyze the statistics
periodically and taking remedial action.
. Plan and upgrade oracle databases from 9i to 11g and 10g to 11g
respectively and apply latest oracle security patches.
. Knowledge on oracle real application clusters (RAC).
APPS DBA SKILLS:
. Hands of experience on administration of both 11i andR12 environments
. Good Exposure on Installation of Oracle Application 11.5.9, 11.5.10,
12.1.1 on Linux.
. Maintaining Oracle Applications using AD utilities.
. Well-versed in adadmin, adpatch, adctrl, admrgpch, AutoConfig
utilities.
. Using of autopatch for patching Oracle Applications.
. Using rapidclone for cloning Oracle Applications
. Managing Concurrent Managers and Monitoring Concurrent Requests.
. Good knowledge on upgradation of oracle applications.
Education:
Master Degree University Year of passing
M.Sc MIDDLESEX UNIVERSITY 2010
SKILL SET :
Work Experience:
Worked as ORACLE APPS DBA with SYSTEMS ONE SOFT SOLUTIONS INDIA PVT LTD
from JUNE 2010 to till date.
Project 1:
Client : MORGAN STANLEY
Project : Maintenance of oracle applications 11i,R12
Duration : JUNE 2010- MAY 2012.
Role : Oracle Apps Dba
Environment : Oracle 11g R1, Oracle Application 12.0.x,12.1.1,RHEL5
Responsibilities:
. Support 24*7 Production and test Oracle Application Instances as per
SLA.
. Installation of both single node, multi node and shared appl_top.
. Checking the status of important services like concurrent manager,
form server, web server, application listener, database listener etc.
. Sysadmin activities like creating users and assigning
responsibilities, roles and profiles.
. Well-Versed in using AD utilities like adpatch, admrgpch, adadmin,
adctrl, adident, adsplice etc.
. Applying applications patches using adpatch utility.
. Merging of application patches using admrgpch utility.
. Monitoring of patch process by reviewing patch log files and worker
log files.
. Monitoring the process by using adctrl utility.
. Using of adpatch options for effective patching of applications.
. Applying database patches using opatch.
. Compiling of invalid objects using adadmin utility.
. Relinking and regeneration of application objects using adadmin.
. Effectively using of adadmin to do administrative tasks.
. Monitoring of concurrent managers and concurrent requests submitted by
users.
. Creating concurrent managers and assigning work shifts.
. Assigned specific concurrent requests to a concurrent manager.
. Resolving the view log/out files issues of concurrent requests.
. Purging the concurrent requests historical data.
. Automated the purging of old trace/log files.
. Troubleshooting the Concurrent Manager issues.
. Cloning of applications using rapid clone utility.
. Cloning of applications from production to test and vice versa.
. Single to multinode and multi node to single node cloning using rapid
clone utility.
. Good exposure on upgradation of applications from 11.5.10.2 to 12.1.1.
. Enable tracings of sql, forms sessions if necessary.
. Interacted with the client to understand their requirements and their
Technical queries.
. Resolving issues using Oracle Support.
Project 2:
Client : LEGAL & GENERAL
Project : Production DB support.
Duration : JULY 2012 - till date .
Environment : Linux, Oracle 10.2.0.x.,11.2.0.x
Role : Oracle Database Administrator.
Responsibilities:
. 24 X 7 Production database administration and support.
. Planning, Installation and Configuration of Oracle Database on the
Server.
. Plan and upgrade oracle test databases from 10.2.x.x to 10.2.0.5,
10.2.0.5 to 11.2.0.3 respectively and apply latest oracle security
patches.
. Performing Database migrations from Windows to Linux when necessary.
. Configuring data guard for production databases for high availability.
. Manage tickets generated through ticketing system.
. Patch the ASM, RDBMS and Grid Infrastructure homes using OPatch
utility.
. Providing technical assistance to application developers.
. Manage, monitor and configure RMAN backups.
. Refreshing development database from production using export/import.
(BHARGAVI)
Operating Systems Red Hat Linux AS 5.0, AS 4.0
Languages SQL.
Databases Oracle 11g (R1), 10g, 9i.
DBA Oracle Database Administration,
Tools & Utilities Export, Import, RMAN, OEM, OAM.SQL developer
Oracle Applications Oracle Applications Release 11.5.10,R12.1.1,12.0.x
Contact this candidate