Oracle Database Production Support, Oracle Apps DBA role

Purnanand B

Oracle Apps DBA

****************@*****.***

Mobile no: 940-***-****

Summary:

Having 14 Years of experience in Oracle APPS DBA, Oracle DBA, Oracle Fusion Applications DBA with good hands on in administering of Oracle Database Tools, and Oracle Applications.

Profound knowledge in maintaining Oracle Exadata and Oracle Golden Gate environments.

R12.2 Development/Prod Upgrades from 12.1.3 to R12.2 and provided Prod/Test/Dev Support for R12.2. Upgrading databases 10g to 11g/12c,12c to 19c.

Worked on R12 Implementation and Support Project for Food Concepts Plc.

Specialized in Reducing the Downtime of Patching by following various methods and applying patches using Adpatch, Opatch and ADOP utility.

Expertise in the area of WebLogic Administration and Fusion Apps Domain.

Upgrading Oracle WebLogic server from 12.2.0.1 to 12.2.1.3 & 12.2.1.3 to 12.2.1.4.

Experience in WebLogic Cluster configuration. Experience in configuring Node manager to handle WebLogic start stop actions remotely. Managing and Administering WebLogic servers and deployments using WLS Console, EM Console, and command line utilities like wlst.

Extensive experience in Oracle E-Business suite applications (R12.2, 11.5.9 and 11.5.10) on Linux family.

Analyze and apply CPU/SPU and PSU patches released by Oracle every quarter.

Having through knowledge on Database Architecture

Experience in Autoconfig to change configuration in Applications.

Parallel Concurrent Processing configurations

Having through knowledge on Oracle Applications R12 Architecture and file system

Involved in installation, configuration of Oracle Applications R12.

Expertise in AD Utilities like Adadmin, Adpatch, Adctrl, Adsplice, Admrgpch, Adrelink, Adautocfg for Oracle applications

Good Knowledge on PCP Configuration, DMZ configuration.

Exposure working in RAC Environment.

Applied different types of patches with pre-requisites and post-requisites

Cloning the Oracle Database and Applications

Having exposure to Cross Platform migration using XTTS.

Taking different types of logical, physical, and RMAN backups at database level

Expertise in database backup and recovery management

Excellent Remote Systems Support and Troubleshooting Exposure. Performance Tuning Solution for Database and Application.

Experience in Enterprise manager grid control 11g,12c and configure Oracle Middleware technologies like OAM, SOA, BPEL with EM Grid Control. Experience in CRS, RAC & ASM.

Perform half yearly DR exercises for both database and applications in prod systems.

Involved in performing database refreshments as part of the production support activities and also handling customer escalations for various L3 and L4 database issues.

Perform Administrative tasks in Oracle Cloud Infrastructure (OCI) environment.

Knowledge in VPN Connect & Fast Connect, Object storage and file storage services usage in OCI.

Skills Profile:

Languages

SQL, Shell

Hardware

HP, SUN, IBM, DELL

Applications

Oracle EBS 11.5.10, 12.0.6, 12.1.3, 12.2

Database

Oracle RDBMS 9i, 10gR2, 11gR2, 12c, 19c

Operating Systems

LINUX, Sun Solaris, HP-UX, AIX

Tools

High Availability Services

Advanced Configurations

Application Monitoring

MW Technologies

Tuning Tools

Patch application

Toad,OEM, Sql Developer

RAC, CRS, ASM, Data Guard

Shared APPL TOP, PCP, Load Balancing, DMZ Setup, SSL

OEM, OAM, WebLogic Console, FMW Control

FMW 11g, WebLogic, SOA, Forms & Reports

Tkprof, Explain Plan, SQLtrpt, SQL*Trace, Awr, Addm

adpatch, opatch, bsu and ADOP utility

Professional Certifications:

Oracle Cloud Infrastructure 2021 Architect Associate

Oracle E-Business Suite 11i Applications Database Administrator Certified Professional

Oracle Database Administrator Certified Associate

Oracle Database Administrator Certified Professional

Experience:

