GRACE LEA SONWO Status: US Citizen

Apple Inc. Willing to travel:50%

Email:Gracesonwo@yahoo.com Level: Senior Oracle DBA
Cell: (240)-505-1880 Last update: 05/14/19

PROFESSIONAL SUMMARY
I am an accomplished and seasoned professional Oracle Database Administrator and IT security expert with 8+ years of
extensive knowledge and proficiency in Oracle database administration. I have worked on very large production databases,
performing various DBA roles across a multitude of platforms (LINUX, Solaris, UNIX, and Windows) in production, development
and testing environments. I am an enthusiastic, proactive team player who is fast at picking up new technology with great
attention to detail as well as great communication / documentation skills. With strong aptitude to analyze and resolve problems,
I have a well-honed ability to adapt and thrive in a dynamic fast paced and challenging work environment. I have the ability to
work in versatile environments, whether it would be single or team-based roles with limited direction. I can proficiently
articulate technical concepts to a variety of technical and non-technical audiences using both written and verbal
communications.

SKILLS

 Oracle  Oracle Database refresh

 DDL, DML, Select statements  Oracle Database Change Management
 Backup and recovery using RMAN  Oracle Database Performance Tuning
 Transparent Database Encryption  AWR report analysis
 Database security  ADDM, Explain Plain, ASH
 export/import and Data Pump  Multitenant Database
 Oracle Data Guard/standby databases  Standalone Database
 Oracle Database upgrades  Oracle Grid Control
 Real Application Clusters (RAC)  SQL Developer
 Automatic Storage Management ASM (3  SQL Tuning
years)  Linux  Access &
 Database Resource Management Excel  SQL
 Management Server
 Gold e n Ga te  Load (ETL)/Data Integration experience
 Da t a P u m p  Generating Standard Operating Procedures
 Pa t ch (SOPs)
PROFESSIONAL EXPERIENCE

Apple Inc., Reston, Virginia

Senior Oracle Database Administrator January 2016 –
Present

 Worked closely with Systems Analysts, Systems Engineers/Admins & Application Developers
