Jay Varia

About Jay Varia

Oracle Certified DBA with more then 9+ years of experience in Database Administration as well as E-Business Suite of large production/non production environment and in various platforms like IBM AIX, Red Hat Linux, Sun Solaris, HP-UX,OEL Participated in project requirement and design meetings Perform remote and local installation of Oracle 10g/11g/12c/19c database software, Oracle R12 Application Experience in Database Upgradation and Migration of Oracle database Apply Oracle application server bug fixes, security patches and maintenance pack patches including RUP and RPC patches Cloning of EBS systems to single/multinode. Configuration of Physical standby and performed DR Drill. Design and implement backup and recovery strategy and script in various scenarios while database is in archivelog or noarchivelog mode using methods like RMAN, datapump, export, import, cold backup, hot backup etc. Manage table, index, tablespace, database file; redo log file, control file, spfile, parameter file, rollback segment, view, sequence and other database object. Performance monitoring and tuning of database, application, system global area, I/O, rollback segments using self-developed script, Oracle Enterprise Manager, Toad, explain plan and tkprof. Write UNIX shell script for database monitoring, application interface and high availability of database system. Basic Knowledge of 11g RAC Proven ability to resolve problems, quickly diagnosing & identifying issues and determining proper resolutions.

Experience

1. Consultant

   Capgemini

   Dec 2016 — Present · Mumbai, IN

Education

• K. J. Somaiya Institute of Technology

  Bachelor of Engineering - BE, Information Technology