Certified Oracle Applications DBA Resume

Title
Certified Oracle Applications DBA

Primary Skills
Oracle Applications DBA

Location
US-NY-new york city (will consider relocating)

Posted
Jan-12-09

Summary:

?Overall Six years of experience as Oracle DBA / APPS DBA
? Oracle Applications DBA and Sysadmin activities and worked extensively in cloning, patching
? Extensive experience in Installation, Migrations, Upgrades, maintenance and day-to-day administration capacities of Oracle Applications 11i instances
? Extensively worked with oracle 8i/9i/10g and independently planned and carried out Database Migration/Upgrade/Installation.
? Installation and setting up of Oracle Financials 11i with modules like AP, AR, GL, FA and PO
? Technical expertise in configuration, design, problem resolution, backup and recovery, database security, capacity planning and performance monitoring.
? Extensively worked on Oracle Application Servers (9iAS) and carried out Migration.
? Expertise in Operating system Installation, configuration and managing OS groups and Users and experience in UNIX Sysadmin Activities.
? Knowledge on on-line/off-line backup and recovery principles.
? Effective and efficient UNIX and scripting experience.
? Developed a Pro-Active Monitoring Tool which monitors all Oracle Database and Application process and notifies user for failure process.
? Cloning of the Applications using Rapid Clone and Ad clone.
? Configuring Oracle Tutor and User Productivity Kit
? Installation of Oracle Governance, Risk, and Compliance Manager
? Workflow mailer setup and configuration.
? Discoverer 10g setup and configuration
? Possess exceptional analytical & problem solving skills, excellent communication and interpersonal skills, worked independently as well as in team environments

Certifications:

? Oracle 9i and Oracle10g certified.

Academic Profile:

B.Tech in Computer Science & Engineering, India

Technical Skills:
Databases : Oracle 8i, 9i, 10G
Applications / Ebusiness suite (ERP): Applications 11i (11.5.8/11.5.9/11.5.10), R12
Application Servers : Oracle 9iAS, 10g.
Tools : Oracle Developer 2000/6i), Oracle Discoverer 4i/10g,
Forms / Reports (4.5/6i.2.5, 3, 6i) 7.4, Oracle Portal,
OEM, RMAN, AD Utilities, Export/Import, Sql Loader,
MWA servers, Workflow, VNC
Operating System : LINUX, AIX, Sun OS, HP-UX, Windows NT/XP, Dos
Programming Languages : SQL, PL/SQL, Core Java, Shell Scripting.

Trainings:

? Oracle Application Object Library (Oracle Corporation)
? Oracle 9i DBA Training (Oracle Corporation)
? 11i Oracle Applications Architecture (Oracle Corporation)
? 11i System Administrator Fundamentals (Oracle Corporation)
? RH301 Red Hat Linux Rapid Track Course (Oracle Corporation)

Oracle Corporation, Redwood Shores, CA Nov 2004 -- Till date
Oracle Applications DBA

Worked with the Oracle On-Demand division. This team manages the end-to-end troubleshooting activities, monitoring, Upgradation, Migration, Automation, Regular backups etc. This team basically manages the entire Customer's server hosted @ Austin data center, Texas. This division identifies the Oracle customers and migrate the Instance to the Oracle On-Demand Standards and there after give them end-to-end support. At present Oracle On-Demand supports about 400 clients, approximately 1500 servers are hosted in Oracle On-Demand.

Oracle On-Demand managed by Oracle at Austin Data center, at Customer location, or at a third party to improve the performance, reliability, scalability and security of Client's information.
I have been a member of the team called OHSOA

Migration Projects (Team: OHSOA)

Responsibilities
? To migrate the Customers running the Oracle Application to the Oracle OnDemand Standards.
? The Migration includes cross platform migration, upgrade to the latest release of Application.
? Import and Export of Database from source to target.
? Migrate to Test, Development instance and then moving the Instance to Production.
? Installation of Oracle Application, Deciding Migration path.
? Configuration of Parallel Concurrent Processing (PCP).
? SSL and DMZ configuration.
? Implementing shared APPL TOP.
? Licensing of Oracle products using OEM.
? Extensively worked on Enabling Real Application Clusters (RAC) on 11i instances.
? Involved in troubleshooting Application and database related issues.
? Involved in Regular health check and regular GAP analysis checks to keep the instances updated by performing periodic patching.
? Installing Discoverer 4i, 10g. implementing SSL

