SUMMARY:

• 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 SKILLS:

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:

Confidential

Oracle Application DBA

Environment: Linux, R12.1.3

Responsibilities:

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

Confidential

Oracle Application DBA

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

Responsibilities:

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

Confidential

Oracle Application DBA

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

Responsibilities:

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

Confidential

Oracle Application DBA

Environment: Linux, E-biz 12.1.3

Responsibilities:

• 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

Confidential

Oracle Application DBA team lead

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

Responsibilities:

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

Confidential

Oracle Application DBA team lead

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

Responsibilities:

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

Confidential

Oracle Application DBA

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

Responsibilities:

• 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

Confidential

Lead Oracle Application DBA

Environment: H/w: Dell Power Edge 2600 O/s: Linux RHEL 3 S/w: Oracle Applications 11.5.9 Database: Oracle 9i Tools: TOAD, OEM

Responsibilities:

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

Confidential

APPS DBA

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

Responsibilities:

• 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

Confidential

ROLE: APPS DBA

Environment: H/w: Win compatible O/s: Win, Unix S/w: Oracle Applications 11i (11.5.7 and 11.5.9), SQL, PL/SQL, SQL LOADER, developer 6i, Oracle Workflow Tools: TUMS

Responsibilities:

• Design the presentation and approach
• Replicate the production environment with duplicate data for test up gradation.
• Perform test up gradation
• Design and review up gradation documents
• Design and development of test cases
• Co-ordinate onsite team for production oracle application up gradation