We provide IT Staff Augmentation Services!

Oracle Application Dba Resume

PROFILE

  • As an experienced professional, in a reputed organization I would like to utilize all my previous experience related to technology and critical decision making. I would also like to lead a team and display my leadership qualities.
  • Oracle certified professional in 8i/9i/10g.
  • 12+ years of total experience as an Oracle Apps DBA on various platforms.
  • Managed global DBA teams in US, UK and India.
  • Extensive experience in leading teams for implementation, upgrades, cross platform migration and maintenance/support project for 11i and R12.
  • Strong interpersonal skills to scale up the team to meet the challenges such as troubleshooting, debugging and resolving software related issues.
  • Experience in implementing RAC, Data guard for high availability and Grid control for monitoring and administration.
  • Hands on experience on developing tools for custom needs, automating repetitive tasks
  • Excellent Management Skills to coordinate work between team members and to interact with outside team members to resolve project specific issues.
  • Experience in most major Oracle Applications Modules with recent relevant experience in Financials, HRMS, Workflows, Order Management, and CRM modules such as iProcurement, iStore. I have acquired skills related to using Oracle’s Open Interface tables for conversions.
  • High degree of skills in Performance Tuning, RMAN, JVM balancing, DMZ Configuration, Parallel Concurrent Processing, and Disaster Recovery Architecture planning, Cloning, patching .
  • Handled various projects - R12.1.2 upgrade, E-biz HPUX to LINUX migration, 11g,10g RAC implementation, Shared Appl-top implementation, OLM configuration and SSL implementation
  • Skills in Quality Assurance testing utilizing Mercury Interactive’s Load runner
  • Good experience in Discoverer configuration and load balancing, App server cloning, OBIEE environment installation and configuration, Application express configuration .
  • High level of skill in programming in PL/SQL, Oracle Forms, Oracle Reports, sql*loader, and Pro*C and a moderate level of skill in HTML, Java.
  • Strong project management skills and effective team building skills to bridge different departments within the IT organization.
  • Familiar with regulatory compliance (HIPPA, HSPII) and industrial IT standards and best practices.
  • Excellent communication skills and have always established a good working relationship with peers

TECHNICAL EXPERTISE

RDBMS - Oracle 11g, 10g, 9i, 8i, 8, 7 | MS SQL |

ERP & Applications - Oracle E-Business Suite R12 | 11i | 11.0.3 | 10.7 | Demantra |

Application Servers - Oracle Weblogic | Oracle iAS | Apache | Websphere

Middleware - Oracle ESB/SOA/BPEL Suite | Oracle ODI

Reporting - Oracle OBIEE | Discoverer

Cluster Services - Oracle CRS | IBM HACMP | Veritas Cluster Services

Automation - Oracle Grid Control | Appworx | Control - M | Kintana Application

Operating Systems - IBM AIX | RH/Oracle LINUX | Sun Solaris | HP UX |Windows

Storage Architectures - emc BCV | Oracle ASM | Netapp | Hitachi HDS | IBM DS

Scripting - SQL & PL/SQL | UNIX Shell

Other Tools - BMC-Patrol | REMEDY | Spotlight | TOAD | Quest Re-orgs | Kintana

SDLC Expertise - System Analysis and Architecture Plan | Requirements Analysis |

Data Modeling | Performance Tuning | Change Management

PROFESSIONAL EXPERIENCE

Environment: Linux, R12.1.3

ROLE: Oracle Application DBA

Responsible for the following project deliveries

  • DB upgrade from 11.2.0.2 to 11.2.0.4
  • Discoverer 11g setup with Active data guard database.
  • Production support
  • On-call

Client: Confidential

Environment: AIX 7.1, R12.2, PIM PDH

ROLE: Oracle Application DBA

Set up environment for Product Data Hub with installing and configuring R12.2 2.3 node environment. This is to hold product information from various other applications as a central repository. This project to comply with latest FDI regulations.

Client: Confidential .

Environment: Linux, E-biz 12.1.3 with 3 node RAC,11g SOA, ODI, OBIEE,12c Grid, OEDQ, PIM PDH, OCH/MDM, Demantra, Vertex, Kintana

ROLE: Oracle Application DBA

Confidential is the most influential company in the gaming industry, Japan's third most valuable listed company, with a market value of over US$85 billion. As of 2010 Confidential has sold over 565 million hardware units and 3.4 billion software units., Confidential translates to "Leave Luck to Heaven".

  • Confidential implementing Order management modules on top of HR implementation.
  • Architected, installation, Configuration, supporting E-biz instances and Integrated SOA gateway solutions.
  • Worked on Master Data Management solutions such as OCH and PIM PDH
  • Resizing Tables, Creating AQ tables for PIM outbound infrastructure
  • Configured Business Events
  • Supported various data inbound activities for item, item category, item catalog category, item operational attributes, item user defined attributes
  • Performance tuning - Gathering stats, creating index and tuning memory settings for optimal performance
  • Formulated code migration procedure for EBS,SOA and UCM and Demantra applications
  • Troubleshooting
  • OBIEE server installation and configuration.
  • Vertex installation and configuration on tomcat server.
  • Active DataGuard for Production EBS and the Read-Only Standby
  • Developed & Formulated Cloning steps for EBS, FMW Application Suites. nTier-Single-nTier Solutions.

