Senior Oracle EBS Administrator

HARIKA KOLLA

US CITIZEN

Phone: 732-***-****

Email : ad5dsj@r.postjobfree.com

SUMMARY:

18+ years of IT experience with proven success in architecting and delivering reliable and scalable systems for enterprise solution in a variety of areas, such as Oracle Database, Oracle e-Business suite (EBS), Oracle ASCP, Demantra, Oracle WebLogic 12c, Oracle Application server 10g, Oracle Enterprise Manager Grid Control, APEX and OBIEE.

Experienced leadership qualities in architecting, implementing and maintaining Oracle Maximum Availability Architecture and to provide integrated business solutions, using oracle best practices with Oracle Supercluster M7 and Oracle Exadata Database Machine and provide the most comprehensive high availability solution.

Extensive experience on Linux Red Hat, SUN/Solaris, IBM/AIX, HP-UX and Windows supporting Oracle Databases on RAC and Non RAC versions from 19c, 12c, 11gR2, 10g, 9i, 8i and Oracle Applications versions latest release of Oracle Applications R12.2, R12.1.3, 11.5.10.2, 11.5.9, 11.5.8 and its modules including AP, GL, AR, PO, FA, Order Management (ONT), Oracle Inventory (INV), WIP, BOM, HRMS, Procure to Pay (iProcurement), iSupplier, iStore, iExpense and Self-Service Web Applications.

Engaged with IT leadership to develop multi-year technology and product roadmaps to ensure 'one vision' for physical datacenter migration and execution.

Collaborate with IT leadership team in mapping the current and future state requirements and how IT can shape possible Oracle solutions to fit their needs.

Architected and implemented server consolidation to reduce IT costs and increase control, resulting in savings of over $1.1 million in hardware, operating cost, energy costs and database/software licenses.

Consistently being recognized for providing high level of customer satisfaction and leadership.

Managing multiple projects and worked across high performance teams throughout the full life cycle implementation of the projects.

Drive implementation of best agile practices and ensure that delivery adheres to agile practices maintained by the company.

Headed the cross-platform database migration effort which was key initiative to the business unit growth and modernization.

Worked in partnership with the leadership and audit teams to establish database security structures and adhere to SOX/PCI compliance.

Capacity planning and monitoring the cost of data storage by implementing archive and purge policy.

Skilled in ERP upgrade, migration of applications and database to various releases above said all the activities handled, managing & leading teams for running successful process operations & developing procedures, service standards for business excellence.

Highly Experienced in Oracle Applications E-Business Suite (EBS) Applications 11i and R12 Installations, configuration, Cloning, Patching, Upgrades, and Maintenance using AD and other Utilities.

Experience as Oracle Applications DBA providing support to many Production, Development, Test instances comprising of some of the more complex and challenging environments through 11i and R12 releases.

Oracle Application Upgrades from 11.5.10.2 to R12 and R12.1.3 to R12.2 in Linux and HP-Unix.

Experienced and proficient with 12.2 E-Business Suite ADOP online Patching.

Expert in Cloning using ADCLONE, Rapid clone, DUALFS and ADCONFIG

Experience in Installing and Configuring active modules being GL, Financials, AP, OM, INV, PO, AR, FA, MRP, ONT and MFG.

Upgrade of databases from Oracle 9i to 10g, 10g to 11g and 11g to 12c, 12c to 19c

MWA setup and administration

Upgrade of EBS from 12.1.3 to 12.2.8

Expertise on Cloning of RAC clusterware and Database, Oracle Apps 11i/R12 Single node/Multi node, Oracle Apps 11i/R12(EBS) with RAC and ASM

Experience in platform migrations from HP-UX to Linux and Solaris to Linux for 11i/R12 applications and databases.

Installing and Upgrading Oracle Applications 11i to R12.

Expertise on Backup and Recovery of Single and RAC Databases using RMAN (Oracle Recovery Manager).

Thorough understanding of EBS services management and startup, shutdown troubleshooting.

Expertise in Oracle 11g RAC installations and configurations.

Experience in working on Oracle enterprise manager 10g, 12c Grid control.

Administering Database Instances and Cluster Databases in RAC environment.

Expert in installing and administering Weblogic and SOA suit.

Oracle 11g Fusion Middleware Services

Provisioning complete IDM 11g Suite for Fusion Apps

OAM, OIM, OID, OVD & ODSM

Oracle 11g WebLogic Services

Oracle Enterprise Manager 12c,13C Cloud Control

