Rajeshwar Gummerla

▪ Currently employed with HCL TECH Noida designated as a Consultant -L3 - Exadata and Oracle DBA in the area of Exadata and Oracle Database Administration.
▪ Oracle Exadata Database Administrator (DMA) in a highly customer-focused database administration team, which provides 7×24 support in test/prod environments. Responsibilities include designing, installing, upgrading, patching, tuning, monitoring and troubleshooting databases with large amounts of data (Terabytes) and high transaction rates and 4+ years experience in managing AWS RDS/EC2 instances.

• Manage Oracle Exadata environments supporting mission-critical enterprise databases.
• Perform Exadata half yearly patching (rolling/non-rolling) of Storage Cell/Compute node(Dom0)/DomU,
InfiniBand/ROCE/Admin switch patching and hardware maintenance.
• Cell/Compute Node harddisk_replacement/ Exadata Storage Cell flash disk replacement
• Worked in close coordination with field engineer for cell disk/flash disk, DIM replacement, Battery
Replacement.
• Administer Oracle Database versions from 11g through 19c across Linux environments.
• Perform Oracle RAC, ASM, Grid Infrastructure installation, configuration, and administration.
• Implement Oracle backup and recovery strategies aligned with business RTO and RPO objectives.
• Execute quarterly Grid Infrastructure and Database Release Update (RU) patching.
• Perform Oracle 12c to 19c database upgrades with minimal downtime.
• Configure and maintain Oracle Data Guard environments for disaster recovery.
• Administer Oracle Enterprise Manager (OEM) installation, migration, and upgrades.
• Analyze ExaChk reports and implement Oracle best practices.
• Troubleshoot complex production issues while maintaining SLA compliance.
• Expertise with Performance tuning at database level and SQL query level.-L3 Suport
• Expertise in restore and recovery part to handle any scenario using (Datapump/RMAN)

Worked with Accenture (Navisite India Pvt Ltd part of Accenture), Gurgaon designated as an Associate
Manager - Oracle DBA in the area of Oracle Database Administration. Handled Oracle team with the size of 22 L3/L2 DBAs .Supported 100+ Customers (USA) database end to end Oracle Database maintenance and
administration.
• Possess expertise in Installation and Administration of Oracle databases (9i, 10g, 11g, 12c, 19c, AWS RDS and OCI Databases). Responsibilities
Include daily maintenance review, Patching, Database Upgrades, Performance Tuning, Database Growth Planning, Rman
Backup and Recovery, export/import, User Management, Standby database Administration, Database Refresh, Database
Cloning by Rman/Export/Import, Creating Role and assigning them end users, Installation of Oracle 10g, 11g, 12c & 19c
Databases on various Operating Systems and Managing AWS RDS/EC2 instances administration and OCI Instances & implement
Database Backup Recovery strategy as per defined RTO & RPO, Exadata platforms like Linux Red Hat 6-7 and Oracle Linux 6-7.
Skilled in maintaining production databases, Exadata patching, Engineered Systems Exadata identifying core issues,
Investigating & troubleshooting botleneck, system study.

• Led a team of 22 Oracle DBAs supporting 100+ enterprise customers across North America.
• Managed Oracle production environments with 24×7 operational support.
• Administered Oracle RAC, ASM, Data Guard, OEM, RMAN, AWS RDS and OCI databases.
• Planned and executed database migrations, refreshes and upgrades.
• Managed Exadata infrastructure administration and quarterly patching.
• Performed database performance tuning and capacity planning.
• Coordinated change implementation, incident management and customer escalations.
• Automated routine DBA activities using Shell scripting.
• Worked closely with application owners and infrastructure teams to maintain high availability.

