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 cycle
  • implementations.

  • Providing support to 120 plus production, development, test instances comprising of
  • complex and challenging environments from versions R12, 11.5.X,9i,10g,11g.

  • Experience includes server migrations, cloning, patching, database upgrade, sync and split
  • from 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, database
  • creation 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

    Environment:

    Oracle 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.
  • We'd love your feedback!