Naresh Bathala

Project1:

Projects Details: RRR Project

Environment: 19C RAC Database ,12.2 EBS.

Role: Senior Database Administrator

Description: Successfully built and configured new Primary and Disaster Recovery (DR) environmentsfor Oracle E-Business Suite and Oracle Database, including full DR setup and execution of Disaster Recovery (DR) testing for business continuity planning.

Responsibilities:

• Successfully built and configured new Primary and Disaster Recovery (DR) environments for Oracle E-Business Suite and Oracle Database, including full DR setup and execution of Disaster Recovery (DR) testing for business continuity planning.
• Built and configured Primary and Disaster Recovery (DR) environments for Oracle E-Business Suite R12.2.x and Oracle Database 19c on Linux/Unix platforms.
• Installed and configured EBS Application Tier components (Admin Server, WebLogic, Forms, Concurrent Managers) in both Primary and DR environments.
• Performed end-to-end cloning of Oracle EBS environments using Rapid Clone, including database and application tiers, followed by post-clone configuration (apps tier context file updates, autoconfig runs, workflow mailer setup).
• Cloned production database to lower environments DR using RMAN backups, cold backup, or Data Guard snapshot standby where applicable.
• Customized clone scripts to automate repetitive steps for faster and error-free environment refreshes across multiple tiers.
• Synchronized DR EBS environments with primary by regularly cloning applications and applying patches/configuration changes to maintain parity.
• Set up and maintained Oracle Data Guard for disaster recovery, including configuration of redo log transport services, archive log application, and gap resolution.
• Validated EBS and Database DR clones by running key modules, concurrent programs, and ensuring integration with third-party systems (e.g., OAM, OID, SMTP).
• Conducted Disaster Recovery (DR) Tests by performing database and application switchover/failover procedures, followed by functional testing of EBS modules.
• Coordinated full-cycle DR drills with Infrastructure, Network, and Functional teams, documenting RTO/RPO compliance and testing success criteria.
• Monitored log shipping and lag metrics using custom scripts and Oracle Enterprise Manager (OEM) to ensure real-time DR readiness.
• Implemented Automated Cloning Scripts using shell scripting for faster turnaround during regular environment refreshes and DR sync.
• Documented complete DR and Cloning procedures, including validation checklists, known issues, resolution steps, and recovery strategies.
• Performed post-clone tuning and validation, including hostname change, apps password reset, listener and service registration, and SMTP/workflow mailer reconfiguration.
• Supported multi-node and single-node clone scenarios across on-prem and hybrid cloud environments.
• Handled post-clone tasks such as clearing cache, bouncing services, clearing FND_NODES, and updating Workflow Notification Mailer settings.
• Worked with Functional/Dev teams to ensure successful environment refreshes and DR readiness for patch testing, UAT, and performance testing.

Project2:

Projects Details: VM Migration Project

Environment: 19C RAC Database ,12.2 EBS.

Role: Senior Database Administrator

Description: Migrated Oracle E-Business Suite R12.2.X with Oracle Database 19c from legacy on-premise server to new Linux-based server as part of hardware upgrade. Handled cloning, configuration updates, mailer setup, and ensured successful post-migration validation across all functional modules with zero critical issues.

Responsibilities:

• Migrated Oracle E-Business Suite R12.2.X with Oracle Database 19c from legacy on-premise server to new Linux-based server as part of hardware upgrade.
• Handled cloning, configuration updates, mailer setup, and ensured successful post-migration validation across all functional modules with zero critical issues.
• Successfully performed end-to-end migration of Oracle E-Business Suite (R12.x) from legacy server to new hardware/server environment with minimal downtime.
• Migrated both Application Tier and Database Tier to new servers, ensuring compatibility of OS, storage, and network configurations.
• Conducted pre-migration assessment, including sizing, software versions, custom components, and integration points.
• Performed full EBS application and database cloning to the new server using Rapid Clone and RMAN for database restoration.
• Validated and updated configuration files (context.xml, .env, listener.ora, tnsnames.ora) to reflect the new server details.
• Reconfigured workflow mailer, hostnames, node names, and all system profiles post-migration to ensure correct behavior in the new environment.
• Ran AutoConfig on both tiers to regenerate necessary configurations for the new server setup.
• Applied necessary patches and ensured compatibility of OS/kernel, libraries, and database versions with EBS.
• Performed application testing post-migration to ensure all modules, concurrent programs, and integrations were functioning as expected.
• Coordinated with application teams to validate custom objects, workflows, forms, and reports in the new environment.
• Tuned and optimized the migrated system for performance improvements on the new hardware.
• Documented the entire migration strategy, including pre-requisites, cutover steps, fallback plan, and validation checklist.
• Ensured minimal business impact by performing the migration during a planned downtime window and validating all services post-migration.
• Worked closely with infrastructure and network teams to plan IP changes, DNS updates, and firewall configurations on the new server.
• Supported post-migration activities such as patching, performance tuning, and user access verification.

Project3:

Projects Details: Database & EBS Upgrade Projects

Environment: 12C Database ,12.2 EBS.

Role: Database Administrator

Description: Executed multiple upgrade projects involving Oracle E-Business Suite (EBS) and Oracle Databases, focusing on moving from 12c to 19c (Multitenant Architecture) and upgrading EBS from older 12.2.x versions to latest supported releases.

Responsibilities:

• Executed multiple upgrade projects involving Oracle E-Business Suite (EBS) and Oracle Databases, focusing on moving from 12c to 19c (Multitenant Architecture) and upgrading EBS from older 12.2.x versions to latest supported releases.
• Led and executed end-to-end Oracle E-Business Suite (EBS) upgrades across multiple environments (11i, R12.1.x, R12.2.x).
• Performed Oracle Database upgrades and migrations (e.g., 11g to 12c/19c), including pre-upgrade assessments, patching, testing, and post-upgrade validations.
• Managed cloning of EBS instances using Rapid Clone and troubleshooting environment-specific issues.
• Applied EBS patches (AD, TXK, NLS, etc.) and database PSU/CPU patches using adop/adpatch/datapatch tools.
• Administered and monitored EBS applications (Forms, Concurrent Managers, WebLogic, OACore, OAFM, etc.).
• Configured and maintained high availability and disaster recovery setups (RAC, Data Guard, RMAN backups).
• Automated routine DBA tasks using shell scripting and custom tools for improved operational efficiency.
• Performed performance tuning of Oracle database and EBS applications – including SQL tuning, AWR analysis, and index/optimizer management.
• Coordinated with development, infrastructure, and functional teams for EBS customization deployments and environment refreshes.
• Ensured system compliance through regular security patching and vulnerability remediation.
• Managed WebLogic Server and Oracle Fusion Middleware components in R12.2 architecture.
• Set up and maintained Oracle Workflow Mailer, Notification Mailer, and integration with SMTP servers.
• Conducted impact analysis, compatibility checks, and dry-runs for EBS and database upgrade projects.
• Created detailed documentation for standard operating procedures, upgrade steps, and rollback plans.
• Supported SOX and audit compliance through user access reviews, segregation of duties, and secure configuration practices.
• Provided 24x7 production support for critical issues related to database or EBS outages, performance degradation, or concurrent manager failures.