Oracle Database Administrator - HA & DR

SANDRA MUKWAYANZO

ORACLE DATABASE ADMINISTRATOR PRODUCTION SUPPORT HIGH AVAILABILITY & DISASTER RECOVERY ***********@*****.*** +1-240-***-****

PROFESSIONAL SUMMARY

Oracle Database Administrator with 9+ years of experience supporting mission-critical production, development, test, and staging environments across Linux, UNIX, AIX, Solaris, and Windows. Strong hands-on expertise in Oracle 10g/11g/12c/19c, RAC, ASM, Data Guard, RMAN, OEM 13c, backup and recovery, patching and upgrades, performance tuning, database security, capacity planning, cloning, migration, and 24/7 incident response. Proven ability to improve database availability, recovery readiness, operational efficiency, and query performance through proactive monitoring, root-cause analysis, automation, and disciplined change management.

TECHNICAL SKILLS

Database Platforms: Oracle 10g, 11g, 12c, 19c; PostgreSQL 9.x-11.x High Availability & Disaster Recovery: Oracle RAC, Data Guard, Physical and Logical Standby, ASM, RMAN, Planned Switchover, Backup Validation, Restore and Recovery, Disaster Recovery Testing Performance & Monitoring: Oracle Enterprise Manager (OEM) 13c, AWR, ASH, ADDM, STATSPACK, SQL Trace, TKPROF, EXPLAIN PLAN, SQL Tuning Advisor, SQL Plan Baselines, Index and Space Management Database Administration: Installation, Configuration, Patching, PSU/CPU Maintenance, Upgrades, Migration, Cloning, Refreshes, Schema Changes, Data Pump, SQL*Loader, Capacity Planning Security & Access Management: User and Role Administration, Profiles, Privileges, Least-Privilege Access, Auditing, Account Management, Database Security Controls

Systems & Automation: Linux, RHEL, UNIX, AIX, Solaris, Windows Server, Bash/UNIX Shell Scripting, SQL, PL/SQL, PL/pgSQL

Tools & Operations: SQL*Plus, SRVCTL, CRSCTL, Toad, PuTTY, WinSCP, IBM TSM, Veritas NetBackup, Oracle Support/MOS, Incident Management, Problem Management, Change Management, Root Cause Analysis, 24/7 Production Support PROFESSIONAL EXPERIENCE

Database Administrator Zuckerman Gravely Chevy Chase, MD Sep 2022 - Present

• Administer Oracle 12c/19c and PostgreSQL databases across production, development, test, and staging environments; monitor database availability, listener health, storage, capacity, alert logs, and system performance to sustain approximately 99.9% service availability across 25+ database instances.

• Own RMAN backup and recovery operations, review backup status, validate retention and recoverability, and perform controlled restore/recovery testing; maintain backup completion rates above 98% while supporting business-defined recovery objectives.

• Diagnose database and SQL performance using OEM 13c, AWR, ASH, ADDM, SQL Trace, TKPROF, EXPLAIN PLAN, and SQL Plan Baselines; tune SQL, indexes, memory, and configuration settings to reduce recurring performance incidents by approximately 25%.

• Administer users, roles, profiles, privileges, and access requests using least-privilege practices; review account activity and database auditing requirements to protect sensitive business data and maintain access-control consistency.

• Plan and execute database patching, version upgrades, schema releases, object changes, and maintenance activities through formal change controls, coordinating testing, rollback plans, implementation steps, and post-change validation.

• Automate recurring health checks, storage reviews, account checks, and operational reporting with SQL, PL/SQL, and Bash scripts, reducing routine manual DBA effort by roughly 30%.

• Lead incident troubleshooting and root-cause analysis for connectivity, capacity, locking, backup, and performance issues; coordinate with application, server, storage, and Oracle Support teams to restore service and prevent repeat failures.

Oracle Database Administrator Insight Bethesda, MD Sep 2019 - Aug 2022

• Supported 40+ Oracle 10g/11g/12c/19c databases across production and non-production environments on Linux, Solaris, and AIX, providing 24/7 operational coverage for database availability, incidents, maintenance, and application releases.

• Designed and supported Oracle Data Guard physical and logical standby environments, RAC/Grid Infrastructure, and ASM storage; performed planned switchovers, standby validation, and recovery exercises that strengthened high- availability and disaster-recovery readiness.

• Executed RMAN cloning, point-in-time recovery, Data Pump exports/imports, and database refreshes for application and QA teams, standardizing procedures and reducing average environment refresh turnaround by approximately 35%.

• Installed, configured, patched, and upgraded Oracle database and Grid Infrastructure components, including PSU/CPU maintenance and version upgrades, with pre-checks, rollback planning, post-change validation, and coordination across production support teams.

• Improved performance and monitoring through OEM 13c alert tuning, AWR/ASH/ADDM/STATSPACK analysis, SQL tracing, index maintenance, tablespace management, and instance/query tuning, reducing recurring database alerts and performance escalations by about 20%.

• Developed PL/SQL, DDL/DML, materialized views, and UNIX shell automation for reporting, data replication, health checks, and repeatable DBA procedures, cutting manual operational effort by roughly 25%.

• Managed database users, roles, privileges, profiles, password controls, and audit requirements; partnered with infrastructure and application teams on production changes, troubleshooting, capacity planning, and Oracle Support service requests.

Oracle Database Administrator Seagate Technology Columbia, MD Feb 2017 - Aug 2019

• Administered and monitored 25+ Oracle production and non-production databases, tracking availability, growth, listener status, CPU utilization, blocking sessions, alert logs, tablespace utilization, and capacity to identify service risks before user impact.

• Resolved incidents involving database sessions, connectivity, account access, locking, storage, and SQL performance; used AWR/ADDM diagnostics and Oracle Support service requests to investigate database bugs and recurring technical issues.

• Configured and maintained RMAN backup strategies with IBM TSM/Veritas NetBackup integration, validated backup completion, and performed scheduled restore/recovery tests, maintaining backup success rates above 98%.

• Executed database builds, cloning, patching, upgrades, schema deployments, Data Guard implementation, tablespace maintenance, and Data Pump exports/imports under ITIL change-management processes and documented implementation plans.

• Standardized SQL and UNIX shell scripts for recurring monitoring, cleanup, storage checks, backup verification, and account administration, reducing repetitive manual DBA activities by approximately 25%.

• Administered users, roles, profiles, privileges, schemas, objects, and tablespaces while enforcing approved access controls and supporting application deployments across development, testing, and production environments.

• Collaborated with application, system, storage, and network teams on release support, capacity planning, root-cause analysis, service restoration, and post-incident corrective actions in a 24/7 production environment. EDUCATION

Bachelor's Degree, Computer Systems and Technology - ESMICOM, Kinshasa, Democratic Republic of the Congo, 2008 High School Diploma - Lycee Motema Mpiko, Kinshasa, Democratic Republic of the Congo, 2003 Certificate: Big Data Expert, DATA ENDEAVORS, 2022

Contact this candidate