We provide IT Staff Augmentation Services!

Senior Oracle Apps Dba Resume

Baraboo, WI

OVERVIEW:

A seasoned enterprise Senior Oracle Apps DBA with 16+ years of extensive IT experience working with Oracle Apps and Oracle databases and Project Management. Can handle effectively and efficiently any Implementations, Upgrade/Migrations of any Oracle Application Versions.

SUMMARY:

  • Extensive experience in Oracle Applications Releases (11.5.10 and 12.1.3, 12.2.6).
  • Specific Oracle Applications modules installed include AP, GL, AR, FA, PO, PA, QA, INV, OE/ONT, CM, HR/Payroll, BOM, MRP, WIP, VCP and ASCP , and I Procurement.
  • Hyperion Financial Management, Planning, Essbase.BI tools OBIEE, Discoverer reports.
  • Provided support to over 20 Development, Test and Production Oracle Apps Databases Size from 500GB to 4TB and 14000 users.
  • Automating scripts for DBA Tasks, Capacity Planning, Database Backup and Recovery (RMAN). Snap Manager for Confidential .
  • Installed and configured Golden Gate.
  • Experience with Exadata and Teradata.
  • Upgraded to Oracle Apps Release 11.5.10.2 to 12.1.3 / 12.2 and also the database from 11.1.0.7 to 11.2, 11.2 to 12C.
  • Implementation of Oracle Advanced Supply Chain Planning ASCP, VCP and APPC and Oracle configurator.
  • In charge of change management system and Release Management System. Member of downtime reduction team.
  • Performance tuning, large table Reorg and data purging. Analyzing traces, sql tuning, explain plans, index management, AWR reporting. Sql tuning. Gather stats.
  • Implemented physical and logical Stand by database using data guard.
  • Installed and configuration of Oracle Enterprise Manager 10g/11g/12c. OEM monitoring and configuring alerts.
  • Implemented Oracle Fusion, OAM, OID, SOA.

TECHNICAL SKILLS:

Oracle Applications ERP: Oracle Apps 12.2/12.1.3/12.0.6/11.5.10.2 , VCP, ASCP, APCC, Oracle Access manager, SSO Hyperion, Essbase, OID, Demantra, Exadata, Teradata.

Oracle Databases: 7.3/8i 9i/10g/11g. PLSQL / SQL

Middleware: Oracle Application Server 9i / 10.1.2 / 10.1.3 , Oracle Fusion, Weblogic,OAM,OID

Tools: oracle warehouse builder (OWB), Oracle discoverer, oracle portal, business intelligence (OBIEE). Appwrox /UC4 job Scheduler. HP archiving tool. Hotsos Profiler.

Operating System(s): Linux AS, Sun Solaris, Windows, HP - UX, AIX, UNIX Shell ScriptingPro*C, XML.

PROFESSIONAL EXPERIENCE:

Senior Oracle Apps DBA

Confidential, Baraboo, WI

Responsibilities:

  • They have existing 11.5.10.2 EBS business environment, they have decided to re-implement the R12.2.6. As part of this re- implementation project, Installed Oracle EBS R12.2.6 Oracle Data Appliance X5-2 server.
  • Configured Oracle ODA (Oracle Data Appliances) X5-2 box from scratch, setup the DOM server and VM guests.
  • Migrated oracle EBS, Oracle databases and MSSQL database from Baraboo, WI datacenter to One neck WI.
  • Provided different options, strategies and recommendations for re-implementing EBS (Ebusiness) R12.2.6, Oracle ASCP, Oracle ENDECA, Oracle UPK, Oracle Hyperion other application to different datacenter.
  • Apply patches using the ADOP and familiar with FS CLONE, FS1, FS2 and FS NE file system.
  • Provision environments with the latest Oracle Application releases, builds and install required components.
  • Implemented DR solution using data guard with Physical Standby and EBS Application server.
  • Used RMAN for hot backups and Uni Trends for Tape backups.
  • Created and maintained Performance Dashboard through OEM for management analysis.
  • Provide support to Oracle E-Business Products Family (ASCP, ENDECA, MFG, FIN, HR, etc)
  • Install and configure tech stack components. (9iAS, OracleAS 10g, Apache, CM, Forms, etc.).
  • Extensive experience in configuring DMZ for internal and external EBS users.
  • Create, maintain and optimize development and testing databases & environments.
  • Created custom tops in R12.2.6 with editions enabled.
  • Migrated the custom objects between DEV/TEST/PROD environments, updated Adopsync driver.

