Organizational Experience-4:

12 JUNE 2017 to Till date.Organization    :Virtusa Consulting Services Limited
Client        :American Lawyer Media (ALM).
Role        :Sr. Oracle DBA

Environment:    Oracle Database 10g/11g (11gR1, 11gR2) /12c OEM, Data Guard, RAC, RMAN, Data Pump, OPatch, OPatch auto, Sun Solaris, Linux, AIX, windows family, Xmanager, MySql.

Roles & Responsibilities:    

    Provide Support on  Priority for multiple instances, database Incidents Issues and Critical DB Activities.
    Monitoring single instance and  RAC databases on a daily basis as part of Health check.
    Raising SR with ORACLE to find the radical cause of the problem and providing suggestion to a client to avoid in future.
    Developing and submitting RCA to client with Proper justification.
    Applying Oracle Patches (PSU/Bundle/One-off Patches) on the critical Production Environment (Single Instance/RAC) on a quarterly basis to avoid incidents also Applying Auto patches on RAC setup for grid as well as for Database home.
    Knowledge of configured  Standby / Dataguard and Data Guard Broker to manage data guard environment on (Single Instance/RAC) Environmental.
    DR-Drill Activity. Performed manual Drill Switchover and Switchback on multiple databases (Single Instance/RAC).
    Creating new Production, UAT and DR Database configuration setups as per client requirement.
    Implemented database refreshes with the Data pump and Traditional Exp/Imp to do table level and full database defragmentation.
    Implementation and support for Oracle Clusterware& Database Software (Troubleshooting using cluvfy & handling common issues that arise during the integration of the whole – bugs, network issues, configuration file issues, OCR issue, deinstallation & cleanup of Clusterware).    
    Database Upgradation (Oracle 10g, 11g, 12c and RAC instance).
    Manage the Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle Clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
    Performing weekly activities like Index Rebuild, Gather Stats and Table/Schema Reorg activities.
    Convert database Non-ASM database to ASM Database (Oracle 10g, 11g, 12c).
    Convert database physical standby to snapshort mode and activated databse if necessary.  
    Resolving gap between production to physical standby (Oracle 10g, 11g, 12c).
    Handling new technologied MySql, MongoDB databases.
    Installing and configuring MySql database setups as per client requirement.
    Implement and configured MySQL Replication as part of HA solution.
    MySQL database backup and recovery strategies and Replication and synchronization.
    MySQL backups using mysqldump and restore using mysql from one host to another.

Organizational Experience-3:

11 JAN 2016 to 05 JUNE 2017. Organization    :Netmagic Solutions Information Technology& Services
Client        :Multiple Clients from Various Domains.
Role        :Sr. Oracle DBA

Environment:    Oracle Database 10g/11g (11gR1, 11gR2) /12c OEM, Data Guard, RAC, RMAN, Data Pump, OPatch, OPatch auto, Sun Solaris, Linux, AIX, windows family, Xmanager, panacis tool.

Roles & Responsibilities:    

    Provide 24*7 On-Call Support on  Priority for multiple instances, database Incidents Issues and Critical DB Activities.
    Monitoring single instance and  RAC databases on a daily basis as part of Health check.
    Raising SR with ORACLE to find the radical cause of the problem and providing suggestion to a client to avoid in future.
    Managing tablespaces, user quota, rollback segments, user maintenance, database security imposition by creation & granting of roles & privileges, performance tuning, backups (Hot/Cold) using RMAN. 
    Applying Oracle Patches (PSU/Bundle/One-off Patches) on the critical Production Environment (Single Instance/RAC) on a quarterly basis to avoid incidents also Applying Auto patches on RAC setup for grid as well as for Database home.
    Implemented RMAN advance compression and Table level compression on mission critical databases to optimize execution.
    The experienceof Resolved/Diagnose Node Eviction.
    Collecting Diag-collection, RAC-check and ORA-check reports to Analyze Database issues.
    DR-Drill Activity. Performed manual Drill Switchover and Switchback on multiple databases (Single Instance/RAC).
    Backup and Recovery issues related OCR, Voting Disk.
    Experience of Add or Remove Node and ASM Disk from RAC.
    Knowledge of configured  Standby / Dataguard and Data Guard Broker to manage data guard environment on (Single Instance/RAC) Environmental.
    Managing MySQL servers includes production, Cap stage and QA environment.
    Upgraded MySQL 5.5 to MySQL 5.6 with necessary patches.
    Backup, restore and recover of MySql database.

Organizational Experience-2:

08 OCT 2014 to 05 JAN 2016.Organization    :ThinkApps Solutions Private Limited(WiproInfotechPrivate Limited)
Client        :HDFC Bank, Chandivali, Andheri (E), Mumbai.
Role        :Oracle DBA

Environment:    Oracle Database 10g/11g (11gR1, 11gR2) /12c OEM, Data Guard, RAC, RMAN, Data Pump, ASMCMD, OPatch, OEM12c, Sun Solaris, Linux, AIX, windows family, Xmanager, panacis tool.