Good knowledge on Service Oriented Architecture (SOA), BPEL, OBIEE.

Experience in ASM setup and administration.

ASM setup and installation for 11g, 12c databases with 11g, 12c GRID ASM installation.

Good experience of Oracle PL/SQL, Procedures, Triggers, Cursors and Functions.

Expert in performance tuning.

Experience with NAS and SAN solutions to handle very large databases.

Experience in many system development life Cycles (SDLC), from requirement development, architecture design, and testing with post implementation revisions.

Proficient in Database Administration activities such as Upgrades, Patches, TAR-Support, Cloning and with monitoring tools like Grid control, third party software and Oracle Application Manager (OAM).

Expert in Backup and Recovery.

Good working Experience on Sun Solaris, Linux, HP-UX and AIX.

Exposure to different Hardware like Compaq Server, IBM Server, Sun Fire v1280, Sun Fire v480, HP Blade Servers (BL e-class), DELL, EMC Storage and Fire wire

Worked On-Call providing 24*7 Support for production databases.

Very good capabilities in understanding the business process functionalities, leading to gaining excellent domain knowledge.

An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management and significant experience working with steering committees and other project managers.

TECHNICAL SUMMARY:

RDBMS: Oracle 8i, 9i, 10g, 11g and 10g/11g/12C/19c RAC, MS Access

RDBMS Tools Oracle Enterprise Manager (OEM), SQL*Loader, RMAN, SQL Trace, TKPROF, Stats pack, TOAD

ERP: Oracle E-Business Suite R12.2, R12.1.3 11i

Databases: Oracle 9i/10g/11g/12C RAC/19c

Operating Systems: Oracle Enterprise Linux 3/4/5, Red hat Linux 3.0/4.0/5.0, Sun Solaris 5.6/5.9/10,

UNIX IBM AIX, Exadata

Tools: KINTANA, TOAD, OEM, OAM, SQL*Plus, SQL*Net, SQL*Loader, RMAN

Middleware: Fusion Middleware -10g AS, Weblogic

Education: Master of Computer Applications from Andhra University

PROFESSIONAL EXPERIENCE:

WellsFargo Jan 2021 – Present

Oracle Database, Oracle E-Business Suite 121/12.2, 12c/19c RAC Database and Oracle (Performance Tuning, Backup and Recovery and OEM Grid Control).

Responsibilities:

Lead proof of concept efforts for database upgrades to 19c for EBS/SAP databases.

Gathering requirements, designing solutions for a very high transaction volume

Provide technical leadership and mentoring to Oracle DBA and application team members and provide input to performance evaluation and development planning.

Architected and successfully implemented 12c & 19c Real application cluster for large scale e-Business suite and non e-Business suite database implementations.

Lead the team and efforts for quarterly DR activity

Managed and coordinate On-Site and Off-Shore teams, work as One team fulfilling customer/project needs.

Carried out multiple upgrade projects in the areas of Database, Oracle e-Business suite, Demantra, Oracle ASCP, WebLogic, Oracle Heterogeneous connection, Oracle Enterprise Manager, Oracle Application server 10g and other third-party tools which includes upgrade of 12C database to 19c with EBS 12.2.6

Participated and led the new technology initiatives like Oracle Supercluster, Exadata, enterprise backup recovery and Disaster recovery solutions

Upgrade 12C database to 19c with EBS 12.1.3

Reorganized and implemented change management process to reduce the number of outages and helping the business to achieve their strategic goals. Provided support for Incident Management and prioritizing tickets and task related to Projects.

Upgrade of EBS from 12.1.3 to 12.2.8

Prepare Final Presentations to Application Owners and Business users on alternate solutions

Headed the cross-platform database migration effort from Linux to Solaris. It was a million-dollar project which was key initiative to the business unit growth and modernization. Project took 12 months moving more than 40 servers and Terabytes of data resulting in saving of $1.1 million annually.

Implemented hot backup cloning solutions with reducing production downtime of 23 hours.

Installed 12CR1 Clusterware and ASM to upgrade from 11gR2.

Train the team and share best practices. Guide the team in preparing SOP’s for the maintenance activities.

Migrating the 11gR2/ 12C databases with EBS 12.1/EBS 12.2* from Linux hardware to Exadata.

Managed and implemented Infrastructure and capacity planning using Oracle Maximum Availability Architecture (Oracle MAA) on Oracle Supercluster M7 using Oracle Exadata Storage and ZFS Storage environment. Patching EBS 12.2 (ADOP online patching) with database 12C on Exadata.

