ORACLE DATABASE

PERFORMANCE TUNING & OPTIMIZATION RECOVERY PROCEDURES DATA MANAGEMENT

Accomplished, certified, and innovative professional with 8+ years of experience in the Information Technology Sector and 6+ years of experience working with Oracle Database inclusive and providing project and production support for several big-name organizations including Fortune 500 financial conglomerate, GAP INC. thorough knowledge of network operations and ability to take a project from initial startup through completion of production and support Creative problem solving and troubleshooting skills complemented by precise attention to detail. Delivers success through continued system and process improvements and remaining focused on the end goal in fast-paced environments.

EXPERTISE

AWS Cloud Management MS SQL SERVER BASH/SHELL Scripting PostgreSQLResearch Data Management Goldengate Oracle SQL Developer Software Deployment Backup & Recovery Oracle HA Stack• Upgrade & Patching Oracle EBS PLSQL SQL Security Patching Automation & Scripting RAC Implementation Oracle 12c, Oracle 18c, Oracle 19c Oracle Grid Control RMAN Exadata Oracle 13c Cloud Control

PROFESSIONAL SKILLS

Take full responsibility and expertise in database administration duties including Performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances.

Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure.

Experience on Data Replication using Snapshot and Materialized views.

Configured Oracle Data guard for Oracle Disaster Recovery and Performed switchover/switchback from primary database to standby database for testing purpose for the application teams when required.

Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for issues and validating disk space.

Upgrade of large number of databases from 11g to12c,18c and 19c. Implemented ASM on RAC and stand-alone databases and Applying PSU Patch and Migration of non ASM database to ASM database.

Using list partitions for large tables and bitmap indexes for the OLAP databases.

Scheduled Cumulative Incremental backups using RMAN Cloned databases using RMAN Utility.

Installation and configuration of GoldenGate and Replication of data using Oracle Golden Gate.

Resolved/Diagnose Node Eviction issues.

Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 11 TB.

Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.

Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements and design indexes to improve response of queries.

Automated monitoring of Golden Gate process and heart beat monitoring.

Experience in Installation of Oracle Databases 11, 12c, 18c and 19c versions.

Experience in the Upgrade of Oracle Databases in patch set Level and also in version Level (11g to 12c), (12c to 18c) and (18c to 19c).

Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.

Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)

Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, datapump export/import.

Superb Knowledge of MS SQL Server 2008-2106 in Database Administration.

Experience in database upgrade and migration to newer versions

Experience in troubleshooting and resolving database installation, integrity, performance, blocking and security issues.

Strong experience with Performance Tuning and query Optimization using performance monitor, SQL profiler, and other related monitoring and troubleshooting tools.

Assisted in management and database administration of Oracle database applications on Exadata platforms.

Provided technical assistance for designing, installation and upgrading of existing Oracle databases.

Performed database management functions such as maintenance, access issues and security.

Conducted designing, assembly and tuning of databases in coordination with development teams.

Evaluated database performance for investigation of issues and further resolution for efficiency.

Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.

Supporting Half and Quarter Rack EXADATA servers in OCI cloud.

Creating and configuring ACFS on Exadata servers.

Migrated databases from Non-ASM file system to ASM file system using RMAN.

Configure Physical Standby for 12C Production databases.

Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump& Transportable Tablespace (TTS).

Experience in configuring Middleware such as WebLogic and Oracle Access Manager (OAM)

Experience in implementing and supporting Single Sign-on (SSO) and SSL using Web gate and OAM.

PROFESSIONAL EXPERIENCE

ORACLE DATABASE ADMINISTRATOR KING & SPALDING LLP - WASHINGTON, DC APR 2018 – Current

Installation, configuration and upgrading of Oracle server software and related products.

Establish and maintain backup and recovery policies and procedures.

Take care of the Database design and implementation.

Implement and maintain database security (create and maintain users and roles, assign privileges).

Work as part of a team and provide 24 7 support when required

Perform general technical trouble shooting and give consultation to development teams.

Interface with Oracle Corporation for technical support.

Perform database tuning and performance monitoring.

Cloning DEV and TEST from PROD.

Plan, engineer, configure, and deploy USER MANAGEMENT and SPACE MANAGEMENT solutions while supporting software that grants required privileges to users.

Administer data analysis and database management for Oracle systems including applications upgraded and scheduled. RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.

Implemented procedures for automation of database management through tables and indexes.

Executed processes for evaluation of system space, database allocation and storage metrics.

Maintained all existing databases and new installations at current and stable production levels

Guide 24/7 network troubleshooting on 12 databases of 2.0 TB 4 Node production 11g and 12c RAC, restoring routine technical service and equipment problems by analyzing, identifying, and diagnosing faults.

