We provide IT Staff Augmentation Services!

Oracle Dba/apps Dba Resume

SUMMARY:

Committed IT professional with over 13 years of experience in Oracle Database, E - Business Suite and Fusion middleware products. Extensive expertise with installation, monitoring, administration, backup and recovery, security and integration of various Oracle products. Experienced and working with onshore and offshore modal, mentoring, setting and defining standards.

TECHNICAL SKILLS:

Specialties: Oracle Database versions (8/9i/10g/11gR2/12c)/Performance Tuning /Security/Backup and Recover/Oracle E-Business Suite (11.x/11.5.10/R12.1.3)/Oracle R12 customization/Oracle Hyperion 11.1.1.3/SQL Server 2005 and 2008/Oracle Portal/ Oracle Internet Directory/Oracle Single-Sign-On/ Oracle Application Express/ Oracle Application Server (6i/9i/10g)/Weblogic Server (10g/11g/12c)/ Discoverer (10g/11g)/ Oracle SOA Suite (10g/11g)Application Integration Architecture(2/3/11g)/ Oracle Business Intelligence(10g/11g)/Siebel UCM 8.1.1/Web center 11g(Oracle Enterprise Content Management)/Integration of all the above with Oracle E-Business Suite

PROFESSIONAL EXPERIENCE:

Confidential

Technology: Redhat Linux 6/ Oracle E-Business Suite 12.1.3/ Oracle Database 12.1.0.2/ IBM Storage V7000 SAN (RAID 5)/ VERITAS Volume Manager

Oracle DBA/Apps DBA

