Summary
Overview
Work History
Education
Skills
PROFILE
ORACLE APPS DBA
Timeline
Generic

Chandra Mohan Patteda

oracle dba
hyderabad,TS

Summary

Around 14 plus years of professional experience in Information Technology industry which includes Oracle Applications DBA with hands on in administering Oracle Databases, Tools and ERP Applications.

Overview

18
18
years of professional experience

Work History

Oracle Apps DBA

TCS Pvt Ltd
11.2011 - 09.2025
  • Project 4#
  • Project Name : CISCO SYSTEMS INC
  • Client : CISCO SYSTEMS
  • Database : 19C Database
  • Applications : Oracle R12.2
  • Duration : Dec 2024 –Jul 2025
  • Responsibilities
  • Managed incident escalations from customer and functional teams, driving them to closure within SLA.
  • Resolved various concurrent Manager issues
  • Created data sources in the domains in oracle WebLogic
  • Imported application SSL root certificates in the WebLogic EM console
  • Resolved Oracle wallet issues in Oracle database
  • Worked on Concurrent Program failures and its resolution
  • Worked on Golden gate replication enablement between two tables of different databases
  • Resolved issues related to lag and other extract and replicate issues
  • Worked on performance issues of SQL's and deployed the SQL Profiles
  • Performed Table rebuild activities on the fragmented tables
  • Worked on the relinking the executable files of concurrent programs
  • Worked on 19c containerization issues
  • Resolved database connection issues on the other external applications
  • Performed complete ERP and database services bounce for the maintenance activities
  • Resolved issues with database services and listener
  • Guiding juniors on their incident resolutions
  • Project 3#
  • Project Name : Oracle Dedicated Region Cloud Customer (DRCC)
  • Client : Vodafone
  • Database : 19C Database
  • Applications : Retail Applications - 16.0.3
  • Duration : Mar 2024 –Nov 2024
  • Oracle Dedicated Region Cloud@Customer (DRCC) is a transformative solution that brings the full capabilities of Oracle Cloud Infrastructure (OCI) directly to an organization's data center. This offering is designed to address the unique requirements of enterprises that demand high-performance cloud services while maintaining stringent data residency, security, and latency requirements.
  • With DRCC, organizations gain access to a complete set of Oracle Cloud services, including databases, analytics, application development, and integration tools, all within their own secure environment. By bridging the gap between public cloud innovation and on-premises control, DRCC empowers enterprises to modernize their IT infrastructure, accelerate digital transformation, and achieve operational excellence.
  • Responsibilities
  • Migrated Retail applications to DRCC without installing the Applications
  • Reconfigured of non-prod applications.
  • Sanity check of all application servers .
  • Server monitoring.
  • Oracle Retail vulnerability checks to ensure system risk mitigation

Oracle Apps DBA

Western Union Business Solutions(WUBS) (Convera)
01.2015 - 02.2024
  • Project 2#
  • Project Name : Western Union Business Solutions(WUBS) (Convera)
  • Client : Western Union
  • Database : 12C Database
  • Applications : R12.2
  • Duration : Jan 2015 –Feb 2024
  • The largest non-bank B2B cross-border payments company in the world. Convera deliver solutions ranging from simple currency exchanges to sophisticated risk management solutions and platforms, everything they do is designed to enhance the customer experience and seamlessly power their global commerce needs. Powered by a sophisticated and expansive global settlement network, Convera’s capabilities are built on efficiency, accuracy and compliance at its core, alleviating risk and accelerating smarter decision making.
  • Responsibilities
  • Performed cloning on EBS 12.2
  • Good knowledge on adop patching
  • Working as support Engineer for couple of AWS and Big Data servers
  • Knowledge on DR switchover between Datacenters.
  • Worked on weekend/Monthly Releases on EBS Enhancements
  • Implemented additional oacore for better performance in EBS.
  • Worked on OIC Configuration.
  • Regular maintenance works and Patching, Performance Tasks etc.
  • Daily 24/7 active support for Prod and Non-Prod environments.
  • Involved in all kinds of DB activities. Refreshes, Patching, DB Performance issues etc
  • Analysis and application of Apps and DB Patches and adadmin activities.
  • Effectively Following the Post Refresh Documentations.
  • Effectively managing all the Front-end tasks.
  • Performing SYSADMIN tasks.
  • Performing Pre-Patch Analysis for multiple patches.
  • Monitoring and Troubleshooting of OIC Issues

