Sakthivel Mohan Email & Phone Number

Bangalore, Karnataka, India

Installation and Configuration of oracle 19C Grid Infrastructure and RAC databases. Expertise in Migrating Oracle DB 12C to 19C on AWS EC2 instances using RMAN.Handled up to 200TB Production DB migration from On-premise to AWS Cloud.Expertise in Oracle Data guard ADG and Cascade ADG build upto 4 Standby nodes on AWS EC2.Migrated up to 100+ databases and 2 Petabytes of data to AWS cloud without any issues.Configured RMAN backup to AWS S3 bucket.Worked effectively on cost saving/optimization in AWS EC2, RDS and EBS.Experienced in migrating Onprem DB to AWS RDS for Oracle.Performed POC activities for Database Failover and DR scenarios using Active DataguardPatching RAC and standalone Database servers quarterly.Roll forward the standby database if they are not in sync.Expertise in setting up read replica in AWS RDS Oracle DB.Good experience in Backup and restore using RMAN utility.Database performance tuning using ADDM, AWR, ASH, SQL-T reports.Exporting and importing data in database using Data Pump utility.Automated Opatch upgrade, Patch analyse and pre patch activities using Ansible script.Performing DR drill activities.

Madurai, Tamil Nadu, India

Installation of Oracle Database servers.Good knowledge and hands-on experience in implementation of database servers (includes HA setup like RAC, and data guard).Grid Infrastructure installation and configuration.Patching the binaries with the latest PSU patches.Roll forward the standby database if they are not in sync.Configuration and administration of Data guard.Configuration of Goldengate unidirectional replications. Execution of scripts, user creation and management.Database migration using RMAN in various scenarios.Cluster configuration verification using Cluvfy utility.Implemented DR setup using AWS RDS Read replica.Exporting and importing data in database using Data Pump utility.Deploying the scripts in database on the advice of application team.Regular monitoring of all DB environments (RAC, data guard & single instance).Database refresh in various servers using RMAN (both single instance & RAC setup).Troubleshooting the problems and issues and finding a workaround and avoiding down time for all the environments.Hands-on experience in working on DR-drill activity various times and ensuring that activity is completed perfectly.

Chennai Area, India

Providing 24/7 support of both development and production 11g/10g databases.Oracle DB server Installation and building database as per requirement. Perform schema backups and restoration from production to development in a request basis to make sure the UAT data’s are in sync with production for reporting purpose.Regular online shrinking in DB segments to reclaim unused space and improve DB performance.Ensuring sync between primary and standby databaseInstallation and configuration of Oracle Client softwareGood Experience in Incident, Problem and Change Management.Administer database user accounts. Create, Granting and deactivate user accounts.Performed series of database schema refreshes from production to test using expdp/impdp.Monitoring the blocking sessions and take appropriate action to kill the inactive sessionsSOLARIS/LINUX commands for administering database.Register, classify the incidents and undertake an immediate effort to restore the failed IT service as quickly as possibleIdentifying impact and Root cause of various exceptions from checkout app servers using Splunk tool.Coordinate cross department communications when required to assist in resolution of Incidents/ Problem/ Changes.Responsible to ensure Severity 1 & 2 SLA's are met. Ensure proper management of Sev1 & Sev2 queries/ monitoring.The core role was to keep the applications and the servers up 24/7 and to be in touch with administrators and users to help them and to resolve server and application related issues.Identifying the scope for automate the tasks and working with Automation team to automate the various periodic / repeated activities.