We provide IT Staff Augmentation Services!

Oracle Applications Dba Resume

4.00/5 (Submit Your Rating)

Professional Summary

  • Eight plus years of IT experience, As Oracle Applications DBA involved in life cycleimplementations.
  • Providing support to 120 plus production, development, test instances comprising ofcomplex and challenging environments from versions R12, 11.5.X,9i,10g,11g.
  • Experience includes server migrations, cloning, patching, database upgrade, sync and splitfrom source to target, code movements, shell scripting, backup & Recovery, hot/cold 
    backups, cronjobs and proactive health check of the database.
  • With resource limitation of 2 provided 24 X 7 support to reporting environment.
  • Support activity includes creation of reporting instance, daily releases, on duty tasks.
  • Knowledge in Database administration activities like physical database design, databasecreation and maintenance, user schema, space management, performance tuning activities, besides developing applications using RDBMS, PL/SQL.
  • Achieved certificate of excellence for outstanding contribution from GE Energy services.

Education B.E - Computer Science 

Certifications

Oracle Corporation OCA 9i Certified.

Technical Skills

ERP Environment

Oracle Applications R12, 11.5.10.2,11.5.9,11.5.8,11.5.7,
11.0.3,10.7, 11i Systems Administration, workflow,
Forms 6.0,4.5,Reports 6.0,4.5.

Tools Oracle Enterprise Manager, Discoverer, Mark view, RMAN, RAC
Data Guard,10gGrid, Apex, Remedy, Change management,Winscp, Toad, Net APPS technology.

Database Oracle 10g, 9.2.0.8, 9.2.0.7, 9.2.0.6, 9.2.0.5, 9.2.0.4, 8.1.7.4, SQL Server

Programming UNIX Shell Scripting, SQL, PL/SQL, C, VB6.0, ASP

Operating Systems Sun Solaris 5.9,2.8,2.6,2.2, Redhat Linux 2.1/3.0 AS, HP UX, Windows NT, 2000

Hardware Fuji Primepower 650 12GB 4 2.1GHz Solaris 5.9, IBM x330 1.3 GB 2 1400 GHz Win 2000 Server, Fuji Primepower 250 8GB 2 1.9GHz Solaris 5.9

Application Servers 10gAS, Apache, 9iAS, Java web server

Professional Experience

Project start to end date Jul 2009 to Till Date

Client Confidential

Role Oracle Applications DBA

Team Size 4 DBA’s

Environment Oracle Applications 11.5.10.2 Oracle 9i Windows

Responsibilities:

  • Infrastructure Maintenance and support of New York state department of motor vehicles Financial Management System [ FMS ] 11i.
  • Maintenance of Production, Development and Test Instances of DMV Family.
  • Cloning FMS instances to keep all instances in SYNC.
  • Integrating 10gAs with eBiz suite for SSO and OID.
  • Maintain oracle applications system by applying latest security patches.
  • Provide proper understanding to other DBAs about FMS.
  • Maintain documentation about FMS and other APPS related stuff as part of KT.

Project start to end date Sep 2008 to May 2009

Client Confidential

Role Oracle Applications DBA

Team Size 8 DBA’s

Environment Oracle Applications R12, 11.5.10.2, 11.5.9 Oracle 9i, 10g, Solaris, Linux