Senior Oracle Apps DBA

Confidential, Austin, TX

Responsibilities:

  • As part of this implementation project, Installed Oracle EBS R12.2 in a multi node RAC environment on Oracle Enterprise Linux Servers.
  • Architect servers in new Datacenter in Austin, TX and Datacenter migration from Irvine, CA to Austin TX.
  • Provide different options, strategies and recommendations for moving EBS (Ebusiness) R12.1.3, Oracle Agile, Discoverer, Safenet, SOA, OBIEE, Salesforce and other application to different datacenter.
  • Completed the POC for ERP upgrade of Legacy 11.5.10.2 to R 12.2.4. With Oracle 11G database and ASM storage on Confidential server.
  • Gather the integration information and coordinate with all teams for datacenter migration.
  • Build production, dev, test, project environment in Austin, TX datacenter. Integrated them with Discoverer, SOA and Oracle Agile. Reconfigured OBIEE servers.
  • Cloning of the EBS 12.1.3 from Irvine datacenter to Austin, TX datacenter. Reconfigure DMZ servers with new firewalls and new Cisco Blade with Confidential Storage
  • Used RMAN for compressed backup and restore database. Created shell script for backup. Configured Commvault backup.
  • Configured active data guard 11g for Disaster recovery from Austin to Salt Lake City.
  • Support the Dry run cycles and fix issues during the dry run. Track issues in issue log and make sure these are taken care during next dry runs and production cutover.
  • Prepare detailed cutover tasks, coordinate with all teams on cutover day. Coordinated cutover activity. Project went live successfully with minimum problems.
  • Prepare Architecture documents and provide the detailed document for tasks during the cutover. Posts go live support after production cutover.
  • Code Migration and changement. Review the code before going to production and provide suggestion for performance and tuning.
  • Upgrade E-business suit from 12.1.3 to 12.2.5. Database upgrade from 11.2.0.4 to 12 C.
  • Install the OEM 12C grid and setup the alerts, Incident rules.
  • Apply patches and updates to Vertex. Support for Oracle Agile (Production Management) environment.
  • Automate the cloning from PROD to Prod support every weekend.
  • Troubleshooting long running concurrent managers. Tuning the workers and recommending the new queues.
  • Install, configure and support oracle RAC instances with ASM storage.
  • Worked with SOA integration team and setup the Meta data for SOA Fusion middleware and setup data sources and connection pools for SOA. WebLogic administration.
  • Supported WebLogic, Apache server’s administration.
  • Migrated Oracle database to AWS postgreSQL database.
  • Supported Mango DB database. Experience with working on VM’s. Confidential storage.
  • Experience with Service now tickets and coordinating with offshore team.

Senior Teradata / Exadata DBA

Confidential, Seattle, WA

Responsibilities:

  • As Teradata DBA Lead, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 5500, 4 node for production, development and testing.
  • Setup core process required to source new data streams into Teradata data mart
  • Participate in the design and development of a technical architecture that will be aligned with the client’s business objectives.
  • Experience with ODA( Oracle Data Appliances).
  • Responsible for providing the best Teradata Informatica Loading strategies for ETL processing of getting data into Data mart.
  • Performed database health checks and tuned the databases using Teradata Manager.
  • With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
  • Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
  • Use of all database administration tools to analyze system status/performance.
  • Analyze explains/statistics/diagnostics to isolate SQL problems.
  • Very large 60 TB database support on Exadata x2,x4 and x5 servers. Running on 4 node RAC.
  • Work with Oracle Support for proactive patching of Exadata machines.
  • Database upgrade from 11.2.0.4 to 12c and Grid upgrade to 12c.
  • Configuration of Data guard and RMAN backup.
  • Support of OLAP and cubes, Dimensions for ETL, Micro Strategy and Cognos.
  • Worked closely with various development teams across the company to ensure proper use of Oracle Exadata features and best practices.
  • Implemented IORM and intra database resource management
  • Setup & configuration of Enterprise Manager (OEM) 12c for complete control of Exadata environment via Ops Centre.
  • Database Migrations from non-exadata to Exadata.
  • Maintaining and Administering EXADATA X2, X4 and X5, patching, monitoring, Proactive working with Oracle Support.
  • Archiving and compression of tables to save space and keep database clean and efficient.
  • Database performance tuning, identify bad sql’s and provide tuning methods. Run stats and AWR and ASH report to trouble shoot performance issues.
  • Make indexes invisible and check performance. Cache tables in flash Cache. Provide recommendation for Exadata EHCC and OLTP compressions.
  • Provide different options, strategy and recommendations for different data sources from SAP, R12.
  • Experience with Oracle ASM with ACFS file system.

