Senior Oracle Application DBA Resume

SUMMARY

I have 15 years of experience and extensive breadth of knowledge in Architecture, Installation, Configuration, Performance Tuning and Upgradation of Oracle Products (EBS, OTM, SOA, OBIEE, Demantra, Weblogic).

TECHNICAL SKILLS

Oracle Fusion Applications 11g
Fusion Middleware 11g ( Weblogic, SOA, OBIEE, IDM )
Oracle Applications EBS (R12, 11i)
Oracle Database 11g & 10g
Oracle Transportation Management 6.2.X & 6.1.X
Fusion Transportation Intelligence 6.2.X & 6.1.X
Oracle Demantra 7.3.X
Oracle Application Modules (Financial, HRMS, AP, AR, OM, VCP, WMS).

PROFESSIONAL EXPERIENCE

Confidentia

Architect

Responsibilities:

Install/configure OBIEE 11g with High Availability (HA)
Database 11g with 4 Node RAC
Upgrade OBIEE from 11.1.1.3 to 11.1.1.6
Upgrade DAC from 10g to 11g
Configure SSO with OBIEE 11g
Informatica from 8.6.1 to 9.0.1
Install/Configure SOA for HA
Integrate SOA with R12/OTM
Install ODI and Integrate with OBIEE

Confidential

Senior Principal Consultant

Responsibilities:

Architect & Install, configure Oracle Application R12/11i
Upgrade Oracle Application from 11i to R12 and R12.0.6 to R12.1.3
Architect & Install Fusion Middleware (Weblogic & SOA)
Integrate SOA with Oracle Application R12
AIA Integration with SOA
Install/Configure OBIEE 11g on High Availability (HA)
Install DAC 11g & Informatica 9.x
Install RAC 11g with 4 nodes
ODI 10g/11g Installation
Upgrade ODI from 10g to 11g
OTM 6.1.x & 6.2.x Implementation and support
Demantra 7.3.x Implementation
Demantra 7.3.x Performance Tuning
SSO/OID Integration with R12
Install OEM and Configure Management Pack for Middleware
ODI Integration with OBIEE 11g

Confidential

Senior Oracle Application DBA

Responsibilities:

Installation of Oracle Application 11i (11.5.9 & 11.5.10.2)
Database upgrade from 9i to 10g
Cloning of Oracle application from PROD to TEST & DEV
Stabilization & Documentation of DB Upgrade & refresh process covering all Customization.
10gDB for any performance analysis and SQL tuning.
StatsPack Implementation & performance tuning related work.
Troubleshooting of various database related issues.
Workflow setup and Performance Tuning
Performance tuning of various reports from different oracle modules mainly related to Pricing, quoting, order management, service contracts etc.
ASCP Implementation & Performance Tuning.
Backup and recovery using RMAN
SQL analysis and Tuning
Concurrent queue design to distribute the concurrent program load on different instances
Installation of GRID(OEM) and agents to monitor various instances
Oracle Discoverer installation and configuration
Performance analysis using tkprof, sqlt and statspack report.

Confidential

Oracle Apps DBA / Oracle Core DBA

Responsibilities:

Installation of Oracle Application 11i (11.5.7,11.5.9)
Managing Application Security, Monitoring Concurrent Manager, Printer Setup, Registering Customized Forms and Reports, Defining Flex fields and Profile Management, Maintain Database Space Management Using Oracle Alerts Events
Working with administration utilities like adaimgr, adadmin, adpatch, adctrl, adodfcmp, adrelink
Setup of Responsibilities, Menus, Request Groups, Profile Options, Custom functions, custom concurrent programs, custom application registrations
Cloning Of Oracle Applications From Production to Testing Environment Using Adclone
Backup the database using Veritas Netbackup with RMAN as well as hotbackup
Tuning the upgrade scripts by creating custom indexes, adding SQL Hints, rebuilding statistics, and trying out different options
Troubleshooting of issues in clients environments based on health check reports and OEM
Database Design, Sizing, Installation, and Deployment of Development, Testing, Production Databases Data Migration
Database Administration and Performance tuning.
Providing Backup and Recovery strategy and Data Archival policies.
Monitoring and Troubleshooting Oracle Database
For High Availability Configured the Standby database
Users and Security Management
Rebuilding objects in clean, safe and efficient way, providing it for database growth and performance improvement
Creating tables with partition concept and Maintaining large tables and indexes
Writing Shell scripts for various database management activities
Database Tuning Confidential database level using Utlbstat and Utlestat and Statspack

Confidential

Oracle Developer

Responsibilities:

Involved in developing Forms and reports and wrote Stored Procedure & DBA Activities.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship