Mrityunjay Kumar Tiwary

Dynamic Principal Advanced Services Engineer with extensive experience at Oracle Solution Services, specializing in OCI database management and optimization. Proven track record in database upgrades and performance tuning, leveraging skills in RMAN and SQL. Adept at collaborating with teams to enhance operational efficiency and ensure high availability.

• Raising Start award for second quarter of 2011.
• Spirit of winning the summit Individual Award Oct 2013.
• Spirit of winning the summit Individual Award Mar 2015.
• Monthly Star Awards- Nov’2016.

• Date of Birth: 07/01/83
• Nationality: Indian
• Marital Status: Married

• Anthem Inc., Anthem, USA, Oracle Database Administrator, Oracle 19c, 12c, 11g, Exadata, RMAN, RAC, Golden gate, OEM24AI, Dataguard, ASM
• OCI Customer Support, Multiple clients, Oracle Database Administrator (DBAAS), OCI, Golden gate, OEM13c, Dataguard, ASM
• Anthem Inc., Anthem, USA, Oracle Database Administrator, Oracle 19c, 12c, 11g, Exadata, RMAN, RAC, Golden gate, OEM13c, Dataguard, ASM
• Ooredoo Telecommunication Pvt. Ltd., Ooredoo, Kuwait, Oracle Database Administrator, Oracle 12c, 11g, Linux, RMAN, RAC, ASM, Golden gate, OEM13c, Dataguard, Remedy

• Managing OCI databases for different customers.
• Created Backup policies for OCI databases.
• Created Data guard Setup for OCI databases.
• Creating and Managing OCI databases for different customers.
• Upgraded database from 12c to 19c on OCI.
• Applying quarterly patches for OCI databases.
• Create a database deployment on Oracle Cloud.
• Use the Database Cloud Service Console.
• Backup, recover, scale up, and patch your database deployment.
• Secure your cloud database.
• Delete database deployment.
• Create and terminate the DB systems in OCI.
• Patching DB system and Database using DB Console in OCI.
• Installing Oracle 10.x and 11.x, 12c, 19c in various o/s platforms.
• Installing Oracle 32-bit and 64-bit client in different o/s environments.
• Database monitoring through OEM 12c and 13c.
• Database configuration in VERITAS cluster.
• Managing the physical and logical objects of the database.
• Using TKPROF, AWR, ASH to find ways to improve the database’s performance.
• Gathering Table and Schema stats. Performing Query tuning.
• Restoration of old table statistics using history tables.
• Database upgrade from 11g to 12c and 12c to 19c.
• Creating and managing CDB and PDB’s on 12c.
• Migrated database from 12c to 19c (CDB & PDB).
• Upgrading database from 12.1 to 12.2 by un-plug and plug method.
• Fixing the SQL query performance issue by using SQL base line.
• Database character set migration using DMU tool.
• Performed cloning of databases from production to production or production development-test environment as per client need.
• Restored 2-node RAC database in standalone system by using RMAN.
• Migrating Single Instance database to 2-node Rac Database in linux.
• Adding and Deleting node in existing RAC nodes.
• Worked on various DR exercises.
• Worked on SQL server to Oracle Migration.
• Golden gate installation and configuration.
• Troubleshooting day to day Extract, Replicate and Pump process issues.
• Logical Backup of Databases using Export and Import Utility as well as DATAPUMP utility.
• Recovery of lost objects and data files. Incomplete Recovery.
• Configured RMAN backup on AVAMAR and ZDLRA.
• Monitored and scheduled RMAN hot backups, Full Database Exports of Production databases and troubleshooted errors if any.
• Planned and Performed RMAN backup for Prod, QA databases. Recovery Catalog using RMAN.
• Creating TESTING, QA database by using RMAN point in time recovery.
• Data file Consistency using DB Verify.
• Migrating NON-ASM Database to ASM Database.
• Maintenance Work in ASM - addition, dropping disks, rebalancing of disks.
• Worked on Oracle Data Guard and managed the Standby databases for all the OLTP databases.
• Implemented SOX password change across 1200+ databases.
• Checking the Archive log shipping between the Primary and the standby (DR) databases and troubleshooting it by rebuilding the Standby databases.
• Experienced with Oracle Support, opening, managing, and resolving Oracle SR's.
• Experienced in DB migration from Solaris to Linux.
• Materialized Views.
• Applying CPU and PSU, RU and Bug fixing patches using Opatch utility.
• Upgrading Oracle homes by applying software patches.
• Installing OEM agent and configuring database in OEM console.
• Created various OEM reports which help day to day operations.
• Configured and Managed BCV databases.
• Performed Database clones using BCV backup.
• Migrating Database in 10.2.x and 11.x from 32-bit to 64-bit in Linux system.
• Downgrading Database from 10.2.0.5 to 10.2.0.2.
• Retiring/Decommissioning the old databases.
• Manual Database Creation and using DBCA.
• Develop, document, and implement security configuration for Oracle software and database instances to comply with existing standards.
• Worked on Various Replication technologies on Mysql and Maria Dbs.
• Setup Group Replication on MySql(3-nodes).
• L1 knowledge of Tera Data.
• Provided 24x7 on-call technical supports. And on-call supports on week end.

•  Oracle Database Administration 2019 Certified Professional (OCP19c)