Neeraj Roy Gunnam

Project: Paypal Inc,

• Design and implement database structures to support business applications. Ensure optimal database performance and scalability.
• Taking backups on scheduled time and monitoring scheduled backups, performing backups and recoveries using RMAN hot backups.
• Monitor database performance, optimize queries, and indexes. Using tools like AWR and ADDM for performance analysis.
• Implemented data guard with maximum availability, protection, and performance configurations and worked with data guard failover and switchover cases at the times of upgrading and migration.
• Performing day-to-day database administration tasks, including installation, upgrades, backup/recovery, monitoring, disaster recovery procedures (switchover/failover), and database cloning across environments, and patching.
• Performed troubleshooting, scheduling, monitoring, and execution of database activities in cron jobs.
• Migrate database across different servers and platforms using transportable tablespaces and data pump export/import, and perform database refresh and RMAN cloning.
• Provided 24x7 on-call support for critical database systems, ensuring rapid resolution of issues and minimizing downtime.
• Mentored junior DBAs and shared best practices to enhance the overall skillset of the team. Drafted runbooks to ensure that the standard procedures are followed.

• Performed object, Schema & Full database Level Exports/Imports
• Oracle Upgradations from Oracle 12c to 19c
• AWS Database Backup and restoration from PROD to UAT
• Implementing and maintaining database security (create and maintain users, roles and assign privileges).
• Streamlined backup and recovery processes, enhancing overall system stability and availability.
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
• Collaborated with cross-functional teams to develop custom applications that supported business objectives and met user needs

• Worked on 100+ instances, including RAC (Production Box) and Non-RAC (Nonproduction Box).
• Supporting production databases from 10TB to 100TB as a primary and secondary point of contact.
• Tablespace management, User Management, and Object Management.
• Managing the Linux hugepages and Linux node reboot.
• Involved in RHEL upgrades and hardware replacement.
• Creating necessity Linux Mount Points, maintenance of the same.
• Experience on Oracle database using DBCA and Clusterware Installation.
• Performed object, Schema, and Full database level exports/imports.
• Implementing and maintaining database security (creating and maintaining users, roles, and assigning privileges).
• Management of schema objects, partitioning of tables and indexes, and performing SQLLoader jobs for loading data from flat files (ETL) and Oracle database monitoring. Troubleshoot and resolve the issues.
• Quarterly PSU, Bundle Patches, RU patching on 11.2.0.4, 12.1.0.2, and 19.8.1.0 databases.
• Successfully installed the client patches on the application nodes.
• Stopping/starting Instances listeners in the cluster environment.
• Fail over the connections from one node to the other node in RAC.
• Configure, add, and delete database resources in HAS/CRS using SRVCTL.
• Relocate the database resources (Listener, VIP, Instance, etc.). To another node.
• Catalog database Configuration, registering target database.
• Maintaining uniform size of disks in the disk groups to promote good performance across the disk group.
• Adding disk to ASM disk group to maintain the space threshold of the disk group.
• Troubleshot database issues to create and resolve trouble tickets.