We provide IT Staff Augmentation Services!

Oracle Fusion Middleware And Apps Dba Resume

4.00/5 (Submit Your Rating)

Tampa, FL

SUMMARY

  • Overall 7+ years of professional experience as Oracle Fusion middleware DBA,Oracle Apps DBA and Oracle Core DBA
  • Experienced in 10g and 11g Database administration & Oracle Applications 11i and R12
  • Experienced in oracle Weblogic components OAM,OID, oracle Webcenter portal, Webcenter imaging and Endeca
  • Experienced in various Unix Platforms like HP - UX, Sun Solaris, IBM-AIX, RHEL X86-64 and Windows System.
  • Adept in Database Administration activities such as patch installs, cloning, backup and recovery of mission critical databases, performance tuning, script development (shell scripting) and documentation
  • Proficiency in standby database (Data guard) installation, upgrading, configuration, maintenance, backup and administration for disaster recovery on 10g/11g RAC
  • Expertise in converting single instance database to Real Application Cluster (RAC)
  • Experience in upgrading SOA suite (BPEL, ESB and OWSM) from 10.1.3.1 to 10.1.3.3 and 10.1.3.4.
  • Proficient in installation and upgrading Oracle Applications 11i e-business suite to R12.
  • Applied quarterly CPU security patches to Oracle E-Business Suite 11.5.x and R12.x
  • Experienced in working with adutilities like adadmin, adpatch, adctrl and adsplice and also resolving the issues during patching.
  • Proficient in cloning the Oracle Apps and database using rapidclone and autoconfig.
  • Done version upgrades in oracle weblogic components like OAM,OID and Oracle webcenter portal
  • Experience in working and tuning with Oracle Workflow.
  • Experience in using 11g features such as real application testing, sql plan baselines.
  • Experience in using 10g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
  • Experience in Installing Oracle 11gR2 GRID Infrastructure, 11gR1 CLUSTERWARE, 10g CRS on RHEL.
  • Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, 10046 trace, 10053 trace, AWR, ADDM, to collect and maintain performance statistics and improve the database performance.
  • Proficient in SQL, PLSQL, Stored Procedures, Functions and Database Triggers.
  • Proficient in implementing and maintaining Database Security (Users, Roles, Privileges), space management (logical structures such as tablespaces and rollback segments) and auditing of users.
  • Profound knowledge in Oracle utilities including export/import, Toad, SQL*PLUS, Data Loading using SQL Loader.
  • Adept in data modeling, Physical and Logical Database design, partitioning of tables and indexes, management of schemas.
  • Exceptional communication and interpersonal skills. Ability to work efficiently as a part of the team and individually. Possessing excellent developmental and analytical skills.
  • Proven ability to combine project and staff management with technical expertise to consistently exceed corporate goals.

TECHNICAL SKILLS

Applications: Oracle Release 12 and 11i instances (11.5.5-11.5.10 ), Oracle Application Server 10g, Kofax/Mark View

Databases: Oracle 10g, 11g and 12c

FMW: Oracle Weblogic server 12,10.3.6, 10.3.5, 10G SSO,OAM,OID,Portal,Imaging,Endeca

Modules: GL, AP, FA, PO, AR, INV, Iprocurement, FND, AU, AD, AK, SYSADMIN

Tools: TOAD, SQL Developer, Putty, Vnc

Operating system: Oracle Linux 5.5, 6.2, H.P UNIX, IBM AIX, Sun Solaris

Languages: SQL, PL/SQL, C, UNIX Shell Scripting, HTML

PROFESSIONAL EXPERIENCE

Oracle Fusion Middleware and Apps DBA

Confidential, Tampa,FL

Environment: Oracle 11g, OEM 12c, weblogic 10.3.6,RHEL 6.2,Solaris, SQL*Plus, SQL * Loader, PL/SQL Developer, Import, Export, Toad