Oracle Apps DBA

CISCO SYSTEMS INC.
12.2011 - 01.2013
  • Project 1#
  • Project Name : CISCO SYSTEMS INC.
  • Client : CISCO SYSTEMS
  • Database : Oracle Database 10g and 11g
  • Applications : R12.2
  • Duration : Dec 2011 –Jan 2013
  • Responsibilities
  • Worked as Oracle DBA in Cisco Systems.
  • Support and maintenance of 11i Applications with PCP configured. 9i RAC and 10g Databases.
  • Support for Non-RAC, Single Node RAC and Multi Node RAC environments.
  • Refreshes includes Multi Node to Single Node, Multi Node to Multi Node, Single Node to Single Node, Single Node to Multi Node, RAC to Non-RAC, and Non-RAC to RAC etc.
  • Involved in Weekly based Refreshes Sometimes as requested by Customer.
  • Involved in performance issues related to DB MT.
  • Analysis and application of Apps and DB Patches and adadmin activities.
  • Merging the patches using admrgpch.
  • Involving with the Support/Development Teams for getting any work arounds on the issues.
  • Managing in creating the TAR's.
  • Effectively managing the Standard process flow and maintaining Customer satisfaction.
  • Responsible for maintaining the database of CISCO data Centre San jose(US) And Richardson (US) .
  • Job responsibility includes Migration, Customer Support & Services, Installation, Maintenance
  • GDCP provides database migration services to CISCO and played a prominent role in migrating database from SanJose datacenter to RCDN datacenter and decommission the databases which are migrated from SanJose data Center.
  • To migrate and upgrade oracle databases located in the SJ Data Center to RCDN or RTP datacenter.
  • To standardized database/schemas as per latest CISCO standard.
  • Implement and enforce latest CISCO standards.
  • To implement latest CISCO backup technologies
  • To stabilize the before the handover
  • To Handover databases to OPS after Stabilizing and standardizing
  • As a team member supported project releases and production releases.
  • Roles and responsibilities includes implementing production changes in the CR window.
  • Decommission the old database and release the servers.
  • To Guide application PMs on migration process
  • Tracking projects to successful closer
  • Managing OWC sessions across Customers and Other team members.
  • Provide Go-live and Post go-live support.

Oracle DBA

ASM TECHNOLOGIES Pvt Ltd
01.2011 - 10.2011
  • With ASM TECHNOLOGIES Pvt Ltd Jan '2011 to Oct '2011
  • Designation: Oracle DBA
  • Clients: Oracle PVT LTD (Multiple clients with multiple environments)
  • Environment: 11i Applications, R12.1.x, 9i 10g, 11g.
  • Description: Worked in release management team for multiple clients
  • Environment: Oracle Database 11gR2 11.2.x
  • Description: Applying Quarterly Release patches for multiple clients for multiple environments as a DBA, Support of Oracle Apps 11i .
  • Responsibilities
  • Worked on Maintenance, Support, Patching.
  • Quarterly patches planning and execution.
  • Involving in Database and Application performance issues including WebLogic issues.
  • Troubleshooting issues.

Junior Oracle DBA

