We provide IT Staff Augmentation Services!

Sr. Oracle Apps Dba Resume

SUMMARY:

  • Over 15+ years of extensive experience in the IT industry, with 14+ years of experience on various Oracle Technologies as Sr Oracle Applications DBA.
  • This experience comprises of oracle applications R12.2 implementation, database administration.
  • Installing and upgrading of the Oracle Application products Release R12 (12.2.7/12.1.3 )/11i (11.5.10.2/11.5. X/11.0.X) coupled with excellent knowledge of the Oracle Applications system administration, management of users, Security privileges, concurrent processing, workflow, profile options, Database upgrade from 11g RAC to 12c RAC and SSO Integration with Oracle E - Business R12.2.4. I’m also Oracle R12 Certified applications DBA.
  • Architecture, Installing, monitoring and maintaining Single Node and Multi Node (shared Applications File) Oracle Applications (E-Business Suite Version 11i & R12).
  • Installed and configured Oracle Access Manager 11.1.2 and OID 11g. Configure SSO for EBS 12.2.4/OBIA and Sunflower Assets systems
  • Expert in Cloning Oracle EBS 12.2.4 from RAC to non RAC and single to multi node application
  • Upgrade EBS R12.1.3 to 12.2.7 -- Migrate Single Instance to 12c RAC, Setup PCP, Forms Load Balancing
  • Installed and Configured ASM, Migrated Non-ASM Databases to ASM. Implemented Oracle RAC.
  • Experienced in Installation, configuration, upgrade, Migration and Administration of OBIEE, Oracle BIApps(OBIA), Oracle Data integration(OI)
  • Installed and configured Mark view 9.0 and integration with EBS 12.2
  • Load Balancing Mid-Tier web servers with BigIP.
  • Experience in troubleshooting Oracle Application Techstack issues, performance issue
  • System administration responsibilities including creating application users and assigning roles and responsibilities.
  • Installed and configured Sunflower Asset management.
  • Migrated OBIEE dashboards/web catalogs including supporting files between environments during development process. DEV, UAT, PROD
  • Installation and configured GRC modules. AACG, PCG and CCG
  • Excellent working knowledge in configuring multiple WebLogic domains including machines, manage servers, node managers and cluster environments.
  • Installation of OEM grid control, configuration and installing agents on all database and application Servers
  • Implemented RMAN backup Solutions for Production and Cloned test/dev instances using RMAN production backups.
  • SOA and WebLogic install and SOA configuration, deploying applications, Experience in setting High Availability and clustering for SOA suite.
  • Installed and configured Oracle Apex 5.1 Web development tool.
  • Set up configured and maintained Oracle Data Guard (primary and standby database) to ensure disaster recover, high availability and data protection
  • Automated Database refresh using 11g snapshot standby technology

WORK EXPERIENCE:

Confidential

Sr. Oracle Apps DBA

Responsibilities:

  • Installed and Configured 12.2.0 with 12.1.0.2 database and upgrade Oracle application from 12.2.0 to 12.2.4 and migrate the database from 12.1.0.2 to 12.2.0.1
  • Installed and configured OBIEE 11.1.1.7 and integrating EBS R12 with Oracle Bi 11g and upgrde OBIEE from 11g to 12c
  • Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment
  • Installed configured OBIEE 11.1.1.9.0 , OBIA 11.1.1.9.0 , ODI 11.1.1.9.0 on Production Server
  • Expertise in Oracle Apps 12.2 Patching using ADOP.
  • Setup Configuration, and Maintenance of Multi-node/Shared Application file system architectures
  • Experience in Cloning from Single node to Multi Node and Multi Node to Multi Node. RAC to Non RAC and RAC to RAC using Rapid Clone.
  • Troubleshooting Apex configuration and login issues
  • Document critical issues with root cause analysis, provide timely resolution of service tickets
  • Tuning Concurrent Managers Parameters and settings for Custom Concurrent Manager
  • Configuration of Oracle workflow notification mailer

Confidential

Sr. Oracle Apps DBA

