7 Plus Years of Oracle Applications database administrator with 11g RAC experience in 11i and R12 Implementations and Post Production Support projects.
Upgraded from 12.1.3 to 12.2.4,.Install and configure the 12.2.4 and upgrade from 12.2.4 to 12.2.5.Applied patches on 12.2.4 with adop utility with all the options.
Installed and configured Oracle 12c.Good knowledge on CDB and PDB databases.
Experience on Data guard and Active Data guard setup on Oracle 11g.
Installation and configuration of R12, 11i with Manufacturing, Healthcare and IT sectors.
User Management setups in R12, 11i environment ans DMZ Setup on R12.
Experience with tools such as OEM12c, Oracle ADI, XML Publisher and Workflow , Advanced Supply Chain Planning (ASCP).
Worked on Incident management within SLA for all production issues providing RCA for those issues,Written Monitoring scripts for health check of Oracle apps and core dba.
Database Performance Tuning using (stats pack, tkprof, AWR),Advance performance Table compression experience on 11g,Expert on Oracle memory, storage, and I/O internals.Expertise in Explain plan and SQL Optimizer use to resolve the performance issues,Oracle Apps performance on Concurrent Mangers and workflow related issues.
Install,Upgrade, Support and maintain Oracle EBS applications with high availability and DR and also Worked on Setup, configure, implement, test and validate Oracle E-Business Application modules and OID- OAM, Single Sign on.
Experience with Java and Java Database Connectivity (JDBC)
Expert in RMAN backup process and Restorations. Able to write shell scripts for scheduling the jobs as per business requirement.
Worked on Parallel Concurrent Processing(PCP) as well as debugging concurrent managers and requests
Worked on disaster recovery and fail over plans .
Good at applying patches of Oracle Applications and Maintenance Activities using AD Utilities. Experienced in Space Management, Memory Tuning and Application Tuning.
Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, J-initiator and database) ·
Handling the offshore/onsite Team as a Team Lead and Manage project - task estimation, planning, risk mitigation analysis, etc.
Worked with Oracle for resolving critical and transactional issues through SR’s and OWC’s. Good at intellectual knowledge base creation-documentation during the project implementation phase and Post production phase · Excellent communication, analytical and inter personal skills and ability to learn new concepts and supported 24/7 on call in production and development environment.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Oracle Apps DBA
Pathfinder Managemment Consulting Pvt Ltd.
Hyderabad
08.2019 - Current
Production support the Oracle Application 11i and R12 instances Including the boundary applications like Weblogic,OBIEE ,Apex Portal applications with glass Fish server.
Responsible for installing OEM12c(12.1.0.4) and configure the various Instances.
Install and configure Weblogic (12.1.3.0.0) ,Install and configure APEX on Weblogic and GlassFish domain .
APEX Upgrade from 4.2 to 5 Versions and also Listener Upgrade from 2.0 to 3.0
OS Migration from RHEL 5 to Oracle linux 7 suceesfully.
OAM Installation and configure with Integration with R12.1.3.
Upgrade 11.1.0.7 to 12.1.0.2 and also upgrade R12.1.3 to 12.2.5.
Document, test, implement and provide ongoing support for Oracle E-Business Suite applications
Oracle Apps DBA
Bensussen Deutsch & Associates Inc
Hyderabad
08.2017 - 08.2019
Providing Production support for R12 and OBIEE Databases.
Database Problem Diagnosis, Research, Fix, Testing and Resolution.
Experience in follow established procedure to perform code migrations to Dev, Test and Prod Instances. Support for maintenance, troubleshooting of R12 (12.1.3) environment.
Setup OXTA configuration for Agile in oracle applications R12 and also Configured iSupplier on Oracle application R 12.1.3.
Resolved OBIEE ETL program performance issues Validating & Creating grants & synonyms on Apps schema, Performed jar file/forms generation as a post patch step, relinking the Oracle apps program.
Worked STAT Implementation for change control and automated workflow, migration management, and reporting and auditing capabilities.
Have expertise in activities like maintaining instances, maintenance of file system and taking appropriate backups for security and consistency, Regular database activities, backups monitoring and issues resolving.
clone the Instances from PROD to TEST with RMAN and Adclone utilities.
Oracle Apps DBA/Core DBA
Chicken of the Sea Inc.
Hyderabad
12.2015 - 07.2017
Responsible for Backup/restore/tar and Cloning of Oracle Applications to development/test instances and database refresh frequently.
Provided Production and development technical support to developers/users for all R12 instances, databases, technology stack and applications issues on IBM AIX environment.
Configure, troubleshoot, Start-up, Monitor performance, Schedule and manage Concurrent programs, forms/reports, Apache server and database issues as and when arises.
Knowledge on Installation, configuration and troubleshoot issues for Oracle 10g RAC database on ASM grid control on AIX box.
Work with Oracle support for issues and generate diagnostic reports/logs and help to all developers for SR assistance.
Wrote Awk and UNIX shell Scripts for automating the process of downloading the ftp files from ftp site and unzipping it on to the staging area of the server.
Install Oracle Applications Release 12.0.4 and cloned applications.
Involved in Real Application Clusters installation and creating the RAC databases using raw devices and asm instance. Migrated from NON-RAC database to RAC database. Successfully Added node to the existing cluster database.
Implementing sound backup and recovery strategies, for rac databases using rman according to the SLA.
Taking the backup of voting Disk and OCR as per the backup policy.
Monitoring and administrating rac database using utilities like srvctl, crsctl, crs_stat, olsnodes and ocrconfig.
Configured Flash Recovery Area, monitoring and working with FRA.
Created ASM instance and disk groups. Migrated non ASM based database to ASM based database.
Cloning the production database and refreshing the test and development databases to synchronize with production database.
Perform regular database activities like database health checkup, space management.
Monitoring the scheduled jobs and solving any issues related to failed jobs.
Managing Table spaces, Data files, Control files, Redo Log files and Archived logs.
Education
B.Tech - Electronics And Computers
Acharya Nagarjuna University
04.2012
Skills
Middleware: Oracle Application Server 10g, WebLogic, SSO, OID, LDAP
Programing: SQL, PL/SQL, Shell Scripts, C, HTML, JavaScript and XML
Database: Oracle 9i, 10g, 11g RAC, 12C,19C
Hardware & OS: Linux, UNIX, Solaris 9, 10, Windows 2000/2003
NetWare: TCP/IP, FTP, Telnet, Netscape, and Internet