We provide IT Staff Augmentation Services!

Sr.oracle Apps Dba Resume

Philadelphia, Pa

SUMMARY:

  • Having 11 years of Solid Experience in Oracle 11i, R12 Applications (R12.1.3 upgrade to R12.2.5, R12,Oracle EBS 12.2.5 ) and Oracle Applications Server (9i/10g) in UNIX Sun Solaris, Red Hat Linux, AIX and Windows environment.
  • Experienced as Oracle Applications 11i/R12 DBA & Oracle DBA, providing 24x7 support of both Production & Development on Various Platforms.
  • Experienced in Oracle Apps Administration and Sysadmin tasks
  • Installation, Configuration & Deployment of Oracle E - Business Suite 11i/R12.
  • Implemented Oracle Apps 11.5.10.2 with Oracle RAC.
  • Implementation of High Availability solutions with Oracle 11g/10g RAC, Physical and Logical Standby Databases (Data Guard).
  • Trouble shooting Forms server, Reports server, Apache server, Jserv, Jinitiator and Workflow.
  • Expert in 11i Apps Cloning, Implemented new techniques for Apps Refreshes.
  • Applied Patching, Upgrades, framework, SSL For 11i Apps.
  • Application and Concurrent Manager load-balancing and Failover, Shared APPL TOP configuration.
  • Excellent experience in Installation of Oracle 8i, 9i, 10g in UNIX/LINUX and Windows environment.
  • Proficient in Database and Applications Administration activities such as Upgrades, Patches, TAR support, Backup and Recovery, Performance tuning, script development.
  • Effective troubleshooting of Database and Performance problems.
  • Worked with development teams and data administration staff to enhance Database and application performance.
  • Extensive performance tuning of Concurrent programs, Concurrent Mangers and SSWA
  • Very strong in Auto Patch, Upgrade, cloning.
  • Expertise in using ADPATCH, ADADMIN, ADCTRL, ADRELINK, ADIDENT, ADMERGE, ADCONFIG, ADMRGPCH, ADLICMGR & PTS tools.
  • Experience on Multi Org
  • Production DBA Experience on Oracle releases 11g/10g/9i/8i
  • Excellent knowledge in installation and maintenance of Oracle Application Server
  • Expertise in configuring various oracle application modules like Discoverer, Workflow
  • Management of schemas, objects & Partitioning the tables & indexes.
  • Experience in a variety of different environments like HP-UX, SUN SOLARIS, Linux and Windows.
  • Experience in managing very large databases (Multiple TB of size).
  • Experience in administration of large Oracle database running in SAN environment, setting up databases for bank environment.
  • Write Korn shell scripts to monitor and maintain the Oracle Applications database.
  • Performed backups and tested crash recoveries using conventional Hot & Cold backups and RMAN.
  • Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM
  • Expertise in installing, maintaining and administering Oracle Applications 11i (11.5.8, 11.5.9, 11.5.10, R12) instances.
  • Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite.
  • Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude.
  • A very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS:

Operating Systems:: HP-UX, Sun Solaris, Windows, Red Hat Linux, Oracle Enterprise Linux.

RDBMS: Oracle8i, Oracle 9i, Oracle 10g RAC, Oracle 11g RAC.

ERP:: Oracle E-Business Suite 11.5.7, 11.5.8, 11.5.9, 11.5.10.2, R12.

Languages:: Sql, C, UNIX Shell Scripting.

Tools: RMAN, OEM, OAM, SQL*PLUS, SQL*Loader, External Tables, TOAD.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia PA.

Sr.Oracle Apps DBA