Responsibilities:

  • Production support the Oracle Application R12 instances including the boundary applications like WebLogic, OBIA, Markview, GRC SOA
  • Database Problem Diagnosis, Research Fix, Testing and Resolution
  • Worked on OBIEE security like configuring LDAP authentication , creating users and groups
  • Clone the Instances from PROD to TEST with RMAN AND Adclone utilities
  • Creating and Monitoring Application users, assigning Responsibilities and managing user profiles
  • Day to day troubleshooting of the environments which includes fixing all the issues coming in them and supporting the various components of the Oracle Application - Forms, Apache, concurrent Managers, DB Listener
  • Applied Fusion Middleware Technology stack patches (OHS, WebLogic, FMW) for EBS R12.2 environments.
  • Monitoring the Scheduled jobs and solving any issues related to failed jobs
  • Document, test, implement and provide ongoing support for Oracle E-business suite application
  • Database Problem Diagnosis, Research, Fix, Testing and Resolution.
  • Supporting Transition team to move DNDO Prod and TSA instances from IBC to DX data center
  • Developed suite of utilities for maintenance of multiple Oracle Applications environments: environment configuration, initialize environment, automated databases, Webserver, Form servers and concurrent manager’s startup/shutdown process.
  • Scaling up Managed servers (oacore) for EBS R12.2 environment.
  • Applying patches in production and test instances, using AD utilities to maintain the integrity of the Applications and Database
  • Installation and integrating OBIEE 11g with Oracle EBS R12
  • Administration of Oracle E-Business Suite concurrent managers, jobs, PCP.
  • Monitor Workflow related services & Notification Mailers.
  • Troubleshooting ODI Load execution issues and user login issues
  • Password change management for EBS, OBIA and SOA
  • Setup, Configuration, and Maintenance of Multi-node/Shared Application file system architectures.
  • Troubleshooting Apex configuration and login issues
  • Document critical issues with root cause analysis, provide timely resolution of service tickets
  • Tuning Concurrent Managers Parameters and settings for Custom Concurrent Manager
  • Configuration of Oracle workflow notification mailer

Confidential

Senior Apps dba/Core DBA

Responsibilities:

  • Installed and configured Oracle Apps 12.0 Oracle Applications with 11.1.0.7 database and upgrade oracle applications from 12.1.1 to 12.1.3 and upgrade of database from 11.2.0.4 to 12.2.0 1
  • Effective Troubleshooting of database and performance problems
  • Setup, Configuration, and Maintenance of Parallel Concurrent Manager.
  • Took care of Applications and Database performance tuning issues related to long running requests and locks.
  • Installed and configured Mark view 9.0 and integration with EBS 12.1.
  • Setup, Configuration, and Maintenance of Multi-node/Shared Application file system architectures
  • Experience in Cloning from Single node to Multi Node and Multi Node to Multi Node. RAC to Non RAC and RAC to RAC using Rapid Clone.
  • Managing and monitoring BPEL Component instances
  • Troubleshooting SSO issues.
  • Recovery of database from RMAN tape and disk backups.
  • Work actively on oracle features such as AWR. ADDM and ASH. Performance statistics collection and fine-tuning database
  • Implemented RMAN backup Solutions for Production and Cloned test/dev instances using RMAN production backups.
  • Running Autoconfig and fixing autoconfig related issues.
  • Configuration of workflow notification mailer for R12.1
  • Applying the Application of Security Patches, PSU, CPU, RDBMS Patches, Functional Patches, JDK upgrade and Jinitiator upgrade patches, isetup Patches and configuration.
  • Installation and upgrade of 12c/11g databases.
  • Utilize Oracle diagnostics tools like Explain Plan, SQL Trace,TKPROF and AWR to analyze timing execution plan for tuning . Also use TOP and VMSTATS to understand the impact on memory and CPU processes.
  • Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, Jinitiator and database)
  • Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing

Confidential

Sr. Oracle Applications DBA

