We provide IT Staff Augmentation Services!

Oracle Application Dba Resume

CT

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’sLoad runner
  • Goodexperience inDiscoverer 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.
  • Oracle Enterprise Manager grid(OEM) configuration for various databases and application with ACMP plugin.
  • Oracle BI applications (procure& Spend Analytics) - installation and configuration.
  • Familiar with regulatory compliance (HIPPA, HSPII) and industrial IT standards and best practices.
  • I have 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 | KintanaApplimation

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 | Oracle Enterprise Manager 11i,12C

SDLC Expertise: System Analysis and Architecture Plan | Requirements Analysis | Data Modeling | Performance Tuning | ChangeManagement

PROFESSIONAL EXPERIENCE

Client: Confidential

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
  • Oracle Enterprise Manager(OEM) 12c configuration for Dev,Test and prod databases to centralize monitoring of enterprise wide databases
  • Configured OEM for space management and setup thresholds for monitoring
  • Installing ACMP plugin with OEM for Application monitoring.
  • Discoverer 11g setup with Active data guard database.
  • Production support
  • SSO Implementation

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 informations from various other applications as a central repository. This project to comply with latest FDI regulations.
  • Planning and developing POC for 12.1.3 to 12.2.4 instance.
  • Documentation and training client resources.

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 extendsupto 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.
  • Twonode RAC implemented for production system using data guard to minimize downtime.
  • Formulated Code Migration Procedure.
  • Spend analytics BI application tool installation and configuration.
  • Oracle Enterprise Manager 11i configuration.
  • 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.

Client: Confidential, CT

Environment: IBM, AIX,Windows, Oracle Applications 11i, Oracle 10g, Oracle Grid control,AP,AP, PA CRM modules

ROLE: Oracle Application DBA team lead

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

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.

  • 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.

Client: Confidential, MA

Environment: Dell Power Edge 2600, Linux RHEL 4,HPUX,Windows, Oracle Applications 11i, Oracle 10g(RAC), Oracle Grid control, Quest tools(Spotlight,FogLight,TOAD), HP Data protector, AP,AP, GL, HRMS, CRM modules

ROLE: Oracle Application DBA

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.

  • Support Oracle Application 11.5.10.2 with Financials, HRMS and CRM modules
  • Implemented 1+ TB2 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

Client: Confidential, TX

Environment: Dell Power Edge 2600, Linux RHEL 3, Oracle Applications 11.5.9 Database: Oracle 9i, TOAD, OEM

ROLE: Lead Oracle Application DBA

Lead offshore DBA for 3 member team and supporting Oracle Application 11.5.9

  • Support Oracle Application 11.5.10 with 10g RACwith Financials, manufacturing
  • Upgraded 11.5.9 to 11.5.10 with shared APPL TOP and 2 node 9i RAC to 10g RAC.
  • Performed database builds, clones, DB patching, and e-business suite patching
  • Assisted the DBA team on initiatives on refining cloning process, automating post cloning steps, simplifying hot backup option, developing monitoring tools using PL/SQL and shell scripts.

Client: Confidential

Environment: H/w: Win compatible O/s: Win, HP-UXS/w: Oracle Applications 11i (11.5.8), SQL, PL/SQL, SQL LOADER, Oracle Forms 6i, Oracle Reports 6i. Tools: TOAD, X MANAGER, SAM

ROLE: APPS DBA

Project Description: Finance modules (GL, AP, AR, FA) implementation.

  • Capacity planning
  • Installation of Oracle Application R11.5.8 on HP-UX with RAID configuration with India Localization (IN60103D).
  • Performed sysadmin responsibilities like user creation, assigning responsibility,Setup Audit Trials, printer configuration, Security settings, concurrent manager/program configuration
  • Developed backup scripts, cloning methods and trained users

Hire Now