Responsibilities:

  • Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, firefighting, developer/integrator relations, script development, and documentation.
  • Design and Implementing Business Continuity Plan for Oracle ERP Application with Active Data Guard.
  • Performed R12.1.0 to R12.2.5 upgrade on RHL 7.3.29 and Solaris version 10
  • Oracle Database 11g upgrade to 12c
  • Performed 11.5.8 to 11.5.9 upgrade with migration from Windows NT to Sun Solaris 9.
  • Applied patches for R12.1.0 and R12.2.4 on • Oracle 11i experience includes, 11.5.8 install and upgrade to
  • 11.5.10 with the Forms, Web Server, Reports and Concurrent Mangers on Sun Solaris node.
  • Performed numerous application and database tuning assignments on Oracle Applications, legacy, custom and third party systems.
  • Monitoring the Application System with OAM.
  • Involved in Web Logic 10.3, Oracle SOA suite and configuration in development to production environments
  • Experience in weblogic troubleshooting, creating managed server and deployment process
  • Installed and configured an Oracle Applications Release 11i (11.5.10) environment with Oracle database 9i Release 1 (9.2.0.5).
  • Installing and maintenance of Oracle Applications 11i on Windows NT, Windows 2000 and Sun Solaris
  • Cloning of application and the database by using autoconfig and creating multiple instances in Order to support the Application developers to test various scenarios.
  • Coordinating with Oracle Technical assistance Team to resolve any issue relating to ERP
  • Using AD utilities to maintain applications by compiling Apps Schema, Maintain Application Object menu, maintaining snapshots of the application using adamin and adpatch utilities for application of patches.
  • Web Related Oracle webdb, Oracle web application server, SOA
  • Frequent Monitoring of alert log, system log, for information or errors and resolve the same based on the logs
  • Monitoring database for fragmentation and de-fragmenting of tables. Reorganization of the tables, table space Refreshing development database from production for testing
  • Online / Offline backup of database using the archive logs and the sun operating system backup using Confidential command.
  • Planning the Disaster recovery in the event of database crash to recover without any loss of any data.
  • Analyze, drop and recreate indexes to improve performance both with enterprise Manager and manually through command Prompt.

Environment: Oracle Applications EBS 11i/R12, Oracle 10g RAC, TOAD, RedHat Linux 4/5, SUN Solaris 10, 10g (10.2.0), AIX

Confidential, Irving TX.

Sr.Oracle Apps DBA

Responsibilities:

  • 24x7 Production Oracle Applications Administration.
  • Maintaining production, development & test databases and applications.
  • Good knowledge on Oracle applications 11i Rapid Installation.
  • Upgraded Oracle Applications 11i (11.5.10) Database Version 8.1.7.4 to 10g (10.2.0.4) on Solaris.
  • Involved in creating, editing, scheduling and deleting of sessions and batch of session using Workflow manager in Informatica.
  • Designed and implemented OLS label cache to enable use of Hibernate with OLS and to improve performance by eliminating repeated use of Oracle conversion functions.
  • Resolved session locking issues using Informatica repository manager.
  • Upgraded Oracle Applications 11.5.10 to 11.5.10.2, 11.5.10.2 to 12.0.4 and 12.0.4 to 12.1.3 and database 9.2.0.8 to 10g
  • Installation and configuration of 9iAS/10gAS and performance tuning of Oracle Database which is on RAC.
  • Successfully upgraded Oracle Applications 11.5.10.2 to R12 (12.0.4) in multinode configuration
  • Applied patches using ADPATCH, ADCTRL utilities.
  • Performed installation and configuration of oracle SOA suite 10g/11g for the integration of Application and Database.
  • Administration of Oracle ERP applications version 11.5.10.2
  • Good knowledge in Data Modeling tools like Ervin.
  • Implemented AUTOCONFIG in the apps environment and used ADCONFIG, ADBLDXML commands.
  • Implementation, customization and personalization of Oracle iProcurement.
  • Experience on various modules such as Financials, ASCP, MFG, CRM, AR, AP, GL, and PO.
  • Involved in developing a disaster recovery (DR) plan.
  • Implemented and support of both physical, logical standby databases and Oracle Data Guard.
  • Perform SQL tuning and assist developers with coding PL/SQL.
  • Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, and Family pack).

Environment: Red Hat Linux 4/5, SUN Solaris 9, HP-UX 11i v1 (B.11.11), Windows XP, Oracle 8i (8.1.7), 9i (9.2.0) & 10g (10.2.0), Oracle Applications EBS 11i/R12, Oracle 9i & 10g RAC, TOAD, Developer 6i.

Confidential, Bothell WA

Sr. Oracle Apps DBA.