Environment: Oracle Application E-Biz, 11.5.8, 11.5.9, 11.5.10, 11.5.10.2, R12, Oracle 9i/10g,
Red Hat Linux AS 1.1/2.1, AIX 5, Sun --OS

Clopay Corporation, Mason, OH

Clopay Building Products Company is the nation's largest residential garage door manufacturer. The company is widely known for its unique patented technology developments.

Responsibilities
? Understanding the requirement, complete setup and the process for Upgradation
? Upgrading individual Tech Stack Components.
? Installation of Oracle Application R12
? Import and Export of Database from source to target
? Discoverer 10g setup and configuration
? Running Autoconfig on all Tiers
? Enabling Database in Archive log mode
? Implementing shared APPL TOP
? Creating Custom Queue Concurrent manager
? Configuration of Parallel Concurrent Processing (PCP)
? Applying Maintenance pack (MP) and other required patches

Environment: Oracle Application 11.5.9, R12, Oracle 9i, 10g, Red Hat Linux AS 1.1/2.1

Del Monte, San Francisco, CA

Del Monte Foods is one of the country's largest and most well known producers, distributors and marketers of premium quality, branded food and pet products for the U.S. retail market.

Responsibilities
? Providing DBA support 24x7
? Monitoring and administering Concurrent managers issue
? Monitoring performance related issues and DB locks
? Licensing new Products using Adsplice utility
? Monitoring and Optimizing the performance of the databases and tune database server performance & INIT.ORA parameters
? Tablespace maintenance like adding and resizing datafiles
? Solving Issues mainly related with iProcurement Self Service Frame work.
? Created custom Top per Client requirement
? Running Autoconfig on all Tiers
? Enabling Database in Archive log mode

Environment: Oracle Application 11.5.9, 11.5.10.2, Oracle 9i, 10g, Redhat Linux 2.0

GAP, San Francisco, CA

Gap Inc. is one of the world's largest specialty retailers. They operate four of the most recognized apparel brands in the world -- Gap, Banana Republic, Old Navy and Piperlime.

Responsibilities
? Proactive monitoring of Database and Oracle Applications using OEM (24 X 7)
? Upgrading individual Tech Stack Components
? Upgradation of Database from 9i to 10g.
? Cloning of 11i Instances, DB and MidTier Refresh
? Maintaining APPS using the AD Utilities like: adadmin, adpatch, admrgpch, adctrl, adsplice,
? Implementing customizations recommended by consulting team
? Writing Shell scripts for backup and scheduling them for daily backup of datafiles

Environment: Oracle Apps 11.5.9, 11.5.10, 11.5.10.2, Oracle 9i/10g, Red Hat Linux AS 1.1/2.1

Welch's, Concord, MA

Welch's is the world's leading marketer of Concord and Niagara-based grape products with over 400 items ranging from refrigerated juices and sparkling juice cocktails to jams, jellies and a variety of single-serve products in all shapes and sizes.

Responsibilities
? Providing DBA support 24x7
? DB/Application Backup
? Copy/Clone of oracle application environment
? Monitoring the all-running Instance to ensure everything working
? DB Upgrades and Database patches using Opatch tool

Environment: Red Hat Linux AS 1.1/2.1, Oracle 9I, Oracle Application 11I (ERP & CRM)

TetraTech, Pasadena, CA

Tetra Tech is a leading provider of consulting, engineering, and technical services worldwide. They are a diverse company, including individuals with expertise in science, research, engineering, construction, and information technology.

Responsibilities
? Trouble-shooting of all oracle application problems
? DB refresh from production environment to Quality environment.
? Patch analysis and Applying Mini packs
? Database Patch by using Opatch utility
? Licensing the new products

Environment: Oracle Apps 11.5.10, 11.5.10.2, Oracle 9i/10g, Redhat 2.1 Linux

Estee Lauder, Newyork, NY

Estee Lauder Companies Inc. is one of the world's leading manufacturers and marketers of quality skin care, fragrance and hair care products.

Responsibilities
? Apps - Creating users, assigning responsibilities, troubleshooting the issues, Cloning of Production to test.
? Database - Administering and monitoring daily activities, monitoring performance, creating index, taking backups (Hot/Cold) and cloning of database.
? Running AD utilities, Resolving Jinitiator issues, Printer configuration
? Monitoring and Optimizing the performance of the databases and tune database server performance & INIT.ORA parameters

Environment: Oracle Application 11.5.8, 11.5.9, 11.5.10.2, HP-UX PA-RISC

XOMA Berkeley, CA

XOMA is at the forefront of antibody discovery and development, one of the most powerful and transformative fields of drug innovation today.

Responsibilities
? Cloning the Oracle Application & Database, Applying Database & Application Patches.
? Monitoring the Concurrent Managers & Tuning the concurrent Programs
? Workflow mailer setup and configuration.
? Responsible for creating and managing user accounts efficiently

Environment: Oracle Application 11.5.9, 11.5.10.2, Solaris 10

Nevada Cancer Institute, Las Vegas, NV

Nevada Cancer Institute (NVCI) is the official cancer institute for the State of Nevada. A nonprofit organization, NVCI is committed to reducing the burden of cancer by pursuing the development of a comprehensive cancer research institute, as defined by the National Cancer Institute.

Responsibilities
? Understanding the requirement, complete setup and the process for Upgradation
? Cloning the Oracle Application & Database, Applying Database & Application Patches
? Monitoring the Concurrent Managers & Tuning the concurrent Programs
? Perform day-to-day database administration and ensure integrity, security, and daily health checkup of the database
? Quantum upgrade and licensing the New Products

Environment: Oracle Application 11.5.9, 11.5.10.2, Windows 2000

Sleepy's, Bethpage, NY

Sleepy's, the Mattress Professionals is a family-owned company that has grown from a single Brooklyn location to nearly 700 stores in 50 years.

Responsibilities
? Involved in troubleshooting the APPS 11i related issues
? Cloning of the Applications using Rapid Clone and Adclone
? Performed daily & scheduled backups
? Create custom responsibilities, request groups and menus
? Patch Analysis and Patching of both Apps, DB tier
? User/ Role management

Environment: Oracle Application 11.5.9, 11.5.10.2, Linux, HP-UX PA-RISC

Covansys India (P) Ltd May 2003 -- Oct 2004
Oracle Applications DBA

Covansys is a global consulting and technology services company specializing in industry-specific solutions, strategic outsourcing and integration services. There are one of the very few companies in the world to achieve SEI CMM® Level 5 and SEI's People Capability Maturity Model (PCMM®) Level 5 with a unique Onsite/Offsite/Offshore approach for providing cost-effective IT solutions.

Responsibilities
? Involved in logical and physical database design and implementation
? Sysadmin Activities -- Concurrent Manager, Conflict Resolution Manger, Profile Options
? Trouble-shooting of all oracle database problems
? Patching and Cloning of both Tiers
? User management and administration
? Interacted with Oracle support for Application and Database issues
? Licensed new Products using Adsplice utility
? Applying major Patches for DB upgrade
? Regular monitoring of production as well as Test application
? Monitoring Performance, Locks using OEM
? Auditing & Securing Oracle Applications
? Analyzing SQL statements using SQL Trace & Tkprof
? Tablespace Maintenance like adding the increase the size of the data files
? Ensuring maximum Uptime for Production Test Instances
? 24 X 7 Support on call DBA Support
? Working On TAR

Environment: Oracle Application 11.5.8, 11.5.9, 11.5.10.2, Red Hat Linux AS 1.1/2.1, AIX 5, Sun --OS

Certifications
Certifications:

? Oracle 9i and Oracle10g certified.



You must be logged in and have a current resume access subscription. Login or Register »

Resumes in new york city, NY | Resumes in New York

View other Certified Oracle Applications DBA resumes, Database Administrator resumes