▪ Providing business as usual (BAU) support on 24/7 window (Sun Model) for the production database systems.
▪ Database Administration for Oracle (10g, 11g, 12c and 19c) responsibilities includes daily maintenance review,
Backup and Recovery, export/import, Data-pump, Disaster recovery planning and testing.
▪ Monitoring all alert logs, troubleshoot them immediately.
▪ Providing support and solutions for automatic alarmpoint alerts/Incidents raised against production database systems based on the severity and SLA.
▪ Providing support and solutions for UAT and DEV database Remedy task raised by the Application team.
▪ Providing support and solutions for Incidents raised by an application teams against production database systems.
▪ Handling recovery calls and providing solutions for mission critical business related database issues.
▪ Implementation and deployments of the authorized database and application changes on the databases in development and production environments by raising MCR (Master Change Record) & TCR (Task Change Record) changes in Infoman/ServiceNow tools.
▪ Creating Production Database Implementation steps for application changes support.
▪ Providing support and configuration for replication technologies e.g. Oracle Golden Gate & Oracle Streams.
▪ Performing and supporting disaster recovery test during switchover/failover and failback as maintenance activities.
▪ Creation and configuration of databases with and without RAC & ASM.
▪ Up-gradation of CRS, ASM and RDBMS using one-off & CPU patch and patch sets.
▪ Weekend Production database changes Implementation support.
▪ Oncall (Night) production support for Crit1 and Crit 2 Incidents
▪ Supporting and configuring RMAN backup and recovery strategies for the production database systems using
autosys scheduling tool as well as crontab.
▪ Performing production and development databases full, partial cloning & refresh using RMAN and
data pump & export-import.
▪ Supporting & optimizing performance of the databases.
▪ Familiarity with VCS clustering functionality.
▪ Cloning/Refresh of Oracle Databases from Productions.
▪ Installation, Administration and Maintenance, Cloning, Upgrading Oracle 19c/12c /11g/10g/9i, and have knowledge
about ORACLE 9i/10g/11g database on LINUX/Windows server platform.
▪ ASM installation and configuration.
▪ RAC installation and configuration.
▪ Installation and Administrating High Availability - FLASHBACK, and Standby Database.
▪ Create and maintain database objects (tables, indexes, views).
▪ Hands on Experience of Performance tuning (database and Sql level)
▪ Planning and implementing the Archival policies as per the requirements.
▪ Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes
▪ Perform backup using RMAN/USER managed database of online/offline databases in archive/no archive mode.
▪ Perform RMAN/ User Managed maintenance of database from a recovery catalog. Manage remote
database failure/network failure.
▪ Transportable Tablespaces, Migration of tablespaces between different platforms, and between
versions of different DB.
▪ Created a Database link between two Oracle Servers.
▪ Cloning of the databases in various possible ways, restorations of databases using RMAN/UMAN.
▪ Creating a Physical Standby using RMAN/Active Data Guard and Data Guard Broker Configuration on 10g/11g/12c/19c.
▪ Performing Switchover/Failover/snapshot standby on Production Database.
▪ Experienced in Data Moving Utilities Such As Data-Pump, export/import.
▪ Proficient in working with Oracle’s Enterprise Manager (OEM), Stats pack Reports and AWR Report generation.
▪ Writing Basic Level of Shell Scripts and Scheduling through Crontab
▪ Working in 24x7 production support.

• Administered Oracle production databases in Banking environments.
• Managed RAC, ASM, Data Guard and RMAN.
• Implemented backup and disaster recovery strategies.
• Supported database cloning, refresh and migration activities.
• Performed production deployments using ServiceNow change management.
• Supported GoldenGate and Oracle Streams replication.
• Conducted DR drills including Switchover, Failover and Snapshot Standby.
• Performed SQL tuning and database performance optimization. Supported critical production incidents in 24×7 environments. DR testing (Switchover, Failover, Failback) to business continuity readiness.
✔ Improved critical banking domain database performance through AWR analysis, SQL tuning, statistics
optimization, and index maintenance. designed and maintained RMAN backup and recovery strategies, improving database
recoverability and reducing recovery time during critical incidents.

▪ In-Solutions, a renowned brand, is amongst the top-rated solution providers for the Electronic Payment vertical of the Indian banking industry. It has covered a niche in the card & payment industry and is known in industry circle for its innovative solutions, earned through 24 years of experience.


Key Accountabilities:

▪ Database Administration for Oracle (10g 11g and 12c) responsibilities includes daily maintenance review, Backup and Recovery, export/import, Data-pump, Disaster recovery planning and testing.
▪ Monitoring all alert logs, troubleshoot them immediately.
▪ Installation, Administration and Maintenance, Cloning, Upgrading Oracle /11g/10g/9i, and have knowledge
about ORACLE 9i/10g/11g/12c database on LINUX/Windows server platform.
▪ ASM installation and configuration.
▪ RAC installation and configuration.
▪ Installation and Administrating High Availability - FLASHBACK, and Standby Database.
▪ Create and maintain database objects (tables, indexes, views).
▪ Hands on Experience of Performance tuning (database and Sql level)
▪ Planning and implementing the Archival policies as per the requirements.
▪ Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes
▪ Perform backup using RMAN/USER managed database of online/offline databases in archive/no archive mode.
▪ Perform RMAN/ User Managed maintenance of database from a recovery catalog. Manage remote database
Failure/network failure.
▪ Transportable Tablespaces, Migration of tablespaces between different platforms, and between
versions of different DB.
▪ Created a Database link between two Oracle Servers.
▪ Cloning of the databases in various possible ways, restorations of databases using RMAN/UMAN.
▪ Creating a Physical Standby using RMAN/Active Data Guard and Data Guard Broker Configuration on 10g/11g.
▪ Performing Switchover/Failover/snapshot standby on Production Database.
▪ Experienced in Data Moving Utilities Such As Data-Pump, export/import.
▪ Migration of database on different servers.
▪ Proficient in working with Oracle’s Enterprise Manager (OEM), Stats pack Reports and AWR Report generation.
▪ Writing Basic Level of Shell Scripts and Scheduling through Crontab
▪ OS level activities like space monitoring of Mount points and RAID configuration.
▪ Tape backups (Database Cold Backup and Jboss Applications) with help of Symantec Backup Exec System Recovery 2010 Tool.
▪ Working in 24x7 production support.

• Oracle Database Administration (9i-12c)
• Backup & Recovery
• Oracle RAC
• Oracle ASM
• Data Guard
• Database Cloning
• Performance Tuning
• Linux Administration
• Production Support