through the SDLC from Development to Production, Requirements Gathering, (Server
hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and
Implementation, database user creation and database access both at role & table levels, as well
as final Project Performance Assessment/Evaluation.
 Managed Oracle databases in very large (over 10 TB)
 Implementation of High Availability solutions with Oracle 12c, Physical and Logical Standby
Databases (Data Guard).
 Installed and configured Oracle identity manager and Oracle role manager.
 Performed evaluation of existing Oracle identity Manager implementation and deployed
performance and process improvement.
 Organized various migration review meetings with the application team to discuss the migration
strategy based on their requirements.
 Performed various tasks in administration of databases including capacity planning, instance
creation.
 Upgrade/Migrated applications/databases 10.2.0.4,11.2.0.3 on Solaris to Oracle 12.1.0.2,
12.2.0.1 on Linux RHEL 6.x
 Designed and implemented partitioning for large tables. Develop packages and procedures for
the data migration.
 Developed stored procedures and triggers to retrieve data from Development and Production
databases to satisfy reporting needs.
 Created and debugged PL/SQL Stored Procedures, Functions, Cursors and Triggers etc
 Monitored and maintain system security and Auditing. Supported SOX related auditing
Controls.
 Design of databases following OFA: Creating Databases schemas, profiles, database links,
Snapshots and Synonyms of objects as required to ensure data quality and security to comply
with company's business rules. Oracle scripting in Windows/Linux and UNIX platform.
 Performance Tuning: Tuned various large critical OLAP and OLTP databases of Terabytes size
using various tools like STATSPACK, AWR, SQL Trace, Tk prof, Analyze, ADDM and Explain Plan
Methods.
 Implemented Database Backup and Recovery concepts using RMAN utilities (scheduling
full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for
RMAN).
 Performed LOGICAL BACKUPS for Database migration using Data Pump, Export/Import and
Transportable Table spaces.
 Set up 12C OEM Grid Control to monitor all databases centrally. Monitor health, availability,
performance, cloned and schedule backups using 12c Grid Control
 Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM
client, oracle 12c OEM as well as other third party tools (TOAD, SQL Developer).
  Monitored database systems and provide technical support for database system issues and
application performance enhancement/improvement using both OEM (client), Oracle 10g,11g
and 12c database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
 Created and Scheduled jobs through Oracle DBMS Scheduler and Oracle Cron.
 Responsible for Creating and dropping of users, granting and revoking rights as and when
required
 Supported variety of hardware and software platforms including; MS-Windows 2000, 2003, NT
Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
 Troubleshoot installation errors both independently and with Oracle support (via My Oracle
Support)
 Maintenance of Oracle 12c Real Application Cluster (RAC) Database for High Availability,
Scalability and Performance by determining the best Cluster architecture, choosing the best
hardware configuration for Oracle RAC.
 Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using UNIX
command-line utilities.
 Maintain and administer change management policies and updating the ticketing system using
BMC Remedy and Jira.

Weatherford laboratories, Houston, Texas

Oracle Database Administrator February 2014
– December 2015

 Provided day-to-day support for Oracle 11.2.0.4 databases in 24/7 production environment on
Red Hat Enterprise Linux servers, as well as Microsoft SQL Server 2012 databases on Windows
Server 2012. Oversee data analysis and database management for Oracle systems including
applications upgrades.
 Developed and tested storage strategies and disaster-recovery plan for large manufacturing
company’s operational database, delivering solution that guaranteed recovery performance
and high availability in RAC environment.
 Developed database structure, implement applications, enhance system and ensure security.
 Designed scripts and develop tools to automate periodic task and improve monitoring of
system.
 Install, configured, and supported Standalone environment consistently. provided remote
support and manage numerous technical queries for client needs and try to resolve on time
within SLA breached.
 Configured Oracle Transparent Data Encryption (TDE) to encrypt sensitive data such as
customer’s personal and payment information.
 Provided and maintained high availability and disaster recovery using Oracle Data Guard.
 Monitored space utilization and optimized performance of Oracle 11g databases using Oracle
Enterprise Manager.
 Enforced business rules and maintained data integrity via the use of constraints using DDL
statements.
 Performed bulk load into databases SQL Loader.
 Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to
install, test, and deploy patches to all database instances

Walmart ecommerce, Washington D.C

Database Administrator May 2012 –
January 2014
  Provided day-to-day support for Oracle 10g and 11g databases in test, development, and
production environments on UNIX servers. Created, reviewed and implemented maintenance
plans on production servers.
 Installed SQL Server 2005 for new servers as well as in-place upgrades to 2005 on 2000 servers.
 Created and maintained documentation for DBA standard operating procedures.
 Supported clustered and non-clustered environments as well as log shipping for disaster
recovery.
 System Development Life Cycle (SDLC) methodology for designing, analysis, development and
implementation
 Implemented cold backups and hot backups for production and development environments.
 Performed extensive follow-up procedures to obtain, update, and validate information;
maintained an exceptionally high accuracy rate through data verification, attention to detail, and
regular quality control checks.
 Coordinated the migration of project information from an existing system to new database,
enabling company to produce proposals and other project-related documentation more
efficiently.
 Managed database security by creating, assigning appropriate roles and privileges to users, and
auditing user activity.
 Planned, implemented and monitored backup and recovery strategies for production databases
using RMAN.
 Conduct Data modeling using tools like SQL Developer
 Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to
install, test, and deploy patches to all database instances.
 Resolved Oracle related errors/issues assigned through Remedy ticketing system.
 Configured Oracle databases using DBCA

EDUCATION
Bachelors Degree in Finance – University of Maryland

AWARDS & HONORS

ABA Diversity Scholarship in 2013

CERTIFICATION

• Oracle Database 12c Administrator Certification Oracle University

•Certified Associate, OCA
•CompTIA Security+ (CE) SYO-051

ACCOMPLISHMENTS

LANGUAGES:

 English - Fluent.
 French - Native or Fluent.