Hanumantha Rao Ballana

Having 11+ years of experience in administering, patching, cloning, and troubleshooting Oracle E-Business Suite (R12.1.x, R12.2.x) and Oracle Databases (11g/12c/19c) across development, test, and production environments. Expertise in ADOP patching, performance tuning, RAC/ASM, Data Guard, and OEM. Having around 3 years of experience in Postgres and MySql Databases administration. Proficient in database administration, production support, installation, configuration, upgrades, patches, backup and recovery, cloning, space management, performance tuning and troubleshooting. Supported Oracle EBS R12.1.3 environments with 11g/12c databases. Managed concurrent managers, workflow mailers, and forms/reports. Applied one-off patches, PSU, and CPU patches using adpatch and adop. Manage Oracle EBS R12.2.10 on Oracle DB 19c with RAC/ASM across multi-node architecture. Lead online patching using ADOP with minimal downtime and post-patch validation. Perform cloning and refreshes of EBS environments for development and testing teams. Implement RMAN-based backup and recovery strategies, including Data Guard configuration. Resolve performance issues at DB and application level (SQL tuning, trace analysis). Creating users, assigning privileges, roles, quotas, profiles to users and good experience in tablespace Management. Applying latest releases of the application patches (with/without hot patch option) to resolve any kind of application issues. AD Utilities AD Admin, AD Patch, AD Controller, AD Splice etc. Experienced in Oracle Applications 11i, R12 & R12.2 Managing Concurrent Requests and Concurrent Managers. Changing the Apps password by using FNDCPSASS utility. Hands on experience in OEM 12c and 13c installation. Configuring and Monitoring Tablespace, Mount point and blocking session alerts from OEM. Performing logical backups using Export/Import and Expdp/Impdp utilities. Hands on experience on database backup and recovery using RMAN. Hands on experience on RAC 10g/11g/12c/19c architecture and Troubleshooting RAC Instances. Configuring 3-node and 5-node RAC systems which includes ASM and database creation. Experience with ASM (Automatic Storage Management) for standalone and RAC databases. Migrating database from one server to another including Non-ASM to ASM. Creating disk groups, adding disks to existing disk groups and doing ASM rebalance. Configuration and managing of oracle data guard physical standby, Active standby and Snapshot standby database. Database Upgraded from lower versions to higher versions. Hands on experience on data guard switchover and resolving archive gap latency. Cloning the instances regularly using RAPID CLONE and SDDC. Applying latest releases of the application patches (with/without hot patch option) to resolve any kind of application issues. Experienced in Oracle Applications 11i & R12. Keeping the database up to date by applying the latest PATCHES from Oracle using the OPATCH utility. Changing the Apps password by using FNDCPSASS utility Specialized in Oracle Databases (Versions 12c,11g,10g, 9i), Oracle Apps Database Administration (11.5.10 & R12). Creating AWR and ADDM report periodically, using snapshots, to review the performance of database and keep note of most time-consuming events.

I have completed multiple projects independently and got best employee in VMware project.

I have completed OCA and OCP certifications .

• Name: Hanumantha Rao Ballana
• Nationality: Indian
• Marital Status: Married
• Languages Known: English, Telugu and Hindi
• Pan Card: BALPB7693G