Database Administrator Administration

LILIAN GAKUBIA

***********@*****.*** 301-***-**** Frederick MD

Summary

I am an accomplished and certified Oracle Database Administrator, with good hands-on experience in database administration related oracle version ranging from 10g, 11g, 12c and 19c. I possess extraordinary written, verbal, analytical and organizational skills. I am a global thinker with experience working with diverse and talented groups of individuals.

Skills

Database Administration

Information Systems Management

Linux Operating System

Customer Needs Assessment

Database Development

Database Analysis

Agile Methodology

Data Testing

Compiling Data

Microsoft SQL

Data Conversion and Migration

Data Acquisitions

Data Migration

Information Protection

Continuous Process Improvement

Disaster Recovery

New Product Testing

NoSQL Databases

XML Database Proficiency

Experience

AURORA HEALTH CARE

Senior Database Administrator

06/2022 - Current

Designed backup strategies executing of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively.

Used block and change tracking (BCT), reducing backup time.

Resolved space issues with backup optimization, reducing storage costs.

Constructed database security policy using passwords, privileges, user profiles, Transparent Data Encryption to encrypt tables and tablespaces; implemented auditing policies as well as data redaction and data masking.

Capacity planning to meet the demands of the dynamic aspects of storage & Monitored AWR, ADDM, ASH, Alert log, dynamic performance view, DBMS_STATS, Trace file system event logs for unusual events & took appropriate action according to company policies of incident reports.

Cloned databases using RMAN and DATAPUMP utilities for all database sizes.

Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.

Sprint Washington, DC

Oracle Database Administrator

05/2020 - 12/2021

Rewrote and implemented a backup strategy following company SLA, execution of backup schedule for both physical and logical backups.

Maintenance of production database and development database which includes table space management, user creation, and privileges, roles.

Support RMAN backup and recovery including physical backups and logical backups by using data pump (Expdp/Impdp) tool.

The project has reduced downtime for databases by allowing switchover, failover and recovering databases due to hardware or network failures.

Deployed Database security policy and installation, using passwords, privileges and user profile.

Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces.

Keep records of changes made to the database environment.

Create database manually and with DBCA tool.

Maintain documentation for database configurations, procedures, and processes.

Develop and implement scripts for monitoring and maintenance.

Present project plans for approval prior to starting the implementation process.

Walmart Federick, MD

Junior Database Administrator

02/2019 - 04/2020

Implement table and index partitioning to Minimize down time, increase disk load balancing, improve query speed and enable faster parallel query.

Responsible for ensuring that all applications and networks run in accordance with business practices.

Managed database security by creating, assigning appropriate roles & privileges to users depending on user activity, auditing, & performing other security related tasks including transparent Data Encryption

Ensure databases comply with regulatory requirements.

Participate in audits and provide necessary information.

Offer support and assistance for database-related issues.

Education and Training

Frederick community college

Associate degree in psychology

06/2015

Websites, Portfolios, Profiles

https://www.linkedin.com/in/lilian-g-n/

Certifications

Oracle Database 19c Administrator Certified Professional

TECHNICAL SKILLS

• Oracle Databases 10G, 11G, 12C &19C

• Tools- Putty, SQL Developer, SQL*Plus, & WinScp

• Scripting Languages - Sql, Pl/Sql & Unix Shell Scripting

• Operating Systems - HP-UX, Redhat Enterprise Linux, Solaris, Oracle & enterprise Linux

Database Utilities - OEM 12c & OEM 13c Cloud Control, Exp/Imp, Data Pump, DBCA, DBUA, OUI, RMAN, Goldengate Monitor, DGMGRL & GGSCI

PROFESSIONAL SKILLS

• Extensive experience with RMAN Backups, Hot Backups and Logical Backups.

• Database monitoring/maintenance, replication process and performance tuning done using OEM (Oracle Enterprise Manager).

• Experience in applying PSU patch on standalone as well as RAC databases.

• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Data pump, conventional Export/Import of Oracle 11g, 10g.

• Configured and maintained physical standby databases using Oracle Data Guard to perform quick disaster recovery.

Contact this candidate