Prasad D
Chennai
Summary
Dynamic database professional with extensive experience at Optimum Infosystem Pvt Ltd, specializing in Oracle RAC setup, Data Guard troubleshooting, and RMAN backup strategies. Proven track record in enhancing system performance and ensuring business continuity through effective disaster recovery solutions. Strong analytical skills complemented by a collaborative approach to problem-solving.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Catalyst Migration Project
Optimum Infosystem Pvt Ltd
01.2025 - Current
- 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.
Senior Software Engineer
Optimum Infosystem Pvt Ltd
Chennai
05.2023 - Current
- 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 optimize 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.
Support Engineer
Standard Chartered Bank
05.2023 - Current
- Supporting for BC5 criticality application.
- Supporting for migration project from RHEL physical servers to VM.
System Engineer
CGI
Chennai
06.2022 - 05.2023
- 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.
- 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.
Engineer
3i-Infotech Pvt Ltd
07.2021 - 05.2022
- 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.
Engineer
Foxconn (RSMIPL Pvt Ltd)
03.2020 - 07.2021
- 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.
Analyst
Apex Co-vantage Pvt Ltd.
10.2018 - 06.2019
- Worked as software tester, testing an in-build application fixing-up bugs with the development team.
Team Lead
MPS Limited Pvt Ltd.
07.2012 - 10.2018
- Company Overview: Its an e-publishing organisation
- Worked as team lead ensuring deliverables on target. Along with tool development.
- Its an e-publishing organisation
Editor
Laserwords Pvt Ltd.
06.2010 - 06.2012
- Worked as copy-editor.
Editor
Techset India Comp Pvt Ltd.
12.2008 - 06.2010
- Worked as copy-editor.
Education
B.Sc - Chemistry
Ramakrishna Mission Vivekananda College
07.2007
Skills
- Oracle RAC setup & troubleshooting
- Data Guard build & trouble shooting
- Database performance tuning
- GoldenGate setup and troubleshooting
- RMAN backup and restore
- Database cloning and refresh
- Data Pump utility
- Linux administration
- Database refresh using RMAN and Data Pump utility
- Database migration
- Shell scripting & Linux administration
Certification
Oracle Certified Professional, 03/01/25
Languages
- English
- Tamil
- Telugu
Projects
Catalyst Migration Project, Optimum Infosystem Pvt Ltd, 01/01/25, Present, 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. Standard Chartered Bank, 05/01/23, Present, Supporting for BC5 criticality application and migration project from RHEL physical servers to VM.
Personal Information
- Title: Senior Software Engineer
- Date of Birth: 12/14/85
Company
Optimum Infosystem Pvt Ltd
Language
Telugu
First Language
English
Proficient (C2)
C2
Tamil
Proficient (C2)
C2
Timeline
Catalyst Migration Project
Optimum Infosystem Pvt Ltd
01.2025 - Current
Senior Software Engineer
Optimum Infosystem Pvt Ltd
05.2023 - Current
Support Engineer
Standard Chartered Bank
05.2023 - Current
System Engineer
CGI
06.2022 - 05.2023
Engineer
3i-Infotech Pvt Ltd
07.2021 - 05.2022
Engineer
Foxconn (RSMIPL Pvt Ltd)
03.2020 - 07.2021
Analyst
Apex Co-vantage Pvt Ltd.
10.2018 - 06.2019
Team Lead
MPS Limited Pvt Ltd.
07.2012 - 10.2018
Editor
Laserwords Pvt Ltd.
06.2010 - 06.2012
Editor
Techset India Comp Pvt Ltd.
12.2008 - 06.2010
B.Sc - Chemistry
Ramakrishna Mission Vivekananda College
Similar Profiles
RAMYA RAVIRAMYA RAVI
Senior Consultant at Optimum InfoSystem Pvt LtdSenior Consultant at Optimum InfoSystem Pvt Ltd
Akshay BagdiAkshay Bagdi
Technical Co-ordinator at Optimum Infosystem pvt LTDTechnical Co-ordinator at Optimum Infosystem pvt LTD
Hina PathanHina Pathan
Automation/Functional Test Engineer at Optimum Infosystem Pvt LtdAutomation/Functional Test Engineer at Optimum Infosystem Pvt Ltd
Sree Deepthi BapatlaSree Deepthi Bapatla
Scrum Master at Citicorp Services India Pvt LtdScrum Master at Citicorp Services India Pvt Ltd
Burhan BashaBurhan Basha
Account Operations Lead at Hewlett Packard EnterpriseAccount Operations Lead at Hewlett Packard Enterprise