Mohammed Wiqaruddin

Having 13.5 Years of experience in Oracle/SQL/PostgreSQL Database Administration/Support/maintenance/development and Oracle cloud infrastructure consultant. Expertise in Oracle RAC (12c/19c) and MSSQL and PostgreSQL databases across multiple cloud environments (OCI, AWS). Proficient in query optimization, SQL tuning, and database performance analysis using AWR, EXPLAIN PLAN, TKPROF, and DB Tuner.

Led migration of Zeal and Pillar applications to Oracle Managed Cloud Services and AWS. Managed backup strategies using RMAN, ZDLRA, and Oracle Data Guard. Configured and managed Oracle Data Guard (physical and snapshot standby).

Implemented

Oracle TDE encryption for Exadata migrations and managed auditing.

Senior Oracle DBA - Estuate INC - Philadelphia USA

(2024-12 - 2026-07)

Client: MGM Resorts International

• Managed and administered large-scale Oracle databases (11g/12c/19c/26AI) ensuring high availability, performance, and security.
• Performed database installation, configuration, upgrades, and patching in mission-critical environments.
• Played a key role in migrating on-prem Oracle databases to Oracle Opera Cloud environment, ensuring seamless data transition.
• Planned and executed data migration activities with minimal downtime using tools like Data Pump, Goldengate, or RMAN duplication.
• Validated post-migration data integrity, performance, and application compatibility.
• Tuned databases post-migration to optimize performance in cloud infrastructure.
• Implemented and managed Oracle Data Guard (Physical/Logical Standby) for disaster recovery and failover strategies.
• Configured and supported Oracle RAC environments for high availability and load balancing.
• Performed DR drills, switchover, and failover testing to ensure business continuity.
• Designed and implemented real-time data replication using Oracle GoldenGate across heterogeneous environments.
• Performed database migrations and workload consolidation on Exadata.
• Monitored Exadata performance using Enterprise Manager, AWR, ASH, and ExaWatcher reports.
• Managed Exadata storage using ASM, Grid Infrastructure, and Cell Services.
• Installed, configured, and administered PostgreSQL databases on Linux environments.
• Managed PostgreSQL users, roles, schemas, and privileges.
• Performed backup and recovery using pg_dump, pg_restore, and physical backups.
• Configured streaming replication and monitored database replication.
• Handled replication setup, monitoring, troubleshooting, and performance optimization.
• Ensured zero/low downtime migration using GoldenGate for critical systems.
• Conducted in-depth database performance tuning using AWR, ASH, ADDM reports, and OEM tools.
• Identified bottlenecks and implemented proactive measures to enhance database performance.
• Managed users, roles, privileges, tablespaces, and storage allocation efficiently.
• Automated routine DBA tasks using Shell/Python scripting.
• Managed physical backups using pg_basebackup for disaster recovery.
• Performed logical backups using pg_dump and pg_restore.
• Developed and maintained database monitoring scripts and alerts.
• Provided 24/7 production support for critical systems, resolving high-severity incidents (P1/P2) within SLA.
• Conducted root cause analysis (RCA) and implemented preventive measures.
• Implemented monitoring solutions using Oracle Enterprise Manager (OEM) and custom scripts.
• Automated database health checks, backups, and maintenance tasks to improve efficiency.

Senior Oracle DBA - Oracle - Hyderabad INDIA

(2022-02 - 2024-02)

Maintaining and monitoring of Exadata systems located in 2 different regions based on OCI.

