Mukesh Chauhan
Faridabad
Summary
- Dedicated Oracle Database Administrator with 10 years of experience managing complex environments across Oracle 19c/12c/11g on Linux, Solaris, and AIX platforms. Expert in Oracle RAC, Data Guard, and GoldenGate (3+ years), with 2+ years of specialized experience in Exadata X9/X10 administration and zero-downtime quarterly patching. Proven track record in performance tuning (AWR/ADDM), high-availability disaster recovery, and RMAN backup/recovery. Skilled in supporting 24/7 production environments and collaborating with development teams to deliver secure, optimized, and scalable database solutions
Overview
10
10
years of professional experience
1
1
Certification
Work History
Sr. ORACLE DBA
Total System Services / FIS Global
2025.01 - Current
- Maintaining around 250 databases combined on all the production, development, and testing environments.
- Provided 24/7 on-call support for Oracle production and development databases to ensure maximum availability.
- Expertise in Setup, Installation, Configuration, Maintenance and Troubleshooting of OGG for heterogeneous environments.
- Performed Database refresh from Production to QA, UAT and DEV Database whenever requested by client.
- Performed schema and table refresh using expdp/impdp data pump.
- Applied Oracle security patches every Quarterly on the Oracle Grid and the databases using OPATCH utilities.
- Performed Daily maintenance task like space management, rectified locking problems, managed quotas etc.
- Experience in Oracle Physical standby, Data Guard configuration, Maintenance, and support for DR activities.
- Experience of Switchover and Switchback of production Database.
- Experience in User Management, Space Management, tnsnames.ora & Listener Configuration.
- Experience in Creating and Managing Tablespace, datafiles, schema objects and users.
- Performed index rebuilt, tables re-org to improve the performance.
- Experience in Oracle Golden Gate replication, database, server configuration, installation and troubleshooting golden gate extract and replicate issues.
- Experienced in Exadata X9/X10 Storage Cell administration and maintenance using cellcli and dcli utilities.
- Performed full-stack quarterly patching for Exadata and ZDLRA systems, including Cells, Switches, and Compute nodes.
- Experience to provided Support to Linux Team for OS Patching Activity.
- Supported Application Team by providing SQL statement tuning and optimizing ETL procedures and removing and query performance bottlenecks by using EXPLAIN PLAN, AWR and ADDM reports.
- Monitor physical resource of servers like RAM, CPU /IO and also Query performance by using Oracle OEM Utilities.
- Key Skills: High learning ability, Team worker, Self-motivated, Willingness to accept most challengeable responsibilities, Positive attitude, excellent team player and well proven problem solving and trouble shooting skills.
Sr. ORACLE DBA
Wipro Limited.
2022.07 - 2025.01
- Familiar with Table spaces (Temp/Undo) and Disk group level issues in Database.
- Monitored and killed hung User’s session by user confirmation.
- Handled Blocking issue and User’s query related to long running in databases.
- Startup and Shutdown of individual instance on RAC 2 node environments.
- Created users, roles and granted privileges according to the business requirements.
- Migration of code from development to production instances and database space and file system related issue space monitoring.
- Applied CPU and quarterly patches in the development and production environments using OPatch Utility.
- Rebuilding of Indexes for better performance, maintenance of Oracle Databases.
- Data Refresh from Production to UAT and Development environments using RMAN Duplicate Database.
- Took Hot backups, Performed Full and Point in Time Recoveries using RMAN, investigated causes for failures and resolved them.
- Generated Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports.
- Installed agent and Added target in OEM.
- Installed, configured, and resolved issues related to Golden Gate replication.
Associate Oracle DBA
Cognizant Technology Solutions India Pvt. Ltd.
2020.11 - 2022.07
- Checking on the Daily basis Production and standby database should be in sync.
- On the Daily basis checked Database RMAN backup.
- Monitoring the Alert logs, disk space utilization and connectivity of Database.
- Monitoring CPU and Memory utilization using OS commands.
- Performed Logical backup by using export, import and Data pump utility as per client need.
- Refreshing of DEV, INTG, ACCP Database with help of production RMAN full backup as per Client Requirement.
- If require point in time recovery for the Dropped table.
- Gather stats as per need to improve DB/Query Performance.
- Cloning/Refreshing of Database when management has required.
- Perform weekly database maintenance activity (Gather Statistics, Rebuild Indexes and Compile Invalid Objects).
- Installed Agent on server and add host target through OEM.
- Experience in Oracle Golden Gate Replication, Analysis of trail files using Log dump and monitoring.
- Tested and implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full database recovery by using hot Backup and export/import etc.
- Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges.
- Recovered databases from corrupted/lost datafiles in real time on UAT/TEST systems.
- Experience in Switchover activity by using DGMGRL.
Jr. Oracle DBA
Sify Technologies Limited
2019.03 - 2020.11
Jr. Oracle DBA
ACCESS INFOTECH INDIA PVT. LTD.
2018.08 - 2019.03
Jr. Oracle DBA
CMS IT SERVICES PVT. LTD
2016.06 - 2018.08
Education
Bachelor of Engineering -
Shri Krishna Institute Engineering and Technology
01.2012
Class XII -
Rishikul Vidyapeeth Public School
01.2008
Class X -
Rishikul Vidyapeeth Public School
01.2006
Skills
- RMAN, AWR, ASH, ADDM
- Data Pump, Export and Import Utility
- DBCA, DBUA, NETCA, NETMGR
- DATAGUARD, DGMGRL
- SRVCTL, CRSCTL, ASMCMD
- GOLDEN GATE 19c, Goldengate Microservices 23ai
- Exadata X9/X10, ZDLRA
- OEM13c
- Service now (Ticketing Tool)
Certification
- Oracle Testing ID, OC1698146
- Oracle Certified Associate (OCA), 11g
- Oracle Certified Professional (OCP), 11g
- Oracle Certified Professional (OCP), 19c
Languages
English
Hindi
Timeline
Sr. ORACLE DBA
Total System Services / FIS Global
2025.01 - Current
Sr. ORACLE DBA
Wipro Limited.
2022.07 - 2025.01
Associate Oracle DBA
Cognizant Technology Solutions India Pvt. Ltd.
2020.11 - 2022.07
Jr. Oracle DBA
Sify Technologies Limited
2019.03 - 2020.11
Jr. Oracle DBA
ACCESS INFOTECH INDIA PVT. LTD.
2018.08 - 2019.03
Jr. Oracle DBA
CMS IT SERVICES PVT. LTD
2016.06 - 2018.08
Bachelor of Engineering -
Shri Krishna Institute Engineering and Technology
Class XII -
Rishikul Vidyapeeth Public School
Class X -
Rishikul Vidyapeeth Public School