Navionics Technologies Private Limited
10.2007 - 08.2010
  • With Navionics Technologies Private Limited, Oct'2007 to Aug'2010
  • Designation: Junior Oracle DBA.
  • Clients: Navionics Technologies
  • Environment: 9i
  • Description:
  • NAVIONICS to develop seamless database & nautical electronics charts of sea navigation. Navionics charts are a fundamental tool of navigation, featuring water depths, navaids, obstructions, and other information necessary for safe navigation. The project deals with digitization of coastal, harbors, restricted, cables & pipeline areas, digitization of contours, placing of navaids symbols abbreviations from the nautical charts supplied by the client. Also includes separation of point data & vector data (database integration) and importing into Global Geo-database (GDB).
  • Responsibilities
  • Maintaining over 15 Spatial Database servers of size each around 200GB.
  • Performing backups (hot backup, cold backup, and export) of the databases and checking the backups by Restoring on Test Server.
  • Checking Alert logs and Taking Archives Logs Backup of all Servers.
  • Analyzing Tables and Indexes, Reorganize Tables/Indexes whenever necessary.
  • Regular Monitoring of Free Space in the Datafile(s).
  • Resizing or adding new database files when needed.
  • Taking logical backups using export and import.
  • DB monitoring and User support for oracle client installations.
  • Rename the database name.
  • Creation of Oracle Objects like tables, indexes, synonyms.
  • Solving Connectivity Problems for Client(s) in connecting to Server.
  • Regularly Monitored the Alert Log file
  • Restoring and Recovering Old backups by applying archives.
  • Configured the TNSNAMES and Listener as per the Requirements
  • Implemented the Concept of Resumable Tablespaces
  • Developed scripts for backup and recovery, Import and export procedure.
  • Used locally managed tablespace to improve the performance and to decrease the burden on the data dictionary.
  • Creating new database without data (Empty structure).
  • Creation of Partition and spatial indexes.
  • Creation of Users and Setting them the Default Tablespaces.
  • Monitoring the growth of the database like table, index and tablespaces etc.
  • Configuration of Navionics tools i.e. IOGDB, XF Writers, Geo Designer etc.

Education

Bachelor of Science - B TECH

JNTU
Hyderabad
04.2001 -

Skills

Operating Systems Linux RHEL5x,6x, Windows

PROFILE

  • Chandra Mohan Patteda
  • Oracle Apps DBA
  • Email: c.patteda@tcs.com
  • Mob: +91-8297479797

ORACLE APPS DBA

  • Extensive experience in managing shared service model containing more than 100 Oracle-business suite instances which includes Production, Stage, and Development Test instances.
  • Experience in EBS suite 11i to R12.1 UPGRADE.
  • Apply Quarterly release patches for MT, DB and Grid, WebLogic.
  • Trouble shooting of long running requests and improving performance.
  • Standby Database archive log resolution.
  • Extensive experience in administering maintaining Oracle Applications E-Business Suite 11i:11.5.10,11.5.10.2 and R12:12.0.4,12.1.x,12.2.x and Oracle Databases 9i,10g 11gR1/R2,12c,19c.
  • Good hands-on experience in executing Patching, Refreshes, Upgrades.
  • Expertise in Data guard/Standby setup.
  • Expertise in 10g/11g Grid Infrastructure implementation CRS ASM, RAC databases installation.
  • Good knowledge on using Data pump and Physical Backup's like COLD and HOT Backup, Restore and Recovery at different scenarios. Expertise in migration of tablespaces, schemas and huge data across the environments using data pump.
  • Expertise in RMAN Backup and Recovery, Developed weekly strategy for RMAN Incremental backups and weekly Tape backups. Extensive experience in refreshing core DB instance using RMAN backups.
  • Familiar with Discoverer, Workflow configurations, Forms and Reports. Troubleshooting Concurrent manager, Apache and Discoverer issues.
  • Expertise in Oracle WebLogic Installation and Administration. Discoverer installation.
  • Experience on Implementation, Maintenance of Oracle Apps R12.2. Expertise in Cloning, Patching using ADOP in 12.2
  • Ability to work with and listen to customers/users. Capable of self-learning to explore technically. Ability to interact with end users, self-motivated, quick learner and team player with good communication skills.
  • Monitoring jobs through OEM/Enable Blackouts.
  • SQL tuning in OEM and long running query resolution and monitoring through OEM.
  • Refresh, custom code migration using service now ticketing tool.

Timeline

Oracle Apps DBA

Western Union Business Solutions(WUBS) (Convera)
01.2015 - 02.2024

Oracle Apps DBA

CISCO SYSTEMS INC.
12.2011 - 01.2013

Oracle Apps DBA

TCS Pvt Ltd
11.2011 - 09.2025

Oracle DBA

ASM TECHNOLOGIES Pvt Ltd
01.2011 - 10.2011

Junior Oracle DBA

Navionics Technologies Private Limited
10.2007 - 08.2010

Bachelor of Science - B TECH

JNTU
04.2001 -

Similar Profiles

CREATE PROFILE
Chandra Mohan Pattedaoracle dba