Responsibilities:

  • Configured dataguard for RAC and standalone databases
  • Installed Oracle weblogic 10.3.6 server and deployed custom java war files
  • Created WLST scripts for monitoring weblogic server 10.3.6
  • Responsible for configuration and implementation of backup and recovery using RMAN.
  • Responsible for monitoring Oracle database activities using Oracle Enterprise Manager 12c
  • Created automatic portioning of tables and indexes to increase the performance
  • Used datapump feature to migrate data from oracle 10.2.0.5 to 11.2.0.4 database
  • Created shell scripts to monitor oracle database services
  • Applied latest quarterly CPU patches to oracle database and oracle grid control 11g

Oracle Fusion Middleware and Apps DBA

Confidential, Tampa,FL

Environment: s: Oracle E-business suite 12.2.4,12.1.3,12.0.6,oracle 11g, RHEL 5 and 5.5, 10G SSO, OID,OIM, Oracle portal 11G, SQL*Plus, SQL * Loader, OEM, PL/SQL Developer, Import, Export, Toad,Weblogic 10.3.5,10.3.6.

Responsibilities:

  • Working on POC implementation of Oracle Ebiz R12.2.4
  • Working on POC implementation of Oracle Mobile security suite
  • Worked on POC implementation of OAM 11.1.2.3 and OID 11.1.1.9 integration with Ebiz
  • Production Support of ERP R12 environment Database 3 - Node RAC, 8 Node Application Tier with load balancer in DMZ configuration
  • Installed and Integrated OAM 11gR2 with OID,Ebiz other weblogic components like Webcenter content Imaging and oracle Webcenter portal 11g
  • Integrated webcenter imaging with ebiz suite using 11g Accelator
  • Installed and configured ODC and OFR 10g in DEV,UAT,PROD and integrated with webcenter imaging
  • Created Custom authentication schemes for Netegrity Siteminder integration with OAM
  • Installed and configured Webcenter portal 11.1.1.7 on a single node, clustered in PROD and DR.
  • Expertise in Installing and configuring Oracle Webtier 10g,11g, enable Weblogic proxy, SSL
  • Installed and configured oracle Webgate with Webtier
  • Implemented IDM solution for Ebiz with OAM and OID using Oracle EBS access gate.
  • Implemented SSO solution for the ODSM console for OID user maintenance
  • Migrated users and groups from 10G OID to 11G OID using ldap bulkload
  • Expertise in trouble shooting issue with Endeca extension for EBS
  • Installed OAM 11.1.1.7 with OID 11.1.1.6 on Weblogic 10.3.5 and 10.3.6 on RHEL 5.6
  • Integrated OAM 11.1.1.7 with OID 11.1.1.7 and Ebiz 12.0.6 using webgate and accessgate
  • Implemented OAM, OID on two node cluster with virtual URLs right from designing and implementing
  • Integrated 11.1.1.5 OAM with Siteminder R12 using a custom JSP
  • Worked with the Dev team to create custom portal login page and Multi factor Authentication
  • Performance tuning of Weblogic and other OFMW products
  • Successfully performed Dr testing for OAM,OID and other Fussion Middleware components
  • Upgraded oracle E-business suite Accessgate to latest patch version
  • Upgraded oracle database 10.2.0.4 to oracle 11.2.0.2 with datagaurd
  • Upgraded oracle database from 11.2.0.2 to 11.2.0.3 with datagaurd
  • Performed Database character set conversion from UTF8 to AL32UTF8 to support additional language requirement using DMU,CSCAN, and expdp/impdp utilities
  • Implementation of GL, AP, FA,PO modules in R12.1.3 Ebusiness Suite & configured and used PPM tool for code migrations
  • Refresh/cloning of ebiz from production
  • Refresh/Cloning of Database from production environment to test environment and application of patches.
  • Created the backup policy document and also Unix shell script for backup
  • Created RMAN backup, cloning and recovery scripts
  • Implemented 10g IDM, Installed 10g OID, 10g OSSO,10g portal
  • Integrated 10g OID,OSSO, 10g Portal with ebiz
  • Integrated 10g OSSO with ebiz and siteminder r6
  • Frequent patching activities in ebiz and database
  • Responsible for User Acceptance testing and supporting the end users by resolving problems faced by them.
  • User support and production support.
  • Updated development databases by using import/export and SQL loader utilities.
  • Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.
  • Experience in recovering the database in case of failure (Complete/Incomplete recovery)
  • Wrote scripts for database maintenance activities such as monitoring the growth rate of tablespaces and extents.
  • Wrote WLST scripts for Weblogic JDBC connections, threads and Weblogic service monitoring.

