Database Administrator Oracle Data

Name: Samuel Lebaga

Email: ************@*******.***

Cell: 702-***-****

**** * ******* **

PROFESSIONAL SUMMARY

An accomplished and seasoned professional Database Administrator (DBA) with 7+ years of experience. Worked on large-scale database environments performing various DBA services across a multitude of platforms such as LINUX/UNIX, Windows, and Solaris. A highly motivated individual with strong leadership and interpersonal skills, who can be trusted with highly sensitive/confidential documentation and projects. An enthusiastic, proactive team player who is fast at picking up new technology with great attention to detail. Possesses excellent written and verbal communication with the ability to articulate a variety of concepts to technical and nontechnical audiences.

AREAS OF EXPERTISE

Database Security, STIGS & Patching

Backup & Recovery, Upgrades & Migration

Installation, configuration, capacity planning

Transparent Data Encryption (TDE)

Oracle Data Guard

Golden Gate / Data Warehouse

Oracle ASM & Grid Control

Oracle RAC

Data Pump

Oracle Exadata

Bash/Unix Shell scripting & Automation

Grid Control and Data Masking

Performance Monitoring & Tuning

Oracle Exadata

Python & AWS RDS

TECHINCAL SKILLS AND TOOLS

Installation, configuration and update of Oracle 11g, 12c, 18c and 19c using OUI, DBCA, DBUA.

Oracle ASM (Clusters) & RAC Configuration & Administration

Database Security

Oracle Golden Gate (Data Replication)

Backup & Recovery using RMAN

SQL, PL/SQL, UNIX Shell Scripting

Monitoring and performance tuning using OEM Console, Toad, SQL Developer, Grid Control, TKProf, Explain Plan, Statspack/AWR, ADRCI, ADDM, DRA, Dbms_monitor

Work with various operating systems like MS Windows Servers (2008,2010, 2012,2014), UNIX (Solaris 8/9/10), LINUX (Red Hat, Ubuntu, Centos)

Oracle Data Guard installation/administration for High availability and Disaster Recovery (DR)

Database migration using Exp/Imp Datapumps and SQL Loader

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Texas Health Presbyterian Hospital Allen, TX 10/2020 – Present

Monitor for vulnerabilities and ensure Security Technical Implementation Guides (STIG) compliance, implement security and performance enhancement per DISAs guidelines.

Review scan results remediate and/or provide recommendations to SAs and business partners. Stay up to date with industry current issues with respect to IT vulnerabilities including researching latest findings, trends and vender -specific issues and resolutions.

Install and configure software for Oracle 12c, 19c on both Windows and UNIX platforms using Oracle OFA. Also Installed, Administered and Maintained SQL Server Instances 2008 and 2012

Champion Database migration project from 12c to 19c and database upgrade from 12c to 19c using the Oracle Data pump and DBUA respectively.

Rewrite and implemented backup strategies following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. Enable block change tracking (BCT) which reduces incremental level 1 backup time from 3hrs down to 25mins.

Resolve space issues with backup optimization, reducing storage costs by 20%.

Apply Oracle’s quarterly Critical Patch Update (CPU/PSU application) using OPATCH utility to install, test, and deploy patches to all database instances.

Supporting daily administration, monitoring, tuning, and troubleshooting on single instance on UNIX/Linux, Windows server 2008 and 2012 (Database sizes range 100GB to 39TB)

Monitoring AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS_STATS, Trace Files, and System Event Logs for unusual events and took appropriate action according to company policies of incident reports.

Implementing table and index partitioning so as to Minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query.

Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases

Deploying Database security policy and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces, also implementing the “triple A” (AAA) and database auditing policies as well as data redaction

Cloning databases using RMAN and DATAPUMP utilities for all database sizes

Installing and administering Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD)

Applying Oracle's quarterly Critical Patch Update (CPU/ PSU application) using OPATCH utility to install, test, and deploy patches to all database instances and add the embedded JDK patch

Perform database Refresh from production environments

Performed PL/SQL errors fixed and modified the applications using PL/SQL

Part of the on-call production support team for 24/7 on-call production support.

Oracle Database Administrator

Mirage Hotel and Casino Las Vegas, NV 10/2014 – 09/2020

Performed Day-to-Day DBA tasks: performance tuning, system security, database installation configuration, patching, technical database support in 24X7 environment to ensure system performance and stability.

Executed daily incremental backup and weekly full backup of databases using RMAN.

Loaded data into database tables using SQL Loader.

Frequently monitored emails regarding any database issues.

Responsible for quarterly patches, maintaining/monitoring/upgrading the production and test databases.

Setup/configured oracle RMAN for database backup and recovery. Application of different recovery.

Used different procedures for complete and incomplete recoveries depending on the type of failure by using Export/Import scripts.

Restored and recovered database from offline, online and RMAN backup.

Carried out table space monitoring, Performance monitoring and tuning for performance improvement.

Granted roles and privileges to end users.

Managed, troubleshoot and resolved oracle database and application issues.

Created scripts and scheduled backups in Cron for RMAN database backups and recoveries.

Implemented database security using Oracle's Transparent Data Encryption based on Database Security Technical Implementation Guide (STIG) developed by DISA.

Tested backups & recoveries by forcing database crashes.

Performed database tuning by reviewing AWR & ADDM reports, implementing SQL profiles and baselines, designing table and index partitioning and coalescing of database objects for faster query performance. Include memory, I/O, contention, and SQL statement tuning.

CERTIFICATIONS AND EDUCATION

EDUCATION

Bachelor's Degree in Mathemetics / Computer science, University of Buea, Cameroon

CERTIFICATIONS

Oracle Database 12c: SQL Fundamentals, Oracle University

Oracle Certified Associate, OCA, Oracle University

Contact this candidate