Summary
Overview
Work History
Education
Skills
Certification
Summary
Timeline
Generic
VEERAVALLI LAKSHMI KIRAN

VEERAVALLI LAKSHMI KIRAN

Oracle Apps DBA
Hyderabad

Summary

Results-oriented Oracle EBS R12.2.12 Release Developer and Cloud Database Administrator with extensive experience in Oracle 11i and R12.1/12.2 Applications Administration, eager to contribute to a dynamic, growth-oriented company. Proven troubleshooting skills and technical expertise enhance customer satisfaction and drive organizational success. Adept at optimizing systems and processes to support product development and innovation. Committed to delivering high-quality solutions that align with business objectives and foster long-term growth.

Overview

15
15
years of professional experience
5
5
Certifications
1
1
Language

Work History

Oracle Apps DBA

GENPACT INDIA PVT LTD
02.2011 - 12.2025
  • Worked as Oracle Apps DBA Consultant in GENPACT INDIA PVT LTD from FEB 2011 to Dec 2025.

Consultant

GENPACT INDIA PVT LTD
10.2023 - 12.2025
  • Providing Production support (24/7) and troubleshooting the incidents in Production, UAT and other non-prod instances.
  • Cloning various Applications R12, R12.2 Including Multi node Cloning Apps from PROD to TEST, DEV, and UAT Instances.
  • Applying database patches with Opatch utility. Applied application patches using ADPATCH & ADOP utility in oracle APPS 11i, R12 environments.
  • Applying Weblogic patches using BSU
  • Regular monitoring of OEM13c for blocking sessions, tablespace space issues, high CPU, high I/O, long-running concurrent job and other metric alerts to keep track of database performance.
  • Maintaining various SLAs including ticket response and resolution time.
  • Day-to-day business database support and management of the production databases.
  • Scheduling Concurrent programs on Prod and Test instances.
  • Troubleshooting user related issues and coordinating with the users from different time zones.
  • Responsible for patch analysis and impact for all kinds of patches.
  • Changing Apps password using FNDCPASS utility.
  • Applied application patches on RAC and Non-RAC instances and checking the patch impact.
  • Handling and Troubleshooting of Apache, Forms, Conc. Manager and Database related issues.
  • Familiar with all kinds of ad-utilities like adop, adpatch, adadmin, adlicmgr, adctrl, adident, adrelink, etc.
  • Monitoring mount point alerts, Archive logs alerts and takes required actions based on the Alert Guide.
  • Migrating the Code on database and application as per customer/ development teams Requirement.
  • Coordinated with UNIX administrators on database issues.
  • Giving all Audit reports on time
  • Delivered Outages and tasks without zero defects on time
  • Converted IQA Audit completion task as GB Project
  • Performed SOX Audit related Activities.
  • Involved in system administration including configuration, administration and troubleshooting of concurrent managers.
  • Company : GENPACT INDIA PVT LTD
  • Client : Cytiva Project
  • Project : BIOPROD, VCP
  • Role : Consultant
  • Duration : OCT 2023 – DEC 2025

Consultant

GENPACT INDIA PVT LTD
02.2021 - 10.2023
  • Involved in the SINGLE-NODE installation of Oracle Business Accelerator (OBA) on RHEL 5.
  • Cloned the instances of Test, Dev, SIT, UAT from PROD
  • Migration of Database Objects using FNDLOAD from one instance to different instances.
  • Regenerating forms jar files and compiling the invalids etc. by using Adadmin.
  • Involved in system administration including configuration, administration and troubleshooting of concurrent managers.
  • SSO implementation and troubleshoot.
  • Upgraded Oracle Applications from 11.5.10.2 to 12.1.1.
  • Done multiple application clones in multiple application versions line 11i to 12.2.9 and 12c to 19c database clones.
  • Checking the status of important services like concurrent manager, form server, web server, application listener, database listener etc.
  • Company : GENPACT INDIA PVT LTD
  • Client : GE Power & Water
  • Project : (Alpha, Foxtort,Echo, Bravo,Julite,Zeal,HPPM)
  • Role : Consultant
  • Duration : FEB 2021 – OCT 2023

Lead Associate

GENPACT INDIA PVT LTD
11.2019 - 01.2021
  • Involved in the SINGLE-NODE installation of Oracle Business Accelerator (OBA) on RHEL 5.
  • Cloned the instances of Test, Dev, SIT, UAT from PROD
  • Migration of Database Objects using FNDLOAD from one instance to different instances.
  • Regenerating forms jar files and compiling the invalids etc. by using Adadmin.
  • Involved in system administration including configuration, administration and troubleshooting of concurrent managers.
  • Upgraded Oracle Applications from 11.5.10.2 to 12.1.1.
  • Done Database and HPPM Version Upgrade.
  • Checking the status of important services like concurrent manager, form server, web server, application listener, database listener etc.
  • Upgrade E-Business Suite R12 from 12.1.1 to 12.1.3.
  • Database Upgrade from 11.1.0.7 to 11.2.1.3.
  • Database Upgrade from 12c to 19c.
  • Performing APPS/DB Bounces, Applying Data fixes, setting up Debug logs and Gather Schema Statistics.
  • Used AD Controller to see the status of workers and restarted failed workers for resolving the patching problems.
  • Reducing the patch time using features like defaults file, merge patch and using Adpatch options.
  • Adding, Roping and Resizing Tablespaces.
  • Reviewing TAR with Oracle support personnel.
  • Responsible for creating Application and managing user accounts and assigning responsibilities.
  • Maintenance tasks like Purging Concurrent manager log files and Gather schema statistics.
  • Company : GENPACT INDIA PVT LTD
  • Client : BAKER HUGHES
  • Project : (PASCAL, PRIMAVERA, GRC, M&C, OTM)
  • Role : Lead Associate
  • Duration : NOV 2019 – JAN 2021