Oracle.

Client: British Telecom, Lands o Lakes, National Lotteries.

Project Description: R12 Support and Maintenance and 11i Fusion Appl.

Job Role: IT Senior Consultant

Duration: Oct 17 –Jun 23

Responsibilities:

Worked with the senior leadership to help prioritize, plan, and coordinate both short- and long-term systems strategy and implementation.

Worked on R12.2.1.3 and R12.2.1.4 versions of Oracle Applications and database related activities. Successfully completed Application upgrades from 12.2.1.3 to 12.2.1.4 and upgraded associated databases to 12c.

Upgrading databases from 11g to12c, and 12c to 19c.

Worked with Functional and development teams to resolve several application, code, forms, and concurrent program issues.

Worked on 11g, 12c WebLogic fusion applications.

Providing RCA (Root Cause Analysis) for severity 1 issues.

Specialization in understanding AWR/ASH/ADDM Reports, trace files and accordingly tuning the SQL as required.

Configured DATA GUARD setup for production database in different datacenter for maximum availability and provided support to have prod and standby in sync all the time.

Applied patches on R12.2.X environments with Opatch,BSU utility and worked on to resolution for various issues encountered.

Apply various patches to Database like CPU Patches, patch sets, DST patches etc.

Installed, Configured and Administered ORACLE Web Logic Server 12c in various environments.

Configuring, monitoring, and managing the Oracle database 12c, EM Console. Deploying, Tuning, and configuring Oracle 11g,12c environment for high availability.

Troubleshooting and Monitoring the Performance by tuning JVM heap size and garbage collection. Configured of JDBC connections, data sources and troubleshooting to fixing up problems. Handling all the aspects of Installation, Configuration, Clustering, Deploying, Troubleshooting Maintenance and Performance Tuning of Web Logic Server.

Setting up multiple domains, including Administration Servers, Managed Servers, Machines, Node managers in different cluster environments. Deploying JAR, WAR and EAR Applications on various targeted clustered environments. Involved in Configure JDBC Connection Pools, Multiple Pools, and Data Source.

Installation and setup of Oracle Golden Gate. One way and two way Replications

Provided 24/7 on call support for production servers during weekdays and weekends.

Worked on fixing major DR issues and resolved DR lag issues.

Involved in performing database refreshments as part of the production support activities and also handling customer escalations for various L3 and L4 database issues.

Computer Science Corp.

Client: Beckman Coulter Inc.

Project Description: 11i and R12 Support and Maintenance

Job Role: DBA

Duration: Feb14 –Oct 17

Responsibilities:

Providing Production support (24/7) and troubleshooting user issues

Cloning of Oracle Applications using Cold/Rman/Snap Backup

Exposure on advanced Configurations like PCP, Load Balancing and Shared APPLTOP.

Knowledge in Installation, Configuration and administration of CRS, RAC, ASM & EM Grid Control.

Excellent Remote Systems Support and Troubleshooting Exposure.

Applied CPU patches as per oracle Release

Proven ability to work under pressure of time constraints and to prioritize assignments necessary.

Doing Pre and post patch analysis and documentation

Worked on DR Rebuild using PROD Snapshot

Using TKPROF utility generating text file for the trace file

Executing the Action Plans and Updating the SR's

Enabling the Notification Mailer

Monitoring Concurrent requests and troubleshooting.

Experience in Autoconfig to change configuration in Applications.

Interact with Functional and Technical teams to understand their technical queries/issues related to Database and Applications provide assistance in resolving them.

Database backup restore and recovery.

Tuning the database using database utilities like ADDMRPT, SQLTRPT.

Troubleshooting effectively on application and database issues.

Working with Support to resolve the issues.

SR creation and Monitoring.

OSI Consulting

Client: Robbin Bro's, Dendreon,REI,BDA

Project Description: ETAS Support and Maintenance

Job Role: DBA

Duration: Jan12 –Feb14

Responsibilities:

Providing Production support (24/7) and troubleshooting user issues

Did Analysis on 11.5.10 extended support by using patch wizard