Oracle APPS DBA

Confidential, Seattle,WA

Environment: RHEL, SUN Solaris 8, Oracle database 10g, 11g, Oracle Applications R12 (12.1.3),Discoverer 11g, OID 11g, OEM 11g, Toad

Responsibilities:

  • 24x7 Production Oracle Applications Administration with E-Business 11i and R12
  • Responsible for cloning and patching the E-Business environment by utilizing tools such as rapid clone, adadmin, adctrl and adpatch.
  • Installation and configuration of discoverer11g on weblogic server 10.3.6
  • Installed and configured OID 11g with Ebiz 12.1.3
  • Migrated users from 10g to 11g using ldap bulkload
  • Created users and roles for the other applications integrated with OID
  • Oracle database upgrade from 11.1.0.7 to 11.2.0.3 and Applications upgrade from Oracle Applications (E-Business Suite) 12.1.1 to 12.1.3
  • Supported major projects like HR Portal migration and Open Enrollment.
  • Cloned Oracle home to all non prod instances and made sure everything is in sync with production.
  • Upgraded Java from 1.6.0.17 to 1.6.0.35 and supported application team in resolving the post-upgrade issues.
  • Upgraded the existing HRMS and Payroll Module to RUP1
  • Applied HRMS latest patchsets in 11i
  • Involved in Cloning and patching of oracle applications R12.
  • Supported merchandising databases with Golden gate and RAC set up
  • Provide technical assistance to all internal/ external customers and team members during system problems and implementation.
  • Implemented Oracle Directory services and configured Oracle Internet Directory 11.1.1.5.0
  • Applied patches using adpatch, adctrl and opatch utilities. Applying Oracle security patches within 30days of their release.
  • Providing oncall Production support for various production databases.
  • Being Involved troubleshooting various issues related with web logic issues.
  • Registering the new Forms, Reports, pl/sql scripts as concurrent programs, analyzing the performance and coordinating with application teams regarding the same.
  • Tuning the database with AWR, Tkprof, TRACE, Execution plans, SQL profiles, SQL Plan Baselines, SQL HINTS
  • Coordinating and working with offshore DBA team regarding various day to day tasks and following up through completion.
  • Configuration of Workflow Notification Mailer, OAM, OEM10g. Coordinated with the application team for the migration of mail servers from .
  • Worked on the user and data security issues. Worked closely with users group to ensure timely implementation of an ERP.
  • Providing the technical support to the Users on HRMS module implementation
  • Took active role in communication with various development and test teams.
  • Preparation and maintenance of documentation of all the activities according to the team standard.

Oracle Core/APPS DBA

Confidential, San Jose,CA

Environment: Oracle Server 10g/11g,Weblogic 10.3.5, OID 10g, IDM,Oracle EBS 12.0.6, RHEL, Solaris 10, TOAD, OEM 10g&11g.

Responsibilities:

  • Supporting Oracle Databases 10g/11g RAC on Linux/UCS( Confidential linux version)
  • Experience in troubleshooting Oracle EBS hosted databases on R12 and 11.5.10.2
  • Installed oracle weblogic server 10.3.5 and OID 10g
  • Integrated EBS with the 10g SSO
  • Performed Cloning and Patching of R12 EBS and database
  • Created logical and physical database using 11g data guard.
  • Designing the security and database access strategies.
  • Performing backups and recoveries using RMAN and conventional hot backups.
  • Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
  • Creating and dropping of users, granting and revoking rights as and when required..
  • Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
  • Tuning heavy data loads. Monitoring and Performance tuning.
  • Monitoring of database for growth and performance
  • Monitoring Database for fragmentation and correcting and reorganizing those objects
  • Written Unix shell scripts, Korn and Perl scripts.
  • Partitioning R12 E-business suite large tables with range, list partitions, hash sub partitions
  • Diagnose and troubleshoot Database problems and failures
  • Creating and refreshing materialized views.
  • Performing SQL*Loader jobs for data loading.
  • Performed and Monitored Database using OEM 10g and 11g.

