• Successfully managed a portfolio of over 500 production databases, encompassing Standalone, RAC, and RAC one node configurations.• Proficiently installed, configured, and administered Oracle versions 10g, 11g, 12c, and 19c, ensuring seamless database operations.• Implemented high availability measures by configuring Oracle Physical Standby databases (Data Guard) to safeguard against downtime.• Applied quarterly Oracle patches across all database servers to enhance security and performance.• Conducted full database refresh and schema refresh of Production databases to non-production databases using expdp/impdp.• Monitored Standby databases, promptly troubleshooting discrepancies between standby and production databases.• Deployed Oracle Enterprise Manager (EM) 13.3 agents on all servers using the push method for efficient centralized management.• Successfully integrated newly created databases into OEM and resolved issues with targets in unknown or down status.• Managed the upgrade of Oracle GRID and RDBMS from version 11.2.0.4 to 12.2.0.1 using the Out-of-Place method.• Proficiently created new users, assigned roles, privileges, and profiles to ensure secure and controlled access.• Collaborated with Oracle Support to address bugs and errors, including resolving issues such as ORA-600.• Effectively managed space in mount points and ASM disk groups, optimizing storage efficiency.• Monitored scheduled RMAN backups, promptly addressing any issues to ensure data integrity 24/7.• Played a key role in database creation and upgrades in both Standalone and RAC configurations.• Proactively monitored tablespace growth, adding new data files and resizing existing data files as needed.• Conducted regular gathering of statistics and rebuilding of indexes to optimize database performance.• Managed archived data on tape for efficient data storage and retrieval.• Specialized in RMAN Backup-Based Duplication and Active Database Duplication techniques.

• Install and set up Oracle database software, configuring database instances accordingly.• Establish and customize database instances.• Conduct regular backups to ensure data integrity.• Identify and rectify performance bottlenecks.• Monitor and audit database activities to ensure security compliance.• Apply patches and updates to uphold system security and stability.• Deploy and oversee high availability solutions, such as Oracle Real Application Clusters (RAC) or Data Guard.• Strategize and evaluate disaster recovery procedures.• Execute database refreshes from production to non-production environments.• Oversee and manage database storage, encompassing tablespaces and data files.• Tackle issues related to space usage and allocate additional storage as required.• Develop and implement automation scripts for routine tasks.• Collaborate with developers, system administrators, and other IT professionals.• Effectively communicate with stakeholders regarding database-related updates and issues.• Predict resource requirements and suggest hardware upgrades when necessary.