• Regularly patching/upgrading POD DB's to required certified versions across the fleet through automation.
• Resolving any issues arising through any DB maintenance activity for the databases.
• Creation of DB's/VM's in OCI and setting up monitoring accordingly.
• Regular Refresh/Clone of Test instances from Production using automation through ansible/python via RMAN DB backup.
• Planning the backup strategies for PROD/NON-PROD DB's through RMAN in OCI storage.
• Performed various Oracle cloud opera related tasks in OCI related to such as booking, client relations admin, inventory, Inventory admin, reports, role manager, toolbox, worklist, OHIP.
• Resolving any RAC issues like node eviction / node reboot, etc.
• Performance tuning of any long running sessions by query tuning.
• Managed Exadata Storage Cells and monitored Cell Server (CELLSRV), Management Server (MS), and Restart Server (RS).
• Administered Oracle Exadata environments supporting mission-critical OLTP and Data Warehouse databases.
• Coordinating the oracle support calls for any DB issues in our environment.
• Deploying scripts on server for getting alerts (Backup, Tables pace and Filesystem).
• Working knowledge on Devops tools like – Docker/Kubernetes, Python and Ansible.

Senior Database administrator - Cloud4c (Ctrls Data center) - Hyderabad INDIA

(2021-05 - 2022-02)

• Creating and managing Initialization parameter file, Data files, tablespaces, Control files, and Redo log files.
• Regularly watching Alert logs to know types of bottlenecks recorded if any and rising to encounter them.
• Security Administration by creating Users with appropriate Roles and Privileges, Creating and granting profiles to users.
• Taking backups using RMAN, incremental backups, full database backup.
• User Managed Backups and Recoveries – Backup and Recovery Operations, Closed and Open DB Backups (Hot and Cold), Complete Recovery.
• Regular Refresh/Clone of Test instances from Production using RMAN backup.
• Managing oracle golden gate & handling golden gate errors.
• Investigate, trace fix and report replication failures using Log Dump.
• Installing Bug Patches and PSU patches in standalone database and RAC databases.
• Troubleshooting the RAC availability issue.
• Installing and handling/managing the Postgres SQL server Database.
• Database upgrades to 19c and Quarterly CPU Patching across PROD/UAT DR DB's.
• Configuring the Physical standby DB's and resolving any log gap issues.
• Administered Oracle databases on Exadata X7/X8 infrastructure supporting mission-critical production environments.
• Supported PostgreSQL failover and switchover activities.
• Worked with standby databases and replication slots.
• Monitored Write-Ahead Logging (WAL) generation and archive management.
• Configured and monitored Exadata Cell Services, Flash Cache, and Smart Flash Logging.
• Supported database refresh, cloning, and environment provisioning activities.

Database Administrator - Franklin Templeton Investments. - Hyderabad INDIA

(2016-03 - 2021-05)

Work on Database security, Oracle enterprise manager, Oracle Exadata, Oracle golden gate, Oracle Real application clusters, Database patching and upgrade, Database performance tuning, RMAN and ZDLRA backup, Restore/recovery Unix shell scripting, Database migration & ERP systems.

• Maintenance of Oracle Database, Backup, Recovery, and other database-related activities.
• Monitoring Scheduled Backups on daily basis and investigating any failure.
• Creating and dropping users, granting, and revoking rights as and when required.
• Checking Oracle files for abnormal behaviors.
• Optimization of Golden Gate configurations.
• Day to day Performance Monitoring and tuning of database.
• Used CellCLI, DCLI, and ExaCLI for administration and troubleshooting of Exadata components.
• Monitored hardware components including disks, flash cards, power supplies, and network interfaces.
• Configured and monitored Exadata alerts using Oracle Enterprise Manager and CellCLI.
• Diagnose and Troubleshoot Database Problems and failures.
• Oracle database security (OS and Database's scans).
• Oracle enterprise manager, RAC, Gilden Gate, Data guard.
• Imperva web secure sphere Administration.
• Supported PostgreSQL failover and switchover activities.
• Worked with standby databases and replication slots.
• Monitored Write-Ahead Logging (WAL) generation and archive management.
• Database Auditing and Compliance.
• Zero data recovery appliance (ZDLRA).
• Exacc (Cloud at customer) and Oracle Exadata systems.
• Cohesity Backup tool.