Oracle APPS DBA

Confidential, Dearborn, MI

Responsibilities:

  • Upgraded Oracle Applications from 11.5.10.2 to 12.0.4.
  • Upgraded Database from 9.2.0.5 to 10.2.0.2, 10.2.0.2 to 10.2.0.3 and 10.2.0.3 to 11.2.0.2
  • Preserved the customizations of 11.5.10.2 instance during the upgrade process.
  • Tuned the upgraded Release 12 instance by assigning the number of OC4J’s and sizing there memory.
  • Migrated 10.1.2 application server from Solaris to Linux.
  • Integrated Infra, SSO and Portal with Release 12 EBIZ.
  • Implemented High Availability replication and OC4J clustering for Infrastructure tier services.
  • Implemented Siteminder netegrity single sign on along with Oracle single sign on.
  • Implemented shared appl top in 11.5.10 environments
  • Extensive patching and cloning of 11.5.10 instances.
  • Production support Maintenance activities, written shell scripts for Monitoring production activities.
  • Perform general technical troubleshooting and working with Functional teams for possible solutions for various issues.
  • Concurrent manager administration and Oracle Apps sysadmin functions.
  • Performed Backup and Recovery using RMAN and written shell scripts for scheduled online backups.
  • Troubleshooting RMAN backup and recovery related issues.
  • Worked with Oracle Corporation to resolve applications/database issues by opening TAR/SR

Environment: Oracle 9i, 10g Database, Oracle Apps 12.0.4, 11.5.10.2, 10gAS Application, Redhat LINUX, Sun Enterprise Servers, RMAN.

Oracle Core/APPS DBA

Confidential, VA

Responsibilities:

  • Migrated oracle applications middle tier from Sun Solaris to RHEL
  • Installed oracle CRS 10.2.0.1 and upgraded it to 10.2.0.4
  • Installed oracle database 10.2.0.1 and upgraded to 10.2.0.4
  • Installed oracle Application server 10.1.3.1 and upgraded to 10.1.3.3
  • Automated the tasks with the shell scripting and constant monitoring on the production and development instances with the shell scripts
  • Reorganization of segments (tables, indexes) to release space and increase the performance.
  • Installation and administration of the oracle E-business suite 11.5.10/12.0.6
  • Cloning the Oracle Apps and database using rapidclone and autoconfig.
  • Cloned both single instance and RAC from production to test instances in order to fix the issue
  • Cloned Oracle CRS from one server to another in a RAC during the crash recovery of the server
  • Responsible for installation, maintenance and trouble shooting of databases on 2 node RAC.
  • Upgraded the database from 9.2.0.4 to 10.2.0.3 and applied patches when required.
  • Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, Statspack, Explain plan and SQL*Trace.
  • Partition of tables and indexes to increase the performance.
  • Populated staging tables with data using SQLLDR and PL/SQL.
  • Created database objects, users, roles and profiles.
  • An active member of the backup and recovery team and was responsible for configuration and implementation of backup and recovery using RMAN. Installed and configured Recovery Manager.
  • Configuration of Oracle streams for replication between two databases.
  • Responsible for monitoring Oracle database activities using Oracle Enterprise Manager. Hence responsible for setup and configuration of OEM.
  • Involved in Data refresh from production to test and development.
  • Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.
  • Responsible for User Acceptance testing and supporting the end users by resolving problems faced by them.
  • Experience in recovering the database in case of failure (Complete/Incomplete recovery)
  • Wrote scripts for database maintenance activities such as monitoring the growth rate of tablespaces and extents.
  • Troubleshooting of Database replication issues.

We'd love your feedback!