Applied Ad and TXK patches for EBS R12.2.

Managed and worked on Cross Platform migration of Oracle Database 12c from Linux to Oracle Sun OS ver. 11 on Oracle Supercluster M7 environment using Transportable Tablespace and Data pump to reduce overall downtime for 14TB database.

Implemented SSL for R12.2 and R12.1 E-Business Suite.

Provided Performance issues resolutions for EBS12.2* for 12C databases on Exadata.

Supported large databases ranging 15 TB to 85 TB in size.

Canon USA, Inc. NJ April 2013 – Dec 2020

Position: Sr. Oracle Applications DBA/Oracle DBA

Responsibilities:

Lead the migration of e-Business Suite Database and Application Server from Sun Solaris Servers to Red Hat Linux/Dell Servers on 2 node RAC server and Multi-Node Application Server using shared filesystem.

Creating and maintaining all databases required for development, testing and production usage.

Upgrade Oracle Grid Infrastructure 12c to 19c environment on 2 node cluster.

Managing Oracle Cloud Infrastructure, Patching Database and SOA environment in Oracle Cloud environment.

Installation of HP “PPM Project and Portfolio Management” application, also known as “ITG – IT Governance” or “Kintana”.

Performing Upgrades, patching, troubleshooting and performance tuning of HP PPM.

Upgrading HP PPM Kintana application from 7.5 to 9.30, 9.31, 9.32 and 9.42

Performs ongoing tuning of the database instances.

Plans and implements backup and recovery of the Oracle database.

Installing Oracle 11i, R12 Applications E-Business suite.

Installed 11gR2 Clusterware and ASM to upgrade from 10gR2 to 11gR2.

Installed and configured RAC setup for 11i (EBS) on 11gR2 RAC and ASM.

Specify users and user access levels for each segment of database.

Enforces and maintains database constraints to ensure integrity of the database.

Applied patches on RAC databases and Clusterware.

Cloning of RAC PROD instance to TEST and DEV (involves cloning CRS, ASM, database and applications) using ADCONE utility and ADCFGCLONE on single, multi and RAC to RAC cloning.

Modify existing databases and database management systems or direct programmers and analysts to make changes.

Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.

Control’s migrations of programs, database changes, reference data changes and menu changes through the development life cycle

Patching of Oracle Fusion Applications in TEST, DEV, QA & PROD environments.

Cloned/Upgraded 11gR2 RAC and ASM with 10gR2 data using data pump’s and went live on new hardware

Monitoring and Managing the Fusion Apps R8 & IDM using OEM 12c, Exadata Database 11g RAC servers.

Working on weekend maintenance Activities like planned maintenance and unplanned issues handling

Installing and configuration of OEM 12c Cloud Controls

Interacting with client’s business teams during new releases and other vital activities

Performing Continuity of Business exercise by interacting with various teams at the client’s site.

Outage Management, Instance Management and Release coordination

Starting and stopping components and environment

Fusion Apps User Management using OIM

Configure security in Fusion Apps.

Deploy customizations in Fusion Environment.

Monitor Fusion Apps and IDM environments.

Manage log files and diagnostic information.

R12.2.4 environment production support (iStore) integrated with the R8 Fusion application

Standalone IDM environment support integrated with the R8 Fusion application

Verifying the status of applications

Assists with impact analysis of any changes made to the database objects.

Upgrade of databases from Oracle 9i to 10g and 10g to 11g. 11g to 12c.

Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. Perform reviews on the design and code frequently to ensure the site standards are being adhered to.

Performs database re-org as required to assist performance and ensure maximum uptime of the database.

Troubleshoot problems regarding the databases, applications and development tools.

Applying patches to 11.5.10.2, R12 versions of e-business suite.

Implementation, Troubleshooting and Maintenance of Concurrent managers and Parallel concurrent Process (PCP)

Working on Oracle enterprise manager 10g Grid control.

Administering Database Instances and Cluster Databases in RAC environment.

Troubleshooting and Administration of Oracle 9i/10g Application Server.

Performing system administration, user management, applications, opens interfaces, alerts and workflows maintenance.

Implementing High Availability solutions with Oracle 10g RAC, Standby (Datagaurd).

Creating and managing primary objects like Custom tables, Procedures, Packages, Triggers,

Alerts, views, Indexes, user accounts, roles, grants and performing day-to-day operations.