Client: Confidential

Environment: Linux, E-biz 12.1.3 with 3 node RAC and 11g Grid

ROLE: Oracle Application DBA

Confidential, Travel and leisure industry leader wants to implement Oracle financials for their global foot print. And the project is being carried out in multiple phases whereas first phase is going live soon followed by Peoplesoft financials retirement, affiliates and Hotel collect implementations

  • Support implementation tasks such as working with development team to get their tasks going and get the infrastructure in place.
  • Fine tuning the process around Apps DBA activities such as automating cloning, patching and all sorts of maintenance activities
  • Participating in project cutover plans. Validate and refine DBA tasks in the cutover plan.
  • Supporting and maintaining 5 node application with 3 node RAC monitored by 11g grid infrastructure.

Client: Confidential

Environment: Linux, E-biz 12.1.3

ROLE: Oracle Application DBA

At this position, responsible for Global Financial Systems maintenance and support

  • Support recently upgraded R12 (12.1.3) instance with financial modules. It is four application node with active standby instance.
  • Working on other initiatives like ACMP implementation along with grid installation, High availability architecture implementation
  • Support activity extends upto 100+ non-EBS databases that includes database creation, cloning, recovery and standby creation, failover and monitoring for space allocation
  • Participating in pilot projects which are at design phase like exadata and RAC.
  • Implementation Support for Oracle SSO integration with EBS R12

Client: Confidential

Environment: HP UX Itanium, E-biz 12.1.2, 11.1.0.7, Kintana

ROLE: Oracle Application DBA team lead

At this position, responsible to lead the the team of 5

  • Managing five member team for production support and various projects.
  • Production support, Test and development instances with patching, Cloning, Monitoring
  • Upgraded existing 11i instance to R12.1.2 version by following R12 implementation methodology
  • Hardware migration from PA RISC to Itanium (HP UX) using data guard to minimize downtime.
  • Two node RAC implemented for production system using data guard to minimize downtime.
  • Formulated Code Migration Procedure.
  • Developed & Formulated Cloning steps for EBS nTier-Single-nTier, RAC-RAC and RAc-non RAC Solutions.
  • Analyzed & Implemented Quarterly CPU Patch cycles for EBS.
  • High availability architecture implementation for R12 instance for disaster recovery.
  • Data Guard implementation for DSS reporting.
  • Implemented contracts module and helped on data conversion.

PROJECT: Confidential

Client: Confidential, CT

Confidential is the premier provider of global relocation and workforce development solutions serving the corporate, government and membership organizations

Environment: H/w: IBM O/s: AIX,Windows S/w: Oracle Applications 11i, Oracle 10g Tools: Oracle Grid control, Modules: AP,AP, PA CRM modules

DBA for Oracle applications, 10g databases. Responsibilities include daily maintenance review, Patching, Cloning, Optimization, disaster recovery planning and testing and custom software database installation support. Working as a team member with other DBA's to ensure 24 hour x 7 day a week support of all corporate databases.

ROLE: Oracle Application DBA team lead

  • Lead the team of 4 to support oracle 11.5.10.2 instance which caters Finance, Manufacturing and CRM modules
  • We take care of patching, backup/recovery and maintenance support of all ERP instances
  • We are responsible for reproducing the production issues and deriving solutions
  • We are also responsible for architectural changes and certifying any changes before it goes to production.
  • Am responsible for all the team lead activities like resourceing the team, Client interaction, user interaction and coordinating discussions with vendors.

PROJECT: Confidential

Client: Confidential, MA

Environment: H/w: Dell Power Edge 2600 O/s: Linux RHEL 4,HPUX,Windows S/w: Oracle Applications 11i, Oracle 10g(RAC) Tools: Oracle Grid control, Quest tools(Spotlight,FogLight,TOAD), HP Data protector, Load runner Modules: AP,AP, GL, HRMS, CRM modules

DBA for Oracle serving oracle applications,10g databases. Responsibilities include daily maintenance review, Patching, Cloning, Optimization, disaster recovery planning and testing and custom software database installation support. Working as a team member with other DBA's to ensure 24 hour x 7 day a week support of all corporate databases.

ROLE: Oracle Application DBA

  • Support Oracle Application 11.5.10.2 with Financials, HRMS and CRM modules
  • Implemented 1+ TB 2 node 10g RAC along with HPUX to Linux migration
  • Implemented Shared APPL TOP along with HP UX Linux migration
  • Assisted Oracle Application R12 up gradation on assessment, design phases.
  • Performed database builds, clones, DB patching, and e-business suite patching
  • Participated on various small scale projects like CPU patching, DR drill, Quantum upgrades, Discoverer upgrades, Load balancing, parallel concurrent processing, VTL backup.
  • DMZ configuration
  • Worked on oracle grid implementation

Hire Now