Resume of Oracle Apps DBA

Title
Oracle Apps DBA

Primary Skills
Oracle 11i Applications (Oracle EBS) DBA ,Oracle DBA, Installation, Oracle 11i

Location
US-NJ- (will consider relocating)

Posted
Jan-28-08

SUMMARY:

• 7 Years of Software experience in various applications
• 5 Years of experience in Oracle 11i Applications (Oracle EBS) DBA
• 2 Years of experience in Oracle DBA
• Strong experience in Installation,Setup,Implementation,Customization & Product Support of Oracle Applications 11i(11.5.8,11.5.9,11.5.10,11.5.10.2)
• Strong experience in Installation and Configuration of Oracle Application Server(Oracle 9i AS/AS 10g)
• Strong experience in Patching and Cloning Oracle Applications on different platforms
• Strong experience in Up gradation of Oracle Database from Oracle 8i to Oracle 9i
• Strong experience of System Administration and Knowledge of Application Object Library(AOL)
• Strong experience in Creating Users,Responsibilities,Menus and Form Functions
• Strong experience with Oracle 9i database and Oracle 10g database
• Hands On experience on Real Application Clusters(10g RAC)
• Strong Knowledge of Release 12/12i
• Extensive DBA experience in maintenance,development,Export/Import,Backup/Recovery
• Registering Concurrent Programs with Concurrent Managers, Registering of Reports and Creation of Additional Concurrent Managers and Maintenance
• Strong experience in Registration and Configuration of Printers in Oracle Apps
• Worked on different flavors of Unix for supporting 11i Oracle E-Business Suite
• Experience of Kintana Patch Management Utility

TECHNICAL SKILLS:

Operating System : Linux, Solaris, AIX, Windows NT,
RDBMS : Oracle 8i,9i,10g
GUI : Developer/2000
Languages : C, SQL*PLUS, PL/SQL
Tools : SQL*Loader
Administration : Linux Administration, Solaris Administration
Database Administration : Oracle 8i, 9i ,10g Administration
ERP : Oracle Applications 11/11i

EDUCATION:

• Bachelor of Technology in Civil Engineering
• Post Graduate Diploma in Computer Applications
• Oracle Certified Professional

TECHNICAL TRAINING

• Oracle Applications DBA
• Oracle 9i Database Administration
• Oracle 10g Database Administration
• 10g RAC on Linux AS 4
• Basic Unix and shell programming


PROFESSIONAL EXPERIENCE

Client Name: USANA Health Sciences
Client Location: Salt Lake City, Utah
Duration: Mar-2007 to Nov-2007
Role: Oracle Apps DBA Consultant
Environment: SUN 8,Oracle 9i,10g Oracle Apps 11.5.10.2


I was responsible installation and maintenance of 11i Oracle E-Business Suite on Solaris. I used AD Utilities like adadmin and adpatch to maintain Applications. Additionally, I was involved in cloning and applying HRMS Family Pack RUP 1 for Test and Product instances. And I installed and Configured Oracle Demantra 7.1.1 .Database on Solaris and Analytical Engine, Administrative Utilities,Application Server on Windows.

Responsibilities
• Installation of Oracle Applications 11.5.10.2
• Clonig of Oracle Applications
• Install Oracle 10g RAC and ASM
• Configured Load Balancing and TAF for RAC environment
• Apply RDBMS patches using Opatch
• Monitoring concurrent jobs for Oracle E-Business Suite
• Apply applications patches using adpatch
• Performed Application admin tasks using ADADMIN utility
• Providing Production support
• Administration of Concurrent Managers and Concurrent Processing
• Defined Executables, Concurrent Programs, Request Sets
• Configuration of Forms & Reports for Oracle Application Server
• Tuning the database using the explain Plan, init.ora parameters
• Monitored the Applications and database using OEM and OAM
• Refresh from production to Test and Dev Environment
• Installation of Demantra 7.1.1
• Installed, maintained, tuned Metadata Repositories
• Administered and Troubleshooting of Oracle applications Server issues

Client Name: GE Energy
Client Location: Atlanta, GA
Duration: Mar 2006 to Feb-2007
Role: Oracle Apps DBA Consultant
Environment: SUN 8,Oracle 8i & 9i Oracle Apps 11 Data Servers on Windows, Unix and
Linux

I was responsible for installation, implementation and maintenance of Oracle Applications 11i on Solaris. I used AD Utilities like adadmin and adpatch to maintain Applications. Additionally, I was involved in cloning and applying maintenance packs and database patches for Development, Test and Product instances.

