We provide IT Staff Augmentation Services!

Delivery Lead Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • Instrumental in Upgrades of oracle EBS applications from 11.5.X to R12.1.X and from R12.1.X to R12.2.X, implemented Maximum Availability framework, Techstack migration, Addition of NLS Languages, RMAN implementation, Database Reorgs, Various Database upgrades from 9i - 11g-12c and strategic execution of initiatives to enhance productivity, quality, customer service, technology and performance.
  • Excellent working skills with Installation, Upgradation, DR Setup, Cloning, Patching, RMAN/ZDLRA/snapshot/nbc backup and Recovery, administering and tuning Application, Good troubleshooting skills.
  • Proficient in Planning and implementation of various high impact EBS Migrations projects, Datacentre movement projects globally and providing mentorship and coaching to the team members to accomplish measurable business process improvements.
  • Supported Advanced EBS Topologies: Multi node Shared APPL TOPs,Extranet, SSL and F5 Load Balancer.
  • Oracle EBS - OATM conversion from OFA, Converted the oracle EBS database from OFA to OATM with custom tablespaces.
  • Installation of Oracle Fusion Middleware Patch sets and configuration of OHS(Oracle HTTP server)
  • Supported Demantra,OBIEE,Webcenter,Config Snapshot,HVR, Appworx OAM Integrations.
  • Oracle SSO, OID, OAM 11g Administration.
  • OEM Implementation for Oracle EBS, Databases, and FMW.
  • Performance Tuning of Oracle Databases.
  • Performance Tuning of Oracle EBS.
  • Performance Tuning of Oracle FMW, WebLogic, and SOA Services.
  • Migrated databases to Amazon Web Services (AWS) Cloud
  • Migrated Oracle EBS to Amazon Web Services.
  • Experience on Oracle EBS migration (Lift& shift) to Oracle Cloud.
  • Automated end to end EBS R12.2 Clone process using OEM smartclone procedure and shell scripting.

PROFESSIONAL EXPERIENCE

Confidential

Delivery Lead

Responsibilities:

  • Responsible for quality standards, resource planning respective to deliverables and flawless deliveries of Oracle ERP applications Maintenance activities and upgrade activities of databases belonging to GE Corporate Services: HR systems, Capital Finance and Shared Services and Aviation Systems.
  • Involved in Upgrade of EBS applications from R12.1.3 to R12.2.4, R12.2.5, R12.2.8, R12.2.9 architecture.
  • Migrated GE-OHR from single instance to multi node RAC from scratch for clustering the database server to support the increased number of daily claim transaction volumes and high availability of the database system by enabling Load balance and Instance failover features.
  • Configured and implemented MAA architecture of EBS environments using SyncSplit replication mechanism and Physical Standby setup of databases and NAS application filesystem replication.
  • Co-ordinate Quarterly Release Security Patching and project migrations.
  • Managed Demantra, OBIEE, SPWA, Webcenter FMW applications.
  • Configured Oracle Enterprise Manager Grid control for monitoring to manage and automate the alerts based on thresholds.
  • Managed and administrated database and database applications 24x7 that include Oracle 10g/11g Databases with RAC (real application cluster) of ERP applications (R12.1.3), OEM Grid, High Availability, Data Guard, ERP Applications.
  • Defined Policy/Standards and process for the database changes migration model flow drafted for the production.
  • Implemented Informatica life cycle management and integrated with ERP systems for archiving and purging outdated data.
  • Managed the automation and digitization of cloning process.
  • Upgrading of Oracle RDBMS and Cluster CRS (cluster resource services) home with the oracle recommended patches and security alert patches
  • Managed team of on-site and offshore DBAs across global locations. DBA categorized of Administration, Application, Production, Operation, Change Management, On-call support and Optimization.
  • Preparing dash boards for weekly DBA calls, and participating in the weekly operation calls.
  • Planning and co-coordinating Oracle Critical patch implementation, Oracle Applications upgrade activities.
  • Performed OATM Migration of ERP instance
  • Re-org of fragmented database/tablespaces to optimize the space utilization and performance.
  • Managing CAB call with change management team and implementing the work orders.
  • Performance tuning of the queries which are impacting badly.
  • Application cloning from Multi node to single node and Multi node to Multi node.
  • Monitoring RMAN backups and restores and troubleshooting in case of any issues.
  • Periodically Co-ordinating the production database backups/restores on development servers using RMAN for cloning databases.
  • Migrated the EBS RAC database/Application from Legacy to EXADATA/Exalogic platform on Linux.
  • Integrated the 12.2.4 ERP with OAM and OID (SSO)
  • Add & Delete application nodes to existing configuration
  • WebLogic administration and addition of multiple managed servers
  • Upgrading JRE an JDK to latest certified versions
  • Install the latest AD & TXK patches, ETCC,weblogic and RDBMS patches under ADOP patching cycle.
  • Deploying the FWM Techstack patches
  • Upgrading the FMW webtier from lower versions to 11.1.1.9
  • Applied the latest EBS PSU/CPU patches on regular basis.
  • Working on implementing the OAM 12c for oracle EBS
  • Oracle 12.2.6 EBS migration to Oracle Cloud
  • Maintaining OAM /OID environment for oracle 12.2 EBS
  • Used ticketing tools like Service-Now, Support Central and Kintana.
  • Automated complete ERP(R12.2.x) application and Database clone using Smart clone procedure and shell scripting.

Confidential

Lead oracle EBS DBA

