We provide IT Staff Augmentation Services!

Oracle Applications Dba Resume

OBJECTIVE:

Provide unique and focused design and excellent quality results as a consultant working with Oracle e - Business Suite, Oracle Database and Oracle Application Server technologies

EXECUTIVE PROFILE:

  • With over Twenty four years of extensive and diversified technical experience in Information Technology industry of which, over 15 years of consulting experience in a variety of Oracle software and customer environments, over six years as a trainer (Instructor) and over four years in software development using Oracle products
  • With wide, varied and deep experience of Oracle’s internals, architecture and features, on various versions of Oracle products, Performance Tuning, implementing and maintaining Real Application Cluster (RAC) and GRID, Oracle Application Server as Oracle Applications DBA / Technical Architect
  • Experience includes I/O design for performance and troubleshooting on various UNIX / Linux Operating Systems and clustering tools
  • Best practices and long term plan being followed makes me a unique and a capable candidate for lead and key roles in Installations, Upgrade, and Performance Tuning
  • Technical skills include database management and administration, relational database design and implementation, capacity planning, benchmarking and mentoring.
  • I have been an implementer and also played lead roles on numerous projects, and involved in post implementation support and technical workarounds. Having played the roles as Trainer / Developer / Designer, I am comfortable with the programming concepts. In short, I have been an Applications Architect
  • With in-depth knowledge of result-oriented troubleshooting in Oracle Database, E-Business Suite and Oracle Application Server, I have been a customer-satisfied consultant
  • The long experience has given me the opportunity to work with various Operating Systems (Sun Solaris, HP-UX, AIX, Linux) on a variety of hardware providing me with the deep knowledge of them
  • Being part of the team in building successful proposals for fresh installs and upgrades, defining the hardware and other system requirements based on the implementation needs and along with manpower planning for various projects both for Private and Public sector. In short, been a Solution Provider for various projects
  • Consistently produced high quality work results under time and cost constraints by leading heterogeneous teams of varying sizes
  • Quickly assume a productive lead role on any project and also provided Technical / Team Leadership to various clients.
  • Efficient problem solving and reasoning skills on issues with innovative technical know-how is a specialty
  • Team / Project Management with Leadership Capability to manage resources and to achieve the goals on time, Conflict Resolution capability, with excellent communication, interpersonal and organizations skills makes me the candidate.
  • Managed teams of size between 12 and 30 members on various projects and as Consultant Manager

TECHNICAL SKILLS:

Databases: Oracle RDBMS (5.x - 12c), Oracle 9i AS, 10g AS, Web Logic Server

Operating Systems: Oracle Applications 10.7 SC, 10.7 NCA, 11.0, 11i (all releases), R12, R12.1, R12.2 Solaris, HP-UX, AIX, Linux

Methods: SSADM, AIM, EMM

CLIENT PROJECT EXPERIENCE:

Confidential

Oracle Applications DBA

Responsibilities:

  • Analyzed and implemented PCP for e - Business Suite instances
  • Also, I am the primary DBA / Apps DBA for troubleshooting performance and data issues on these databases. A few of these Databases are on RAC
  • I was also responsible for migrating code to various databases and also the DBA / Apps DBA for Production migration and maintenance
  • Requirement Analysis / Patch Analysis was also performed by me for CPU and various other patches as and when necessitated
  • Installed and implemented Golden Gate, documented the process and monitored and maintained it
  • Installed 12c DB with container and pluggable DB's and migrated the container DB to pluggable DB
  • Installed Oracle Grid Control 12c, documented the agent deploy and monitored non-Production Databases
  • Installed Oracle e-Business Suite R12.2 and applied the patchset to make it R12.2.2 on a single node OEL

Confidential

Oracle Applications DBA

Responsibilities:

  • More particularlyTrouble shooting, issue resolution, performance tuning of Oracle Databases (RAC and non - RAC), Oracle Applications, WebLogic and other Oracle products
  • Configuring Oracle Grid Control for backup and recovery
  • Using Oracle and third party tools in issue resolution and reporting

