Anup Vasu

Background

About Anup Vasu

Oracle certified professional with over 10+ years of experience in various Oracle Database and System Administration functionalities including installation, upgrades, patches, Disaster recovery, Oracle Golden Gate, cloning in health care, logistics and manufacturing domains.• Expert On-Call 24x7 production DBA support, application/development DBA.• Extensive knowledge on database administration for Oracle 11g and 12c, with experience in very large-scale database environment and mission critical large OLTP and OLAP systems.• Extensive Knowledge with installation and maintenance of ORACLE RAC and standby database for High Availability and Disaster Recovery purpose.• Experience in managing Oracle databases running on MS-Windows, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.• Expertise in Oracle 11g/12c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).• Good experience RAC Clusterware administration, Configuration and Patching.• Extensive experience in Dataguard configuration, implementing and maintaining standby databases.• Hands on experience in Grid control, Streams, GoldenGate Replication.• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.• Setup Oracle Enterprise Manager (OEM) for database monitoring/performance/diagnostics.• Extensive experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.• Good experience in writing/editing UNIX Shell Scripts.• Good experience in PATCHING AND UPGRADATION. Expertise in upgrading Oracle Development and Production databases from 8i to 9i, 9i to 10g & 11g, 10g to 11g.• Extensive knowledge and experience on managing very large Data Warehouse databases.• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB.• Experience in Flash-Back Technology.• Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.• Experience in Capacity Planning and Bench Marking.• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).• Trained in Oracle Exadata appliance concepts