Senior Oracle Apps DBA

Confidential, Sunnyvale, CA

Responsibilities:

  • Production support of Oracle Ebusiness applications(EBS) (R12.1.3 / R12.2) databases size of 5T. 20 Application servers and 4 CM servers and 20 Weblogic servers, Cloning, Patching and maintenance of DEV / QA/PreProd instances.
  • Installation and configuration of Oracle applications databases in 4 node RAC environment, Configuration of CRS, ASM. Supported Oracle ADF project.
  • BI tools OBIEE, Hyperion and Discoverer reports installation and configuration. Configuration of Demantra server. Integration with Fustion Middle ware, SOA.
  • Configured Oracle Access Manger (OAM), Webgate,and OID. Implemented Single Signon SSO.
  • Implemented Golden Gate for datawarehouse data collection from various sources.
  • Patch Analysis and application of one off patch, mini packs, family packs and maintenance pack for TEST, DEV and PROD. Troubleshooting patch application procedure and resolving issues encountered during patch application. Configured PCP and multi node applications.
  • Database upgrade from RAC( Real Application Cluster ) 11.1.0.7 to 11.2. Configured ASM instance. Performing Database clones for RAC and Non RAC databases. Applying latest CPU patches.
  • Designed and Implemented Oracle Disaster Recovery Solutions using Oracle 11g Data guard Physical and logical. With auto failover feature.
  • Change management using the HP ALM Kintana tool and Perforce. Release management and Environment allocation. Coordinated with Developer and Testers.
  • Install, configure and supported Web logic server. Portal deployment. JVM tuning, monitoring the oacore restarts, crashes and chaning the Java Heap size parameters.
  • Database backup using the snap technology and RMAN. Database cloning from Prod to DEV / TEST.
  • Used oracle ASM with ACFS file system.
  • OEM 12C installation and configuration, setup the database alerts and metrics. Review AWR reports frequently.
  • Performance and tuning on SGA and Automatic Undo management. Providing recommendation on PL / SQL tuning. Trace Analysis and provide index recommendations and hints.
  • Run statistics and use ASH and AWR and ADDM to tune queries. Analyze AWR reports regular provide the recommendation for tunings.
  • Database base performance and tuning. Purging and archiving strategy. Review Load and performance test results and provide the recommendations.
  • Database security and keeping the database and Oracle Applications R12 and Weblogic with latest CPU patches.

Senior Oracle Apps DBA at

Confidential, Memphis, TN

Responsibilities:

  • Part of Upgrade team and representing from Confidential . Sucesfully migrated oracle Appication from 11.5.10.2 to R 12.1.3.
  • Production support of Oracle Applications ERP 12.1.3. Cloning, Patching and maintenance of DEV / QA / PreProd instances.
  • Installation and configuration of Oracle databases in RAC environment, Configuration of CRS.
  • Supporting the 5 internal servers and two external (DMZ) servers. Support of Financial and HR modules. iProcurement, iSupport and iRecuirtment. Support of Payroll and month end closing and period closing. Support for Budgeting.
  • Performing Application Clones and Database clones on environment like Single and Multi Node Architectures of Oracle Apps. Using the Rapid clone and RMAN backups.
  • Configuration of DR site using Data guard Physical Standby.
  • Patch Analysis and application of one off patch, mini packs, family packs and maintenance pack for TEST, DEV and PROD instances using ADPATCH and AD Tools. Troubleshooting patch application procedure and resolving issues encountered during patch application.
  • Database upgrade from RAC (Real Application Cluster) 10g to 11.2. Oracle Apps upgrade from 11. .1.3.
  • Oracle Hyperion Financial Management 11.1.2 Installation & Configuration.
  • Oracle Hyperion Planning 11.1.2 Installation & Configuration.
  • Oracle Essbase 11.1.2 for System Administrators.
  • Oracle Hyperion Data Relationship Management 11.1.2 Administration .
  • Workflow administration and Discoverer administration.
  • Performance and Tuning of APPS. Managing the Concurrent Queues and adjusting the number of workers.