Confidential

Oracle Applications DBA

Responsibilities:

  • Implemented 11g Grid Control and deployed configured agents on various VM servers
  • Configured RMAN thru Grid Control for backup and recovery
  • Troubleshoot and resolved many day - to-day issues and documented them for future
  • Designed, implemented, documented and monitored DR with EBS on 11g DB
  • Administrating Weblogic server 10.3.3 which includes installation, application deployments, Domain Creation with templates, cluster servers management, nodemanager and troubleshooting
  • Integrated 3rd party applications like More4Apps with Oracle R12
  • Defined and implemented SOX guidelines for various clients

Confidential

Oracle Applications DBA

Responsibilities:

  • I was called in to, Perform an upgrade from R11i to R12.1.3 along with OATM migration
  • Documented the OATM migration and the upgrade process with comments on issue resolution for further upgrade iterations

Confidential

Oracle Applications DBA

Responsibilities:

  • I was involved in Upgrading the Oracle e-Business Suite from 11.5.10.2 to R12 (12.0.6) on Linux RAC with Oracle 10g DB
  • Implemented Oracle Time and Labor along with Oracle Federal Financials
  • Test 11g R1 RAC install for learning and purpose of their DBA’s on a Linux server
  • Provided recommendations on Single Sign-On and Identity Management processes and implemented it
  • Installing E-Business suite 12.1.3 with Database 11.2.0.3 and latest Technology stack (10.1.2.3 and 10.1.3.5) including post product specific patches
  • Environment planning for Gold, Development, Configuration, Conversion, system Testing, Integration Testing and UAT serving multiple projects and releases
  • Having strong skills in Performance tuning and troubleshooting issues caused by very high concurrency. Tuned multiple queries and reduced the execution times from hours to minutes
  • Integrated 3rd party applications like MarkView and Vertex with Oracle R12

Confidential

Technical Architect

Responsibilities:

  • Initially I went into this client to Stabilize and maintain the Oracle R12 (12.0.4) e - Business Suite application on Linux VM Ware (both the DB and the Apps Server) with the DB version being 11g R1
  • Upgrade 12.0.4 to 12.1.1 with 2 other languages along with Database upgrade from 11gR1 to 11gR2 on a VM Ware guest OS.
  • Implemented Oracle HRMS, SCM, EBS Tax along with Oracle Financials
  • Implement 10g and 11g Grid Control for performance monitoring and tuning
  • Planned, implemented and documented Data Guard for EBS 12.1.1 with 11g DB
  • Tuning JVM and memory settings for garbage collection
  • Responsible for managing Development and Production environments containing Databases, E Business Suite and Middleware and Architecting database solutions and delivering multiple projects with availability, scalability, adaptability and security features meeting the business needs
  • Administrating Weblogic server 10.3.3 which includes installation, application deployments,
  • Domain Creation with templates, cluster servers management, nodemanager and troubleshooting
  • Integrated 3rd party applications like Hyperion and Taxware with Oracle R12
  • Defined and implemented SOX guidelines for various clients

Confidential

Technical Architect

Responsibilities:

  • I was responsible for Upgrade re - implementation of Oracle Applications 11.5.9 to 12.0.6 on a single node RAC
  • Architect for OBIEE and its integration with Oracle Applications
  • Provided recommendations on Single Sign-On and Identity Management processes and implemented it
  • Installed and supported UPK
  • Integrated 3rd party applications like Hyperion, Maximo and Vertex with Oracle R12
  • Assisted the client in HP Load Runner with R12

Confidential

Technical Architect

Responsibilities:

  • Upgraded the R12.0.1 to R12.0.4
  • Initially the software installed on a single node server then migrated the DB to ASM and the converted it to RAC
  • The E - Business Suite product families like Financials, SCM and OM was implemented
  • I was also involved in performance tuning the server and the software
  • Integrated 3rd party applications like Hyperion and Markview with Oracle R12

