SKILL SET.) Oracle Certified Professional (OCP) with 10 years of experience that includes developing, deploying, Administration and managing Databases in Production environments ranging in size up to 100TB on various platforms such as Solaris, HPUX,AIX, LINUX and Windows Operating systems. Versions include 10g, 11g, 12c and 19c..) Cross platform migration using FAST XTTS WITH CROSS PLATFORM INCREMENTAL BACKUP with Automated and Manual methods..) Migration of ON-PREM Databases to CLOUD PDBs using different approaches like TTS and Unplug/Plug PDBs. .) Attention to DSS/Datawarehouse environment by providing proper PARALLELISM settings and RESOURCE PLAN/CONSUMER GROUP and careful in gathering STATISTICS for Batch loads..) Experience on monitoring and troubleshooting Performance issues using HISTOGRAMS, JOIN METHODS, JOIN ORDER, OPTIMIZER, TRACE, HINTS, AWR, ADDM, ASH, SQL PLAN, SQL PROFILE, BASELINES, TKPROF, Load average, HANGANALYZE etc..) Very good exposure and hands on Goldengate undirectional Oracle to Oracle..) Expertise in 4-8 node RAC Installation, Node addition/deletion, configuration and managing Oracle RAC 11g/12c/19c databases. Skilled in RAC performance issues. .) RAC ONE node installation with server pool configuration / Patch server pools in rolling fashion with less downtime..) As part of Disaster Recovery (DR), Implemented and administered DATAGUARD/DG_BROKER set up with OBSERVER in all DB versions with different modes depending on the acceptable RTO and RPO. .) Highly skilled in RMAN (Backup/Recovery/Validation/Cloning/Block Corruption) task..) Defined protection policy to databases and configured/scheduled backup cycles to Tape(TSM/NETBACKUP).) Administered, cloned, patched and upgraded Oracle databases 11g, 12c, 19c and in between releases.) Very good Knowledge on Exadata. .) Enable and AUDIT the database to protect and preserve privacy information stored in the database as per the client requirement..) Create and configure Oracle Audit Vault and WALLET for storing SSL certificates and connection ALIAS to avoid exposure of user password. .) Transparent Data Encryption (TDE) and REDACTION methods to secure confidential data. .) Creation and maintenance of PARTITION tables. Purging historic data and rebuilding Index when necessary. .) Automation/Documentation of the reoccurring task. ADDITIONAL SKILL.) SQL SERVER DATABASE ADMINISTRATOR. - Installation, Patch, Upgrade. - ALWAYS ON AVAILABILITY GROUPS (AOAG).- Database Security.- PT and Defragmentation.