Responsibilities:

  • Established and performed refresh/cloning Oracle Application Test and Development environments from Production environment.
  • Setup system and user profiles for Oracle Applications, administer concurrent managers and reports.
  • Developed suite of utilities for maintenance of multiple Oracle Applications environments: environment configuration, initialize environment, automated databases, Webserver, Form servers and concurrent managers startup/shutdown process.
  • Installed and configured Oracle Recovery Manager (RMAN), Oracle Management Server, Data Gatherer, Oracle Enterprise Manager with Diagnostic Pack and Tuning Pack.
  • Performed databases performance tuning and monitoring using shell scripts, Oracle Enterprise Manager Tuning Pack, and Diagnostic Pack.
  • Created and tested shell scripts for automated cold and hot backup. Installed and configured Veritas NetBackup with Oracle RMAN for all backups.
  • Recovered/restored multiple databases from physical disk failure. These failures include lost of datafiles/system tablespace/control files/on-line redo logs.
  • Administered Discoverer Business Area, End-User-Layer (EUL) and designed business critical reports using Oracle Discoverer and Oracle Reports
  • Created and managed the project plan for upgrading EBS to 11.5.10.2/10 gR2-multi-node RAC/ASM/SSL and integration with OAS 10g/Portals and compatibility/upgrade of several third-party products into a single integrated solution for global operations.
  • Created and managed strategies for multi-vendor product mix and hardware/software cost matrix: procurement procedure, multi-instance development, and implementation process. Implemented oracle best practice standards and methodologies.
  • Implement Oracle Advance Collections implementations project and provided all infrastructure support for Oracle Apps 11i.
  • Perform performance tuning for database and upgrade Oracle Applications from 11.5.9 to 11.5.10.2. Responsible for customizations in 11.5.9 and the test plan for regression testing by respective functional users. Executed post-upgrade product-specific task and included business users for regression testing. Completed capacity planning and working on upgrade issues.

Environment: Oracle Applications EBS 11i/R12, Oracle 10g RAC, TOAD, RedHat Linux 4/5, SUN Solaris 10, 10g (10.2.0), AIX

Confidential

Sr.Oracle Apps DBA

Responsibilities:

  • Involved in Installation of Oracle E-Business Suite R12 and Upgradation from 11.5.10.2 to R12 on Linux Platform Code migrations
  • Cloning the Oracle Apps instances from prod to test by using Rapid Clone process
  • Resolving issues related to Concurrent manager and login problems.
  • Performing Patch analysis, downloading patches and applying patches by using Auto Patch (adpatch).
  • Monitoring the Application System with OAM.
  • Reducing the patch time using features like defaults file, merge patch.
  • Applied the patches like one-off patches, mini patches, family patches, CPU patches.
  • Converted forms socket to servlet forms mode.
  • Adding new off cycle Products by using adsplice utility.
  • Generated AWR reports and used TKPROF utility.
  • Proactively monitoring the Application health checks and taking preventive action as required.
  • Applied RDBMS patches by using Opatch.
  • Installation of Oracle Weblogic 10.3.5 and deploying application
  • Debugging the Apache issues by using Apache configuration & log files.
  • Monitoring and resolving Database & Apps listener and tns issues.
  • Tracing the User session, Concurrent program and Form session as per requirement or request mail.
  • Troubleshooting all level issues, by working with oracle all levels.
  • Cluster and Data guard issues.
  • Have configured Data guard.
  • Troubleshooting and Performance tuning of oracle Application / DB.

Environment: LINUX 2.6.9-67.ELsmp, Regular (non-ERP) Database Oracle 9i&10g, Weblogic10.3.5, Oracle Applications 11i (11.5.9 & 11.5.10), Oracle 9i RAC, Release 12.0.4

Company: Mahindra Satyam - Hyderabad, India

Client: Liberty Mutual, UK.

Duration: July 2010 to Sep 2011

Sr.Oracle Apps DBA.