Confidential

Technical Architect

Responsibilities:

  • Implementing Oracle Financials with Financials Hub ( Confidential ) and Enterprise Asset Management apart from maintaining the Oracle Benefits and related modules that were live
  • This was three projects running concurrently and I was the point person for Technical Architecture with modernizing the backup and recovery
  • Implemented Disaster Recovery and also instance / server management
  • Managed 24 Oracle Applications instances, of which 7 where are on RAC on 3 node cluster
  • Oracle Financial Hub ( Confidential ) which was in a separate instance from the main production, hence we had to maintain a pair of instances and clone / patch them in tandem and keep them in sync
  • Integrated a host of 3rd party applications like Hyperion and Taxware with Oracle E - Business Suite 11i (11.5.10)
  • Assisted the client in HP Load Runner with 11i

Confidential

Technical Architect

Responsibilities:

  • I was responsible for the technical architecture and maintenance of the instances for Proof of concept for Oracle Federal Financials, Supply Chain and also Order Management product families
  • I was leading a team of 3 Apps DBA s. Provided recommendations on Single Sign - On and Identity Management processes and implemented it
  • Laid down the strategy for backup of Oracle databases and maintained the instances

Confidential, Florida & Texas

Technical Architect

Responsibilities:

  • I was involved in installing 10g CRS, RAC Database on HP Hardware with HP Service Guard as the cluster software
  • My job role also involved applying HP - UX, HP Service Guard patches
  • After the RAC installation, I performed various testing scenarios involving hardware and software components
  • Implemented 10g Streams and monitored it for the electoral database to maintain the history of changes for electorates
  • I was assisting the DBA team to build and implement best practices for their Global single Instance (GSI) implementation of Oracle Financials and Lease Management
  • Co - ordinated the DBA team for assisting a team of offshore developers in India, near shore developers in Memphis and users
  • The Apps DBA team was involved in day-to-day upkeep of the e-Business Suite applications and also involved in patching, cloning and tuning these applications
  • Provided recommendations on Single Sign-On and Identity Management processes and implemented it
  • Migrate the similar database from Sun Solaris Operating system into these Linux servers
  • Responsible for cloning, patching and performance tuning this instance apart from migrating tables from the data warehouse database into the 11i e-Business suite

Confidential

DBA Team Lead

Responsibilities:

  • Assisted ASP DBA team with maintenance, upgrades, patching, cloning and backup / recovery of Oracle Federal Financials
  • Responsible for capacity planning and for setting up and enforcing performance budgets through a combination of developer, code reviews, tuning and architectural recommendations
  • Architected solution for data warehouse using Streams technology and for Disaster Recovery using Data Guard and Veritas Volume Replicator
  • Worked on migrating a single instance 1.2TB database from Sun Solaris to a two node Real Application Cluster instance with OATM on IBM AIX. PCP was configured for handling concurrent processing
  • Designed and monitored stress tests to identify and resolve performance bottlenecks
  • Assisted in the migration effort from one ASP to another. This involved O/S, storage and data center migration
  • Assisted prime vendor on implementing efficient application setups for users, responsibilities and job scheduling and to evaluate various third party tools to assist application and database administration
  • Led effort to Benchmark system at full load at the IBM - Oracle competency center
  • Set and implemented audit guidelines and monitored and reported the guideline violations if any to the upper management

Confidential

Technical Architect

Responsibilities:

  • I was involved in Defining technical architecture for implementing Order Management and CRM products of Oracle E - Business Suite
  • Upgrading Oracle Applications from 11.5.3 to 11.5.6 and then to 11.5.8 (Financials, HRMS, Order Management and CRM)
  • End-to-End Performance tuning and load testing using Mercury s Load Runner
  • RMAN strategy, planning and implementation
  • Import and export of Oracle Applications for uniform segment size and automatic segment space management
  • Migrating middle tier from HP-UX to Linux (30 machines)
  • Implement SSL for Apache based connectivity
  • Configuring the hardware load balancer (Net Director)
  • I was involved in technical audit of the Oracle Applications along with various components encompassing it
  • Indentify and suggest remedies for Hardware and Operating system bottlenecks
  • Indentify and suggest remedies for network bottlenecks
  • Performed database and e-business suite tuning
  • Suggesting steps and also laying down a template for future performance tuning and monitoring of the various subsystems