Roles & Responsibilities:    

    Experience as a production DBA, maintaining and troubleshooting, maintaining multiple instances in a 24/7 Production supports.
    Performing Database Maintenance/Performance  Activities as per USD call logging. Updating USD Call status.
    Experience in Oracle 10g, 11g,12c  and RAC Installation, Administration, Monitoring, Database Backup and Recovery , Table Re-org , Patch Application,DB Reviews, Baselining. Maintenance tasks such as index rebuild, schema analyzes.
    Extended usage of Data Pump expdp/impdp to clone/refresh Schema, database from Production to Test and Development Environment.
    Produce and manage tablespaces, indexes and physical storage structures like data files, redo logs, archive logs. Allocate and manage logical storage structures like tablespaces, schemas and extents.
    Setup and configured Oracle (Data guard) physical standby database as DR Solution for production database using RMAN create standby database command, also set up Data Guard Broker to manage data guard environment.
    Experience with ‘graceful’ switchover and switchback between primary to physical standby to snapshot databases using the Data Guard broker. 
    Experience in Oracle database 10g/11g (11gR1,11gR2), 12c and RAC Upgradation.
    Backup of the database  as per request taken through Cold Backup/RMAN/EXPDP.  
    Performed DB Cloning uses user managed backup and RMAN and active cloning.
    Tuning and Troubleshooting: Diagnose and resolve locking conflicts; monitor the instance, collect and analyze relevant database performance
    Experience in Performance Tuning and Monitoring using various instruments such as  Explain Plan and by Rebuilding Indexes.
    Restoring Of databases for UAT and development setups.
    Patches Implementation (PSU, CPU, One-Off) including RAC.
    Migrating Non-ASM database to ASM Database.

Organizational Experience-1:  

 02 JAN 2012 to 05 OCT 2014.Organization    :iwarelogic technologies Private Limited
Client        :parametric technologies corporationPune
Role        :  Oracle DBA

Environment:Oracle Database 10g/11g (11gR1,11gR2), Linux, RMAN, Data Guard, 
            EXP/IMP, OPatch, Xmanager, Windows family, Putty, MSTSC.

Roles & Responsibilities:

    Daily monitoring includes checking whether all databases are running, the listener is running.
    Make the required Tablespace, add new Datafiles, Resize Datafiles, Rename Datafiles as per required.
    Implementing and maintaining database security (create and maintain users, roles and assign privileges). 
    Performing table re-org activity & index rebuilding.
    Monitoring of scheduled backups (RMAN & Export). Checking backup logs to find out backup status & troubleshoot if backup failed.
    Experience in performing the retrieval of the Oracle Database files in various recovery scenarios.
    Experience in Upgrading and applying, to security patches the databases.
    Plan and implement database backup strategy (hot/cold backup, IMPORT/Export, RMAN).
    Installation and creation of Oracle 10g/11g Database Instance.
    Experience of  Implementation and apply the patch (PSU, CPU, One-Off) on database binaries.
    Have done Switchover and Switchback of the many production database.
    Maintenance tasks such as index rebuild, schema analyzes, Creating Standby database, Table Re-org.
    Experience in configuring the Standby Database (DataGaurd) Setups.
    Creating new Production, UAT and DR Database configuration setups as per customer demand.

Accomplishment Summary:

    Managing the ticketing system to support Database24X7 and track the activities for proactive approach solutions.
    Expert in Oracle single instance/ Real Application Cluster (RAC) Database administration involving capacity planning, Implementation of medium and very large sized mission critical production databases Designing & creating physical database.
    Experience with Oracle 10g/11g Real Application Clusters (RAC) Installation, Database creations, Administration, Monitoring, Database Backup and Recovery.
    Broad exposure to database Cloning (i.e. Cold/Hot Backup and RMAN) 
    Substantial experience in logical backup using Data pump and Traditional Exp/Imp.
    Sound understanding of Real Application Cluster (RAC) Databases, OCR, Voting Disk and good exposure in CRSCTL & SRVCTL commands.
    Experience in User Management, Space Management, tnsnames & Listener Configuration.
    Creating and Managing Tablespace, datafiles, schema objects and users.
    Broad exposure to RMAN, Backup, Rman restoration and Recovery techniques for single instance as well as RAC environment.
    Experience in oracle database Upgradation with 10g/11g/12c.
    Implemented Data Guard (logical &physical) for maximum protection, performance and availabilityand Dataguard broker.
    Experience of Switchover and Switchback of production Database.

Master Certifications:

    Oracle Database SQL Certified Expert.
    Oracle Certified Associate (OCA) 10g Database Administrator.
    Oracle Certified Professional (OCP) 10g Database Administrator.
    Oracle Certified Associate (OCP) 12c Database Administrator.
    Oracle Certified Expert,RAC 11g and Grid Infrastructure Administrator.
    ITIL® Foundation Certificate in IT Service Management.

Academic Qualifications

    MCM in Information Technology (2009-2011) from University Of Pune.
    Bachelor of Science (2005-2009) from University Of Pune.

Technical Competencies:

    OperatingSystem        :  Linux, AIX, HP-UX, Sun Solaris, Windows XP, Windows Server. 
    Database            :  Oracle RDBMS, 10g,11g,12c, SQL Server 2008/2012,
MongoDB, MySql.
    Application            :  Oracle E-Business Suite release 11i, R12, 12c OEM.
    Database Tools        :  DBCA, DBUA, RMAN, EXP-IMP/Data pump,Opatch, 12c OEM, 
                Tkprof, AWR, ADDM, Data Guard, data broker.