Responsibilities:

  • Managing the daily operations and coordinating with the client.
  • Participate in weekly meeting with GE Team to review project progress and planning downtime and activities like Patching, Migration etc.
  • Constant interaction with development teams for trouble shooting & performance related issues. Daily status report to lead Oracle DBA with information on the status of the database, the space utilization, extent information etc. Support customer and system data requirements by providing technical expertise and influence in the design and development, implementation, and maintenance of databases.
  • Involved in total life cycle of upgradation of OHR Oracle ERP application from 11.5.10.2 to R12.1.1 using staged appltop method.
  • Upgraded the Oracle E-business suit application from R12.1.1 to R12.1.3 version.
  • Implemented NLS languages (Russian & Dutch) in ERP application.
  • Upgraded the Database from 10.2.0.4 to 11gR2.
  • Migration of Tape backups from TSM to NBU.
  • Configured RMAN catalog on Oracle Application instances for backup and recovery.
  • Single point of contact from offshore team.
  • Rolled out SCM (Software Configuration Manager) on all instances.
  • DR setup, Support in offsite disaster recovery preparation, planning and testing.
  • Upgraded the JRE/JDK and JRE client plugin in Oracle ERP application.
  • Enabled Parallel Concurrent Processing for Oracle Application Instances and tested the failover of concurrent jobs on production application.
  • Planning and co-coordinating every quarterly released Oracle Critical patch implementation.
  • Upgraded the warehouse databases from 9i to 10.2.0.4 version.
  • Periodic RMAN cloning of oracle database and Rapid clone of oracle ERP application instances.
  • Migrated the databases from 32 bit to 64 bit on Linux platform.
  • Involved in swapping the warehouse load and reporting databases after full loads and restore the load databases from cold backup.
  • Performance effort involved in monitoring and dropping unused indexes.
  • Installed OEM agents on all servers and leveraged AMP on all application servers for monitoring the database and application targets.
  • Trouble Shooting Database Issues - Involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning using Oracle’s regular performance tuning tools like Explain Plan, SQL*Trace, TKPROF, DBMS STATS, STATSPACK, AWR, Data Dictionary Views etc.,.

Confidential

Lead consultant

Responsibilities:

  • 24/7 Production support cases and responsible for the maintenance of Oracle application as well as databases and supporting around 3000+ worldwide users and customers working in GE Industrial project(Security and Sensing ).
  • Administered the Oracle Applications instances 11.5.10.2 which are of Shared appl top with Multi node architecture (1DB Node + 4 internal application Nodes + 2 Extranet Nodes).
  • Application / Database cloning from PROD database on a regular basis
  • Involved in Application as well as RDBMS Critical Patch Updates (CPU) quarterly, Family pack, Mini Pack, Tech Stack Patching. Administering and maintaining Production Apps 11i instances, 24X7 Production Database Support and maintenance.
  • Worked on 11g and 10g RAC databases.
  • Installed E-Business suite single and multi-nodes on Solaris platform.
  • Enabled Autoconfig on 11.5.8 EBS environments and resolving AutoConfig issues during cloning.
  • Implemented shared appltop after upgrading from 11.5.9 to 11.5.10.2
  • Excellent Knowledge on AD Utilities and their usage.
  • Implemented parallel concurrent processing.
  • Purging unwanted request output and log files
  • Troubleshooting self-service web application issues.
  • Troubleshooting forms server, Apache server issues
  • Troubleshooting concurrent manager issues.
  • Performed Sysadmin tasks as per the requirement.
  • Worked with end users in resolving E-business Suite application issues reported by them.
  • User account management - creating users, disabling users, responsibility management.
  • Managing and Tuning concurrent managers for Production load
  • Oracle instance cloning activities and reconfiguration after refresh.
  • Installation and upgradation of application stack (Apache and forms home)
  • Load balancing across Apache, forms servers.
  • Implemented RapidClone procedures and streamlined cloning process
  • Monitoring and Following up TAR’s raised with Oracle.
  • Creation of Concurrent Mangers, Programs, and Request sets.
  • Troubleshooting of Concurrent Requests and Request sets.
  • Code Migrations (reports, forms, Concurrent programs and requests, Value sets, Logical apps rules migrations …etc.).
  • System Administration for Oracle Apps which includes creation and maintenance of Users, Responsibilities, Menus, Profiles, Concurrent Programs, Request Sets, Request Groups etc.
  • Integrations of all the changes into Production databases.
  • Proactive monitoring(BMC Alarms),Alert Monitoring, Backups, Performance Tuning,OEM and other critical activities
  • Vertex tax rates update Patching and upgradation.
  • Maintenance tasks (Customization of autoconfig templates,iStore setup, iPayment setups,Application Diagnostic tests, Tablespace management, creation of read only schemas…etc.).
  • Troubleshoot and resolve issues during cloning, patching and performance related issues.

Confidential

Oracle Application DBA / Oracle DBA

Responsibilities:

  • Upgraded Oracle EBS from older versions of 11i 11.5.7 to 11.5.9, 11.5.10 & 11.5.10.2
  • Enabled Autoconfig on 11.5.8 EBS environments and resolving AutoConfig issues during cloning.
  • Cloning of new instances from CRP2 .
  • Applying Database/Application Patches.
  • Creating custom applications and Installing Printers Creating New Environments/Databases as per client requests.
  • Involved in MLS patching.
  • Custom schemas/Application created and registered with apps.
  • 11i System Administration tasks like Creating Applications Users, Registering Forms, Menus, Functions, Responsibilities and Concurrent Programs.
  • Involved in major Code Migrations (Packages, reports,forms, Concurrent programs and requests, value sets …etc.) and registering with application.
  • Participating in weekly meeting with GE Team to review project progress and planning downtime and activities like Patching, Migration etc.
  • Administered workflow mailer services.

We'd love your feedback!