Dilip Reddy

Oracle Database Administrator with 5.5+ years of experience managing Oracle 11g/12c/19c databases across Production, Development, QA, and DR environments. Skilled in RAC, ASM, Data Guard, RMAN, GoldenGate, database patching, backup & recovery, performance tuning, and cloud technologies. Proven track record of ensuring high availability, SLA compliance, and seamless database operations for enterprise applications.

ORACLE DBA at INFOSYS LIMITED (2024-11 – Present)

Project: Spark

• Executed out-of-place patching in a new ORACLE_HOME to reduce downtime and lower upgrade risk across Oracle production environments.
• Executed database decommissioning activities in accordance with operational and compliance requirements.
• Monitored daily backup reports and proactively investigated and resolved failed jobs.
• Resolved RAM-related database issues by tuning memory parameters, including adjusting cache sizes and increasing PGA/SGA as required
• Managed filesystem and mount point capacity, clearing obsolete data to prevent space-related issues.
• Resolved tablespace issues and troubleshot Oracle Agent and Listener outages to ensure database availability.
• Administered Active-Standby Data Guard databases to maintain synchronization and support database availability for production systems
• Managed RMAN backup scheduling through crontab and monitored job outcomes, rerunning failed backups to maintain recovery readiness
• Collaborated with Oracle Support to troubleshoot patching and upgrade issues, including out-of-place patching
• Provided production support for Single View, Delphix CRM, and EPIC Oracle databases, including monitoring, troubleshooting, and maintenance.
• Configured, scheduled, and troubleshot AutoSys jobs, addressing failures and coordinating reruns as needed.
• Contributed to Oracle to Azure database migration project by executing post-migration validation tasks, including resolving OVD connectivity, network, and DB link issues.
• Supported database upgrade initiatives by performing database relinking and ensuring system stability post-upgrade.
• Managed MongoDB users, roles, and access control using role-based authentication.
• Monitored MongoDB instance health, including CPU, memory, disk, and connection usage.
• Performed start/stop/restart operations and validated service availability
• Working on replication issues.

ORACLE DBA at TATA CONSULTANCY SERVICE (2021-04 – 2024-11)

Project 1: Western power

• Frequently used Logical Backup Export/Import and Data pump on Production Server.
• Database refresh, Table refresh and Schema refresh of test and development databases from Production database.
• Implementing and testing RMAN Backup strategies in production, testing environment for backup and recovery.
• Creation of Clone database for the test database environment using RMAN.
• Experience in configuring Data Guard (Standby Database)
• Create and manage schema and grant users access to those schemas.
• Gathering statistics, Index rebuilding at regular interval to improve database performance.
• Provided production DBA support for critical applications, maintained database health checks for RAC instances, and supported all production databases while meeting 100% SLA targets.
• Monitoring the system response, archival area and file systems.
• Creation of Tablespaces and Space Management Security Policies like Managing Users and Profiles. Creation of Roles and controlling User Privileges. Database storage like managing the size and files of database and adding ASM disks to disk group.
• User Management, Role creation and Privilege Management.
• Refreshing database schema using Export/Import, Data Pump utility as per the application team requirements.
• Handling the Bridge calls with the application team to resolve any database related issues.
• Managing Active standby databases.
• Handling the Golden gate troubleshooting issues.

ORACLE DBA at TATA CONSULTANCY SERVICE (2021-04 – 2024-11)

Project 2: Humana

• Responsible for proactive monitoring and maintenance of database health checks of RAC instances and databases for critical applications.
• Taking the AWR Reports as per the requester's need
• Worked closely with development team and implement CR in the production databases.
• User Management, Role creation and Privilege Management.
• Working on Blocking sessions.
• Creation of Tablespaces and Space Management Security Policies like Managing Users and Profiles. Creation of Roles and controlling User Privileges. Database storage like managing the size and files of database and adding ASM disks to disk group.
• Scheduling jobs through OEM.
• Monitoring Golden Gate processes.
• User Account management: Creating Users, Disabling users, Role management.
• Sorting out oracle error.

B-Tech – JNTUH (2016-04 – 2019-04)