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.

We provide IT Staff Augmentation Services!

Client Services

Job Seekers

Visa Sponsorship