Responsibilities:

  • Installed and Configured 12.2.0 with 12.1.0.2 database and upgrade Oracle application from 12.2.0 to 12.2.4 and migrate the database from 12.1.0.2 to 12.2.0.1
  • Installed and configured OBIEE 11.1.1.7 and integrating EBS R12 with Oracle Bi 11g
  • Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment
  • Installed configured OBIEE 11.1.1.9.0 , OBIA 11.1.1.9.0 , ODI 11.1.1.9.0 on Production Server
  • Expertise in Oracle Apps 12.2 Patching using ADOP
  • Administered and managed multiple instances like Production, Development and Test.
  • Executed OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
  • Migration of sunflower Application from Redhat to Sun Solaris
  • Experience in Cloning from Single node to Multi Node and Multi Node to Multi Node. RAC to Non RAC and RAC to RAC using Rapid Clone.
  • Performed complete Patch Analysis and application of Apps and DB Patches
  • Installed and configured Oracle Access Manager 11.1.2 and OID 11g. Integration of OAM/OID with 12.2 EBS to configure SSO.
  • Created Shell scripts to start and stop the OBIEE instances in Linux environments.
  • Monitor Workflow related services & Notification Mailers.
  • Creating and scheduling jobs on the Control-M tool in both Production and Test environments.
  • Integration of OAM/OID with OBIA and Sunflower Asset management tool
  • Troubleshooting Oracle Database issues reported by users and developers
  • Setup and administration of Oracle workflow notification mailer.
  • Installed and configured Oracle SOA Suite 12c components in Oracle WebLogic Server domains
  • Installed and configured sunflower Asset management for TSA agency
  • Installed and configured Apex 5.0
  • Installed and configured Mark view 10.2
  • Took care of Applications and Database performance tuning issues related to long running requests and locks.
  • SOA and WebLogic install and SOA configuration, deploying applications.
  • Implementation of SSL
  • Performed the user requirements and troubleshooting activities and resolved connectivity issues.
  • Implemented Oracle Applications upgrades, patches using various AD utilities.

Confidential, Sterling, VA

Sr. Oracle Applications DBA/Service Manager

Responsibilities:

  • Responsible for installations of oracle Applications R12/11i in single node & Multinode
  • Setup, Configuration, and Maintenance of Parallel Concurrent Manager
  • Implemented RMAN backup Solutions for Production and Cloned test/dev instances using RMAN production backups
  • Cloning oracle Applications instances both R12 and 11i instances with RAC to RAC and Multi node to Multinode as well as Non RAC and single node
  • Load Balancing Concurrent Processing tier -- PCP with 2 nodes
  • Load Balancing Mid-Tier web servers with BigIP Load balancer with 2 nodes Build
  • Cloned external DMZ for R12.2 and 12.1.3 Oracle Applications
  • Implementation of SSL
  • Creating Project Plans for managing major E-Biz downtime
  • Responsible for the installation and configuration of the following GRC modules. AACG PCG and CCG
  • Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, Jinitiator and database)
  • Upgrade WebLogic to 12c -- Configure WLS Cluster, deploy Code, maintain performance and best practices, monitor in Grid 12c
  • SOA and WebLogic install and SOA configuration, deploying applications.
  • Applying one-off fixes to Database Oracle Homes (both RAC and non-RAC) using Opatch utility
  • Automation of oracle application cloning from production to development instances
  • Applied oracle apps tech stack patches (10.1.2, 10.1.3, iAS, 8.0.6 MT tech stacks + 9.2.0, 10.2.0, 11.1.0.6 DB tier tech stacks), 11g/12c RAC fix patches using opatch
  • Applied product specific fix patches, family packs, maintenance packs -- all types of patches - adpatching
  • Proven experience in Oracle Business Intelligence and OBIEE Administration
  • Administer ETL and data warehousing applications and tools
  • Deployed various WAR, JAR, EAR and J2EE applications on managed servers and in clustered environment using Console or auto deployment scripts in stage and production .
  • Installed and configured Endeca
  • Integrated DEMANTRA applications with oracle Apps R12

