We provide IT Staff Augmentation Services!

Oracle Apps Dba Resume

TX

PROFESSIONAL SUMMARY

  • Over 7+ years of extensive experience as an Oracle DBA and Applications DBA.
  • 4+ years of experience with Standby Database, Data Guard, Replication.
  • Experience in working with different environments/versions and server administration including LINUX, Windows, SOLARIS, AIX and HP-UX.
  • Proficient in the installation, configuration and maintenance of Oracle 10g RAC, 9iAS/10gAS, E-business 11i, R12
  • Experience in implementation of high availability solutions with Oracle 10g RAC, ASM, FLASHBACK and Standby (DATAGUARD).
  • Major responsibilities as an Oracle Apps DBA include Patching, Maintenance, Performance Tuning, Refreshing/Cloning and Backup/Recovery of Oracle EBS Database and Application Tiers.
  • Experience as Oracle Applications DBA providing support to manyProduction, Development, Test, CRP instances (Large and VLDB databases) comprising of environments from versions 11.5.2 through R12 with modules being GL, Financials, AP, AR, BOM, HR/Payroll, OM, INV, OE/ONT, OID, OWB, PA, PO, FA, MRP, MFG.
  • Experience in Implementation and Customizations, Custom Application, Code Migrations.
  • Adept in Cloning & Patching 11i, R12 Instance using Rapid and manual cloning.
  • Proficient in installation and upgradingOracle Applications11i e-business suite to R12.
  • Expertise in administering Oracle 11i Instances using AD utilities such as adadmin, adctrl,adsplice, admerge, adpatch etc.
  • Applied patches to update and implement security fixes to Oracle E-Business Suite11.5.5, 11.5.9, 11.5.10.2.
  • Conducted multiple upgrades of Oracle Apps 11i, which includes database upgrade from 9i to 10g as well as application tier upgrade from 11i to R12, Upgraded Oracle 11i Applications Database 9i (9.2.0.6) to 10.2.0.3 on Linux, Performed Oracle EBS 11i migration from HP-UX to LINUX.
  • Expertise in supporting and maintaining Oracle Application Object Library (AOL/FND), Oracle Workflow (WF), Alert (ALR) and System Administration & Hyperion Financial Management (HFM).
  • Experience in installs of ASCP supply chain environment with Demantra 7.2 and E-Business environments.
  • Adept in installation of Release R12 12.0.4 & 12.1 with ASCP, WIP, BOM, INV and Demantra Integrations.
  • Experience on Oracle forms and reports 6i & 9i.
  • Experience on oracle products like Financial Accounting Hub for accounts validation, Financial Data Quality Management with Oracle Essbase and DRM/MDM.
  • Proficiency in working with packagessuch as Oracle Enterprise Manager, TOAD, SQL Navigator, RMAN, Apache, HTML, RMAN, Schema Manager. Working in environments constituting iAS, Oracle Self Service Web Applications, XML, Discoverer (3.x, 4i).
  • Expertise in converting single instance database to Real Application Cluster (RAC) / Automatic Storage Management (ASM).
  • Implementation, troubleshooting forms server, report server, Discoverer server, Web Server.
  • Installed and Configured 10gRAC with PCP for E-Business 11.5.10.2 and 12.1.1
  • Experience with setup and administration of Oracle10g RAC Database using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.
  • Adept at installing, configuring and maintaining Oracle Grid Control (10g grid).
  • Extensive experience in working with the utilities like OEM, TOAD, Export/ Import, SQL* Loader, SQL Analyze and Oracle Supplied DBMS_PACKAGE.
  • Proficient in analyzing and optimizing queries, performance tuning and providing reports using STATSPACK, TKPROF and Explain Plan.
  • Expertise in configuring backup software like VERITAS Netback up, Legato Networker for oracle using RMAN tool for backup and recovery.
  • Installed and Integrated Oracle Internet Directory with 9i database with Single Sign On.
  • Extensive experience in working with Oracle Developer Suite 10g, Developer 6i, Discoverer 4i, Workflow 2.6 and Application Express 2.2/3.0.

SKILLS

Applications: Oracle EBS 11i/R12, Oracle Application Server 10g As and 9iAS

Databases: Oracle 8i,9i and 10g RAC, 11g R1, 11g R2

Platforms: Windows NT/2000/2003/XP, RHEL, Sun Solaris, AIX, HP-UX

Languages: C, C++, Java, J2EE, SQL, PLSQL, Perl, Shell Scripting, Pro*C

Performance Tools: TKPROF, STATSPACK, Explain Plan, ORADEBUG,

Others: AD Utilities, SQL * Loader, TOAD, XML/BI Publisher, Workflow Builder, SQL Developer

EXPERIENCE

Confidential, TX
Sr. Oracle Apps DBA July 2010 - till date

My major responsibilities as an Oracle Apps DBA included the following - upgrading and smooth functioning of Oracle 11i, R12, upgrading Oracle 11i version 11.5.10.2 to R12 with database upgrade from 10g R2 to 11g R1.

