Projects: -
12.1.3 Oracle Ebs and 12.1 Oracle Database DR Testing drill.
OA Auth 2.0 Enablement for Workflow, Quaterly CPU Patching, JDK Upgrades and Java Webstart Enablement
Planning and implementation of quaterly CPU patching of RAC / NON – RAC Databases.
Enabling Linux shell-based monitoring scripts, DR database setup.
Quaterly CPU patching, Shell Script Automation for schema refresh, purging applied archive logs from dr and primary databases, old trace file deletion, and audit file deletion .
PostgreSQL instance setup and linux shell based monitoring scripts for monitoring PostgreSQL.
Implementaion of bash shell based script for automatic backup transfer of Mysql instance version 5.7 setup along with Replication.
Implementation of Rac instance supporting oracle PIP (WebLogic-based application).
Implemented Supervised learning conceptual based bash script that removes archives based on label determination, i.e., applied archives.
Upgrade auto cloning script kick off mechanism based on supervised learning principle which determines the production backup status and initiates auto cloning on prod accordingly.
Setup Ebs and Non-Ebs clone environments.
Database migration.
Skills: -
My SQL Database / PostgreSQL.
Linux Shell/ Perl/ Python Scripting.
MySQL 5.7 and PostgreSQL version 10.
Oracle Enterprise and Standard edition Database version 10g/11g/12c/19c.
Oracle EBS version 11.5.10.2, 12.1.3, 12.2.5,12.2.8.
Oracle business intelligence suite version (OBIEE) 12.2.1.3.
Data Science and Data Analytics.
Oracle Database Performance Tuning.
Data replication via Oracle Goldengate 12c.
Database DR MySQL 5.7 replication and Oracle data guard (Physical Standby).
Effective communication skills.
Presentation and training skills.
Strong customer service skills .
Exceptional attention to detail with proven analytical and problem-solving abilities.