Vivek Verma

About Vivek Verma

Total 16 years of experience as Oracle Database Administrator and experience on UNIX (Solaris, HP-UX, AIX), Linux, PL/SQL, Sql etc. • Worked as Oracle Database Performance Tuning expert (SME)• Good understand of AWS• EC2 - on-demand, reserved, saving plans, spot instances, dedicated hosts, capacity reservations- placement groups: Cluster, Spread, Partition RDS - Oracle, PostgreSQL, MySQL, MariaDB, Oracle, Aurora- security (network, IAM, Encryption in transit (SSL/TLS), at Rest (KMS)) Sound knowledge of Oracle Cloud and Amazon Web Services. • Hands on experience of 9i/10g/11g/12c/18c/19c RAC implementation, maintenance and support, Oracle Data guard (10g/11g/12c/18c/19c) and Recovery strategies using RMAN (9i/10g/11g/12/18/19c)• Expertise in OEM 12c/13c Cloud control.• Extensive experience of PSU patching and bug fixes.• Good hands-on experience with shell scripting like sh, bash, ksh, Perl, Python.• Database replication using Golden Gate and administration.• Strong knowledge on Exadata Versions and Configurations.• Strong knowledge on Exadata Hardware Architecture.• Strong knowledge on Three Main HW components on Exadata i.e. DB Servers, Cells and NW components like Infiniband/Roce, Admin Switch and PDUs.• Knowledge on PMEM and RoCE switches introduced in X8m• Knowledge on Front and Back panel port functions.• Knowledge on -2 and -8 DB Servers• Knowledge on HC, EF types of Storages• Strong knowledge of Exadata Software Architecture.• Strong knowledge of Networking Architecture. Clear understanding of Admin/Management, Client and Private networks.• Knowledge on cellip.ora and cellinit.ora• Strong knowledge on Exadata Storage Server unique features like Smart Scan, Storage Indexes, Smart Flash Cache, Hybrid Columnar Compression and IORM Plans.• Support databases in Exadata environment and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues.• Hands on experience on Exadata X4-2, X6-2, X7-2, X8-2, X8M-2 Database Machines.• Knowledge on iDS, RDS protocols, RDMA Mechanism and query offloading mechanism over to storage servers from DB Instances.• Performed caching of existing and new Database objects into ESFC using CFC (Cache_Flash_Cahce) attributes.• Knowledge on Caching hints like \'Cache\',\'NoCache\',\'Evict\'.• Changed the mode of SFC from WriteThrough to WriteBack mode and vice versa in rolling as well as non-rolling methods.• Good experience in Exadata Storage Server Administration.• Complete knowledge on Physicaldisks, LUNs, Celldisks and Griddisks.

Experience

1. Principle Database Consultant

   Oracle

   Nov 2021 — Present · US

Education

• Punjab Technical University

  Master of Computer Application - MCA, Computer Applications

  2008 — 2010

• Punjab Technical University

  Bachelor of Computer Application, Computer Application

  2001 — 2004

Skills

• Oracle Streams
• Sql Tuning
• Oracle Asm
• Shell Scripting
• Oracle Enterprise Manager
• Performace Tuning
• Sql
• Oracle E-Business Suite
• Rman
• Goldengate
• Red Hat Linux
• Oracle Rac
• Python
• Pl/Sql
• Object Oriented Perl
• Amazon Web Services (Aws)
• Database Migration
• Database Upgrade
• Data Guard