Confidential, Rockville, MD

Sr. Oracle DBA

Responsibilities:

  • Installing and Configured 11g database and upgrade Database Version from 11.1.0.3 to 12c
  • Implementation and Migration of Non-Rac environment to 11g RAC with ASM on 2 node cluster for production systems.
  • Migration of 8i database to 11g database on Cloud Services using import and export Procedure
  • Installed and Configured Oracle Application Server 10.1.3.5 and Migration of Application Server from 10.3.1.5 to 11g Oracle Fusion Server
  • Deploying and maintaining Java Application on Oracle Application Servers
  • Implemented Security policies, roles, user password, object privileges across the oracle database environments (Dev/Prod)
  • Performing database backup, recovery and restore operations through dump files(imp.exp utilities) RMAN with Recovery catalog, cloning and developing Solaris scripts to Schedule Warm backup of online database systems in cronjobs
  • Effective Troubleshooting of database and performance problems
  • Applying Security patches on oracle products and interim patches for various bug fixes on database Products
  • Developed shell scripts and database data pump procedures for auto refresh development databases on daily basis
  • Set up configured and maintained Oracle Data Guard (primary and standby database) to ensure disaster recover, high availability and data protection
  • Recovered Successfully Production database from RMAN backups
  • Monitored the various database activities such backup, error logs space object, Performance user and session monitoring to ensure proper capacity and availability
  • Regular Change request meetings and interactions with multiple project managers to approve DBA Change request
  • Implemented automated backup strategy using the UNIX shell script
  • Responsible for Creating/rebuilding indexes, updating dictionary statistics and relocation of the database files to increase performance of database.
  • Provide timely support to resolve critical errors.

Confidential, Reston, VA

Oracle Applications DBA

Responsibilities:

  • Installed and configured 12.1.1 Oracle Applications with 11.1.0.7 database and upgrade oracle applications from 12.1.1 to 12.1.3 and upgrade of database from 11.1.0.7 to 11.2.0.3.0
  • Involved in upgrading Oracle applications from 11.5.10.2 to R12.1.3 and database upgrade from 9.2.0.5 to 11.2.0.3
  • Migrating single node Oracle E-Business Suite (Database & Application) to Multi node RAC.
  • Creating Custom Concurrent Managers and Assigning Work shifts to it.
  • Setup, Configuration, and Maintenance of Multi-node/Shared Application file system architectures.
  • Setup, Configuration, and Maintenance Discoverer.11g and integration with R12 Instance
  • Written/Modified shell scripts to monitor as needed and maintain the Oracle Applications database
  • Setup, Configuration, and Maintenance of Parallel Concurrent Manager.
  • Performed space estimation and calculation, application installation, performance, ‘memory tuning, server/database monitoring, configuration, and troubleshooting.
  • Perform and oversees activities related to day-to-day database maintenance and support including creating and monitoring backups, refreshing development/QA database as needed.
  • Performed the user requirements and troubleshooting activities and resolved connectivity issues.
  • Maintenance of users and system security on Oracle databases.
  • Work actively on oracle features such as AWR. ADDM and ASH. Performance statistics collection and fine-tuning database
  • Implemented RMAN backup Solutions for Production and Cloned test/dev instances using RMAN production backups.
  • Installed and Configured Multiple Confidential Web sphere application Servers. Deployed applications on Confidential Web sphere application Server including flash deployment on Web server using Interwoven open Deploy.

Confidential, Miami, FL

Oracle Applications DBA

