Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Rajasekhar Kondapuneni

Hyderabad

Summary

  • 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.
  • Specialized in Oracle Databases (Versions 11g, 10g, 9i), Oracle Apps Database Administration (R12, 11.5.10, 11.5.9).
  • 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
  • Oracle Tools: SQL*LOADER, Oracle SQL Navigator, TOAD Forms 10g/6i/45, Reports 10g/ 6i, Discoverer 10g/6i/4i, ,
  • ERP Modules: Oracle Applications R12/11i
  • Others: SAN/NAS, Vmware, VERITAS Net Backup
  • Tools & Utilities: RMAN, Data Pump, Dataguard, OEM, Grid Control

Certification

· OCA 12C Certified Professional

Timeline

Oracle Apps DBA

Pathfinder Managemment Consulting Pvt Ltd.
08.2019 - Current

Oracle Apps DBA

Bensussen Deutsch & Associates Inc
08.2017 - 08.2019

Oracle Apps DBA/Core DBA

Chicken of the Sea Inc.
12.2015 - 07.2017

B.Tech - Electronics And Computers

Acharya Nagarjuna University

· OCA 12C Certified Professional

Rajasekhar Kondapuneni