Database Administrator Oracle

ANNA NGWENUE

Greenbelt, MD m: 202-***-**** **************@*****.*** LinkedIn

Driving Organizational Resilience & Efficiency through High-Availability Solutions, Performance Optimization, & Streamlined Database Management Results-driven Certified Oracle Database Administrator with 9+ years of extensive experience in managing, optimizing, and securing Oracle environments (19c, 12c, 11g) for high availability and performance. Skilled in advanced database administration, backup and recovery, performance tuning, and disaster recovery using Data Guard and Oracle RAC. Adept at database migrations, automation with UNIX scripting, and implementing robust security measures, ensuring seamless and efficient operations. Proven ability to deliver proactive database management in mission-critical environments with a focus on maximizing performance and minimizing downtime. CORE COMPETENCIES

● Oracle Database Administration

● Database Installation, Configuration, & Upgrades

● Cross-Platform Database Migration & Integration

● Security Management & Patch Application

● Storage Management & Capacity Planning

● High Availability & Disaster Recovery

● Automatic Storage Management

● Performance Tuning & Optimization

● Database Cloning & Migration

● Monitoring & Maintenance

● Backup & Recovery

● SQL & PL/SQL Scripting

● Partitioning Strategies

● Data Replication

● Database Performance Analysis

PROFESSIONAL EXPERIENCE

ALTICE USA, PLANO, TX, JUN 2022 TO PRESENT

Oracle Database Administrator

Oracle RAC & Database Administration:

● Administered Oracle 19c RAC environments using SRVCTL and CRSCTL for cluster management, and successfully applied patches and updates.

● Installed and configured Oracle 19c RAC along with Oracle ASM and Oracle ACFS for efficient storage management. Managed ASM diskgroups, performed troubleshooting, and ensured optimal performance across RAC environments. Database Performance & Optimization:

● Monitored and optimized database performance using tools such as AWR, ADDM, SQL Trace, Explain Plan, and TKPROF. Conducted root cause analysis to resolve performance bottlenecks and improve application efficiency.

● Enhanced database performance and reduced bottlenecks by optimizing database queries using AWR, ADDM, SQL Trace, and other tuning tools, significantly improving application response times. Backup, Recovery & Disaster Recovery:

● Led the creation and maintenance of RMAN scripts for database backup and recovery, including hot and cold backups, Point-in-Time Recovery (PITR), and database cloning for testing and development environments.

● Implemented and managed Oracle Data Guard for disaster recovery, ensuring business continuity with physical standby databases, and configured Fast-Start Failover (FSFO) for near-zero downtime during failovers. Cloning, Migration, Automation & Scripting:

● Reduced database provisioning time by implementing Oracle 19c PDB Metadata Clone, Remote Clone, and Snapshot Cloning, streamlining the deployment of development and test environments.

● Worked on Oracle cloud migrations and optimizations, automating database management tasks using Oracle Cloud CLI and API, improving scalability and performance in cloud environments. Database Security, Compliance, Replication & High Availability:

● Played a key role in database security by applying STIG checklists and enforcing robust user access management protocols, ensuring compliance with organizational security standards.

● Installed and configured Oracle GoldenGate for real-time data replication, ensuring data synchronization between Oracle 19c databases and enabling high availability across environments. Key Achievements:

● Successfully upgraded Oracle 12c RAC to Oracle 19c RAC in a rolling fashion with zero downtime, minimizing business disruption during the upgrade process.

● Managed large-scale database migrations (1.5TB) from Non-RAC to RAC and Non-ASM to ASM, improving overall database performance, scalability, and reliability.

● Reduced database provisioning time by implementing Oracle 19c PDB Metadata Clone, Remote Clone, and Snapshot Cloning, streamlining the deployment of development and test environments.

● Automated backup, performance monitoring, and schema statistics collection through UNIX/Shell scripting and CRON jobs, improving operational efficiency and reducing manual interventions.

● Achieved enhanced performance and reduced bottlenecks by optimizing database queries using AWR, ADDM, SQL Trace, and other tuning tools, significantly improving application response times.

● Enhanced database security and compliance by applying STIG checklists and enforcing best practices for user access management, ensuring that database environments adhered to organizational security standards.

● Migrated and optimized databases on Oracle Cloud, leveraging Oracle Cloud CLI for automation and improving database performance and scalability in the cloud.

ZEBRA TECHNOLOGIES, CHICAGO, IL, JAN 2015 TO MAY 2022 Oracle Database Administrator

Database Migration & Cloning:

● Performed Data file recovery from logical and physical block corruptions, utilizing advanced recovery techniques to ensure data integrity.

● Implemented Oracle’s Transportable Tablespace (TTS) feature using Data Pump Export/Import for quick and efficient migration of user tablespaces across Oracle databases.

Database Performance Monitoring & Optimization:

● Continuously monitored database performance during peak and non-peak loads using AWR, ASH, ADDM, SQL Trace, TKPROF, and Explain Plan to identify and resolve bottlenecks.