Responsibilities:

  • 24x7Production Oracle Applications Maintenance, Support and Administration.
  • Upgraded Oracle Applications from 11.5.10.2 to Release 12.0.4 on Solaris 10.
  • Upgraded database from Oracle 10g to Oracle 11g RAC.
  • Installed and Configured Discoverer 11.1.1.2 and Oracle OID 11.1.1.2 with E-business R12
  • Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
  • Test & Development support including cloning, project support, patching and bug-fixing.
  • Applied mini-packs, CPU patches, family packs using ADPATCH, ADCTRL utilities.
  • Created test environment through cloning production environment for developers to test on live data using rapidclone and adconfig utilities.
  • Administration of Oracle ERP applications 12.1.1 and 12.0.4
  • Automated database cloning using rapidclone to create the daily refresh environment through scripting.
  • 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, MFG, CRM,AR, AP, GL, PO, INV, FA and OM.
  • Monitored performance and availability of Oracle Applications through Grid Control & OAM
  • Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK
  • Configuration of Workflow Notification Mailer, OAM, 10g Grid Control
  • Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack).
  • Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle10G database
  • Converted the database into Automatic Storage Management (ASM) enabled database.
  • Created a Real Application Clusters (RAC) environment for E-Business Suite.
  • Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
  • Created new application messages and then generated message file for application.
  • Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
  • Worked closely with users group to ensure timely implementation of an ERP.
  • Implemented STAGED APPL_TOP to reduce patching downtime.
  • Implementation, Troubleshooting forms server, report server, Discoverer server, Web Server and Maintenance of Concurrent managers and Parallel concurrent Process(PCP).
  • Installed OracleDemantraserver Windows 2003,OracleDatabase and Application server Red hat 4.0.
  • Oracle 10g DatabaseImplementation/Upgrade/Support.
  • Oracle 10g Application Server Implementation/Upgrade/Support.
  • Oracle OID Implementation and Support
  • Generated several reports using Oracle iExpense (OIE) module in two projects. Advised and made recommendations to improve the overall database design.
  • Involved in developing a disaster recovery (DR) plan for Oracle Applications R12.
  • InstalledOracleApplication Server 10AS 10.2.0.2,OracleDemantra 7.2 and configured. Setup war file for configuration betweenDemantraserver and Application server.
  • Perform SQL tuning and assist developers with coding PL/SQL and code review of customizations.
  • Supported installation and configuration of Oracle WebDB, Oracle OAS and Oracle 9iAS.
  • Installed and configured Single-Sign On with OID and Implemented SSL Security.
  • Utilized Veritas DBAC software to manage raw partitions and clustering on the HP-UX systems.
  • Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users.
  • Applied NLS patches for Canadian French and Japanese Languages.
  • Providing assistance with DBA related activities on Demantra 7.3 project, including but not limited to installation of Demantra 7.3, and applying patches.
  • Applied several Localization patches for country specific functionality.
  • Planning and Administration of backup and recovery strategies.
  • Upgrades of J-initiator, Forms, and OJSP as part of the Applications Upgrade.
  • Migrate existing RAC databases from Veritas cluster server 5.2 to ASM.

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

Confidential, NJ May 2008 - June 2010
Oracle Apps DBA

As an Oracle Apps DBA, key responsibilities included installation, implementations, upgrades and smooth functioning of Oracle ERP applications on UNIX system and Oracle databases.

Responsibilities:

  • 24x7 Production Oracle Applications Administration & Developement & Test Environment Support.
  • Created copies of production environment include PTCH, TEST, DEV, UAT, CRP, PROJ, SUPP using RAPIDCLONE.
  • Installed and configured JRE 1.6.0_10 sun native plug-in with E-business Release 11.5.10.2
  • Installed Release 12.0.4 using rapidinstall staged software method.
  • Installed and Integrated Discoverer 10.1.2.2 with E-Business Suite.
  • Development Support including cloning, patching, SQL tuning of customizations, project support.
  • Performance tuning of Oracle Database, applications and queries.
  • Installed, upgraded and maintained Oracle ERP applications version 11.5.10.2
  • Installed and Configured Oracle Single Sign-On and Oracle Internet Directory 10g 10.1.4.3 E-Business R12.
  • Oracle DataGuard Implementation for HA and remote DR site.
  • Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
  • Upgraded application from 11.5.9 to 11.5.10.2 using maintenance pack.
  • Oracle DataGuard Implementation for HA and remote DR site.
  • Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
  • Performance tuning of Oracle Database, applications and queries.
  • Generated impact analysis and added patches.
  • Administration of Oracle ERP applicationsversion 11.5.10.2.
  • Performed database and application cloning of Production database to TEST environment to provide users the live data for testing purpose
  • Involved in a project implementation of Installation and Configuration of SOA suite Version 10.1.3.3 including Application Server withOC4J, ESB, BPEL, OWSM (Oracle Web services manager) & UDDI Registry.
  • Registered customized applications, created and assigned responsibilities to users, customized menus, attached menus to responsibilities and finally this to users.
  • Applied patches using merged patches and non-interactive patches methods.
  • Setup system profiles in Apps.
  • Configured VERITAS Cluster server 5.2.
  • Applied HRMS patches, quarterly tax updates for HRMS & Financials Data through quantum and vertex updates.
  • Setup a test 9i RAC Cluster using Linux and produced detailed analysis of system performance.
  • Installed Oracle Applications server 10g and integrated this with Oracle OID.
  • Implementation of Oracle Applications Server for use with Portal, Custom Forms and Reports and Discoverer 6i.
  • Troubleshoot Concurrent service, Concurrent manager issues and Implementing Parallel ConcurrentProcessing (PCP) in both normal and RAC environment.
  • Worked with Orchestration Team to simplify the integration Architecture and Transition to ESB.
  • Implemented Oracle 9i RAC on Windows.
  • Installed, Configured and Integrated OID with Single Sign On against 9i Database and VERITAS Cluster.
  • Registered printer in Applications, custom printer drivers and custom print styles in Oracle Applications
  • Created Pasta drivers for Multi-Language printer support in E-Business Applications.
  • Enabled Auditing feature. Worked on Workflow, Oracle Application manager (OAM).
  • Created new application messages and then generated message file for application.
  • Used TOAD, ADDM, AWR, ORADEBUGTKPROF, EXPLAIN PLAN and STATSPACK.
  • Monitoring of database for growth and performance.
  • Created new concurrent managers, Purged concurrent requests table.

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