Confidential

Technical Architect

Responsibilities:

  • Involved in upgrading the Oracle Applications 11.5.4 to 11.5.8 - Financials
  • Transfer of knowledge in best practices, cloning and maintenance
  • Documentation of the upgrade process and issues to resolve in integrating the various 3rd party products
  • Involved in upgrading the Oracle Applications 11.0 to 11.5.9 - Financials, VCP, ASCP and MSC/Warehousing
  • Documentation of the upgrade process and issues to resolve with best practices to follow
  • Transfer of knowledge in best practices, cloning and maintenance
  • Initially involved in performance tuning the Oracle Applications ATP process
  • Later, called in to lead and perform the following:
  • Upgrade and migrate the Oracle Applications 11i from Sun Solaris to HP - UX
  • Performance tune the various product families used (Financials, HRMS, Supply Chain and CRM)
  • Design the disk subsystem for optimal performance
  • Transfer of knowledge in best practices and cloning
  • Laid down the procedure for backup and recovery process

Confidential

Oracle Applications DBA

Responsibilities:

  • Upgraded the Oracle Applications 10.7 to 11.5.8 on a IBM AIX operating system. The size of the 10.7 database was 280 GB
  • Performance tuned the upgrade process and brought it under 40 hours
  • Knowledge transfer of cloning and best practices in maintaining the Oracle Applications
  • Assisted in tuning the AIX operating system
  • Performance tuning of Oracle Applications and the HP - UX operating System
  • Coordinated with Oracle product development to fix the performance issues of the product (Order Management)
  • Knowledge transfer of best practices and cloning process

Confidential

Technical Architect

Responsibilities:

  • Installed Oracle Applications 11.5.5 and upgraded it to 11.5.7 for Oracle HRMS product family
  • Performance tuned and also assisted in cloning of Oracle Applications
  • Knowledge transfer to the in - house DBA
  • Implement SSL for both Apache and Forms
  • Configuring the hardware load balancer (Load Director)
  • End - to-End Performance Tuning
  • Cloning of Oracle Applications
  • Knowledge Transfer to the client Apps DBA s and remote support
  • Migrate Oracle Applications 11.5.2 from HP-UX to IBM AIX
  • Upgrade Oracle Applications 11.5.2 to 11.5.8

Confidential

Technical Architect

Responsibilities:

  • Infrastructure and Apps DBA team lead
  • Lead a group of 2 other Oracle Applications DBA s
  • Performance tuning of Oracle Applications 11i - Financials and Order Management
  • Upgrading Oracle Applications 11.5.5 to 11.5.7
  • Configuring the software load balancer for round robin connectivity
  • Installing Oracle Applications 11i - HRMS and performance tuning and also upgraded Oracle Applications 11.5.5 to 11.5.9
  • Oracle Consulting was brought in to perform a health check and assist on the upgrade of an E-Business suite implementation on AIX
  • Assisted the DBA team to develop a patching strategy to reduce downtime and make it more efficient
  • Identified and resolved a variety of issues related to performance and availability on the Concurrent Processing, Forms and Database tiers
  • Worked with the functional and development teams to architect a high performance data warehouse solution
  • Helped design backup and cloning procedures
  • Oracle Consulting was bought in to diagnose the health and suggest fixes for an E-Business suite implementation on HP-UX and EMC Symmetrix
  • Developed standards and processes for the DBA staff for better control of the performance and manageability for the implementation
  • Implemented processes and scripts to monitor and measure performance in the middle tier and the database

Hire Now