Scheduling of oracle database backup using RMAN.

Maintenance of Oracle Applications 11i, Upgraded Discoverer 4i to 10g. Implemented Shared Appltop.

Implemented securities using Roles, Privileges and Grants.

Developing, registering custom forms and reports for Oracle Apps.

Planning and administration of backup and recovery strategies.

Applied Critical patches, one-off, Family pack patches on DEV, TEST and PROD, used OPATCH for applying database patches

Implementing SYSADMIN tasks.

Daily database and Application health checks.

Developed scripts to Monitor Table space issues

Responsible for analyzing the need for applying the patches to the Application database.

Applying patches using AD patch.

Maintaining the system using AD utilities.

Managing configuration of the system using AUTOCONFIG.

Managing job queues

Checking Alert log, Apache log, and concurrent manager log files for issues and monitoring

Managing Concurrent Managers and its operations like starting, stopping the concurrent managers

Created Data Groups, Responsibilities and users as part of system administration.

Supported the Senior DBA in resolving performance related issues in Production environment.

Created and managed table spaces, monitored the data files space, resizing and adding new data files.

Involved in cloning the instance to test system.

In depth knowledge and experience with Rapid Install, Rapid Clone, adpatch, adadmin, adsplice and adctrl utilities for Oracle Applications.

Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.

Created new application messages and then generated message file for application.

Created new concurrent managers, Purged concurrent requests table.

Worked closely with users’ group to ensure timely implementation of an ERP.

Provided application support to users and created a log of all the problems with solutions for future reference.

Cisco Systems – San Jose CA Feb 2011 – March 2013

Position: Oracle Apps DBA

CISCO Systems Inc. is an American multinational corporation headquartered in San Jose, California, United States, that designs, manufactures and sells networking equipment. Cisco has more than 60,000 employees and annual revenue of US $43.0 billion.

Responsibilities:

Installing Oracle Applications 11i/R12 on single node and multimode.

Cloning Oracle Applications instances both R12 & 11i.

Converting Non-RAC (standalone database) to RAC along with GRID/CRS installation.

Building physical standby database with Data guard broker and Observer setup.

Database up gradation from 10g to 11g.

E-Business Suite upgrade from 11.5.10.2 to R12.1.3

Support development team for 10g and 11i (EBS) upgrades.

Oracle Applications Table Space Model (OATM) migration

Working closely with System administrators, developers, technology Stack team and Server tech team.

Creating documentation during project planning, project execution and project maintenance phases.

Installed Discoverer 10g and integrated with Oracle E-Business R12 instance.

Installed Weblogic server and 11g Application server components Forms, Reports and discoverer 11g.

Monitoring user’s activity using sign-on Audit reports.

Cross Platform migrations from Solaris to Linux for 11i/R12

Capacity planning/Management (Space/machine load/network)

Resolving system errors, disk space problems.

Creating project plans for managing major E-Business downtime.

Installed Weblogic and SOA in a project.

Auditing Apps databases.

Monitoring table space usages.

Administration and maintenance of Oracle Apps 11i(EBS) (11.5.10 ATG RUP4) with 10gR2 RAC

Configured PCP (parallel concurrent processing) in Multinode RAC environments

Registered printer in Oracle Applications and configuring Pasta printing.

Customizing autoconfig templates according to environment requirements.

Upgrading JDK versions from 1.4.2 to 1.5 and 1.6 and JRE/Jinitiator to 1.3.1.28

Involved in ASM setup and installation for 11g databases with 11g GRID ASM installation.

Tuning concurrent managers, defining work shifts, configuring specialization rules, defining primary and secondary nodes for PCP setup.

Using AD utilities for maintaining the application systems (adpatch, adctrl, adadmin, adrelink, adsplice)

Day to day troubleshooting of the environments (part of team maintains 30+ Apps instances – Version of Oracle R12 in all flavors of UNIX, having all versions of databases -9i/10g/11g, size of which ranging from 20GB to 3TB’s) which includes fixing all the issues coming in them and supporting various components of Oracle Applications – Forms, Apache, Concurrent Managers, DB, Listener

E-Business Suite patching

Weekly refreshing test environments from production.

Securing Oracle Applications by periodically changing Apps and schema passwords.

Compiling forms/pll, DB invalids, creating DB links.

Have setup scripts for Oracle database backup, Restore and Cloning using RMAN. Also tested recovery scenarios.

Responsible for regular interaction with UNIX teams to troubleshoot OS/Hardware issues.