Senior Oracle Apps DBA

Confidential, Zeeland, MI

Responsibilities:

  • Production support of Oracle Applications ERP 12.1.3 and 12.0.6. Cloning, Patching and maintenance of DEV / QA instances.
  • Installation and configuration of Oracle databases in RAC environment, Configuration of CRS.
  • Performing Application Clones and Database clones on environment like Single and Multi Node Architectures of Oracle Apps. Install Confidential SMO tool for backup and cloning.
  • Patch Analysis and application of one off patch, mini packs, family packs and maintenance pack for TEST, DEV and PROD instances using ADPATCH and AD Tools. Troubleshooting patch application procedure and resolving issues encountered during patch application.
  • Database upgrade from RAC( Real Application Cluster ) 11.1.0.7 to 11.2. Oracle Apps upgrade from 12.0.6 to 12.1.3.
  • Performing Application Clones and Database clones on environment like Single and Multi Node Architectures of Oracle Apps.
  • Performing complete Technology stack upgrades like Developer patchset, JDK upgrade. Running Diagnostic Scripts installation of support packs on Oracle APPS R12.
  • Maintaining Oracle Database on Sun Solaris, AIX, Linux platforms and resolving issues related to space and background dump errors. Identify and run all the purge programs. Reorg large tables and provide archive solutions.
  • Implemented HRMS, Finance and Manufacturing modules, VCP and ASCP. Troubleshooting Memory based snapshots and Memory based planner. APCC configuration and setups. Installation and configuration of Dematra. Implementation and Configuration of SNO.
  • Responsible for managing, maintaining, configuration and supporting Oracle R12 Apps, interact with offshore client to understand and resolve all the technical and functional issues under various environments.
  • Configuration of Parallel concurrent manager and managing concurrent queues and sleep time.Troubleshooting the workflow issues and concurrent programs.
  • Creating production Database, Planning Database Design, Creating users, Assigning Profile. Performing regular DBA Activities such as Backups, Modifying Database Structures, Managing Database Storage, System Security, Profiles, roles etc.
  • Interacting with end-users for oracle application problems and Trouble-shooting technical and functional issues.
  • Provide Architect Solutions for Confidential hardware upgrade project. Provide solutions for high availability and disaster recovery.
  • Identify the process improvement areas, define new processes for change management and Patching.
  • Provide support for OBIEE, Data warehouse, IAS, SSO(single sign on) and SOA
  • Enabled Korean, Germany, Japanese and Simplified Chinese on Oracle Apps 12.0.6 and applied the requisite patches.
  • OEM upgrade from 11g to 12c.Data guard physical standby active/active setup for DR solution

Senior Oracle Apps DBA

Confidential, Austin, TX

Responsibilities:

  • Responsible for providing 24x7 Oracle Apps DBA support for multiple large Oracle Apps databases in production, development and test environments. Managed a team of 15 Apps DBAs for Design, Development and Production support and Performance tuning. Managing HPOV tickets, Request for Change (RFC) tickets and Approval for patching and instance maintenance.
  • Implemented Oracle Applications Releases (11.5.10.2) and Oracle Databases (7.x,8.x,8i.x,9i.x and 10g.x), Specific Oracle Applications modules installed include AP, GL, AR, FA, PO, PA, QA, INV, OE/ONT, CM, HR/Payroll, BOM, MRP, WIP, and I Procurement. Oracle Advanced Supply Chain Planning(ASCP) and Dematra and Oracle configurator.
  • Onsite lead Apps DBA team and Performance team, develop process for performance improvement and proactively identify poor code and tune it, analyze traces, Index Management, AWR report, Explain plan and Hotsos performance tuning tool.
  • Oracle Application DBA support, applying patches, mini-packs, family-packs and maintenance packs, upgrades, multi-tier installations, automatic routines Apps DBA task, periodic refreshes, oracle support dealing with functional, developers and end users.
  • Enabled Spanish Language, Brazil Portuguese, and Simplified Chinese on Oracle Apps 11.5.10.2 and applied the requisite patches.
  • Converted the existing table spaces structure to OATM .Installed OEM grid control and configured EBS databases for monitoring concurrent managers, forms sessions, database locks, invalid objects and JDBC connections.
  • Creating Custom Concurrent Managers and Assigning Work shifts to it. Finding long running requests and terminates them if needed. Troubleshooting problems with web server, web listener, workflow, forms server, and concurrent managers, and database.
  • Change Management / Release Management. Resulting performance boost of 20% and production downtime reduction.
  • Implement and configured Appworx /UC4 Job Scheduling tool for better manageability and inter job dependency and self-compatibility. Automated 10000 jobs using UC4.
  • Designed and Implemented Oracle Disaster Recovery Solutions using Oracle 11g Data guard Physical and logical. With auto failover feature.

