Asa-Mah Nfor
Sr. Oracle Database Administrator
********@*****.***
Top Secret Clearance
Summary of Experience
Seasoned Senior Oracle Database Administrator with over 14 years of experience managing and optimizing large-scale databases across financial, healthcare, government, and enterprise sectors. Proven expertise in Oracle 19c/12c/11g, RAC, Exadata, and multitenant architecture, with advanced skills in Oracle Enterprise Manager, Oracle Vault, Data Guard, GoldenGate, and RMAN. Adept at database migrations, upgrades, query optimization, and backup/recovery strategies, successfully leading projects involving 40TB+ data migrations with zero data loss. Skilled in automation using Ansible to streamline provisioning, patching, and deployments while ensuring high availability and security. Recognized for strong problem-solving, performance tuning, and collaboration with cross-functional teams, delivering reliable, secure, and high-performing database environments. Technical Proficiencies
Category Technologies / Tools
Operating
Systems
HP-UX, Solaris, AIX, RHEL, SUSE Linux, Windows
Databases Oracle 21c/19c/18c/12c/11g/10g/9i; PostgreSQL; SQL Server Languages SQL, PL/SQL, UNIX Shell Scripting, Perl
Tools &
Utilities
Oracle Enterprise Manager (OEM 13c/12c/10g), Ansible, GoldenGate, Data Guard, RMAN, ASM, Exadata, ODA, Data Pump, TKPROF, AWR, ADDM, STATSPACK, TOAD, Jenkins, Autosys. Oracle WebLogic Server (Admin Console, WLST, Node Manager) Oracle SOA Suite (BPEL, OSB, BPM, Service Bus),Oracle ADF,Oracle HTTP Server / OHS Professional Experience
InfoMarines – Mechanisburg, PA May, 2024 – Present Senior Oracle DBA/ Middleware Administrator – DoD/Navy Environment
Managed Exadata, RAC, Oracle Databases, and Pluggable Databases (PDBs/CDBs), ensuring mission-critical Navy applications operated with high performance, availability, and disaster recovery.
Administered Data Guard, GoldenGate, RMAN, ASM, and Oracle Grid Infrastructure for high availability, disaster recovery, and zero-downtime migrations in secure DoD networks.
Led AWS migrations, integrating middleware, database services, and automation pipelines while maintaining compliance with DoD and DISA security standards.
Automated database patching, backups, monitoring, and middleware deployments using Ansible, WLST, Shell scripting, and Python, improving operational efficiency and reliability.
Administered and tuned WebLogic Server, SOA Suite, ADF, Oracle HTTP Server (OHS), and Coherence clusters, supporting enterprise-scale Navy applications.
Ensured STIG compliance, RMF documentation, DISA audit readiness, and cybersecurity best practices, consistently meeting DoD security requirements.
Conducted database upgrades, patching, migrations, and performance tuning with zero downtime, optimizing operations and application availability.
Mentored and trained junior DBAs and Middleware administrators on Exadata, RAC, cloud deployments, GoldenGate replication, WebLogic, and secure middleware practices, enhancing team capability.
Implemented monitoring, alerting, and reporting solutions using OEM (Oracle Enterprise Manager), and Splunk for proactive system management.
Collaborated with DevOps, Security, and Application teams to streamline deployment, compliance, and troubleshooting in highly regulated DoD environments. LTIMindtree – Hartford, CT Jun 2021 – April 2024
Sr. Oracle DBA
Automated database provisioning, patching, and deployments using Ansible playbooks, Tower, and Vault, reducing manual effort by 40%.
Configured and monitored Oracle Enterprise Manager 13c for RAC clusters, backups, and performance, proactively resolving bottlenecks and alerts.
Implemented Ansible-driven CI/CD pipelines integrating with Jenkins to streamline Oracle deployments.
Migrated large-scale databases from on-premises Linux systems to Microsoft Azure using Data Migration Service, ensuring minimal downtime.
Managed Exadata and ODA environments, including performance optimization and capacity planning.
Applied security patches, PSU/CPU updates, and bug fixes across 19c/12c clusters while maintaining compliance.
Executed RMAN, Data Pump, and GoldenGate migrations, moving 40TB+ systems to Exadata with zero data loss.
Tuned SQL queries and PL/SQL packages using AWR, ASH, ADDM, improving application performance by up to 30%.
Managed Oracle Database Vault and data security configurations for sensitive workloads.
Built procedures for multitenant CDBs and PDBs, backup/recovery, and storage management using ASM/NFS.
Partnered with cross-functional teams to design and implement database high availability strategies using RAC and Data Guard.
Delivered training sessions to junior DBAs on Exadata, OEM, and Ansible automation best practices.
UBS A.G. - Nashville, TN
Senior Oracle DBA with GoldenGate Expertise Jan 2019 - Jun 2021
Installed, upgraded, and administered Oracle Vault 11g/12c, strengthening access controls and audit compliance.
Migrated databases from 12c to 19c, including RAC and non-RAC systems, ensuring smooth transitions with zero critical downtime.
Deployed and tuned Oracle GoldenGate replication for heterogeneous data replication between OLTP and data warehouse environments.
Implemented Data Guard with RAC-to-RAC standby configurations for disaster recovery and failover readiness.
Administered Oracle Enterprise Manager 13c, monitoring top SQL, wait events, and tuning queries using AWR and ADDM.
Conducted online migrations from non-Exadata to Exadata leveraging Data Guard, reducing downtime by 60%.
Configured ASM environments, migrating databases from non-ASM to ASM to improve performance and resiliency.
Applied critical security patches and patch sets with minimal impact to production services.
Developed and executed backup/recovery strategies with RMAN and Data Pump for high-volume transactional systems.
Tuned queries and database structures, achieving 25% performance improvements on revenue- critical systems.
Collaborated with development teams to optimize indexing, partitioning, and clustering strategies.
IBR (U.S. Census Bureau - Suitland, MD)
Oracle Database Administrator Jul 2017 - Dec 2018
Installed, configured, and administered Oracle Vault and Database Security across multitenant and RAC environments.
Managed RAC to RAC, RAC to single instance, and single to single Data Guard setups for business continuity.
Executed large-scale migrations (40TB) using Oracle GoldenGate and transportable tablespaces, reducing downtime for cutovers.
Tuned SQL queries, indexes, and workloads using OEM, AWR, and ASH reports, improving database response time by 20%.
Performed RMAN backups and restores, implemented point-in-time recovery, and automated backup schedules.
Installed and maintained 3-node 11g RAC systems, ensuring 24/7 database availability.
Conducted patching, PSU/CPU updates, and version upgrades for 11g/12c RAC environments.
Supported multitenant CDBs/PDBs with resource management, performance tuning, and flashback operations.
Implemented GoldenGate replication for real-time data transfer between OLTP and reporting environments.
Led troubleshooting for node evictions, cluster instability, and storage issues, minimizing system downtime.
Managed security roles, privileges, and auditing policies in compliance with ITIL-driven SLAs. Cigna - Wilmington, DE
Oracle DBA Jun 2014 - Jun 2017
Installed, configured, and upgraded Oracle 10g, 11g, and 12c databases across Windows and Linux platforms.
Administered and tuned OEM 12c Grid Control for proactive performance and capacity monitoring.
Implemented Oracle GoldenGate RAC-to-RAC replication, resolving abend and latency issues.
Applied critical patch updates and one-off patches using OPatch and runInstaller.
Designed and automated RMAN backup strategies, achieving >99% backup success rate.
Migrated multiple databases using Data Pump and RMAN duplicate, reducing downtime during cutovers.
Tuned SQL queries and PL/SQL procedures with AWR, ADDM, TKPROF, improving workload efficiency by 35%.
Configured Data Guard failover and switchover processes to strengthen DR readiness.
Managed indexes, partitions, and materialized views to optimize OLTP/OLAP queries.
Supported large RAC databases for high-transaction environments, ensuring stability and scalability.
Automated routine DBA tasks with UNIX shell scripting and crontab jobs. CareSource - Dayton, OH
Oracle Database Administrator Mar 2011 - Jun 2014
Installed and configured Oracle 10g/11g databases on AIX and Linux platforms.
Administered OEM 10g Grid Control for proactive monitoring and troubleshooting of production systems.
Automated RMAN backups, log monitoring, and performance alerts using UNIX shell scripts.
Performed data migrations and re-organizations using Data Pump, achieving improved query performance.
Conducted SQL query optimization and SGA/Disk I/O tuning using AWR and ADDM.
Migrated databases to RAC for improved performance and resiliency, enabling 24/7 availability.
Managed roles, privileges, auditing, and authentication policies to meet corporate security requirements.
Executed HOT and COLD backups, RMAN duplicates, and cloning for database refreshes.
Collaborated with developers to enhance application performance through optimized triggers and indexes.
Provided 24/7 support for production and development databases, ensuring adherence to SLAs. Education
MBA (Corporate Finance), University of Gloucestershire
B.Sc. Chemistry, University of Yaoundé 1
Certifications & Training
Oracle Certified Professional (19c OCP) AWS Solutions Architect – Associate PostgreSQL Training Oracle RAC 19c & Grid Infrastructure Admin CompTIA Security+ Data Guard 19c Certification Oracle Certified Associate (12c OCA) SQL Server Training