● Optimized SQL code and database queries to improve performance, including index creation and rebuilding, partitioning strategies, and materialized view refreshes.

● Utilized dynamic performance views (V$ views) and alert logs to monitor and manage performance, ensuring that the database operates efficiently under varying loads.

ANNA NGWENUE Page 2

Disaster Recovery & High Availability:

● Managed Oracle Data Guard for physical standby databases, performing failovers, switchovers, and loss of service tests to ensure business continuity.

● Configured and maintained Exadata Data Guard physical standby, successfully testing failover and switchover processes to verify disaster recovery capabilities.

● Performed disaster recovery testing, including rebuild, corruption recovery, and loss of datafile scenarios, ensuring quick recovery in the event of an outage.

Backup & Recovery Management:

● Designed, tested, and implemented robust backup strategies using RMAN, Oracle Utilities (Export/Import), Data Pump

(EXPDP/IMPDP), and OS-level methods to safeguard critical data.

● Automated backup, recovery, and monitoring tasks through customized Unix Shell Scripts and Cron jobs, improving operational efficiency and reducing manual intervention.

● Created and restored databases using Oracle Flashback Technology, ensuring guaranteed restore points for seamless recovery. Cluster & Storage Management:

● Managed storage environments using Oracle ASM, performing routine tasks such as creating and maintaining disk groups, managing redundancy, and resolving ASM issues.

● Responsible for network configuration, including TNSnames, LISTENER, and Net Configuration Assistant for proper client-server communication.

Database Security & Patch Management:

● Applied critical patches, including Patch Set Updates (PSU), Critical Patch Updates (CPU), and one-off patches using the "runInstaller" and OPatch utilities, ensuring the security and stability of Oracle environments.

● Applied security best practices and patch management protocols, ensuring databases remain compliant with organizational standards. Replication & Data Integration:

● Implemented data replication using Oracle Streams and Materialized Views for seamless data synchronization between databases and for reporting purposes.

● Successfully performed data replication from production to test/development environments using RMAN, Data Pump, and manual methods to ensure data consistency across environments. Automation & Routine Database Maintenance:

● Automated database monitoring, performance parameter tracking, and backup/recovery activities through Cron jobs and Unix Shell Scripts, resulting in improved DBA productivity.

● Scheduled and automated routine DBA tasks, such as backups, exports, space usage monitoring, and archive log management, using customized scripts.

Capacity Planning & Space Management:

● Proactively managed database space by monitoring table sizes, extent allocation, fragmentation, and free/used space to ensure optimal storage utilization.

● Performed space management, capacity planning, and overall database maintenance, ensuring the efficient use of storage resources. Cross-Platform & Cloud Technologies:

● Worked with multiple RDBMS platforms, including Oracle 11g/12c/19c, SQL Server, and PostgreSQL, supporting database migrations, backups, recovery, and performance tuning.

● Collaborated on migrating databases to Oracle Cloud environments, enhancing database scalability and performance while ensuring seamless integration.

Key Achievements:

● Successfully migrated and cloned databases across Oracle 11gR2, 12c, and 19c environments using RMAN and Data Pump, reducing migration time and ensuring data consistency.

● Implemented and tested disaster recovery strategies, including Data Guard failovers, ensuring business continuity with minimal downtime during system outages.

● Successfully implemented and tested Oracle Flashback technology for point-in-time recovery, ensuring quick recovery from data corruption incidents.

● Played a key role in the installation and maintenance of Oracle 11g RAC and ASM, providing high availability and fault tolerance for critical database systems.

EDUCATION & CREDENTIALS

Bachelor’s in Information Technology, University of Bamenda, Cameroon Certified Oracle Database Administrator

OCP

CompTIA Security+

TECHNICAL SKILLS

Oracle Versions: Oracle 11g, 12c, 19c

DBMS: SQL Server, PostgreSQL

Backup & Recovery: RMAN, Flashback Technology, Data Pump (expdp, impdp), IBM Tivoli Storage Manager (TSM), Veritas NetBackup Performance Tuning: AWR, ADDM, STATSPACK, SQL*Trace, TKPROF, Explain Plan, TOAD High Availability: Data Guard, Oracle RAC, ASM, Oracle Streams, Oracle GoldenGate Monitoring & Management: Oracle Enterprise Manager (OEM) 19c, ASH, V$ Views, Alert Logs, ASMCMD Automation: UNIX Shell Scripting, Oracle Cloud Infrastructure (OCI) CLI, Cron jobs Migration Tools: Data Pump, RMAN, Export/Import

Scripting: SQL, PL/SQL, UNIX Shell Scripting

Security & Patching: Critical Patch Updates (CPU), Patch Set Updates (PSU), “runInstaller,” “opatch” Configuration: Oracle Net Configuration Assistant, ASMCA Operating Systems: Red Hat Linux, Oracle Enterprise Linux, HP-UX, Sun Solaris, Windows Server Microsoft Office: Microsoft Word, Excel, Office Suite

Contact this candidate