DataBASE ADMINISTRATOR Oracle

Charlotte Acheba Ajuata

Phone: 301-***-****

Email: ac97qf@r.postjobfree.com

LinkedIn – Charlotte Ajuata

(Willing to obtain a security clearance)

PROFESSIONAL SUMMARY

An accomplished and seasoned professional Oracle Database Administrator (DBA) with over 8 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 non-technical audiences.

AREAS OF EXPERTISE INCLUDE

Installation, configuration, capacity planning

Performance Monitoring & Tuning

Backup & Recovery, Upgrades & Migration

Database Security & Patching

Oracle ASM & Grid control

Oracle Data guard

Bash/Unix Shell scripting & Automation

TECHNICAL SKILLS AND TOOLS

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

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, 20012), UNIX, LINUX (Red Hat)

ETL tools: SQL*Loader, Golden gate

Oracle Enterprise Manager

Oracle VM Virtual Box

MS SQL Server Management Studio

Backup & Recovery using RMAN

SQL, PL/SQL, UNIX Shell Scripting

Oracle ASM (clusters) and RAC configuration and administration

Oracle Golden Gate (Data Replication)

Database security

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

Database migration using Exp/Imp/Datapump, and SQL Loader

PROFESSIONAL EXPERIENCE

MedStar Health Baltimore, MD

Sr. Oracle Database Administrator

06 / 2015 – Present

Installed and configured software for Oracle 10g, 11g, 12c on both Windows and UNIX platforms using Oracle OFA. Also Installed, Administered and Maintained SQL Server Instances 2008 and 2012

Lead database migration project from 10g to 11g and database upgrade from 11g to 12c using the Oracle Datapump and DBUA respectively.

Created and managed pluggable databases in the multitenant container database of the Oracle 12c architecture

Experience migrating database objects from development through test and into production environments

Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. I also used block change tracking (BCT) which reduced incremental level 1 backup time from 3hrs down to 20mins.

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

Implement 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

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

Cloned databases using RMAN and DATAPUMP utilities for all database sizes

Installed and administered Oracle Physical Standby Database for single instances to achieve high availability and DR solution (DATA GUARD)

Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances

Performed database Refreshes from production environments

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

Part of the on call production support team for 24/7 on-call production support. We adhere to the agile methodology; daily scrum meetings in the morning around 9:30 a.m. (via the phone) Monday to Friday and spring meetings every 2 weeks to discuss goals.

1.Understanding the existing Oracle data models, existing PL/SQL and Linux scripts, and fix and rewrite the existing scripts with Oracle Data warehouse standards. i have modified scripts before but have not written them. i also have worked with developers to make sure the PL/SQL PACKAGES that we have work correctly. but writing the package is something i haven't done before but i'm willing to learn.data warehouse is a project im on now but still reading it's more for OLATP. it's another form of storage by a business. i haven't done data modelling before but i know one of the tools used for data modelling is ERWIN. this is another area i can learn as well

2.Proficiency writing scripts using Oracle PL/SQL and Linux scripting (I HAVE MODIFIED SCRIPTS BUT HAVEN'T WRITTEN THEM FROM SCRATCH)

3. Proficient experience with Legacy Data warehouse projects. (JUST STARTED READING ON DATA WAREHOUSING IN MY SHOP DON'T REALLY KNOW MUCH AS OF YET.)

4.Proficient experience with SQL, TkProf, SQL Loader, Packages, triggers, Materialized Views, UTL file and external tables. (I HAVE USED OEM, SQL LOADER, TKPROF IN THE PAST IN MY CURRENT SHOP I USE TOAD, ORACLE DIANOSTIC TOOLS LIKE AWR, ADDM, ASH, EXPLAIN PLAN, SQL TUNNING ADVISOR. TKPROFF IS NOW USEFUL FOR ACTIVE DATAGUARD)

5. Working knowledge with Control-M or any job scheduling tools. ( I HAVE USED JOB SCHEDULER, CRON-TAB AND JUST STARTED USING ACTIVEBATCH)

6.Hands on experience with data warehouse/business intelligence reporting environment. Knowledge in both client-server and mainframe-based systems and the ( I HAVEN’T DONE ANY REPORTING)

7.connectivity/infrastructure requirements to support, design, develop and implement such systems. (I HAVE DONE CAPACITY PLANNING WITH A TEAM WHEN WE HAVE TO START A NEW PRJECT)

8. Evaluating and/or recommending changes to the data model(s). (I HAVE NOT DONE THIS RECENTLY).

9. Analyzing the data provided to assess if the data meets customers' needs. (I HAVE NOT DONE THIS recently)

10.Development of user documentation and guidelines. (I HAVE DONE THIS RECENTLY)

11.Hands on Experience with Oracle DBA skills (schema and database analyze, full back up, resource allocation and trouble shooting skills).( I DO THIS OFTEN IN MY CURRENT ENVIRONMENT. I PERFORM BACKUP AND RECOVERY USING RMAN, DATAPUMP, I USE ORACLE DIAGNOSTIC TOOLS LIKE AWR, ADDM, ASH, EXPLAIN PLAN, SQL TUNING ADVISOR TO TROUBLESHOOT MY DATABASES.)

Bank of America Washington DC

Oracle Database Administrator 04/ 2010 – 06/2015

Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to Optimal Flexible Architecture (OFA) Institution and finally to DB launch.

System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.

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

Designed and implemented the ETL utilizing PL/SQL.

Used range, hash and composite table partitioning which greatly decreased the DB_time and SQL Execution time. Also performed instance tuning by changing init.ora parameters and managed region parameters such as shared_pool_size and db_cache_size with the use of AMM and ASMM.

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

Installed and configured the Oracle Golden Gate software on Unix/Linux platform for both Unidirectional and Bidirectional replication

Worked in a cross functional team that oversaw the Oracle RAC installation and configuration for Linux environments.

Maintaining highly reliable 24x7x365 Linux production servers for AWS EC2 instances.

Worked with PL/SQL including Procedures, Functions, Cursors and Triggers.

Applied Oracle's quarterly Critical Patch Update(CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances

Worked on ORACLE EXADATA Machine X4-2 for the extreme performance of the database

Configure and manage CloudWatch alarms to monitor resources in AWS for Disk, Memory, and CPU utilization.

Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.

EDUCATION AND CERTIFICATIONS

Masters of Science in Health Informatics Walden University

Bachelors of Science University of Maryland

CERTIFICATION

Oracle Certified Associate

Oracle Certified Professional

COMPTIA Security+ (In progress)

Contact this candidate