Senior Oracle Apps DBA

Confidential, Austin, TX

Responsibilities:

  • Install and maintain Oracle Applications 11.5.10.2 in complex environments such as Single-node and multi-node installations. Implemented all financial & manufacturing modules such as GL, AR, AP, PO, INV, BOM & WIP. ASCP implementation and Configuration.
  • Applied latest releases of the patches using AD utilities from Oracle. Cloning the instances from production to test, development instance to test & simulate technical challenges, coordinate with testing and development teams.
  • Managing the concurrent Manager Queues and resolve workflow issues. Purging and reorg large tables. Implemented HP Archive tool for data archiving.
  • Supported over 50 production/ development/ testing Oracle Apps environments, sizes ranging from 500 GB to 4TB GB running on 30 servers Oracle ERP, OLTP and data warehouses with OS as Linux, AIX, Solaris and Windows.
  • Upgraded the Oracle Applications 11.5.8 to 11.5.10.2, database to 10.2.0.3 from 9.2.0.6 on Windows to Linux.
  • Installed OEM and configured alerts. Written/Modified shell / Sql scripts to monitor and maintain the Oracle Applications database.
  • Monitor database alert log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.). Manage and maintain high volume transactional tables and indexes, database reorganization. Run ADADMIN to compile APPS schema, regenerate forms, reports, generate Jar files.

Senior Oracle Apps DBA

Confidential, Austin, TX

Responsibilities:

  • Support and maintain 16 Oracle Applications 11.5.8 instances including production.
  • Responsible for patching of Oracle Applications instance and its maintenance Applying Apps, RDBMS patches and tech-stack patches and used lot of techniques to reduce the patching downtime. Managed system configuration using Autoconfig.
  • Configure JVM and Jserv processes for load balancing.
  • Performing pre-patch analysis and pre-config analysis. Apps system administration Managing application user accounts and responsibilities and database user accounts
  • Change Management and Release management. Conduct performance load test.
  • Bouncing the instance as per customer requirement. Monitoring the instances Worked as a shift lead in pre patch analysis and patching team. Organizing team meeting and co-ordinate with other team leads
  • Administered and provided production DBA support to the several databases of Financial Data Warehouse. Supported month end, period end and Annual closings.
  • Configured database for managing customer addresses using group one / Address doctor software. Implemented Trades spear compliance software to restrict shipping to blacklisted countries.
  • Minimized 20% downtime by emerging patches to Patch bundle.
  • Performed Oracle Gateway / HSODBC configuration for MSSQL and DB2 servers.
  • Migrated Oracle Application 11.5.4 from windows to Linux environment.

Oracle Apps DBA Consultant

Confidential

Responsibilities:

  • Served as Consultant Oracle APPS DBA and Project Manager at several client companies like Sony, Citibank, Emerson and GE. Managed a team of 10 Apps DBAs and Developers.
  • In-charge of the Oracle Applications and has lead the Upgrade on the Applications and database from 11.5.8 to 11.5.9.
  • Involved in R11.5.9, 11.5.8, 9i and Tech-stack new enhancements end to end verification Installation Testing.
  • Tackling all the day-to-day issues for maintenance of Oracle Applications and the Databases.
  • Applying family packs, Rollups, Minipack and one-off patches accordingly.
  • Cloning Oracle Applications experienced with different cloning skills like manual, adclone and Rapid clone. Creating, updating and monitoring TAR activities.
  • Jinitiator upgrade from 1.1.8.16 to 1.3.1.21
  • Gather requirements submit proposal for clients. Design and built environments for Dev. / Test and Production.
  • Management solution in Oracle database for NG Transco helping the company save significant amounts in setting up the trainee and trainer groups.
  • Build new database environments, taking base lines and restoring base line, table space management, and user role management.
  • Performed installation and configuration of 9iAS. Installation of OC4J.9ias Forms / Report Server configuration.

Hire Now