Prasad D

• Installed, configured, and monitored Oracle RAC databases, resulting in reduced downtime and improved system reliability.
• Built Disaster Recovery setups in RAC environments and performed Switchover & Switchback operations for biannual drills, ensuring business continuity and preparedness against data loss.
• Applied RU patches on 19c RAC and conducted rolling database restarts, enhancing system performance and minimizing disruption during updates.
• Configured and optimized Oracle Golden Gate for replication between two data centers, leading to seamless data synchronization and reduced latency in operations.
• Executed Partial and Full DB Restoration in RAC DB using RMAN, resulting in enhanced reliability and uptime for critical databases.
• Facilitated Export & Import processes using datapump for schema refresh, leading to improved database performance and optimized deployment cycles.
• Conducted comprehensive DB restoration from tape backups for non-production environments, ensuring backup validation and effective disaster recovery.
• Executed Switchover & Switchback through DGMGRL during DR Drill activities bi-annually, which contributed to validated disaster recovery plans and minimized downtime.
• Identified performance bottlenecks and collaborated with application teams for remediation, significantly resulting in increased SQL performance and system efficiency.
• Conducted comprehensive SQL performance monitoring and troubleshooting, allowing the application team to swiftly address performance bottlenecks and enhance user experience.

_GoldenGate_

• Configured GoldenGate high availability with Oracle DBFS and Active DataGuard, resulting in enhanced data reliability and reduced downtime for critical systems.
• Implemented GoldenGate downstream mining and Integrated Component for replication, achieving seamless data synchronization across active-passive environments.
• Executed GoldenGate setup on a 4-node RAC cluster, which led to improved performance and scalability in data replication processes.
• Oversaw and optimized Oracle GoldenGate environments, including monitoring and troubleshooting, ultimately providing consistency in data availability and performance efficiency.
• Documented critical processes such as cron jobs and replication setups, ensuring clear guidelines and best practices for future migrations and upgrades.
• Implemented and configured GoldenGate on a 4-node RAC cluster, resulting in enhanced data replication and improved system performance.
• Set up ACFS mount for GoldenGate replication across multi-node RAC clusters, leading to streamlined data access and reduced replication latency.
• Managed Oracle GoldenGate environments with proactive monitoring, maintenance, and troubleshooting, which significantly minimized downtime and maximized operational efficiency.
• Monitored and tuned GoldenGate sessions at both database and GGSCI levels, achieving optimized performance and resource utilization.
• Investigated replication failures through comprehensive analysis using ggserr.log and LogDump utility, ultimately ensuring robust reliability and integrity in data replication processes.

• Developed Shell scripts and batch files to automate backup procedures and archive cleanup across Linux and Windows Server, achieving increased operational efficiency with minimized manual intervention.
• Executed incremental backups in ODG setup and implemented SYNC status alerts, resulting in enhanced monitoring and reduced downtime from sync issues.
• Managed database migration from Oracle to Oracle during server upgrades using RMAN and Data Pump utility, leading to seamless transitions and improved system performance.
• Constructed fresh databases on new operating systems by downloading and installing Oracle Database and Grid software, which ensured reliable and effective setup processes for future applications.
• Performed comprehensive database refreshes and implemented Data Guard for Production, bolstering disaster recovery capabilities and ensuring business continuity through standby modes.
• Developed Shell Scripts to monitor critical system metrics such as disk space, CPU, Memory, and ODG SYNC Status, resulting in enhanced system reliability and early detection of potential issues.
• Executed database cloning via RMAN using the latest version, which led to quicker deployment times and improved resource management across environments.
• Implemented Data Guard on Production with Disaster-Recovery and Standby database modes, ensuring robust data protection and minimal downtime during failures.
• Managed user accounts and privileges, resulting in enhanced database security and accountability through comprehensive auditing of user actions.
• Supported server operations by executing service restarts for OS patching, leading to minimal downtime and maintained operational efficiency of standalone and clustered services.
• Initiated and resolved Oracle Service Requests (SRs) for production issues, which ensured timely resolutions and improved system reliability during critical activities.

• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
• Checking Database Health check reports and taking necessary action for backup status, managing tablespaces, schema status, failed jobs etc.
• Performed Oracle Database patching on Linux (RAC and Standalone) and Windows environment (Standalone).
• Gathering Schema and Table level statistics using DBMS_STATS Procedure in non-business hours based on the requirement.
• OEM agent configuration in both online and offline mode, pulling reports from like CPU, Memory, etc from OEM console.
• Performed Oracle Database patching on Linux (RAC and Standalone) and Windows environment (Standalone).
• Hands on experience of Installation of MSSQL server software in windows platform.
• Preparing the documents for new activity and issues occurred in production environment.
• Creation of Database, Users and Login creation on user requests.
• Performing Full backup and restore operation in same or different server.
• Monitoring the log files space and shrinking it when more disk space is consumed by the Database.
• Scheduling the backups and cleanup task in maintenance per the user requirement.
• Performed MSSQL server Database mirroring for high availability.
• Monitoring server Dashboard using GUI for performance issue.
• Monitoring CPU, Memory Usage, top SQL queries using SQL server GUI feature.

• Checking Database Health check reports and taking necessary action for backup status, managing tablespaces, schema status, failed jobs etc.
• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
• Preparing weekly reports on Performance or other related issues.
• Monitoring dataguard sync issues
• Implementing user request, creating user, granting permission etc.

Worked as software tester, testing an in-build application fixing-up bugs with the development team.

Its an e-publishing organisation worked as team lead ensuring deliverables on target. Along with tool development.

worked as copy-editor

worked as copy-editor

• Migrated Oracle databases from physical servers to VMs using ODG, RMAN, Datapump, and OGG, resulting in enhanced system performance and efficiency in data management practices.
• Mention measurable impact or results you helped deliver. Focus on the outcome of tasks. Example: Modified customer service support system to reduce complaints by 10%.

• Supporting for BC5 criticality application
• Supporting for migration project from RHEL physical servers to VM.
• Mention measurable impact or results you helped deliver. Focus on the outcome of tasks. Example: Modified customer service support system to reduce complaints by 10%.