Database Administrator Oracle

Bernadette Onuorah

Bowie, MD 301-***-**** *******@*****.***

SUMMARY

As an experienced Oracle Database Administrator, I have a proven track record of configuring and maintaining databases, implementing disaster recovery plans, and optimizing database performance. I am well-equipped to support various database environments. My experience includes designing and applying PSU and OJVM patches and performing backups and recoveries using RMAN. I have extensive experience in Securing systems using Security Technical Implementation Guides (STIGs). Throughout my career, I have worked collaboratively with development and operations teams to resolve issues quickly and efficiently. My documentation skills ensure that standard processes are followed and updated regularly. As an Oracle Database Administrator, I bring strong technical skills, attention to detail, and a collaborative mindset to any team.

EDUCATION

Bachelor of Science in Business Management & Finance, University of Maryland College Park, MD

CERTIFICATIONS

CompTIA Security+ CE (Exp. Date: 10/16/2027)

SECURITY CLEARANCE

Active Top Secret

PROFESSIONAL EXPERIENCE

COMPQSOFT, INC Bowie, MD DATE: 02/2023 – Jun25

Oracle DBA

Setup Data guard replication in development and preproduction environments

Setup Oracle Real Application Clusters (RAC)

Install, maintain, and Upgrade Oracle Database throughout the life cycle of the product.

Oracle Automatic Storage Management (ASM)

Maintaining growth, scalability, tasks, and schedules

Expertise in Linux or Windows server operating systems and technologies

Provide ongoing database maintenance, including optimizing databases for specific applications

Update database software as required.

Expertise with Oracle and the ability to troubleshoot issues with Oracle.

Expertise in Linux or Windows server operating systems and technologies

Support users by resolving problems with application databases.

Determine and implement appropriate application database backup and recovery.

Works in the cross-functional domain of data analysis and database administrator

SuprTek Inc, DISA, Fort Meade, MD DATE: 01/2020 - 10/2022

Oracle DBA

Maintain and administer Oracle Database on Solaris / RHEL platforms

Maintain, Install, and Upgrade Oracle Database throughout the lifecycle of the product

Setup Data guard replication in development and preproduction environments

Deploy Cloud Control Agents to all assets in the enclave

Perform regular database administration tasks in systems in the Mil Cloud

Work with Unix System administrators to build database servers and LDOMs

Maintain Oracle 12c, 19c including Multitenant, RAC, Data Guard, Grid Infrastructure, Oracle Automatic Storage Management (ASM) and Oracle Automatic Storage Management Cluster File System (ACFS)

Regularly clone development and test databases

Work on system integration particularly application and database integration

Design and implement appropriate backup strategies for each environment

Develop and Maintain database Standard Operating Procedures SOP

Provide documentation on the database systems including the System Security Plan for each database system SSP

Test and apply patches to development and test instances and produce RFC and implementation plans for deployment of the quarterly patches in different theatres

Strong diplomacy, assertiveness, influencing skills with commitment and ability to work in a dynamic cross-organizational team environment

Good interpersonal, communication, organizational, and customer service skills

Experience hardening of databases according to DISA Secure Technical Implementation Guidelines (STIGs)

Install Client, configure and establish connections from databases to applications

Conduct data refreshes using Logical backup utilities like Export/Import, and Data Pump

Create and assign appropriate roles and privileges to users depending on their responsibilities.

DVS, DISA- Fort Meade MD DATE: 09/2014 - 12/ 2020

Oracle DBA

Performed Oracle software installation, database creation, create database objects, upgraded and migrated Oracle 11, 12c and 19c as required

Applied patches and modifies configuration as necessary to remain compliant with the security requirements,

Determined changes in the physical database by responding to project requirements; identified database characteristics, such as the amount of space required

Oracle Architectures (memory structures like SGA and Shared Pool, processes, data files)

Modified grid Control installation to configure options and add multiple databases onto the grid for global management

Documents database installation and operational procedures

Monitored database performance, created installations based on user requirements, conferred with others on the project team

Performed backup and recovery options (i.e., RMAN, cold/hot backups, and export/import of data) and other monitoring scripts for Oracle databases and scheduled all on UNIX crontab

Troubleshoot Oracle infrastructure problems

Administered all system users, set up profiles, and all other user-related tasks

Created and assigned appropriate roles and privileges to users

Secured systems using Security Technical Implementation Guides (STIGs)

Develop, design, and install Cloud Control in an enterprise architecture

Deploy Cloud Control Agents to all assets in the enclave

Design, build and maintain database systems in the Cloud environment

Perform regular database administration tasks in systems in the Mil Cloud I and II