Responsibilities:

  • Involved in Upgradation of Oracle applications from 11.5.10.2 to R12.
  • Managed Finance team and HR team along with DBA team.
  • Split out of single user application instance to separate apps, db user instance.
  • Maintenance of Production, Development and Test Instances of LV Family.
  • Analysis and application of Oracle Contracts module, Oracle daily Business Intelligence patches on all support and PRD instances.
  • Handling Cloning of all support instances regularly.
  • Setting up Disaster Recovery for eBiz Suite.
  • DMZ Configuration with Oracle E-Business Suite 11i.
  • Maintain proper backups through snapshots by Net Apps technology
  • Accomplishing all releases as per the schedule with out any delay.
  • Covering on duty for any APPS and core DBA related issues through service desk.
  • Involved in all types of datafixes, Issue tracking, Version controls and Patch management.
  • Handled complex database migrations of Oracle Applications 11.5.10.2 instance.
  • Available in 24/7 Environment for any unscheduled bounce and other maintenance tasks.
  • Clearing locks obtained in production regularly.
  • Managing management servers, concurrent programs and reports.
  • Writing DCX scripts for database daily checks and alerts on errors.
  • Creating Change Requests, MAC, Help desk requests through service help desk.
  • Maintaining up to date WIKI for documentation and deliverables.

Project start to end date March 2007 to July 2008

Client Confidential

Role Oracle Applications DBA

Team Size 3 DBA’s

EnvironmentOracle Applications 11.5.10.2, 11.5.9 Oracle 9i, 10g, Sun Solaris 5.9

Responsibilities:

  • Involved in Upgradation of Oracle applications from 11.5.9 to 11.5.10.
  • Maintenance of Production, Development and Test Instances of E*Trade Family.
  • Analysis and application of Security and module specific patches on all support instances.
  • Handling Cloning of all support instances regularly.
  • Handled complex database migrations of Oracle Applications 11.5.9 instance.
  • Responsible for executing Change Requests and all code migration cases.
  • Handling all types of System Administration activities.
  • Available in 24/7 Environment for any unscheduled bounce and other maintenance tasks.
  • Responsible in resolving ADI and Discoverer related issues
  • Checking External tier and standby status.
  • Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.
  • Clearing locks obtained in production regularly.
  • Managing concurrent processing (Concurrent Programs and Reports)
  • Checking for status of database services, concurrent manager, and disk space utilization alerts.
  • Involved in Ariba, Hyperion, Markview and Extensity support.
  • Quarterly password changes as per SOX audit.
  • Creating Change Requests, MAC, Help desk requests through Remedy.
  • Assisting the project management in documenting the deliverables viz. Engagement Summary, etc.

Project start to end date May 2006 to March 2007

Client Confidential

Role Oracle Apps DBA

Team Size 10 DBA’s

Environment\ Oracle Applications 11.5.9, 11.5.8 Oracle 9i Solaris

Responsibilities:

  • Maintenance of Production, Development and Test Instances of GE Family.
  • Cloning Oracle Applications (11.5.9, 11.5.8) production system, for testing and development purpose.
  • Analysis and application of Patches [Maintenance packs 11i, Security, RDBMS, Developer, IAS and Multi Lang] and adadmin activities.
  • Acquainted with tools like wfload, fndload, f60gen, tkprof and sql loader.
  • Handling all code migrations cases in support instances.
  • Handling all types of oracle System Administration activities.
  • Managing concurrent processing (Concurrent Programs and Reports)
  • Responsible for solving Alert Migration cases.
  • Available in 24/7 Environment for any unscheduled Bounce or for other issues.
  • Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc.
  • Monitoring, Scheduling and Modification of Cron Jobs.
  • Involved in Customization Activities.
  • Implemented shell scripts to reduce the time for large code movements during cut over tasks.
  • Use of Import and Export Utility for Logical Backup of Database.

Project start to end date\ Oct 2005 to May 2006

Client Confidential

Role Oracle Apps DBA

Team Size 6 DBA’s

Environment Oracle Applications 11.5.9, 11.0.3, 10.7 Oracle 9i, 8i Solaris 2.8