Responsibilities:

  • Involved in Installation of Oracle E-Business Suite R12 and Upgradation from 11.5.10.2 to R12 on Linux Platform
  • Cloned the Application instance from production to Test and Development using Rapid Clone and Manual Process.
  • Relining the executables, generating forms, jar files, validating apps schema and compiling the invalids etc by using adadmin
  • Worked with various Oracle Applications Utilities like AD Administration, AD Controller, Auto config, AD Merge Patch, AD Relink, AD Splice, AutoPatch, f60gen, CONCSUB etc.
  • Done patch analysis, applied patches and checked the patch impact.
  • Applied the patches like one - off, mini, family patches.
  • Converted forms SOCKET to SERVLET forms mode.
  • Used AD Controller to see the status of workers and restarted failed worker after resolving the problem.
  • Assigned the specific Concurrent requests to concurrent managers and resolving issues.
  • Debugging the Apache issues by using Apache configuration & log files.
  • Resolving issues related to Concurrent manager and login problems.
  • Reducing the patch time using features like defaults file, merge patch and using Adpatch options.
  • Trouble shooted several worker issues while patching.
  • Applied RDBMS patches by using OPatch.
  • Changing the apps password and application user password by using FNDCPASS.
  • Oracle Applications Troubleshooting on Apache (http Server) and Concurrent Manager.
  • Responsible for creating Application and managing user accounts and assigning responsibilities.
  • Monitoring the alert logs & Trace files.
  • Taking the backup of the databases using RMAN, Logical, cold and Hot Backup procedures.
  • Monitoring and resolving Database & Apps listener and tns issues.
  • Tracing the User session, Concurrent program and Form session as per requirement or request mail.
  • Performing routine checks of space utilization and Extended Table spaces by resizing/adding data files when needed.

Environment: Unix/Linux, SUN Solaris 8, Oracle database 9i (9.2.0), Oracle Applications 11i (11.5.2, 11.5.5, 11.5.7), HRMS, TOAD, SQL Loader, AD Utilities

Confidential

Sr.Oracle Apps DBA.

Responsibilities:

  • Responsible for the support and maintenance of the applications & databases
  • Participate in a team to maintain & support for multiple oracle databases and applications in high availability (24 X 7) heterogeneous environment.
  • Install and maintain Oracle Applications in complex environments such as Single-node and multi-node installations.
  • Cloning the instances from production to Test, Development instance to test & simulate few technical challenges, coordinate with testing and development teams.
  • Work closely with teams including Applications development, database development, Oracle Support, and business community.
  • Applying latest releases of the RDBMS patches from Oracle to the Production and test instance to resolve few technical challenges & issues.
  • Concurrent Manager Creation, monitoring, tuning and troubleshooting.
  • Applied and documented patches that included mini-packs, family packs and standalone patches.
  • Applied the Application patches like one-off, mini, maintenance and family pack.
  • Assigned specific concurrent requests to concurrent managers.
  • Performing FNDLOAD/WFLOAD and FNDCPASS.
  • Monitoring Tablespace for space usage and adding required space whenever it reaches threshold value.
  • Worked with various Oracle Application Utilities like AD Administration, AD Controller, Autoconfg, AD Merge Patch, AD Relink, and AD Splice.
  • Changing Apps Password and Application User Password by using FNDCPASS Utility.
  • Performing operations like Creation of Users, Session Management, and Granting Privileges to users from Applications.
  • Performed routine checks of space utilization and adding space to database when its needed.
  • Extended Table spaces by resizing/adding data files when needed.
  • Created new user accounts, profiles, and roles and assigned them to different users and enabled auditing to monitor the system privileges and roles granted.
  • Carrying out migrations of code to UAT and production environments.
  • Performed manual online backups & offline backups.
  • Worked with DBA tools like SQL Loader, Import/Export and dataguard.
  • Maintaining Archive logs and their spaces for routine administration alert and trace monitoring.
  • Interact with Oracle Support for technical assistance requests.
  • Environment: Linux 2.4, Oracle database 9i, Oracle applications 11i, AD Utilities, OEM, PLSQL, SQL Loader

Confidential

Oracle DBA

Responsibilities:

  • Maintain Oracle server in complex environments such as Linux Servers.
  • Monitoring table spaces size and resizing datafiles.
  • Checking whether all the Database and applications are up and running or not.
  • Performed user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security.
  • Monitoring the table space periodically for growth.
  • Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Export and Import utilities.
  • Provided all kinds of DBA support to development teams as well as production support to various applications.
  • Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
  • Transferring the bulk data from text file into Oracle Database using SQL * Loader and export & Import utility for backup purpose and distributing the tables in multiple environments.
  • An active member in the team of migrations.
  • Giving Instance support to Development team for any Database Object modifications and Optimization
  • Configuration of TCP/IP protocol, listeners, SQLNET and tnsnames.
  • Maintaining Archive logs and their spaces.

Environment: Oracle 8i/9i OEM, Linux, HP-UX, TOAD, RMAN, Database Tools/Utilities, STATSPACK, TKPROF, UTL SMTP, SQL*LOADER

Hire Now