Work with Unix System administrators to build database servers and LDOMs

Build development, test and production databases

Regularly clone development and test databases

Conduct database upgrades for different versions including Oracle 12C

Work on system integration particularly application and database integration

Design and implement appropriate backup strategies for each environment

Develop and Maintain database Standard Operating Procedures SOP

Provide documentation on the database systems including the System Security Plan for each database system SSP

Test and apply patches to development and test instances and produce implementation plans for deployment of the quarterly patches in different theatres

Perform some shell scripting to help automate several database activities

SAIC, Pension Benefit Guaranty Corp, VA DATE: 03/2013 - 06/2014

Database Administrator

Assist PBGC customers with Provisioning new users and dropping old users from the database and Applications.

Administered all System Users, set up profiles, and all other user-related tasks.

Maintain and troubleshoot databases in Production, Development and Test environments (PBGC project). Coordinated Oracle installation, upgrade, patch, backup, and recovery

Conducted performance tuning

Created and assigned appropriate roles and privileges to users depending on the user.

Maintained client confidence and protects operations by keeping information confidential

Knowledge of backup and recovering options (i.e. RMAN, cold/hot backups, export/import of data) and other monitoring scripts for Oracle databases and scheduled all on UNIX crontab

Applied patches on the development environment and modifies configuration as necessary to remain compliant with the security requirements.

Familiar with Oracle Architectures (memory structures like SGA and Shared Pool, processes, data files)

Troubleshoot Oracle infrastructure problems

Created new databases, configured listeners and set TNS names for end-users and developers

Knowledge of Maintaining Oracle Application Server Environment i.e. Bounce the OC4j container to implement the changes

Support disaster recovery and COOP

Serco, Arlington, VA DATE: 09/2012 - 12/2012

Oracle DBA

Assist customers of DOD agencies with information technology-related questions in person, electronically, and by telephone. Diagnose and resolve database and application-related issues. Stay current with technological trends related to the DOD environment.

Perform a wide range of configuration and administration duties on Database and general support.

Documents database installation and operational procedures

Monitors database performance and creates installations based on user requirements, conferring with others on the project team

Performed backup and recovery options (i.e., RMAN, cold/hot backups, and export/import of data) and other monitoring scripts for Oracle databases and scheduled all on UNIX crontab

Troubleshoot Oracle infrastructure problems

Attend and actively participate in meetings

Performs other duties as assigned

Write ad-hoc queries based on schema knowledge for various reporting requirements.

Veterans America Business Consulting, Inc, VA DATE: 09/2011 - 3/2012

Oracle DBA

Worked on backup and recovering options (i.e., RMAN, cold/hot backups, export/import of data) and other monitoring scripts for Oracle databases and scheduled all on UNIX crontab

Applied patches on the development environment and modified configuration as necessary to remain compliant with the security requirements.

Tuned databases by adjusting memory structures (SGA and Shared Pool, number of processes)

Modified grid Control installation parameters to configure options and add multiple databases onto the grid for global management

Created new databases, and listeners, and set TNS for connectivity for end-users and developers

Support disaster recovery and COOP efforts

Zolon Tech, Inc. DATE: 03/2009 - 06/2011

Oracle DBA

Supported Oracle database on Sun Solaris platform

Applied patches and modified configuration as necessary to remain compliant with the security requirements.

Provided support in troubleshooting application server issues

Performed Backups and recovery options (i.e. RMAN, cold/hot backups, export/import of data) and other monitoring scripts for Oracle databases and scheduled all on UNIX crontab

Created UNIX shell and SOL scripts for database backups; and scheduled them on crontab

Modified grid Control installation to configure options and add multiple databases onto the grid for global management

Oracle Architectures (memory structures like SGA and Shared Pool, processes, data files)

Implemented Oracle password authentication, Data integrity and Role creation to control database access and modification

Troubleshoot Oracle infrastructure problems

Documented database installation and operational procedures.

Monitored database performance, and created installations based on user requirements.

Project team

Determined changes in the physical database by responding to project requirements; identified database characteristics

PROFESSIONAL DEVELOPMENT

OCA: Oracle Database 11C Administration

Training:

Basic UNIX Administration Hands-on Training Program 08/2006

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g, 12c, 19c, RDBMS, MS access. Oracle Tools: Oracle Enterprise Manager (OEM) with Diagnostics, Oracle Universal Installer, Database Configuration Assistant, Database Upgrade Assistant, Oracle Net Manager, SQL Plus, DBCA and Recovery Manager, Data Pump, NETCA, AWR. ADDM, JIRA, ServiceNow, TOAD.

Contact this candidate