Cloning of Oracle Applications using Cold/Rman/Snap Backup

Weekly bounce for PROD Database and Health Check

Applied CPU patches as per oracle Release

Doing Pre and post patch analysis and documentation

Worked on DR Rebuild using PROD Snapshot

Resolving the Tickets and updating in EDTS Ticketing System.

Downloading and Uploading LDT’s

Using TKPROF utility generating text file for the trace file

Executing the Action Plans and Updating the SR's

Enabling the Notification Mailer

Space Management by shipping and clearing archive log files

Creating and Managing users by granting and revoking certain privileges as per business needs

Creating profiles, roles and assigning them to users for giving read only access to super users

Taking different types of logical and physical backups

Restoring and recovering Databases with available backups

Used different types of utilities like expdp,impdp

OSI Consulting

OSI Consulting

Client: Hawaiian Telecom

Project Description: Cross-platform migration using XTTS.

Job Role: DBA

Duration: August 2011 – December 2011

Summary:

Performing a platform migration with XTTS may reduce downtime compared to performing a migration using a full database export and import, but does so with increased complexity and requires a greater testing effort. Oracle database cross platform migration using XTTS reduces complexity and testing effort and gives potential gain in downtime requirement

Responsibilities:

Automated Target Database creation with all components that are installed in source by using custom scripts.

Minimized the data files conversion time by providing the parallelism.

Validated the Target Database after migration using dynamic script.

Handled objects owned by Users in SYSTEM/SYSAUX tablespaces

Developed dynamic SQL to synchronize Missing Grants and Sequences.

Automated scripts are developed so that any DBA with minimal knowledge can perform whole migration independently

Client: Food Concepts Plc.

Project Description: R12 Implementation and Support Project

Job Role: Associate DBA

Duration: August 2010 – July 2011

Responsibilities:

Cloning of Oracle Application through Rapid Clone

Involved in Capacity planning.

Creation of custom concurrent managers for long running and high priority requests

Successfully implemented the backup policy for Food Concepts.

Enabling the Notification Mailer

Configured Monitoring scripts for pro-active maintenance.

Monitored the data growth during data load period and increased the space proactively to overcome Tablespace issues.

During the Implementation cycle created the Custom Top

Created the Read Only Apps Schema

Checking for errors in alert logs and trace files

Automated some of database jobs and scheduled the RMAN Daily backup

Refreshing the applications and database using control files and RMAN backup

Registering data definitions and templates in Applications using XML Administrator responsibility

Creating users and assigning the required responsibilities using System Administration responsibility of Oracle Applications

Changed database from No-Archive log mode to Archive log mode

Space management by adding and resizing the datafiles

Clearing locks caused by blocking inactive sessions and killing the spinning forms sessions

Performing the database, application service bounces as required

Applying patches using adpatch

Maintaining applications file system like re-link applications programs, copying files to destinations, generating message files, product jar files, form files, report files, and graphics files using adadmin utility

Create applications custom environment file to include custom directories

Submitting the purge concurrent requests

Maintaining availability of Concurrent Managers using system administration module scheduling

OSI Consulting

Client: Robbin Bro's, Dendreon, SMART,REI

Project Description: ETAS Support and Maintenance

Job Role: Associate DBA

Duration: August 2009 – July 2010

Responsibilities:

Providing Production support (24/7) and troubleshooting user issues

Did Analysis on 11.5.10 extended support by using patch wizard

Installed and worked on Maintenance wizard

Applied CPU patches as per oracle Release

Doing Pre and post patch analysis and documentation

Performing the health checks

File system space monitoring

Workflow Notification Mailer Configuration and monitoring

Apps Sysadmin activities.

Code Migrations (form and report migrations and Action Plan)

Daily Health Checks

Executing the Action Plans and Updating the SR's

Enabling the Notification Mailer

Patching (DB Patching and Application Patching)

Creating profiles, roles and assigning them to users for giving read only access to super users

Education:

Completed B.Tech(EEE) from JNT University.

Contact this candidate