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.
