Mona Rupchandani
Bengluru
Summary
Oracle Database Administrator with 4+ years of comprehensive experience in managing, maintaining, and optimizing Production and Development Oracle databases. Proficient in configurations, installations, Refreshes, Patching Activities, Backup and Recovery Management (RMAN), User Management, Database Object Management, Data Pump Import and Export, Performance Tuning, Upgradation, Scripting, Migration etc. Also experienced in high availability solutions ensuring data integrity and consistency(DR, RAC).
Overview
9
9
years of professional experience
6039
6039
years of post-secondary education
Work History
Oracle DBA
Infosys
11.2022 - Current
- Administered production databases 24/7, supporting diverse clients ensuring proactive problem recognition and resolution.
- Installation of Oracle 19c Database software in Linux and Windows operating systems.
- Performed Tablespace management and Resolved tablespace-related issues by resizing the data files and adding new data files optimizing storage utilization
- Monitoring the RMAN Backups, Performing level 0/1 RMAN Backups and executing recovery procedures.
- Performing and monitoring export backup utility and using it to restore data by Import Utility (EXP/IMP/DATAPUMP).
- Performed Oracle Database patching on both QA and Production Database servers.
- Executed Database Refreshes and schema Refreshes from production to non-production environments using Data Pump Utility.
- Managed user access by creating users, assigning roles and granting privileges to control and monitor database access.
- Monitoring the Listener Status and reconfigured settings manually or using NetCA as per operational needs.
- Tuning of Oracle Memory components like PGA, SGA etc.
- Executed database switchover between primary and standby databases.
- Creating and maintaining the Physical standby databases using DGMGRL, enabling FSFO for Failover.
- Performance tuning on Queries that were poorly performing to increase the response time and DB Performance
- Generating and Analyzing Oracle AWR, ASH, ADDM Reports.
- Performed Database Cloning using RMAN Duplicate command.
- Resolving Dataguard Issues to ensure sync between primary and standby databases.
- Upgradation of database from 12c to 19c
- Managing ASM storage by addition/removal of disks in diskgroups
- Monitoring the DB alerts consistently using OEM
- Worked in Migration activity from On Prem to Could database
- Good Knowledge on Exadata and Golden Gate
- Performed RAC PATCHING
- Dataguard Configuration and creating Physical, logical and snapshot standby Databases.
Oracle DBA
Pansoft Data Solutions
09.2021 - 10.2022
- Monitoring and handling the databases of HBMSU and JGE Universities of Dubai
- Creation of the performance reports of databases and proficient in the House Keeping activities like checking space issues, instance, Listener, DB availability,etc
- Database Creation manually and by using DBCA
- Tablespace Management, User Management
- RMAN Backup Management- Monitoring and executing the backups.
- Checking the inactive sessions and invalid objects occupying the space of database
- Configuration of oracle network files- listener.ora, tnsnames.ora
db2 Database Administrator
Tata Consultancy Services
12.2016 - 04.2018
- Administered db2 databases for ABN AMRO bank of Netherlands covering installation and configuration of database.
- Creating and managing users and objects, assigning roles and privileges to different users.
- Monitoring tablespaces, Inspection of log files, creation of tables, indexes and views.
- Executed database backups, performance tuning of the database and many other database activities.
Education
BE -
R.C.Patel Institute of Technology,Shirpur, North Maharashtra University
H.S.C -
R.D.M.P Junior College, Dondaicha, Maharashtra State Board
S.S.C -
S.V.E.M School,Dondaicha, Maharastra State Board
Skills
- Operating Systems- Red Hat Enterprise Linux 60, 70, 73, 89, Oracle Enterprise Linux 50, Windows
- Database technologies- db2, Oracle
- RDBMS- Oracle 10g, 11g, 19c
- Oracle Environments- Single Instance Databases, Multitenant Architecture (CDB/PDB), RAC
- Database Languages- SQL
- Tools- Putty, WinSCP, Mobaxterm
- Database Utilities- RMAN, DBCA, DBUA, sqlplus, Datapump Utility(EXPDP, IMPDP)
- Network- NetCa, SCP, FTP
- High End Technologies- Dataguard, ASM, OEM, RAC, Golden Gate
Certifications and Notable Achievements
- Oracle Certified OCI AI Foundation Associate 2025
- Oracle Certified OCI Foundation Associate 2025
- Oracle DBA course from Learnomate Technologies Pvt.Ltd (2022)
- Achieved rapid promotion from SSE (JL3) to TA(JL4) within one year & Received notes of Appreciation for training my Juniors.
AWARDS
- Awarded with Rise Insta Award for year 2023-2024 for excellent contribution towards projects and ensuring client committed outflow of delivery.
- Successfully migrated 20+ On Prem DBs to Cloud thereby reducing the infrastructure cost.
- Improved Query Performance by 50% using SQL Tuning, INDEXING and AWR RECOMMENDATIONS.
Timeline
Oracle DBA
Infosys
11.2022 - Current
Oracle DBA
Pansoft Data Solutions
09.2021 - 10.2022
db2 Database Administrator
Tata Consultancy Services
12.2016 - 04.2018
BE -
R.C.Patel Institute of Technology,Shirpur, North Maharashtra University
H.S.C -
R.D.M.P Junior College, Dondaicha, Maharashtra State Board
S.S.C -
S.V.E.M School,Dondaicha, Maharastra State Board