Rahul Wankhede

Experience

• 

  Amdocs

  Dec 2008 - May 2015

  Oracle Database Administrator (SSME)

  Techhology : :Oracle DBA, RAC, Datagurad, Golden Gate, Timesten, PSU Patching, Installation and Upgradate, Performance Tuning. Timesten, SQL Server 2005/2008Role:• Installing and setup Database Servers RAC/non-RAC as per Amdocs standard• Planning and upgrading existing Oracle database from 10g to 11g. • Golden gate setup(Classic and Integrated) for existing and new client.• Planning and Applying PSU patches on all production (standalone and Grid) environments. • Configuring Backup Policies, Restore and Recovery using RMAN.• Handling all shift and Maintenance activities, Executing Changes.• Performing any corrective actions required to address errors raised in the log files• Tune queries for Batch Jobs, online standalone scripts and ad-hoc queries • Investigate the database operations of various Billing and reporting jobs to optimize performance. • Represent DBA team in Release Management meet to prepare maintenance activity checklist • Monitoring and troubleshooting replication to client and internal replication through Golden Gate.• Write Shell scripts to automate daily tasks to reduce the downtime.• Handling Amdocs Application Release where Understanding TRN and take action.• Working with developers and releases activity to upgrade the database structure. • Re-organization of table and index to remove fragmentation during downtime.• Setting up internal Database monitoring with the help of cron.• Setting up Timesten In Memory Database and replication.• Monitoring/Troubleshooting Timesten datastore in Production and Production like environments through internal shell scripts. Show less

• 

  Fidelity Investments

  May 2015 - Apr 2017

  Lead Oracle DBA

  Technology :RAC 12c/11g, RMAN, Golden Gate 11/12, OEM 12, Timesten 11, SQL Server 2008.Third part Tools :Delphix, AutoSys, Golden Gate Varidata• 300+ RAC Sever/Database Instance, 100+ RAC Prod / Non-Prod database. • Troubleshoot Grid/node eviction/reboot issues.• Install/Upgrade 12c/11g database / grid infrastructure.• Database migration from non-cdb to cdb.• Golden Upgrade 11 to 12, upgrading Classic EXTRACT/REPLICAT to Integrate.• Setup Golden Gate for database Replication and Migration.• Managing Timesten 11 Cache Group with two safe replication.• Handling DR DRILL involved switchover of Oracle/ Timesten database.• End To End planning for PSU patching across the boards.• Setup Delphix environment, configuring Data source and creating aux database.• Monitoring environment with AUTOSYS.• Configure matrix from OEM to setup a monitoring• Installation of OMS and OEM 13c.• Maintenance of SQL SERVER 2008.Major Project handled :1. Upgrade Golden gate from 11 to 12c and Classic to Integrate to leverage new OGG feature in prod and non-prod environment.2. Set up golden gate replication for migrating 15 TB of database from 11g AIX to 12c Linux. 3. End to End planning/execution of database switchover every after six month without any issue.4. Complete ownership of patches/rolling Patches manually and using OEM.5. Rolling upgrade Multinode RAC environment from 11g to 12c.6. Write Multiple Shell Script for Automate task/ Generate report using shell script and BI Publisher. Show less

• 

  Credit Suisse

  Mar 2017 - now

  Lead Oracle Database Administrator

  • Oracle DBA 12c / 19c multitenant . AWS , Oracle Cloud• Migrated TB's of Oracle Database to AWS, Oracle Cloud using Datagaurd and GoldenGate.• Migrated Oracle Database to OCI using ZDM.• Cloning multitennant PDB's .• Exadata Patching. • RAC, Datagurad, RMAN, OEM, Performance Tuning.• Working on Golden Gate for data replication to Oracle database.• Cassandra, Delphix, SQL Server 2005/2008, Timesten 7/11.• Shell scripting / Automation.Successfully Migrated Oracle Database to AWS using standby switchover.• Installing Oracle binaries and creating database in AWS region using CFT.• creating standby database using RMAN backup and active duplicate.• Switchover standby database to AWS. • Configure Delphix environment to AWS for Migrating Non-prod database . Show less