Responsibilities:

  • Production Support 24 *7
  • Support and maintain Oracle applications for projects like INFOED, INFORM Clinical Trials, B.I, oracle SOA and Production
  • Supporting all environments of Oracle Applications 11.5.10 and 12.1.3
  • Monitoring and Maintenance of Oracle Applications 11.5.10 (OSS) and 12.1.3 using QUIEST/OEM
  • Installing and implementing new oracle apps modules and Products
  • Installation and Configuration of Oracle Financials, Oracle Student System, iRecruitment, iExpenses, iProcurement, workflow mailer and Oracle Grants
  • Installation and Configuration of Tools e.g. Discoverer 4i/9i/11g and Oracle ADI
  • Supporting Oracle Financial and OSS
  • Raising iTar’s (Technical Assistances Request) with Oracle to Resolve -application Issues
  • Patching Applications for Bug fixation
  • Applying oracle/custom patches to Oracle Apps 11.5.10 and 12.1.3
  • Refreshing environments from Production for Different Projects.
  • Perform 2-tier and 3-tier clones of Oracle Applications 11i instances.
  • Troubleshoot problems with concurrent managers, workflow mailer, Apache, Jserv processes, and database performance.
  • Daily and Weekly health checks of Databases.
  • Applying database and applications patches(Maintenance, mini-packs,bugs,technology and security patches)
  • Installation/ Migration/ Upgrades:
  • DBA supporting implementations and upgrades of EBS 11i to R12.1.3 including platform migrations.
  • Oracle eBusiness split from OSS(oracle Student system) 11.5.10 and Financial, HRMS and SelfService Web Applications (iProcurement, iStore and iRecuretment) as 12.1.3
  • Installed multi-node cluster using Oracle Fusion Middleware (SOA) 11g(11.1.1.2), Oracle SOA Suite( BAM,BPM,BPEL) AIA 3.0 and Weblogic 11g (10.3.2) integration with e Business Suite R12.1.3 and e-business suite 11.5.10.2 ( Oracle Student system).
  • Migrated e-Business Suite Database (10.2.0.4) and 7 Middle tiers from Sun Solaris to Redhat Linux (Cross Platform Migration)
  • Upgraded Oracle Fusion Middleware from 11g( from 11.1.1.2 to 11.1.1.5 and 11.1.1.5 to 11.1.1.6)
  • Upgraded Weblogic Server 11g ( from 10.3.2 to 10.3.5 and 10.3.5 to 10.3.6.0.3 )
  • Integrated Oracle Web Center 11g with Oracle e-business suite.
  • Upgraded Oracle Application Express (Oracle APEX) from 2.1/3.0/4.2.2
  • Upgraded Oracle Application Server (OAS) from 6iAS to 9iAS and 9iAS to 10.1.3.5 iAS.
  • Experience with administrating 24/7 business critical systems
  • Production support both OLTP (e-business suite, Oracle Portal, Web Center, SOA & Weblogc servers) and DSS (Data warehouse) systems.
  • Upgraded all versions of standalone/e-Business Suite/B.I/Apex/Oracle Portal Databases from 8.1.7/9.2.0/10.2.0/11.2.0/11.2.0.3/12.1.0.2.
  • Installed/upgraded Oracle Business Intelligence Enterprise Edition (OBIEE (10g/11g) and Oracle BI Applications 11g integrated with e-business suite R12.
  • Ample troubleshooting experience in all version of Oracle Applications Release 11.x,11i.x R12x and Databases Release 8.x,8i.x,9i.x,10g.x and 11gR2.
  • Good Knowledge on SQL, PL/SQL, exp/imp, datapump, AWR, ADDM, TOAD and FoglIght.
  • Implemented Oracle Hyperion planning (11.1.1.4) as replacement Enterprise Planning and Budgeting.
  • Supporting the development and testing team during implementation of the Project and on all DBA related issues.
  • Integrated more4apps and Virtual Trader Application with e-business suite (11.5.10/12.1.3 )
  • Oracle RAC (10g/11g) and Dataguard
  • Oracle10g-RAC Oracle e-Business 11i MFG, Financials & Distribution
  • Provided a health check of production EBS to address many instability and performance issues and documented findings and implement recommendations.
  • Installed OEM Grid12c and configured agents on all the servers. Scheduled alerts 24 hrs based on requirements, defined user metrics, jobs scheduled and generated reports.
  • Strong SQL and PL/SQL skills to automate daily scheduler DBA activities.
  • Monitor oracle Application Servers/Weblogic Server availability using Quest Foglight.
  • Oracle Internet Directory (OID) and Single-Sign-On (SSO) (10.1.3.5) Integration for oracle e-business suite (11.5.10.2/R 12.1.3).
  • Configured SSL at the load balancer layer for WebLogic, Oracle Portal and e-business suite.
  • Configured RMAN for daily backups.
  • Expertise in RMAN Backup & Recovery Strategies including Duplicate DB in Same Node/different Target Nodes.
  • Configured Oracle Data Guard for Maximum performance as Disaster Recovery Plans.
  • Configured oracle e-business suite R12 with 4 node middle tier for internal network and a 2 node public facing middle tier with load balancer and reverse proxy.
  • Oracle Application DBA support, applying patches, mini-packs, family-packs and maintenance packs, CPU and PSU patches for both Application Server and Databases.
  • Extensively used Oracle Applications AD utilities like adconfig, adadmin, adpatch, adctrl, adsplice etc.
  • Full Payment Submission Process (FPS) 2016/17 (Report Set) -- When ran for a full year took 16hrs to complete. Performance degraded after 12c upgrade. There were no hits on metalink or google. Ran the job again and scheduled OEM tuning advisor and it came up with few options, one of the best options was query was using incorrect index "PAY RUN RESULTS 1" instead of "PAY RUN RESULTS 50". Performance will improve or enhance 95% if you use the correct index.
  • Below are few hidden parameters to improve dynamic optimizers alter system set " optimizer aggr groupby elim"=false scope=both; alter system set " optimizer reduce groupby key"=false scope=both; alter system set " serial direct read"=never scope=both;
  • Hands on experience on MS SQL Server2012/2014 cluster administration, backup & recovery and SSIS (SQL Server Integration Services).
  • Relocation of Databases from one server to another server using attach and Detach databases.
  • Refresh Databases from PRD to DEV and TST and support development team.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Supporting the development and testing team during implementation of the Project and on all DBA related issues.

Confidential

Oracle DBA

Application: Financials Apps 11.5.10.2

Database: Oracle 9.2.0.6

O/S: Sun Solaris 8 with RAID 5, 4 CPUs & 8GB Memory.

Responsibilities:

  • Installed and configured Oracle e-business suite 11i on multi-nodes for PROD & TEST and Development is in Single Node.
  • Enabled Kuwait Localization and Seed data using Data Installer and HR Global Patch.
  • Enabling and setting up the environment for HRMS Daily Business Intelligence reports.
  • Configured Oracle Enterprise Content Management (ECM) Server for Viewing the Ads .Learning Materials through OLM Application.
  • Configured Work Flow (Java Mailer) mailer for Self Service HR.
  • Other Database Administration activities like User Creation, Tablespace Creation, Space Management, and Access Control.
  • Refresh TEST and DEV with PROD Instance using RAPID Clone.
  • Administration and maintenance of Concurrent managers.
  • Supporting the development and testing team during implementation of the project and on all DBA related issues.

Confidential

Oracle DBA

Application: Oracle e-business suite 11.5.10.2

Database: Oracle 9.2.0.6

O/S: Windows 2003 Advanced Server

Responsibilities:

  • Implementing Oracle Financials and HRMS in Production/ Development/Testing Environments in Oracle Applications 11i (11.5.10.2) with database version 9i (9.2.0.6) on multi node Windows 2003 Advanced Server.

Confidential

Application: Oracle e-business Suite 11.5.9

Database: Oracle 9.2.0.1 with RAC

O/S: IBM AIX-RS/6000 UNIX

Oracle DBA

Responsibilities:

  • Supported Oracle 200 (Production/TEST/Quality and Development) databases.
  • Supported Oracle Database 8.x, 8.1.x and 9i on different Flavors (SUN, HP,AIX and NT)
  • Supported 3-tier and 2-tier Client/Server Applications.
  • Supported Decision Support System database of 3TB.
  • Supported Application folks to resolve their tickets/Problems
  • Supported Server/Database/Inst/Application’s Sched/Un-Scheduled Outages
  • Created databases/Instances for new projects
  • Created database objects (tablespaces, tables, Views, Synonyms, and Sequences etc).
  • Created/Maintained DR sites (Standby) for critical Databases
  • Created users/roles and Privileges
  • Migration and Upgrades from lower Release of oracle to Higher Release
  • Refreshing of Test/Development/Quality with Production
  • Backup/Recoveries
  • Recovered 42 databases due to Server Crash/Disk failure/bad disks or Application
  • Failures
  • Monitoring Space outage on Databases
  • Monitoring Regular Alerts for database contentions and Monthly health check of Databases
  • Daily lights on Activities on each and every production databases using centralized
  • Monitoring scripts
  • Providing rough order Magnitudes (Efforts estimations) for task like New -
  • Implementations, upgrades, migrations etc.
  • Conducted training to DBA’s Team regarding 9i, 9iAS and oracle Applications
  • Ticket Handling and making sure on meeting SLA’s.
  • Given continuous 24 * 7 Support and Regular Con-Calls with Onshore regarding day-to-day updates

Hire Now