Cloning from production to SIT, DEV instances.

24*7 support on environments.

Giving training to other team members and create knowledge base/ Document.

Ingram Books – Nashville, TN Feb 2009 – Jan 2011

Position: Oracle Apps DBA

Ingram Content Group Inc. is part of the long tradition of successful companies built by the Ingram family of Nashville, Tennessee. Dedicated to helping content reach its destination by providing a broad range of physical and digital services to the book industry, Ingram has been a partner to publishers, booksellers, librarians and educators for more than four decades. As a leader in distribution, print-on-demand and digital solutions, Ingram provides librarians and booksellers with immediate access to the largest selection of trade books, e-books, interactive textbooks, audio, magazines, and other book-related products in the industry. Publishers rely on Ingram as a key provider of demand-driven printing, digital, and marketing solutions.

Responsibilities:

Working as oracle Applications and database management professional in production support for oracle 11i/R12 EBS and 9i/10g/11g databases.

Involved in regular day to day activities like health checkups of oracle database and EBS financial systems, backups progress, resolving performance issues.

Responsible for maintenance of 11.5.10 (EBS) upgrade assessment instances.

Installed and configured RAC setup for 11i(EBS)

Applying applications and database patches.

Manage and executing daily DBA tasks for offshore installation, administration and maintenance of 10gR2 (10.2.0.3) RAC Database with 11i/12i (EBS) in a multi-tier architecture

Scheduling jobs and monitoring oracle databases by using oracle grid control technology.

Database up gradation from 9i to 10g.

Responsible for maintenance of various developments, test and 10gR2 upgrade instances.

Cloning database instance from primary database.

Cloning of RAC PROD instance to TEST and DEV (involves cloning CRS, ASM, database and applications) using ADCONE utility and ADCFGCLONE on single, multi and RAC to RAC cloning.

Managing databases for various applications like ipage, EDI, TIBCO, EBS financial systems.

Migrating cron jobs to 10g grid control.

Trained on IBM UDB DB2 databases from IBM and also worked on IBM UDB DB2 databases.

Worked on Info Sphere replication server.

Installed APEX 3.2.1 and upgraded to 4.1

Configured Ingram digital custom dashboard using modplsql on EBS R12 instance.

Implemented 10g features.

Supported Financials and applied all related patches

Upgraded database from 10.2.0.2 to 10.2.0.4 by applying required patch set.

File system maintenance.

Created monitoring alerts in OEM 10g Grid

Setting new threshold values based on the alert history and business requirements

Taking cold backups.

Upgraded OEM agent from 10.2.0.2 to 10.2.0.5

Migration of single instance 9i and 10gR2 database to 10gR2 RAC (10.2.0.3) with/without ASM

Maintenance of two nodes RAC 10gR2 (10.2.0.3) with 10gR2 streams

Configured Concurrent managers and Apache web server for applications (EBS)

Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of Systems Admin

Performing Applications System Administration tasks like Registering new forms, reports, Fixing Printer Issues, Setting Profile Options, Creating/Assigning Responsibilities, Creating APPS Users etc

Extensive experience on Oracle Enterprise Manager (OEM) 10g Grid control.

Interact with Applications team and Open systems team.

Provided 24x7 on call support.

Oracle, Hyderabad, India June 2006 – Jan 2009

Position: Oracle Applications DBA

Worked as a team member of Oracle On demand supporting about 500 customers.

Responsibilities:

Worked in 24x7 Production Oracle Applications Administration.

Involved in both managing and supporting all Production, Development and Test instances of Oracle databases and Oracle Applications

Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of Systems Admin

Maintaining the Oracle Applications Systems including Oracle databases, Middle tier IAS Applications.

Working closely with Functional/Developers and helping them in issues

Management of Users, Roles and Privileges.

Patching, cloning, using AD utilities like adpatch, admrgpch, adadmin, adclone.

Administration and configuration of Oracle HTTP web server.

Performed database upgrade from 10g to 11g.

Extensive knowledge in working with the tools like OEM, Export/ Import, Stats pack, SQL* Loader, SQL Analyze, TKPROF, Explain Plan, and Oracle Supplied DBMS_PACKAGE.

Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.

Administration of Oracle ERP applications version 11.5.10.2.

Monitoring and handling concurrent manager related issues.

Registration of new oracle Apps users and system printers.

Regular monitoring of alert log file on day-to-day basis.

Database and application cloning from production to test instances.

