ORACLE Database Administrator

Qualifications Profile

Results-driven, performance-focused, and technically inclined professional with broad-based experience in Oracle database administration, encompassing user logins, performance tuning, database cloning, upgrades, backup, and recovery. Recognized for strategic and proactive management approach in identifying and addressing business requirements, formulating customized solutions, and executing continuous process improvements to consistently achieve organizational objectives.

Areas of Expertise

Database Security / Backup and Recovery / Performance Tuning / Data Guard Configuration / Golden Gate Configuration / RAC Installation and Configuration / Cluster Management / Data Migration / Upgrade and Patching / Connection and Network Administration / ASM Storage Management

Professional Experience

US Foods Manassas VA

Oracle Database Administrator Apr 2015–June2018

Serve as an effective member of the team providing 24/7 technical support, with on-call rotation, for all production, quality assurance (QA), and development environments, while managing multitenant databases, such as Oracle 12c Container and pluggable databases

Function as point of contact (POC) regarding 12c new features, such as redaction policy, adaptive query optimization, multiple indexes on single column, and restoration table using RMAN

Maintained hands-on involvement in various database administration, support, configuration, upgrade, patch migrations, backup and recovery, performance tuning, and cloning efforts, as follows:

Cloning of non-multitenant container database to pluggable database in 12c through PDB Metadata Cloning, PDB Remote Cloning, and PDB Snapshot Cloning features

Reorganization of databases and refresh of schema using import and export

Design of different databases with table spaces, tables, indexes, setting privileges, and user logins, as well as physical databases with multiple table spaces from logical and physical data model

Creation of partitioning strategies for very large tables, while deploying range, list, hash and various sub partitions as well as structure of logical and physical database through logical and physical data modeling

Effectively carry out key functions, which include database sizing, table space management, rollback table space management, transaction management, and security administration

Supervise physical standby databases and high-volume production databases ranging to 2 TB in size

Render hands-on support to developers in improving PL/SQL, and SQL codes, while generating new user accounts and executing schema and related user administrative tasks

Strategically utilize Oracle Enterprise Manager (OEM) for database monitoring, maintenance, replication, and performance tuning as well as Oracle Data Pump (expdp and impdp) for high-speed, parallel, bulk data, and metadata movement for all Oracle database contents

Career Highlights:

Earned the Employee of the Year Award in recognition for outstanding leadership in the successful execution and completion of various projects;

Upgrading of databases from 9i to 10g, 10g to 11g, 11g to 12c using DBUA and scripts, along with 10g and 11g standalone databases to 11g and 12c 2-node RAC respectively

Installation of 11g databases on both IBM-AIX and Linux environments using OLTP, decision support system and data warehousing environment

Configuration of Oracle 12c Enterprise Manager to keep track and generate accurate condition report for more than 500 databases

Setup and maintenance of physical standby database in Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5RAC databases

Implementation of proactive monitoring database through Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace, and EXPLAIN PLAN

Rollout of a variety of advanced security measures as per service level agreement (SLA), such as Transparent Data Encryption (TDE), data masking, and data redaction

Served as integral part of the team that led the configuration of GoldenGate for real-time replication and data guard for disaster recovery and RAC for high availability

Developed and implemented OEM database control for single databases and OEM Grid control for multiple databases

AT&T § San Diego, CA

Oracle Database Administrator Jan 2013–Mar 2015

Assumed accountability in tracking performance of databases by reviewing alert log files and trace files

Offered assistance in configuring and installing GoldenGate, while administering pumps and trail files by removing old extract and log files

Efficiently fulfilled various responsibilities which involved

Installation and configuration of 9i, 10g, 11g, 12c, along with 12c container databases (CDB) on standalone servers and cluster on UNIX, LINUX, and Windows platforms

Update of multiple standalone databases and grid infrastructure from 11gR2 to 12cR1

Deployment of physical standby databases on 2-node 11gR2 Real Application Cluster, while automating scripts to clear already applied archive logs on standby databases

Reproduction of table spaces and databases from production to test server in alignment with customer requirement

Creation and enforcement of Oracle Wallets and Tablespace level TDE security

Utilization of DBMS_REDEFINITION in redefining and partitioning tables and columns data types, as well as placing LOBS to different table space

Development of different backup strategies, such as Cold, Hot, and RMAN with flash recovery area and logical backups (expdp and impdp)

Application of PSU on standalone test environment and production cluster through OPatch Auto

Management of new features of 12c databases, which included tables recovery, field masking, and advanced optimization parameters to secure good database performance

Collaboration with Application Team in enhancing application performance within clustered environment

Executed hot and cold backup, recovery, and cloning of databases using RMAN with VERITAS Net Backup and Commvault

Proactively participated in the migration of large size database in multiple platforms, along with the SQL Query tuning to issue tuning recommendations for application jobs, time, and CPU consuming queries

Dispatched applications across multiple nodes by creating database services using all command line utilities server control utility (SRVCTL), cluster ware control (CRSCTL) utility, automatic diagnostic repository (ADR), and ASM command-line utility (ASMCMD)

Made use of SAN level storage mirroring in developing environments for the data refreshing of large production data warehouse environment

Initiated detailed recommendations and implementation of SQL access and tuning advisors, while handling chained rows and row migration

Guaranteed proper production, security, and performance of all application design and code in accordance with standards

Analyzed the release of Oracle, tools and third-party products to secure accurate operation of products and site

Assisted the development teams in addressing and solving all database related issues, including network failures, ASM DISK group errors, and node failures in the RAC cluster

Career Highlights:

Enhanced SQL statements performances by creating new indexes through Explain Plan and Oracle hints

Led the successful upgrade of databases from 11g to non CDB 12c, along with the migration of 12c Non CDB databases to pluggable databases

Administered the implementation and maintenance of Oracle 11g Data Guard and standby databases for fail-over purposes, along with Oracle TDE to deliver transparent encryption of stored data to support release of Oracle 11g R2

Brought significant security improvements by through effective network data encryption and implementation of SSL wallet, thus safeguarding the network connection

Education and Credentials

Bachelor of Science in Computer Science § Lagos State University Lagos, Nigeria 06/2005 – 02/2009

> OCA Certified

> Security + certified

Technical Acumen

Databases:

Oracle Database (11g, 11g RAC, and 9i)

Software/Tools:

TOAD Active Session History (ASH) Automatic Workload Repository (AWR) Oracle (RMAN DBMS STATS Statspack EXPLAIN PLAN PL/SQL SQL-Tuning Advisor DBVERIFY Database Upgrade, GoldenGate, RAC, DataGuard, and Grid Control SQL TRACE Data Pump Automatic Database Diagnostic Monitor (ADDM)

Operating Systems:

Red Hat Linux Windows Server 2012R2 SQL Server Oracle Enterprise Manager (OEM VMS Sun Solaris

Contact this candidate