Responsibilities:

  • Installed and configured 11.5.10.2 with 9.2.0.6 and Migrated the database from 9.2.0.6 to 10.2.0.2
  • Installed and configured 10g Grid control
  • Configured and scheduled RMAN tape backup in OEM for production and development instances and Scheduled Disk backup with Cronjob
  • Configured Shared APPL TOP
  • Monitoring 11g instances and Unix servers from 10g Grid control
  • Migration of Concurrent programs using FNDLOAD
  • Configured Data Guard (Physical) database for production and Development instances
  • Configured 10g Discoverer and Migration of reports using Discoverer
  • Migration of 11.0.3 production instance to 11.5.10.2
  • Applied patches on production and development with adpatch
  • Recovery of database from RMAN tape and disk backups
  • Automation of cloning using flex clone
  • Registering and troubleshooting printers
  • Installed and configured MYSQL Database Migrated MYSQL Server data to Oracle database
  • Moving data from external files to Oracle Database using SQL loader
  • Cloned 11i database instances from production to development and testing instances
  • Resolving user issues, problems and providing the system accessibility 24/7
  • Configuration of Single Sign On (SSO) for Oracle Applications 11.5.10.2
  • Provide 24/7 on-call database operational supports on rotation basis
  • Tuned the databases by working with developers to increase the performance
  • Performed analysis on existing production systems to enhance performance and solve existing resource contention issues.

Confidential, Bethesda, MD

Oracle Applications DBA

Responsibilities:

  • Installed and configured 11.5.9 with 9.2.0.3 database and upgraded database from 9.2.0.3 to 9.2.0.7.
  • Platform migration of Oracle application 11.5.8(Production) from HP Compaq True64 to Sun Solaris with export and import procedure.
  • Configured of Single Sign On (SSO) for Oracle Applications 11.5.9.
  • Conversion of 11.5.9 with 9.2.0.7 64-bit database to Real Application cluster (RAC) on Veritas Storage
  • Applied latest Oracle Critical Patches (Security patches).
  • Implemented RMAN backup and recovery for 10g database.
  • Installed and configured Prism and Platform migration of Prism from HP Compaq True 64 to Sun Solaris.
  • Installed and configured Sunflower Assets and platform migration of Sunflower Assets from HP Compaq True64 to Sun Solaris.
  • Installed and configured Ring Master APM and applied patches using Ring Master AP,
  • Maintained 11i database instances and copied (cloned) from baseline to development, testing instances
  • Converted oracle database from 32 to 64 bit.
  • Installed and configured 9IAS for Sunflower Assets.
  • Database administration includes creation of table spaces, adding data files monitoring alert logs, Periodical backups and database recovery as needed and managing security issues.
  • Recovery of database from critical situation or crash.
  • Troubleshoot problems with concurrent managers, Apache, Jserv processes, and database performance
  • Created and configured the Instances, databases, tablespaces/datafiles RBS, users and rolesschemas, tables and indexes.
  • Apply and document Oracle applications patches using Adpatch.
  • Tuning the database to handle peak loads and resolving the bugs and findings the workarounds for limitations.

Confidential, New York

Oracle Applications DBA

Responsibilities:

  • Installed and configured 11.5.7 with 8.1.7.3 database and applied maintenance pack 11.5.9 and upgraded the database from 8.1.7.3 to 8.1.7.4, from 8.1.7.4 to 9.2.0.3 and to 9.2.0.5.
  • Supported functional and technical teams for the implementation of oracle Applications
  • Capacity planning: Hardware (CPU, memory, disk, tape), Disk space utilization (file movement, purging, placement), I/O contention management, User setup and maintenance, Unix Kernel parameter setups & tuning.
  • Installation of new printers and configuring new styles for the custom invoice and check printing on all the instances
  • Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery and also used to move Oracle data from one machine, database or schema to another.
  • Upgraded Database and changed the Applications passwords
  • Create and maintain shell scripts to do hot and cold backup of the databases
  • Cloned 11i database instances from baseline to development and testing instances
  • Defined Menus, Function, Request Groups, Responsibilities. Installation of new printers and configuring new styles for the custom invoice and check printing on all the instances
  • Monitor Oracle Server and oracle Applications using OEM
  • Registered new Reports, Report sets, Custom forms and PL/SQL stored procedures using AOL.
  • Resolving user issues, problems and providing the system accessibility in 24 x 7 environment
  • Configured the discoverer 4i, created the business areas, secured the business areas and defined the secured rules for discoverer reports.

Hire Now