Merrill Lynch, NJ June 2007 - April 2008 Oracle Apps DBA
As an Oracle Apps DBA I was responsible for installation, upgrades, maintenance, security and implementation of Oracle ERP applications and Oracle databases.

Responsibilities:

  • Responsible for managing production, development & test databases and applications.
  • Maintaining the Oracle Applications Systems including Oracle databases, Middle tier iAS Applications.
  • Involved in Upgrading of Oracle Version 9.2.0.4 & Oracle Applications 11.5.5, 11.5.2 and supporting the production team.
  • Cloning using Rapid clone, Autoconfig and adclone utility.
  • Involved in database migrations cloning Oracle Applications (11.5.5, 11.5.2) production system, for testing and development purpose using rapid clone.
  • In depth experience with oracle application utilities such as RapidInstaller, Rapid Clone, adpatch, adadmin, adsplice andadctrl.
  • Pre-patch or Impact analysis for the patches and document preparation with pre and post patch installation steps.
  • Experience in web development using HTML, JavaScript, and XML.
  • Extensive experience in system architecture of 11i Applications implementation of various Financials modules like GL, AP, AR, FA, etc.
  • Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers and monitoring of the concurrent managers.
  • Using AD Administration and other AD Utilities. Experience with Oracle Applications Desktop Integrator (ADI).
  • Tuning the databases for optimal performance.
  • Partitioning tables by determining the suitable methodology to improve performance and manageability.
  • Enabled Auditing featurefor tables such as FND_USER etc.
  • Created new application messagesand then generated message filefor application.
  • Created new concurrent managers, Purged concurrent requests table.
  • Worked closely with users group to ensure timely implementation of an ERP.
  • Provided application supportto users and created a log of all the problems with solutions for future reference.
  • Good experience and knowledge on Discoverer, Idiscoverer.

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, India May 2005 to March 2007 Oracle Apps DBA

As an Oracle Apps DBA, responsible for production, development and test instances of Oracle Applications 11.5.2, 11.0.3. Installed Oracle Applications 11i and up gradation from 11.5.5 to 11.5.6, up gradation from Oracle RDBMS 8.1.7.4 to Oracle RDBMS 9.2.0.4, developing PL/SQL Procedures, DB Triggers, Backups and Recovery.

Responsibilities:

  • Responsible for, both manage and support all Production, Development and Test instances of Oracle Applications 11.5.2, 11.0.3.
  • Configured and Installed Oracle Application 11i using Rapid Install.
  • Upgrading the Base install 11.5.5 to 11.5.6 and maintaining Oracle Applications.
  • Monitored the Applications and Database using OEM and OAM.
  • Setting up of printers In the Apps.
  • Maintenance of concurrent processing requests and concurrent managers.
  • Tuned concurrent managers using Oracle Enterprise Manager (OEM).
  • Using AD Utilities like ADADMIN, ADIAMGR, ADPATCH, ADCTRL .
  • Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and passwords.
  • Reorganization of the Database using export import.
  • Developing Hot, cold and logical backup scripts to automate the backup procedures.
  • Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
  • Design and development of major processing at the back-end through DB-Triggers, Stored Packages and Procedures using SQL and PL/SQL and SQL.
  • Daily activities include monitoring batch application for performance and space requirements and tuning the system to optimize space and performance.
  • Query optimization and tuning using tools like TOAD and SQL Loader.
  • Provide technical assistance to developers in all matters concerning performance, application related issues.
  • Debugged Oracle Reports and Oracle Forms programs.
  • Provides technical assistance and user support functions.
  • Participated in action planning and implementation.

Environment: Linux 2.4, Oracle database 9i, Oracle applications 11i, AD Utilities, OEM, PLSQL, SQL Loader

EDUCATIONAL QUALIFICATIONS
Bachelor of Engineering (B.E)

References: Available upon request

Hire Now