Mayur Dubey Email and Phone Number

➢ Working in migration and upgrade project in OCI (Oracle Cloud Infrastructure) and on-prim, Exadata Cloud service (ExaCS) database environments➢ Have extensively worked on upgrading the database hosted in OCI from 12c to 19c.➢ Have migrated and upgraded the database on Exadata on premise from 12c to 19c in clustered environment with high availability configured using autoupgrade method and manual upgrade method.➢ Experience in migrating on prim Exadata database to OCI using RMAN and ZDM (zero downtime migration) methods.➢ Regular patching experience in RAC, Oracle restart and standalone database environments including Exadata image and database patching in DBAAS environment .➢ Building physical standby database for RAC environment, standalone database environment.➢ Installation, configuration, capacity planning for new projects and applications having oracle databases including Standby Build for RAC and non-RAC databases hosted in Exadata environment.➢ Worked as SME for the team, grooming the team members to support complex DBA tasks on day-to-day basis, acting as a support role for team in assisting for their day-to-day operational issues related to oracle DBA.➢ Diverse experience in managing multitenant databases (CDB and PDB) , in terms of backup , restore, refreshes , pdb , cdb creation etc .➢ Good exposure and hands-on with Oracle ExaCC, ExaCS (Exadata Cloud @ Customer) architecture, managing and creating resources using cloud dashboard.➢ Experience in participating , planning and executing DR drill for the production databases .

➢ Working as Lead DBA for transformation project as only DBA for environment support.➢ Supporting and assisting development teams in the design, development, testing, tuning and implementation of database applications including provision of such development and testing environments that are required.➢ Enabling data guard for primary databases for new environments using data guard broker.➢ Installation, implementation, and configuration of oracle databases from scratch for new environment. ➢ Complete understanding and very well verse with the lifecycle of application go live from design to UAT, OAT and go live and production support.➢ Assisting with the development teams, testing team on various issues related to infra and networks encountered during the application testing before going live.➢ Configuration of OEM for all the new database environments for monitoring.➢ Implementing and configuring OEM agents, agent installation, configuration for monitoring, creating incident rulesets, and template for monitoring for newly created environment before handover to the application team for better monitoring of the databases.⮚ Enabling backup policies and configuring script for the databases from scratch like daily, weekly, incremental, archive purge scripts for the databases before going live.⮚ Complete environment readiness from the database point of view, from installation to making the database live for production support. ⮚ Database upgrades from 12c to 18c in on premises environment.⮚ Implemented the from scratch DB environment for various telecom applications, including installation, connectivity setup, DB ready, backup policy, upgrades, setting up dataguard environment using DG broker.⮚ Basic working knowledge of mongo DB, ops manager and managing replica set.

➢ Working as oracle DBA for remedy application. Experience in managing production Database.➢ Working closely with developers and assisting them from application point of view for tunning the SQL to make the overall application preformat.➢ Reviewing the SQL queries and tuning them before every software major release cycle.➢ Capacity planning for new databases planned for migration.➢ Working on performance issue related to application, troubleshooting SQL slowness issues using explain plan and other tools like AWR, ASH for performing SQL query tunning, database tunning, memory tunning etc.➢ Assisting application teams for the application migration/upgrade for NGSD8 to NGSD 9 version in terms of DB migration from 11g to 12c.➢ Building physical standby databases in dataguard and working on manual switchover and failover activities in dataguard. ➢ Worked on the DBMS scheduler for scheduling and automating the jobs in the production database related to purging, DB refresh.➢ Experience in managing RAC databases.➢ Performance tuning skills of highly complex SQL code. ➢ Working on the capacity planning part for the new databases coming for new applications.

 Total 3 Years of experience as an Oracle Database Administrator Infrastructure Management Services (IMS) domain. Working as Senior System Engineer at iGATE Global Solutions, Bangalore. Experienced in database 10g,11g, Oracle RMAN/Hot/cold backup planning, export/import data-pump utility. Experienced in 24*7 support project in production and non-production environments. Experienced in environment required to interact with UK/US clients/customers during specifications, development and project implementation phasesTroubleshooting backup failure issues RMAN Backup and recovery Ensuring high availability database on nodes in the RAC environment.Administrating Oracle 12C RAC Databases Script Execution on Production Oracle Databases to automate jobs and creating cronjobs for oracle healthchecks on DB servers Managing and troubleshooting oracle DB errors and alerts and applying patches and upgrading databases for permanent solutions on production databases.

• Experienced in Planning and implementing the Backup strategy using Hot backup, Cold Backup and Logical Backup.• Handling Oracle database (10g, 11g) in production and non-production environments.• Have restored the schema objects for Database Users using the logical backup.• Good understanding of various oracle tuning areas (SGA, PGA, SQLs, IO, Latches, Lock).• Have involved in User Management, Creating Roles and assigning Privileges and Roles to database users.• Good understanding of Unix/Linux• Experience in RMAN backup and recovery.• Good Knowledge of using Oracle's Indexes .• Exposure in performing the flashback recovery of the database files in various recovery scenarios.• Knowledge of working on multiple OS.Responsibilities / Daily Activities:• Oracle 11g software installation in UNIX and Windows platform..• Make the database Optimal Flexible Architecture Complaint.• Managing the Tablespace quota of different users by granting quota .• Managing Redo log files in archivelog mode for online backup, Maintaining constraints.• Creating users and their profiles.• Periodic Checking the Health of the Database, recommending changes and make the changes accordingly. • Sizing of database (Sizing of Tables, Indexes, Rollback Segments & Tablespaces).• Purging of database on a Regular Interval.• Troubleshooting the errors and Recovery of the database files.• Calculate disk space requirements.• Regularly monitoring of the RMAN backups.• Taking incremental, fast incremental , tablespace level, datafile backups in RMAN. • Running the predefined RMAN scripts to automate the tasks.• Monitoring of the change tracking file.• Changing configurations inside RMAN and catalog based on customers requirements like setting the disk parallelism , device locations, maxpiecesize values etc.