Oracle Cerner Corporation
|Oracle DBA
Summary
Currently serving as an Oracle DBA for Cerner Health Care, a leading health care provider, managing critical production and development OLTP environments with databases up to 12TB.
Highlights
Performed comprehensive database backups and recovery using RMAN (hot and cold), ensuring 100% data recoverability for critical healthcare systems.
Executed data exports and imports via Data Pump (EXPDP/IMPDP) with parameter files and remapping, facilitating seamless data migration and integration for various projects.
Conducted performance tuning and alert log analysis, optimizing database performance and availability by identifying and resolving bottlenecks in real-time.
Managed and configured Automatic Storage Manager (ASM), enhancing storage efficiency and performance for high-volume healthcare data.
Successfully handled GoldenGate scenarios, including resolving trail file loss/corruption and troubleshooting performance and Abend issues, ensuring data replication integrity.
Monitored and troubleshot performance of ATPs, GoldenGate Deployments, Replicats, and Extracts via OCI console, ensuring robust cloud database operations.
Configured and maintained physical standby Data Guard setups, including switchover, failover, and activation, ensuring continuous data availability and disaster recovery capabilities.