Data Oracle
Resume:
Daniel Okoronta
Atlanta, GA * **************@*****.*** *205-***-**** Alt *678-***-****
Career objective
I have 9+ years of extensive Oracle database and with ICT experience with good knowledge of metadata management, data modeling, and relational database management tools. Would like to be part of a challenging team environment where my technical skills and analytical abilities can be used towards achieving the objectives and goals of your organization.
Summary
•Good knowledge on writing, modifying, troubleshooting and enhancing complex Unix shell scripts and Oracle PL/SQL.
•Expert in evaluating why certain QEP’s are chosen and deep knowledge of optimizing the sql that makes up those QEP’s.
•Ability to do deep performance analysis on Exadata’s/Oracle’s CPU, Memory, storage and I/O with regards to how our app (GEO) uses the db and recommend sizing(to db or our app) to optimize performance in all 3 releases as stated in item 1.
•Ability to look at codes, with designers help, and identify areas that should be changed to optimize performance.
•Great Knowledge of all Exadata/Oracle parameters, including underscore parameters, and how they are set to optimize performance.
•Generating ‘debug’ traces of the Oracle system as requested by Oracle support or for their own diagnosis.
•Experience using OEM for performance tuning in 12c and managed database using OEM on 11g and 12c.
•Provided system capabilities, subject matter expertise, and data services necessary to enable life-cycle management processes for industrial products data and responsible for designing and migrating of existing TOAD database to a multitenant fault tolerant architecture spanning multiple servers. High level of autonomy in the architecture of a complex fault tolerant collection of multitenant databases that form the backbone of an enterprise solution.
•Involved in implementation of high availability solutions with 9i, 10g, 11g and 12c RAC, disaster recovery infrastructure (Physical and Logical Standby) using Oracle Active Data Guard, Materialized views, Golden Gate.
•Developing and expansion of existing Data Architecture.
•Experience with setup and administration of Oracle Database Security environment using Profiles, database Privileges and Roles.
•Experience in writing, debugging, maintaining and tuning Transaction SQL, and stored procedures.
•Evaluating why certain QEP’s are chosen and deep knowledge of optimizing the sql that makes up those QEP’s
•Experience in deep performance analysis on Exadata’s/Oracle’s CPU, Memory, storage and I/O with regards to apps (GEO) using db and recommending sizing(to db or GEO) to optimize performance in all 3 releases as stated in item 1
•Troubleshooting areas for possible bugs or knowledge of known bugs in Exadata and work with Oracle Support / Designing to have those fixed and applied within 30 days to Exadata from the time the issue is acknowledged by Oracle as a bug
•Looking at codes, with designers help, and identifying areas that needs to be changed to optimize performance
•Good understanding of all Exadata/Oracle parameters, including underscore parameters, and how they are set to optimize performance
•Ability to communicate all items (1-6) directly with a Customer with technical depth but simplified so customers can understand
•Ability to interrupt alert logs and the error messages generated by the Oracle systems
•Familiar with Linux operating system and shell scripting skills.
•Configured Goldengate Integrated components for Active-Active as well as Active passive replication. Monitored database functions such as backup, Object, Performance, User and Session monitoring to ensure proper Availability as well as capacity.
•Extensive knowledge on database backup/recovery strategy (RMAN, Export/Import &Datapump), Capacity Planning, Replication (Streams) standby databases, Oracle configuration management, Database Cloning, Refresh, and patch management.
•Knowledge of data flow diagrams, data dictionary techniques, CASE tools, Entity-relation modeling and design techniques.
•Good Understanding of disk hardware architecture, database design, cache controllers, and disk load balancing for UNIX and Windows Operating Systems.
•Replicating to a disaster recovery site for increased server manageability and availability using Oracle Golden Gate.
Areas of Expertise
•High Availability Solutions (9)
•Oracle Installation and Configuration(9)
•Disaster Recovery(9)
•Performance Tuning(9)
•Data Migration(6)
•Backup and Recovery (9)
•Database Security
•PL/SQL(6)
•Exadata and Golden Gate(5)
•Delphix
•Azure(4)
•PL/SQL(6)
•Data Modeler(8)
•Replication, log Shipping and Mirroring
•Installing and Managing Clustered Nodes(7)
•Database Upgrade Patches (9)
•Integration and reporting Services
•Analytical and Leadership Skills
•Agile Software Development
•Waterfall Methodology
Technical Skills:
Operating System: Red Hat Linux, Windows 2003/2008 Server, VMware Server
Languages: SQL, PL/SQL, UNIX Shell Script, HTML
Database: Oracle RDBMS 10g, 11gR2 and 12c
Tools/ Software: TOAD, SQL Developer, SQL*Plus, SQL*Loader, Oracle Enterprise Manager (OEM), DBCA, Data Pump, RMAN, SFTP, Telnet, TCP/IP, Secure CRT, putty, ADRCI, Oracle Scheduler, Unix Shell Scripting, Microsoft Word, Excel, and Power Point, Photoshop, EPIC - Medical Records Management Software
Professional Experience:
Pacific Group - Atlanta, GA Jan 2018 – present
Sr. Oracle Database Administrator
•Performance Tuning in terms of system architecture, scalability, understanding symptoms and problems and knowing when to tune actionable events solutions.
•Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
•Designing preparation and operational support escalations for small to medium tasks of medium to high level of complexity.
•Evaluating why certain QEP’s are chosen and deep knowledge of optimizing the sql that makes up those QEP’s
•Preparing Production Readiness documentation for implementations of low to medium level of complexity.
•Experience in deep performance analysis on Exadata’s/Oracle’s CPU, Memory, storage and I/O with regards to apps (GEO) using db and recommending sizing(to db or GEO) to optimize performance in all 3 releases as stated in item 1
•Implemented classic Golden gate replication as well as integrated replication.
•Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
•Reporting status to Project management and interfaces with other domains, IT areas and 3rd party vendors as needed.
•Recovered databases from corrupted/lost datafiles in real time on production systems.
•Configure Golden Gate downstream mining and Integrated Component for active passive and active replication.
•Coordinated projects requiring database including, but not limited to: coding, testing, and implementation of physical database applications.
•Managed and allocated database storage reviewing existing and future storage requirements, calculating database parameters, and determining the most effective use of space and memory.
•Implementing backup schema through RMAN.
•Participated in Solution Development process definitions and development of Solution Development best practices and standards.
•Performance tuning of SQL's and procedures. This involved using trace dumps, TKPROF, Stats pack, Net Trace and also used specific Oracle performance parameters on a selected basis.
•Installation, configuration and administration of Oracle RAC on Development boxes in 11G/12C.
•Configured ASM on Windows on development boxes and recommended implementation on Production sites as a High Availability feature.
•Implemented Data Guard on Production with Disaster-Recovery and Standby database modes.
•Writing shell scripts for hot backup and setting up crone jobs to automate backup procedures, cleaning up archives.
•Implemented audit features to locate culprit processes and unauthorized logins.
•Setting up and maintaining Golden Gate on 10g, 11g, and databases.
•Developed conceptual, logical, and physical data modeling.
•Developed procedures to enhance reporting and query capabilities to improve efficiency and accuracy.
•Maintained a state-of-the-art knowledge of existing best practices in database administration.
•Automating tasks using cron for Oracle GoldenGate restart.
•Using Oracle Virtual Private Database Security Policies work with Applications, using Automatic Reparsing for fine-grained Access control policy functions.
•Configured lag using Oracle GoldenGate script and automated the process to email the user every hour in a high volume multi master replication environment.
•Monitoring Alert Log for any and all issues to the database.
•Configured Goldengate High Availability using Oracle DBFS and Active Data guard.
•Configured Goldengate Integrated components for Active-Active as well as Active passive replication. Monitored database functions such as backup, Object, Performance, User and Session monitoring to ensure proper Availability as well as capacity.
SunTrust Bank – Texas County Dec 2013 – Nov 2017
Oracle Database Administration
•Managed various database structures: Table spaces, data files, control files, redo log and archive log files using OEM, GUI tools and command-line
•Involved in 24/7 support for both production and development databases including 2-node production RAC database.
•Implementation of high availability solutions with 9i, 10g, 11g and 12c RAC, disaster recovery infrastructure (Physical and Logical Standby) using Oracle Active Data Guard, Materialized views, Golden Gate. The projects involve replication across geographical time zones.
•Install, upgrade and patch Oracle databases in PROD to TEST and DEV environments
•Managed database using OEM on 11g and 12c
•Communicating database design strategies to technical staff, defining database descriptions and managing changes to the database management system including staff meetings.
•Experienced configuring and deploying Oracle ASM storage.
•Configured and implemented Oracle Goldengate replication.
•Troubleshooting areas for possible bugs or knowledge of known bugs in Exadata and work with Oracle Support / Designing to have those fixed and applied within 30 days to Exadata from the time the issue is acknowledged by Oracle as a bug
•Looking at codes, with designers help, and identifying areas that needs to be changed to optimize performance
•Resolved the issues in conflict with the target and source database in Goldengate.
•Experience using OEM for performance tuning in 12c
•Diagnosed and resolved performance issues associated with SQL tuning and resource contention including locks and deadlocks.
•Implemented transparent data Encryption (TDE). Used TDE with Encrypted columns and Data Pump.
•Designed a high-performing database by creating multiplex control files, mirroring redo logs using redo log groups and configuring table spaces
•Perform hot, cold backups and setup/utilize RMAN for backup and recovery
•Created user accounts and granted them appropriate roles and disk quotas for production usage
•Managed various users’ sessions both in UNIX and WINDOWS environments.
•Planned, tested and performed Database backup and recovery plan and upgrade from Oracle Database 11.2.0.4 to 12.1.0.2
•Setup jobs; create packages, triggers, functions and notification alerts
•Perform daily administration task including managing system security, data integrity, monitoring and deployment of objects in production
•Experienced in using database features such as Data pump, Flash-Back, AWR, ADDM, ASM
•Installed Oracle Software/Grid Infrastructure on UNIX and Windows platforms
•Patch oracle databases with the latest Patch Security Updates (PSUs).
•Experienced in Partitioning as well as creating Global, Local indexes on Partitioned Tables.
•Experience Administering Oracle Database using PL/SQL Developer as well as OEM.
•Very experienced with High Availability Environments.
•Creating duplicate databases for RAT Testing and moving databases from EXADATA to RAC environments.
•Involved in the complete SDLC, Database design, System analysis, design and developments.
•Successfully implemented physical standby database using Oracle Data Guard feature for High availability configurations.
Home Depot- North Carolina May 2010 – Oct 2013
Oracle Database administrator
•Troubleshoot and resolve complex issue for all supported services non-hosted environment.
•Planned and executed both data and data migration.
•Created tickets, prioritized and escalated issues using Remedy Connector based on SLAs.
•Reading Alert Log and User trace Files and Diagnosing the Problem
•Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis
•Provided first and second level software and hardware support to end-users and at client sites
•Good understanding of all Exadata/Oracle parameters, including underscore parameters, and how they are set to optimize performance.
•Designed and implemented migration of large database to multitenant instances spanning multiple servers.
•Reviewed specified database design and integration of systems, including backup and recovery solution and making.
•Maintained security and integrity controls of databases built.
•Ability to communicate all items (1-6) directly with a Customer with technical depth but simplified so customers can understand
•Ability to interrupt alert logs and the error messages generated by the Oracle systems
•Running complex queries to retrieve data from multiple tables within Oracle ensuring fast and secure access to business application.
•Automated DBA task utilizing SQL and UNIX shell
•Managed storage requirement for database-related components – capacity planning
•Installed/re-installed Windows and Linux Server
•Participated and supported Oracle Server installations both upgrades and standalone installations.
•Disaster recovery implementation using physical standby databases for high availability.
•Monitored the Performance of the migrated databases using grid Control and features AWR, ADDM, ASH and generated the reports for metric collection and health check of the databases.
•Implemented Oracle Database 11g/12c 2 to 4 node Real Application Cluster (RAC) using Oracle Cluster ware for achieving high Availability on ASM.
•Maintained production database and development database which includes tablespace management, user creation, and privileges, roles. Support RMAN backup and recovery including physical backups and logical backups by using data pump (Export/Import) tools.
•Performed tuning and optimization of Oracle applications and databases (DB cache, Library catch, Dictionary catch) AWR reports, SQL Trace, explain Plan. Identify problems and implement solutions; ensure the database is running at optimum speed and efficiency.
•Installed new / rebuild existing servers and configure hardware, peripherals, services, settings, directories, storage, etc. in accordance with standards and project/operational requirements.
•Applied OS patches and upgrades on a regular basis and upgrade administrative tools and utilities. Configure / add new services as necessary.
•Perform daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups.
•Configuring the Oracle Network environment including Oracle Net Services and Listeners, configuring and managing oracle network.
•Cloning as well as replication of production environment for testing purposes.
•Automating tasks using cron for Oracle GoldenGate restart.
Lowes –Mechlenburg, NC Nov 2008 - May 2010
Administrative Assistance
•Troubleshoot and resolve complex issue for all supported services non-hosted environment.
•Planned and executed both data and data migration.
•Handling office tasks, such as filing, generating reports and presentations, setting up for meetings, and reordering supplies.
•Providing real-time scheduling support by booking appointments and preventing conflicts.
•Screening phone calls and routing callers to the appropriate party.
•Using computers to generate reports, transcribe minutes from meetings, create presentations, and conduct research.
•Maintained polite and professional communication via phone, e-mail, and mail.
•Ensuring operation of equipment by completing preventive maintenance requirements, calling for repairs, maintaining equipment inventories and evaluating new equipment and techniques.
•Providing information by answering questions and requests.
•Maintaining supplies inventory by checking stock to determine inventory level, anticipating needed supplies, placing and expediting orders for supplies.
•Contributes to team effort by accomplishing related results as needed.
•Type correspondence and reports; edit and update various spreadsheets.
•Served as point person for organizing all large mailings.
EDUCATION &CERTIFICATIONS
University Of Nigeria Nsukka (Alvan Campus)
ORACLE / OCI Certified Professioal/ OCI foundations/OCI Certified Associate/OCICertified Specialist/OCI Certified Architect Associate
REFERENCE
Available upon Request
Contact this candidate