Responsibilities
• Strong Experience Oracle Applications 11i Installation
• Apply applications Patches
• Cloning of Oracle Applications R11i.
• Worked on Oracle Applications AD Utilities
• Application AOL object setup (users, menus, responsibilities
• Create custom concurrent requests
• Registered Printers in Apps
• Monitored the Applications and database using OEM and OAM
• Reset ORACLE schema passwords by using FNDCPASS
• Troubleshoot problems with web server, forms server and concurrent managers
• Installation and Configuration of Oracle Application Server
• Refresh the database from production to test environment
• Database backups and recovery
• Installation & Support to tech team for the Installation, configuration and application of patches for Application Desktop Integrator (ADI) 7.1.3.
• Relinking Oracle applications programs and regeneration of Oracle Forms and Reports
• Raised TAR and follow up with Oracle for SR1 Tars.
• Trained new users on functions, applications and set up.
• Oracle Work Flow administration


Client Name: Veritas/Symantec Software
Client location: Cupertino,CA
Duration: Jun-2004 to Feb-2006
Role : Oracle Applications DBA
Environment: UNIX (Sun Solaris) Oracle 8i/9i/10g, Oracle applications 11.5.9

As a part of 5 members core team, was involved in implementation, installation, cloing, patching and maintaining of concurrent managers . And was involved trouble shooting the problems that are encountered in day-to-day activities. Supported production Instance

Responsibilities
• Maintaining the 24X7 mission critical production databases .
• Cloning of Oracle Apps.
• Monitoring concurrent jobs for Oracle Applications
• Apply database and applications patches
• Performed Application admin tasks using ADADMIN utility
• Administration of Concurrent Managers and Concurrent Processing
• Defined Executables, Concurrent Programs, Request Sets
• Settings Defined Value set and assigning them to Concurrent Program
• Tuning the database using the explain Plan, init.ora parameters
• upgrade to 9i.database
• Monitored the Applications and database using OEM and OAM
• Refresh from production to test environment
• Troubleshooting and handling user requests

Client Name: Aurobindo Pharma Limited
Client Location: Hyderabad ,India
Duration: Apr-2002 to May-2004
Role: Associate Consultant/Oracle DBA
Environment: AIX 5.1 Oracle 8i&9i Oracle Apps 11i Oracle RDBMS 8i,9i,Forms 6i reports 6i

I was responsible for installation, development and implementation& production support of oracle Applications 11.5.8 and RDBMS 8.1.7.4


Responsibilties:

• Installation of Oracle Application 11.5.8.
• Cloning of Application Instance -- Single node to two node Using AD Clone.
• Applied the patches using ADPATCH
• Performed Application admin tasks using ADADMIN utility
• Applied India Localization patches & resolving with Oracle.
• Registered Forms, created Form Functions and Menus
• Registered Executables, created Concurrent Programs and Request Groups
• Created Responsibilities and Application Users
• System Administration of 11i
• Setting up of printers In the Apps
• Maintenance of concurrent processing requests and concurrent managers.
• Created and resized the new Datafiles.
• Pinning of Packages, Procedures and functions in SGA
• Run preparatory scripts -- admin server
• Reset ORACLE schema passwords
• Update configuration-related profiles
• Reapply product customizations to environment and files
• Set rollback segments for normal use.
• Validate and compile APPS schema
• Creation of Schema objects and Space Management
• To take backups as per the corporate policy and perform recovery as and when required.
• Developed Data Loading Scripts
• Designed the database structures for the custom module
• Performed the maintenance of Database and Production Support .


Client Name: VISAKA INDUSTRIES LIMITED
Client Location: HYDERABAD, India
Duration: May 2000 To Mar 2002 DBA / Developer
Role: Oracle Database Administrator
Environment: Windows 2000,Developer/2000(Forms 4.5,Reports 2.5
With Oracle 9i,8i SQL,PL/SQL

Migration of Oracle Database from 8.1.7.4 to 9.2.0.5.


As a part of 2 member's team, was responsible for Installation, configuration of 9i Production Database.
Resposibilities:

• Installed Oracle 9.2.0 Enterprise Edition
• Apply patch set 9.2.0.5
• Backup the database
• Prepare the system for migration
• Execute migration scripts
• Listener and Net 8 configuration
• Execute post- install scripts
• Update,remove.add parameter in init_SID.ora file
• Compile all objects
• Perform post-upgrade tasks
• Database backup and recovery.

Certifications
See above


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

View all resumes in US-NJ »

View other Oracle Apps DBA resumes, Database Administrator resumes