Pioneer Logical backups EXPDP/IMPDP and persuaded conventional EXP/IMP for migrating data from 11G to 19c.

Monitor and troubleshoot database issues with OEM grid control and advised database recovery using GRP (Guarantee Restore Point).

Create data verification and testing methods to resolve Golden Gate issues and prevent glitches/gaps.

Configure, analyze, and maintain Oracle 12c Data Guard system for clients

Responsible for setting up backups and maintenance plans for all production environments.

Applied quarterly security patches to the servers.

Provided Security, consistency, efficiency, track state etc.

Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per customer requirement to make new enhancements or resolve problems.

Responsible for design, installation, administration, capacity planning, upgrade, security, management, performance tuning, backup & recovery, patch management, shell scripting, 24/7 technical support of Oracle 12c/ 11g, 10g databases, on Development, Test, QA and Production environments.

ORACLE DATABASE ADMINISTRATOR GAP INC, San Francisco, CA MAY 2015 – APR 2018

Incorporated SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Managed Datacenter Migration from old datacenter to new datacenter and Migrated and upgraded single instance database to instance databases using export/import, data pump.

Analyzed data migration from databases to new systems, managed user account on Oracle 11g/12c to 11gR2 RAC and Oracle 12.1.0.2 databases.

Assessed customer needs and goals through communication and system evaluations to modify existing databases for personalized customization with a 24/7 support.

Implemented enterprise databases on enterprise Storage Solutions utilizing Storage area Networks (SAN) and Network attached storage (NAS).

Facilitated database and application tuning, interface for application testing and code walk through respective to integrating new or changed applications into the production environment.

Responsible for recommending database solutions to recognized problem and for design and implementation of new Oracle database

Responsible for Installation and Configuration of Oracle solutions like Data Guard, Gold Gate

Responsible for creating, maintaining and updating documentation necessary to support the database operations by the DBA

Developed and conducted security initiatives by viewing alert log files & trace files to protect important company data.

Initiated Creating Users, Groups, Roles, Profiles and assigning the users to groups

Proficient in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning.

Designed, built, guided, and assessed Oracle10g to 11gR2 RAC Database for Clients.

Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases

Implemented security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

Responsible for setting up effective monitoring for alerts and capacity analysis. Also, tunning the database environment to insure optimal performance and resource utilization.

NETWORK TECHNICIAN CABLING SYSTEMS INC., Beltsville, MD MAR 2013 – MAY 2015

Provided support LANs, WANs, network segments, Internet, and intranet systems, along with debugging slowness issues and identifying network bottleneck.

Optimized company access by revamping and configuring network equipment and software/hardware.

Installed coaxial cable, twisted pair cable, and fiber optics and also spliced coaxial cables and network routes within data center to connect network devices.

Installed and managed fiber optic connectors/enclosures and application components to assure nonstop operations.

Inspected blueprints, floor plans and cut sheet to addressed hardware installation, configuration, and operational support

Proposed annual and preventive service maintenance on all software including system backups and recovery.

Executed all equipment running by paying close attention to signs of issues and completing quality repairs and troubleshooting/ resolving hardware/software

Prepared annual and preventive service maintenance on all software including system backups and recovery.

Co-ordinated organization in varying endeavors, including proposal support that may include writing responses to RFPs, etc.

EDUCATION

B.S. Political Science and Public Administration University of Benin, Benin, Edo State, Nigeria FEB 2011

TECHNICAL CERTIFICATIONS

LNS Certification in Copper and Optic Fiber Termination Maryland JAN 2013

Advance Technology Certification Maryland NOV 2013

CLOUD COMPUTING : AWS Certified Solutions Architect (SAA), Oracle Cloud Infrastructure (OCI)

DATABASE MANAGEMENT: SQL Fundamentals, Oracle Certified Associate, Oracle Certified Professional, Oracle Autonomous Database, Microsoft SQL Server 2012/ 2014

TECHINAL SKILLS

OPERATING SYSTEMS : Linux Redhat 7 Windows server 2016 2012.HP-UX 10.x 11.x. Sun Solaris 9 10. AIX RHEL

RDBMS :Oracle 11g 12c 18c 19c Microsoft Sql server 2015

LANGUAGES : SQL PL/SQL T-SQL HTML

TOOLS : TKPROF, STATSPACK, TOAD, SQL DEVELOPER, OEM 13C, AWR, ADDM, ASH, OEM,SQL PROFILER, EXP/IMP/DATA PUMP, DBCA, DBUA, ADDM, PUTTY, WINSCP, VNC, SQL SERVER MANAGEMENT STUDIO, OEM 12C

DATABASE UTILITIES : SQL*Plus Oracle Enterprise Manager Real Application Cluster ASM Transportable Tablespaces SQL*Loader RMAN DataPump Export Import

Contact this candidate