Responsibilities:

  • Maintenance of two Production, 8 Development and Test Instances.
  • Monitor hot backup and cold backup log and resolving backup issues.
  • Managing concurrent processing (Concurrent Programs and Reports)
  • Checking for status of database services, concurrent manager, and disk space utilization alert.
  • Monitoring of all Instances daily monitoring report and Resolving Space Issues.
  • Quarterly password changes as per SOX audit.
  • Maintaining databases in 24x7 Production environments on Multiple Applications Tiers.
  • Monitoring, Scheduling and Modification of Cron Jobs.
  • Analysis and application of different types of patches.
  • Involved in forms customization, Concurrent Program creation activities.
  • As the availability of reporting instance is critical to business Implemented pro-active scripts across the reporting servers to reduce the failure of replication.
  • Knowledge of quest STAT for Issue tracking and workflow, Patch Management, Auditing and reporting.
  • Troubleshot Applications and Database Issues.
  • Worked as a part of Software Quality Assurance team in implementing "Shared pool" for standardizing alert monitoring across the project.
  • Involved in Database Refresh Activity.
  • Assisting the project management in documenting the deliverables viz. Engagement Summary, etc.

Project start to end date Oct 2005 to May 2006

Client Confidential

Role Oracle Apps DBA

Team Size 2 DBA’s

Environment Oracle Applications 11.5.8, 11.0.3 Oracle 9i Solaris

Responsibilities:

  • Involved in resolving SYSADMIN related issues.
  • Password Reset and unlock account through CISE.
  • Code Migration in Source Control System.
  • Responsible to Update Leavers/Transfer records through Access Control Application.
  • Solving GIEA Form requests send by users which involves new user creation, Assigning Special responsibilities.
  • Responsible for Alert Migration.
  • Adding/Removing users from the Alert mailing List.
  • Migration through Chain Link.
  • Involved in ASL*Form Migration.
  • Document standards and operating procedures.
  • Mentored the in-house DBA to assume higher levels of responsibility.
  • Resolving different types of tickets which include Problem Remedy, Change Remedy, Giea Forms, Leavers Process, and Monthly Upload.

Project start to end date July 2005 to Oct 2005

Client Confidential

Role Oracle Apps DBA

Team Size 2 DBA’s

Environment Oracle Applications 11.5.9 Oracle 9i Redhat Linux AS 3.0

Responsibilities:

  • Installation of oracle applications 11.5.9 on LINUX AS 3.0 with both pre-installation and post installation tasks.
  • Resolving application/database hanging issues
  • Monitoring users/concurrent jobs, scheduling background jobs
  • Managing users as creating and assigning responsibilities to Apps Users.
  • Involved in Customization Activities.
  • Managing concurrent processing (Concurrent Programs and Reports)
  • Involved in Enabling Multi-Org Setup.
  • Application / Database capacity planning
  • Applying different types of patches
  • Assisting the project management in documenting the deliverables viz. Engagement Summary, etc.

Project start to end date Nov 2004 to July 2005

Client Confidential

Role Oracle Apps DBA

Team Size 18 DBA’s

Environment Oracle Applications 11.5.9 Oracle 9i HPUX

Responsibilities:

  • Installation Apps 11.5.9 on HPUX 11i with both pre-installation and post installation tasks.
  • Monitoring users/concurrent jobs, scheduling background jobs
  • Managing users as creating and assigning responsibilities to Apps Users.
  • Creation of Custom Responsibilities, Managing Application Security
  • Managing concurrent processing (Concurrent Programs and Reports)
  • Gathering schema statistics, Rebuilding indexes for performance
  • Application / Database capacity planning
  • Applying different types of patches
  • Troubleshooting on cloning, Application problems, Resolving installation, Resolving application/database hanging issues
  • Managing and Troubleshooting Workflow activities
  • Managing Printer, Profile Options
  • Assisting the project management in documenting the deliverables viz. Engagement Summary, etc.

Project start to end date Nov 2004 to July 2005

Client Confidential

Role Oracle DBA

Team Size 6 DBA’s

Environment Oracle 8i Unix

