Walters - Senior Oracle Database Administrator Oracle DBA

Demonstrated experience with Oracle 19c/12c/11g/10g.

Demonstrated experience with Multitenant CDB/PDB.

Demonstrated experience with RAC.

Demonstrated experience with Data Guard.

Demonstrated experience with GoldenGate.

Perform pluggable database refreshable clone and remote clone. Increase resources at the OCI console during pluggable cloning. Perform production refresh to lower environment. Resolve tickets in service now by granting application user access. Assisted new recruits in accounts setup. Assisted in Patching and making sure the database components were running after the patching. Performed import and export using data pump. Implemented data masking solutions using Delphix to protect sensitive data in lower environment. Resolved production standby database showing down in the enterprise manager console. Troubleshoot and identified production database password expired. Designed and implemented OCI compartment structures including network, database, ExaCS, ExaCC, and bastion compartments. Configured and managed Virtual Cloud Networks (VCNs), subnets, and route tables to support secure multi-tier architectures. Monitor and maintained Internet Gateway, NAT Gateway, and Service Gateway for controlled network access. Managed ingress and egress rules using Security Lists and Network Security Groups (NSGs). Created and administered Oracle databases on DBCS, ExaCS, and ExaCC platforms.

Administered a fleet of 2,000+ Oracle databases (Prod/Non-Prod) via OEM 13c, building fleet-wide dashboards, baselines, and alerting thresholds that improved MTTD/MTTR for performance and availability incidents and standardized runbooks across teams.. Implemented Lifecycle Management (LCM) automated patching & provisioning, parameter drift detection, and Job Framework pipelines for backups/health checks/space audits—reducing manual change windows and human error and increasing patching compliance.. Led Exadata discovery & monitoring integration (cellsrv/flash cache/storage metrics) into OEM; tuned I/O hotspots by coordinating with storage/SAs and adjusting ASM disk group layout and striping to stabilize critical OLTP workloads under peak load.. Designed and operated Data Guard (Physical/Active) for HA/DR with RPO-/RTO-driven architectures; validated redo transport, lag monitoring, and switchover/failover procedures through regular DR exercises and post-test corrective actions.. Architected RMAN strategies (Recovery Catalog, incremental merge, block change tracking, crosschecks, validate, and encrypted backups), codified restore runbooks (duplication, tablespace/point-in-time) to accelerate recovery for Sev-1 scenarios.. Built compliance standards in OEM (security & configuration) and collaborated with InfoSec to enforce TDE, Wallets, RBAC, and auditing; supported evidence collection for SOX/PCI attestations with consistent configuration snapshots and job histories.. Orchestrated clone/refresh workflows for Dev/Test using RMAN and Snap Clone, coordinating data masking procedures where required; optimized sizing, temp/undo strategies, and stats gathering to reduce post-refresh stabilization time.. Delivered SQL/PLSQL tuning assistance and guidance on partitioning, indexing, stats, and cursor sharing, using AWR/ADDM/TKPROF to remove plan regressions and stabilize critical reports and batch jobs across shared environments.. Acted as OEM Security Lead (North America); established access models, auditing, and secrets handling for agents/targets; authored SOPs and conducted training to uplift DBA/SRE teams on Cloud Control best practices and incident hygiene.. AS advance customer service support engineer Postgres install on linux using dnf, yum, on Ubuntu using apt and on mac using brew, configured logical and physical backup, performance tuning, upgrade of Postgres, migration, setup logical and physical replication.

Performed installations/upgrades (9i/10g → 11g and 11g → 12c), including DBUA/manual paths, pre-checks, PSU/CPU patching, post-upgrade stats/cursor sharing validation, and fallback plans to minimize business disruption.. Built and administered 12c Multitenant CDB/PDB topologies for consolidation, resource governance, and operational efficiency; orchestrated PDB cloning/refresh, service management, and backup policies aligned to RPO/RTO tiers.. Implemented Oracle GoldenGate for low-latency data replication across critical financial systems; tuned Extract/Replicat, handled DDL replication, and built monitoring to proactively address lag and trail file growth.. Developed shell & PL/SQL utilities (capacity tracking, object growth, staleness of stats, invalids, top SQL deltas) to feed capacity planning and prevent space-related incidents; integrated outputs with OEM and ticketing.. Standardized RMAN + Data Pump strategies for full and partial recoveries; codified schema-level refresh procedures with pre/post steps (constraints, grants, synonyms, stats) to cut refresh cycle time for agile releases.. Troubleshot memory/cursor leaks, dictionary issues, plan regressions, and I/O bottlenecks using AWR/ADDM/TKPROF/SQL Trace, implementing fixes (pfile/spfile tuning, optimizer parameters, SQL rewrites, index design) to stabilize nightly batches.. Deployed and operated TDE with Oracle Wallet for sensitive data; enforced RBAC/least privilege, reviewed privileges, and improved audit trails to pass internal audit checkpoints.. Managed ASM (disk groups, rebalance, failure groups) and coordinated with storage teams on striping/mirroring strategy; improved throughput and reduced hotspots under peak OLTP and ETL loads.. Refresh Oracle non-production database from production.. Setup connectors, profiling, creating masking rule and apply masking Algorithms for delphix masking.. Edit and import csv for masking.. Create and run masking jobs.. Provided 24×7 support with ITIL practices (Change/Incident/Problem), ran post-incident reviews, and implemented permanent fixes to reduce recurrence.

Installed, configured, and maintained Oracle 10g/11g across Linux/Windows with OEM/Diagnostic/Tuning Packs; established baseline monitoring/thresholds and response procedures to maximize uptime for clinical apps.. Implemented RAC (services, node add/remove, service failover testing) and tuned cluster interconnect/issues (e.g., node evictions), improving resilience and session routing under load.. Designed and tested Data Guard DR topologies (redo transport/lag, switchover/failover runbooks); executed DR drills and documented corrective actions to close gaps in readiness.. Built structured backup & recovery with RMAN and validated restores; complemented with logical exports and Flashback use cases for fine-grained recoveries.. Optimized SQL & indexing for long-running queries; used AWR/EXPLAIN PLAN/TKPROF to pinpoint I/O and CPU hotspots and coordinated with devs to remediate anti-patterns.. Administered SQL*Net and Listener; hardened connectivity, rotated secrets, and tuned session limits to prevent resource exhaustion.. Automated data loads (SQL*Loader), Data Pump migrations, and cron-driven maintenance tasks (analyze, stats, space checks), reducing manual toil and weekend work.. Drove capacity & storage management (tablespace/segment growth, fragmentation checks, temp/undo strategies) to keep batch windows predictable and SLA-compliant.. Authored SOPs, build docs, and operational guides to onboard new DBs quickly and reduce handoff friction with app teams.