Senior Associate

GENPACT INDIA PVT LTD
02.2011 - 11.2019
  • Installation, setup and configuration of 10gR2 single Instance Database.
  • Primary SPOC
  • Perform monitoring, administration and troubleshooting of Oracle Databases.
  • Monitoring the growth of Tablespaces and Datafiles.
  • Did imports of Database tables in Dev/QA Environments.
  • SSO implementation and troubleshoot.
  • Applied RDBMS patches by using OPatch.
  • Schema Refresh (Through Import, Export).
  • Create and execute database scripts for data fix change requests.
  • Perform user and security administration activities such as enrolling users, granting privileges to users.
  • Monitoring the Alert logs & Trace files.
  • Removing Trace files and Archive log files.
  • Checking and compiling the invalid objects.
  • Monitoring Archive mount points and Data file mount points.
  • Company : GENPACT INDIA PVT LTD
  • Client : GE OIL&GAS
  • Role : Senior Associate
  • Duration : FEB 2011 - NOV 2019

Education

Master of Science - MCA

Madras University
04.2001 -

BSC - MPC

Acharya Nagarjuna University
08-2005

Skills

Oracle Applications : R1213, 1229, Oracle Applications 11i (115102)

Middleware : WebLogic 11g, PRIMAVERA, OTM, SOA

RDBMS : ORACLE 19c,12c,11g and 10g

Certification

Oracle Cloud Infrastructure 2019 Architect Professional

Summary

  • Presently Working as an Oracle Apps DBA at Genpact India Pvt Ltd, Hyderabad, India.
  • 14+ years of experience in the IT sector as Oracle Apps DBA, Oracle DBA, WebLogic, GRC, OTM Applications.
  • 7+ years of experience in Oracle APPS DBA.
  • Experience in Oracle Applications 11i, R12.1 and R12.2 with Oracle 11g and 12c and 19c Database Administration and EBS 12.2.9
  • SSO implementation and troubleshoot.
  • Experience in managing databases in Oracle cloud infrastructure and familiar with security and patch set updates
  • Being a part of Unified Sox Audit taking the respective reports on monthly and quarterly basis.
  • Extensive experience in WebLogic and GRC (AACG, CCG) Application.
  • Good in Preparing and Presenting Dashboard calls to client on weekly data.
  • Good at preparing shift plans as per the activities list.
  • Ability to learn and master new technologies and to deliver outputs in short deadlines. Managing and Administering 24/7 Production Databases, Development and Test Instances.
  • Managed very large Databases in 24/7 Production Environments.
  • Experience in working closely with application teams, middleware/OS teams, and storage/network teams to ensure smooth deployments and rapid resolution of incidents
  • Proficient in Scheduling Jobs, Patches, Alerting for Databases, Hosts and Database Administration through OEM grid control.
  • Specialized in Oracle Databases (Versions 10g, 11g,12c and 19c), Oracle Apps Database Administration (11.5.10, R12.1 and R12.2)
  • Performing password change management activity as per the schedule.
  • Performing PSU patch analysis on every quarter and applying on Db, Application and WebLogic servers after Client Approval.
  • Strong Experience in supporting Development, Unit Test, System Test, Integration Test, Certification Test, Production Databases under flavors of UNIX (Oracle Enterprise Linux, Red Hat, Sun Solaris)
  • Expertise in Patching, Cloning, Troubleshooting and Performance Tuning of Oracle Applications e-Business Suite.
  • Experience in Oracle E-Business Suite, Administering Shared APPL TOP and Parallel Concurrent Processing.
  • Experience on Oracle Apps 12.2.9 Cloning and Patching.
  • Working with the Development Team to fix the problems in Applications.
  • Management of schemas, objects & partitioning the tables & indexes.
  • Performed Application and Database upgrades.
  • Part of Audit and Management tasks

Timeline

Consultant

GENPACT INDIA PVT LTD
10.2023 - 12.2025

Consultant

GENPACT INDIA PVT LTD
02.2021 - 10.2023

Lead Associate

GENPACT INDIA PVT LTD
11.2019 - 01.2021

Oracle Apps DBA

GENPACT INDIA PVT LTD
02.2011 - 12.2025

Senior Associate

GENPACT INDIA PVT LTD
02.2011 - 11.2019

Master of Science - MCA

Madras University
04.2001 -

BSC - MPC

Acharya Nagarjuna University
VEERAVALLI LAKSHMI KIRANOracle Apps DBA