Responsibilities:

  • Installation and Configuration of Oracle, creation of Database
  • Configuring the Oracle Net
  • Creation & maintenance of user accounts and granting privileges to users
  • Monitoring log files, high activity tables, monitoring the growth of the table spaces
  • Analyzing tables and indexes to improve system performance.
  • Managing DB growth rate and extent utilization of Oracle objects.
  • Maintaining system security and Auditing
  • Implementation of disk quotas to various users
  • Logical Backups Export and Import
  • Planned and implemented Backup and Recovery Strategies for 24X7 databases
  • Monitoring the storage management
  • Database Performance monitoring and tuning
  • Database.cloning on requests for refresh.

Project start to end date March 2004 to Oct 2004

Client Confidential

Role Oracle Apps DBA

Team Size 8 DBA’s

Environment Oracle Applications11.0.3 Oracle 9i HPUX

Responsibilities:

  • Managing users as creating and assigning responsibilities to Apps Users.
  • Creation of Custom Responsibilities, Managing Application Security
  • Managing concurrent processing (Concurrent Programs and Reports)
  • Purging of data, gathering schema statistics, Rebuilding indexes for performance
  • Application / Database capacity planning
  • Applying different types of patches
  • Performing Apps – DBA Tools and Utilities such as Adadmin, adpatch, adctrl, adaimgr, adclone, etc.
  • Refreshing DEV and UAT instances from SAND
  • Troubleshooting on cloning, Application problems, Resolving installation, Resolving application/database hanging issues
  • Managing and Troubleshooting Workflow activities
  • Managing Printer, Profile Option.
  • Assisting the project management in documenting the deliverables viz. Engagement Summary, etc.

Project start to end date March 2003 to March 2004

Client Confidential

Role Oracle Apps DBA

Team Size 3 DBA’s

Environment Oracle Applications11.5.8 Oracle 9i Redhat Linux

Responsibilities:

  • Supporting several installations of the clients
  • Troubleshooting and resolving issues
  • Liaison with Oracle-Support for bug fixes and patch applications (iTARs)
  • Supported post-production activities including backups and patch resolutions
  • Application / Database capacity planning
  • Applying different types of patches
  • Performing tuning of DB and Apps
  • Refreshing DEV and UAT instances from SAND
  • Troubleshooting on cloning, Application problems, Resolving installation, Resolving application/database hanging issues
  • Managing and Troubleshooting Workflow activities
  • Managing Printer, Profile Option.

Project start to end date Dec 2002 to March 2003

Client Confidential

Role Jr. Oracle Apps DBA

Team Size 3 DBA’s

Environment Oracle Applications11.5.8 Oracle 9i\ Redhat Linux

Responsibilities:

  • Partially involved in Installations, cloning, patching, Back-ups, trouble shooting, etc.
  • Managing and Monitoring Concurrent Jobs and Application Users
  • Patch Applications for resolving performance and bug issues
  • Assisting the development team in registering custom forms and reports
  • Supporting the onsite implementation team during their off-hours on TEST instance.
  • Troubleshooting the Applications issues and performance problems
  • Liaison with Oracle-Support for bug fixes and patch applications (iTARs)
  • Supported post-production activities including backups and patch resolutions.

Project start to end date Apr 2002 to Nov 2002

Client Confidential

Role Systems Analyst

Team Size 10 Analysts

Responsibilities:

  • Building computers with different configurations.
  • Involved in Installation of all types of licenced softwares.
  • Involved in solving all types of Hardware related issues.
  • Handling all stock related matters.
  • Involved in preparing sales orders & invoicing.
  • Involved in documentation.

Project start to end date April 2001 to March 2002

Client Confidential

Role Developer

Team Size 3

Environment Visual Basic 6.0 Oracle 7.3 Win 2000

Responsibilities:

  • Designing, Developing forms and reports.
  • Involved in writing code for forms and queries for backend.
  • Testing all forms and reports according to the requirement.
  • Customizing reports and forms according to new requirements.
  • Preparing presentations and documenting them for reference.

We'd love your feedback!