Single node and multi node installation and administration of Oracle EBS 11i and R12 on test instances.

Supported AP, AR, GL, HR, Financials, and Advanced Supply Chain Management and Mfg modules on Linux.

Monitoring the instance statistics and tuning the database to improve performance.

Applying patches for enhancement and fixing bugs using Adpatch, Opatch.

Supported HRMS and applied all HRMS related patches

Handling Tars

Worked on code migrations through kintana tool.

Production Assessment Tests and maintained to the global standards

Tuned the slow running concurrent requests

Define New Concurrent Managers

Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of sysadmin activity.

Compilation of custom forms and libraries.

Registering the new Forms, Reports, pl/sql scripts as concurrent programs as part of system administration activities.

Working knowledge of Kintana to migrate Concurrent programs, Responsibilities, Menus and custom packages.

Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations

Monitoring tablespace usages

Compiling forms/pll’s, DB invalids, creating DB links

Changed the Memory structures of the database based on performance ratios

Daily monitoring and checking the Background Dump File (alert SID Logs) and User Dump Files for errors.

Implementation of Oracle E-Business Suite 11i/R12 Architecture.

Production support for Oracle Applications 11.5.10.2/R12 and database administration including oracle 10g.

Troubleshooting the Applications issues and performance problems.

Worked on Oracle Application Server 10g Release 2 (10.1.2.0.2)

Database Backup and crash/Recovery.

Worked on Non-RAC and RAC database.

Checkout CRS status and Administration of RAC instances using SRVCTL utility.

Administrating Applications using AD utilities.

Created logical Storage Structures (table spaces) as per requirement

Cloning Oracle Applications 11i instance using Rapid clone and from multimode to single node instance.

Performed various database (10.2.0.3) and Oracle Applications 11i (11.5.10.2) Cloning and Patching.

Good understanding in data modeling, entity-relationship modeling

Addressing various teams with daily issues on concurrent programs, forms and apache of Oracle Applications 11i (11.5.10.2)

Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one offs Patches etc).

Installed and Upgraded Oracle e-Business Suite 11i(11.5.10) to R12 with AP,AR,GL, HR, Financials, Advanced Supply Chain Management and Mfg modules on Linux.

Upgraded Oracle Applications 11i (11.5.10.2) environment to the latest certified Oracle Developer 6i patchset (patchset 18).

Registered customized applications, Apps. Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.

Planning and Administration of backup and recovery strategies.

Finding the long running and most resource using processes, updating the responsible team and taking appropriate actions.

Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user

Created new application messages and then generated message file for application.

Created new Concurrent managers, purged concurrent requests table and knowledge in implementing PCP

Handled regular cleaning of unwanted table from the database after confirmation from developers’ team and freeing the extra space.

Supporting oracle applications 11.5.10 CU2 production systems of size 3.5 Terabytes. 4 Node RAC with 16 node mid-tiers. 8 internal and 8 externals with SSL supported configuration. It includes DR site of same configuration.

Installation of R12 and Support

Creating Users, Adding Responsibilities

Defining Responsibilities, Menu’s.

Creating Concurrent requests/sets and managing.

Patching production, development, stage and test environments

Cloning Oracle Apps prod to dev and stage environments

Handling production Crisis calls – Tier 3 support and finding the RCA

Stress test worked with Test Engineer and evaluated the performance

Workflows and WF mailer maintenance, administration, daily support for users and analysts through OAM usage.

Apps Printer registration, types, styles and driver’s setup.

Involved in configuring DMZ setup for external applications

Performed DB patching, troubleshoot issues/errors/incidents and collaborate with Global Oracle support for bugs & issues resolution with SRs and personal research.

Backing up apps system using RMAN backup

Patching multiple appltops and handling patching issues

Knowledge in creating monitoring alerts in OEM 10g Grid

Setting new threshold values based on the alert history and business requirements

Tuning applications

Working on CPU patching using customized scripts.

Handling Concurrent manager PCP issues

Patching and administering RAC nodes

TAR management with Oracle support

Basic shell scripting for the database and application monitoring

Making configuration changes and running autoconfig in all the external and internal mid-tiers

UNIX Shell scripting to simplify the day-to-day activities

24x7 Production Oracle Applications Administration

Maintaining production, development & test databases and applications.

Performing Health Checks for Oracle Application services like Form Server, Report Server, Concurrent Manager to ensure availability at specific times.

Good knowledge on Oracle applications 11i

Contact this candidate