PARTHEEPAN PERIASAMY

• Planning, deploying, and supporting 19c/12c/11g Oracle RAC,Exadata,GoldenGate,Data Guard and ASM environments
• Performance turning on queries that were poorly performing to identify ways to improve response time and throughput
• Upgraded oracle 11g/12c RAC databases to 19c RAC with Zero down time method using Golden Gate and database link
• Create High Availability 11g/12c/19c RAC utilizing Data Guard in compliance with Oracle Maximum Availability Architecture(MAA)
• Implemented Data Guard(Standby) for HA purpose and configured the database to switchover and failover
• Zero Downtime Migration to Oracle Exadata with Oracle Golden Gate
• Migration from AIX oracle database to Exadata
• Excellent architectural knowledge and experience on Oracle Exadata X2-2 (cell patching tasks, restarts]
• Experienced with Oracle Multitenant and single tenant architectural database with standby
• Analyzed client business processes to propose optimal software applications for unique requirements.
• Installed system updates to address vulnerabilities and reduce security issues.
• Investigated system issues and implemented resolutions to reduce downtime.
• Experience on Database monitoring tool (EM grid control)
• Performing POC activity for Monitored and managed different RDBMS databases running on Cloud (OCI, AWS) including database installation, configuration, migration, replication, backup, restoration, replication.
• Improved systems with addition of new features and infrastructure.

• Capacity planning/coordination for critical production databases upgrades
• Experienced with Oracle Multitenant and single tenant architectural database with standby
• Experience on Database monitoring tool (EM grid control)
• Installing, configuring, creating oracle (10g/11g/12c/19c RAC , non-RAC)
• Administer, maintain ASM instances, disk groups, and Perform ASM rolling upgrades
• Install & configure Oracle golden gate for Schema replication
• Configured Golden Gate Active-Active Replication
• Manage all aspects of the OGG implement and support in development, UAT and Production environments
• Identify and resolve OGG problems occurring in all database environments
• Performance Tuning OGG in extremely high data volume environments
• Installing and configuring OGG heterogeneous environments
• Maintain and monitor Oracle golden gate trails files at Source and Target databases
• Experience in configuring Disaster Recovery site, setup of physical standby database for single instance and RAC databases
• Apply patches CPU, (PSU) on development and Production Databases (single node, Multi node)
• Configured and supported Golden Gate Replication for 7TB data from oracle database to Big Data
• Recovery of Database(Recovering from Media Failure, tables dropped accidentally, Recovering data files, block corruption)
• Migrated development/test oracle databases to AWS RDS.
• Prioritized projects and project tasks depending upon key milestones and deadline dates.

· Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment

· Installing & configuring Oracle clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole – bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of clusterware)

· Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.

· Worked with customer for different RAC related issue :[hang check timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on]

· Troubleshoot performance issues for the RAC instances (GC events)

· Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data

· blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with

· block change tracking & also flash recovery area.

· Resolved/Diagnose Node Eviction.

· Create High Availability 11g/12c/19c RAC utilizing Data Guard in compliance with Oracle Maximum Availability Architecture(MAA)

· Implemented Data Guard(Standby) for HA purpose and configured the database to switchover and failover.