Oracle Applications dba Having 6 years of experience
--------------------------------- Resume Format ----------------------------------------
Name
Ph: 99865622222
Professional Summary
Over 6 years
of experience in Information Technology, around 4.1 years of hands on experience as Oracle Applications DBA & Oracle
DBA primarily in Oracle/UNIX/NT/Client
Server environment.
- v Extensively worked on Oracle Applications 11.5.10.2 and R12 administration.
- v Applying patches to Application file system through adpatch.
- v Reducing patch timings by applying patches through features like defaults file & admrgpch.
- v Performed RDBMS Cloning through RMAN & Application Cloning through Rapid Clone.
- v Having good knowledge of Oracle Application Utilities like adadmin, admrgpch, adpatch, adctlr, adsplice, adconfig, adrelink.
- v Performed application’s Sys admin tasks like creating and managing users and their responsibilities, Menus, Functions, Profiles, and Alerts.
- v Concurrent Manager Setup, maintenance and trouble shooting.
- v Creating, maintaining and managing Custom environments in Oracle Applications.
- v Checking the status of important services like Concurrent manager, Form server, Web server, Application Listener, Database Listener etc.
- v Opening, managing, and resolving Oracle Services Requests (Tar’s).
- v Involved in Backups and Restores.
- v Upgradation of database from lower version to higher version (From 11i 9.2.0.2 to R12 10.2.0.5).
- v Cloned Production Database for test purposes.
- v Applying Patches and Patch sets for Oracle 9i and Oracle 10g databases.
- v Experience in Administering Oracle Databases 9i and 10g on Linux.
- v Excellent interaction skills with proven experience in building Client Relationships.
- v Excellent Analytical, Co-ordination Skills and experience in Managing Projects & Delivering quality work.
- v Excellent Communication, Logical and Problem Solving Skills with Quick Adaptability to new environment.
Technical Skills
|
Operating
Systems
|
UNIX, Linux and Windows (Vista,XP,2003,2000,98)
|
|
RDBMS
|
Oracle 9i/10g
|
|
Oracle Tools and Utilities
|
Export / Import, RMAN, Oracle Enterprise Manager(OEM)
|
|
Languages
|
C, C++, SQL, PL/SQL,
Unix Shell Programming
|
Academic Profile
v Master
of Science in Computer Science
from University. Subjects undertaken
include Design and Analysis of Algorithms, Computer Networks, Computer
Architecture, Database Management System, Operating System Design, Software
Engineering with GPA of 3.4/4.0.
v Post
Graduation Diploma in Computer Applications from Jawaharlal Nehru National Youth Centre (India).
Subjects undertaken include Visual Studio, FoxPro, Oracle 8i, and UNIX.
v Bachelor
of Science in Computer Science
from University (India). Subjects undertaken include
Algorithm solving, C with Data Structures, Assembly language coding.
Professional
Experience
v
Working as Applications
DBA with E Mobile Security Systems, Hyderabad from 14th Jun 2010 to till date.
v
Worked as Applications
DBA with CMF Technologies (P)Ltd, HYDERABAD from
2004 Apr 26th to 2006 Dec 14th.
v
Worked as Faculty
at Universal Solutions, Dilsukhnagar, and Hyderabad from 2001 Aug to
2004 Mar (Computer Science).
Project Experience 1 Jun2010 to till date
Client :
C3i-inc
Project :
P4HealthCare
Role :
Applications DBA
Description:
P4 Healthcare is the preferred online health care
community, providing comprehensive customized solutions that enhance the
quality of patient care and increase efficiencies for Physicians, Patients,
Pharmaceutical companies, and Payers.
It provides comprehensive, customized health care
management solutions that increase practice efficiencies and enhance the
quality of patient care. By partnering with the leading specialty
therapeutic practices across the nation, P4 connects physicians, patients,
pharmaceutical companies, and payers to bring these practices new and
innovative.
Responsibilities:
v Performed Upgradation
from 11.5.10.2 to R12 on different
instances.
v Interacted with Customers
to resolve the issues and improved the customer business by reducing the downtime.
v Successfully performed Pre
Patch Analysis for different patches in Applications and Database.
v Worked on different environments and on different versions (11.5.10.2 and R12)
v Good experience on Troubleshooting
Issues related to different application components.
v Resolved various issues during Patching,
Auto config and Upgradation.
v Performed various configuration changes in the file system running
auto config and also performed many Sys Admin
tasks.
v Working with
large number of production, Development and Test Databases.
v Actively interacted with Developers
to improve the performance of instances.
v Monitoring
the Scheduled Backups, and referring the backups in case of failures.
v Creating Table
spaces, Users and Roles for test environment.
v Managing Data Table
space, Undo Table space, Temporary Table space.
v Cloned Database from PROD
to TEST.
v Involved in System
Administration Tasks like creating responsibilities and assigning them to Users.
v Assigning
concurrent requests to Concurrent Manager.
v Monitoring Concurrent
Requests & Concurrent Manager.
v Documenting
and maintaining checklists of various DBA activities like Cloning,
Patching, Code migrating, etc.
Project Experience 2 Apr 2005 to Dec 2006
Client : Sonata Software Ltd
Project :
Customer Solution Center, Symantec Inc., USA
Role :
Oracle Applications DBA
Description:
Symantec
is a global leader in infrastructure software which helps customers to protect
their infrastructure, information and interactions by delivering software and
services that address to security, availability, compliance and performance.
Symantec is having operations in 40 countries.
The
organization seeks to increase the effectiveness and efficiency of their
customer support activities into one customer solution center. Accordingly
Symantec has designed the initial parameters to manage and operate a customer
support to consolidate all support activities into a single integrated contact
center.
Responsibilities:
- v Maintenance and Administration of the Oracle Apps software.
- v Applied various RDBMS patches by using OPatch Utility.
- v Cloning of Production Database to the Test Environment.
- v Support for Development and Production Databases.
- v Performing Day-to-Day Database Administration tasks and maintenance.
- v Working with all AD Utilities like adadmin, adpatch, adctrl etc.
- v Defined and Maintained Concurrent Manager.
- v Performing Weekly Application Backups.
- v Involved in Custom Top creation and registering custom application.
- v Involved in System Administration Tasks like creating responsibilities and assigning them to Users.
- v Good understanding of Oracle Applications Architecture including advanced topologies like multi-node instances using Shared APPL TOP's.
- v Having knowledge of cloning of Oracle Applications from Multi Node to Single Node.
- v Worked closely with teams including Applications development, Database development, Oracle Support, and business community.
- v Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, and Admin).
Project Experience 3 Apr 2004 to Mar 2005
Client : Sonata Software Ltd
Project : Oracle 9i Installation/Maintenance
and Support (24/7)
Role : Jr. DBA
Responsibilities:
v Installation and
Administration of Oracle Database on Linux
and Windows environment.
v Good experience of Oracle Enterprise Manager Tool in monitoring database.
v Performed traditional backups (Hot backup and Cold backup).
v Restoring and
Recovering Databases with Available backups.
v Used different types of tools and utilities like Exp, Imp and RMAN.
v Creating Users,
Roles, and Profiles and administering Database for Security.
v Setting the default temporary table spaces and
assigning quotas, roles, privileges, and
profiles to users.
v Maintenance of Table
spaces, Data files, Control files and Redo
log files.
v Experience in Trouble
Shooting and Resolving Problems during the regular maintenance of Oracle
database.
v Provided 24X7
DBA Support for Production Problems.
