Vinod Kumar Ranjan

About Vinod Kumar Ranjan

Experience Summary:Proven capabilities in administration of large-scale Oracle databases and Engineered machine like Exadata. Expertise in handling multi-geographical Oracle projects in VLDB environment with top tier financial organisations. 8+ years of experience in handling Oracle production databases along with various database administration activities. • Grid (GI) upgradation from 11g to 12c• Database upgradation from 11g to 12c (Standalone & RAC) • Creation of Standby databases• Creating RAC and Standalone DB’s• Applying PSU, DBBP, RU one-off patches for oracle RAC and standalone databases.• Applying PSU, DBBP, RU patches on GI • Configuring DG BROKER setup• Maintenance of Backups and restoration using RMAN• Experienced in backup and recovery• Creation of 12c database Container and non-container database• Providing support for DR drill (using Flashback method/switchover and switch back)• Experience in database migration from one datacenter to another • ACFS setup• Conversion of database from filesystem to ASM• Conversion of database from oracle restart to single node RAC• Conversion of database from normal to single node RAC• Ensuring Health of Database by Monitoring alert log and Archive Generation• Tablespace, User management • Goldengate setup and administration, troubleshooting • Basic database Performance troubleshooting• Working with application team to understand the need and designing a database env (Goldengate/rac/non-rac/nodes)• On call support and weekend tech-window support• Experience in migrating/refreshing schema/schemas using data pump utility• Experience in developing shell script for team • Worked on oracle apex in developing automating DR switchover/switchback tool• Experience in python scripting• Experience in Oracle Exadata

Experience

1. Senior Engineer

   FICO

   Dec 2021 — Present · Bengaluru, IN

Education

• Visvesvaraya Technological University

  B.E

  2005 — 2009

• Visvesvaraya Technological University

  BE

  2005 — 2009