Oracle Data
Resume:
Anthony Ajebon
*****@*****.***
Database Administrator
SUMMARY
Over 15 + years of experience in Oracle DBA specializing in high availability database, AWS environments & solutions such as 19c, 12c, 11g, 10g Oracle RAC, Oracle Golden Gate Replication, Oracle Data guard, ASM, Veritas Cluster, RMAN, PL/SQL, Database Cloning, Cross-Platform Migration, RHEL, Oracle Linux, Centos, EDB PostgreSQL (9.x 11.x) database, Oracle VM, AWS Virtualization and Cloud Computing applications, shell scripting, Disaster Recovery, Tuning, AWR, ADDM and ASH reports.
Ability to guide, motivate and re-direct efforts to achieve a highly productive environment.
CERTIFICATIONS
Oracle Database 8, 8i, 9i, 10g, 11g & 12c Certified Professional
Oracle RAC 11g Release 2 & Grid Infrastructure Administration
Oracle Certified Cloud Infrastructure Architect Professional
AWS Certified Cloud Architect Associate
EDUCATION QUALIFICATION
Bachelor of Arts (Business Administration) Uni Cal, Nigeria 1985
MSc. Information Systems Technology University of Liverpool Online Laureate 2013
TECHNICAL SKILLS
Operating Systems : All Linux flavors (RHEL, OEL, CentOS) & Unix
Database : Oracle 8i,9i, 10g, 11g, 12c, 19c, PostgreSQL (9.x/11.x) database
Replication : Oracle 11g/12c Golden Gate
HA Cluster : Oracle Real Application Cluster (RAC), VMWare
AWS Services : EC2, VPC, RDS, S3, IAM, Cloud Watch,CloudTrail
Scripting Language : Unix shell Script/ SQL, PL/SQL, PL/pgSQL
Tools : Grid Control 12/13c (OEM), SQL Developer, SVN, Clear case,
AWR, ASH, ADDM, Toad, pgAdmin, Nagios, Kabana etc.
TRAININGS
Oracle 10g RAC Training. Oracle Corp, USA, 2009
Oracle 10g Backup & Recovery / RMAN Oracle Corporation, USA, 2007
Oracle 10g Standby Database / Data Guard Oracle Corporation, USA, 2008
PeopleSoft 8 Server Administration training Oracle / Peoplesoft University, USA 2004
Attended Oracle training on Oracle 10g to 11g migration.
PROFESSIONAL EXPERIENCE
USAC
Senior Oracle Consultant/Production Support (May 2015 – Present)
Member of GDBA 24x7 support team; monitored alerts and supported RAC, non-RAC, Data
Guard databases on Linux servers using Oracle OEM; analyzed, created solutions for
challenging performance-tuning situations; recovered databases; proactively patched and
upgraded databases to latest release; performed database change requests; worked closely
with Oracle support to debug issues & applied solution.
Provide support for various Oracle & PostgreSQL database projects within USAC. Maintained USAC’s high transactional financial Oracle 11g/12c RAC, Golden Gate and Data Guard databases, must be available 24x7. Support a mix of OLTP and data warehouse databases. Responsible for enterprise-wide database optimization, instance and resource monitoring.
Designed and implemented Oracle Disaster Recovery Solutions Data Guard and Golden Gate Technology. Setup multiple 11g/12c standby’s using Active Data Guard Technology (deployed Data Guard Broker-DGMGRL) for Single Instances and RAC Clusters. Enabled Fast-start Failover, performed DR drills (Failovers and Switchover/Switchback).
Responsible for Installation and setup of Oracle 12c/13c Cloud Control for monitoring of databases and Golden Gate environments. Apply Security vulnerability or interim patches (PSU/CPU) patches as they become available after rigorous testing in lower environments. Maintained database security and audited databases for security.
Worked on Implementing Disaster Recovery strategies for RDS Oracle databases and documented into confluence page.
Worked on AWS Oracle databases for App migration into private cloud. Worked on migrating Oracle databases to AWS RDS using utility AWS Database Migration Service (DMS).
Hands on experience Cross platform Migration of Oracle database from HP UX to Linux. Experience using use Oracle Golden Gate/RMAN endianness/DataPump for this migration.
Configured and managed uni & bi-directional Golden Gate environment for multiple databases, prepare and setup source and target for initial load, direct load and or data pump loads with flashback SCN and setup heartbeat for monitoring. Develop scripts to monitor replication lags, configure error handling, logging and status reporting.
MUNICIPAL SECURITY RULEMAKING BOARD
Snr. Oracle/Golden Gate DBA/Production Support (Jan 2013 – May 2015)
Led management and support of Oracle databases on multiple platforms and designed and implemented Production and Development databases. Managed
installation, maintenance, tuning, troubleshooting, backup and recovery of Oracle databases; assisted Linux systems administrator with aspects related to database
hosting; contacted vendors and recommended equipment purchases.
Lead the Migration project of upgrading all Oracle 11gR2 RAC & Single Instances to 12c Grid Infrastructure RAC database upgrade / migration projects.
Experience includes deploying & managing Oracle 12c /11g databases and RAC Grid clusters, all functioning in a 24x7x365 environment. Implemented, configured and managed Oracle 12cR2 RAC clusters as well as 11gR2 Grid Infrastructure Cluster ware / ASM.
Configured 12c Grid Control and agents to manage database environments. Configured services for load balancing and wrote call-out scripts to automatically relocate services to their preferred node in an event.
SQL tuning and Database optimization with ADDM, AWR, Toad & SQL*Plus scripts. Worked with using PX (parallel execution), TAF (app failover), and load balancing on RAC as well as exposure to Data Guard 11g/12c.
Designed & implemented Golden Gate 11g/12c integrated capture replication to remote sites (bi-directional & uni-directional) for reporting and disaster recovery, change data capture, platform migrations & load balancing.
Configured extracts, pumps and replicat utility. Added error handler to ignore unwanted or false transaction during the Replication. Added and excluded tables for replication and troubleshoot and fix abend issues with extract or replicat.
Implement filters and error handling/ conflict resolution. Tuned and optimized Golden Gate for network latency.
CAREFIRST BLUE CROSS BLUE SHIELD
Senior Oracle Database Systems Engineer/Production Support (Nov 2012 – Dec 2013)
Supported very large and complex 4 RAC node Operational Data Storage (ODS) and Enterprise Data Mart (EDM) databases. Worked with Java J2EE developers to
develop and formulate capacity planning for 11g databases.
Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions. Install setup and configured oracle enterprise manager cloud control 12c as a tool of administration, performance tuning, monitoring, alerts and also OEM grid control 11g/12c.
Troubleshooting errors using Cluster ware logs and patching 11g and 12c RAC environments involved in upgradation of databases from 11. 2. 0. 4 to 12c in QA and dev environments. Implemented ASM on RAC and standalone databases and managing disks and disk groups. Monitored and performed database sizing, transaction management and security administration data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump. Migrate Oracle 11g on Windows to Red Hat Linux using DataPump.
Experience in handling multi-terabyte database migrations/consolidations with minimum/no downtime. Experienced with all facets of oracle dba day-to-day activities like production, database monitoring, backup & recovery using RMAN, cloning, troubleshooting production issues, and physical database design.
Worked with the internal development team to provide the necessary SQL, PL/SQL and other database management scripts to enhance, tune, optimize and implement database related development activities.
Installed and supported 2-node 10gR2 and 11gR2 RAC databases, running on Red Hat Linux 6. Collaborated with managed service providers, internal development team, consultants and Oracle Support, to plan, optimize, and design database systems and its supporting applications.
Wrote several scripts (shell, SQL) associated with monitoring, database backups, tuning, and cloning. Deployed and implemented Oracle Grid Control (10g, 11g, and 12c) to monitor all databases. Improved code deployment techniques by enhancing shell and SQL scripts and processes.
CLEARWIRE CORPORATION
Snr Oracle Database Engineer/Mixed Dev/Production Support (Jul 2010 – Nov 2012)
Lead migration of large-scale database environment and mission critical large OLTP and OLAP systems to new data center. Implemented and supported all major
database technologies like RAC, Grid, Goldengate, Shareplex, RMAN, Flashback database etc. Supported mission critical databases ranging up to 20 TB in size.
Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure / Cluster ware, Oracle 12c two node RAC for the database tier.
Planning and implementing DR & high availability solutions using Oracle 11g /12c Standby Database using Data Guard.
Installing agent 12c on the server. Adding high Available database with CRS, scheduling Backups through OEM12c. Responsible for Build Work in various servers which has 3 Node RAC & Non – RAC, High Availability, Golden Gate Technologies.
Configured Data Guard Broker and used for switchover and stopping and Starting Media recovery process. Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases. Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
Applied database patches using opatch utility & building Clone instances for Development and Test teams. Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c. Implemented Data Guard with maximum availability and performance configurations for production databases.
Performance tuning of oracle databases using SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Advisor. Upgraded oracle 10g databases to oracle 11g R1 (11.1.0.6, 11.1.0.7) and 11g R2 (11.2.0.2). Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.
CHRISTUSHEALTH.ORG
Senior Enterprise Database Consultant//Production Support (Jan 2010 – Jun 2010)
Completed migration project support for Knonos, Identity Management, Content Management test and production databases on various Red hat Linux servers from
Clustered / RAC / ASM to non-RAC/ non-ASM / non-Clustered. This included documenting, testing, and implementing the process in production with limited
downtime.
Performed Oracle RAC/GI, ASM and database installation and deployment in over 30 environments; performed Oracle 10g/11g RAC/database patching and upgrades in over 100 occasions.
Performed Oracle database performance tuning on numerous company Crisis Management calls, working with dev team in quickly identifying the issue and implement root cause fix or workaround to minimize application down time
Designed and implemented database backup and recovery strategy for numerous CH database applications, utilizing Oracle RMAN and enterprise net backup. Successfully restored and recovered over 10 corrupted enterprise Oracle databases (due to hardware failure, incorrect user data manipulation or bad data loading) with zero data loss.
Implemented Oracle physical standby database infrastructure, including Data Guard as well as Golden Gate replication for numerous Oracle applications, providing another layer of stability and availability to customer, in additional to Oracle RAC
Wrote and implemented numerous shell scripts and SQL scripts to proactively monitor Oracle database health. The scripts will page or email the team, depending on severity, to alert for critical database events. This proactive monitoring helped the team to find out and correct database issues before they became visible to application and customers.
Attended requirements gathering sessions in new application design or migration projects. Recommended appropriate Oracle high availability and high stability configuration to customers based on their business needs and budget.
EXXONMOBIL CORPORATION
Senior Oracle Replication DBA (Aug 09 – Dec 09)
Oracle Database support for ExxonMobil Well Operations & Data Management applications used in well drilling, planning and engineering projects. Setup and
managed Oracle Streams Replication to support EMDRILL, EMWELL& WELLVIEW 8/9 apps.
Installed and configured Oracle 11g database on a test server using Oracle standard procedures and of, for performance testing and future 10g production implementation. Support multiple databases for production, development, test and staging purposes on Unix/Linux and windows environments.
Monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs in cron.
Applying upgrade patch, maintenance and interim (opatch) patches on all the databases. Refreshing dev and test instances with data from production on a regular basis.
Developed pl/SQL packages, dml, ddl, Oracle tables, stored procedures, functions, cursors, triggers, and UNIX shell scripts.
Developed PL/SQL error and drilling Apply Handlers for the Apply Process for Well View application Security. Configured complex capture and propagation processes and developed PL/SQL procedures to support BLOB, LONG RAW data types. Configured multiple apply processes for various critical risk and cost drilling assessment and performance analysis projects.
Troubleshoot errors with data mismatch between a row LCR and the table for which the LCR is applying changes. Configured several internal streams (capture, propagation, apply of schema in same databases) and external streams (capture, propagation and apply and different database) for various projects.
Developed Streams monitoring scripts to check status of apply, capture and propagation processes, checks for errors and display how LCR’s are currently being applied.
Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab. Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
OFFICE OF LAW ENFORCEMENT NOAA FISHERIES
Snr. Oracle Database Engineer (Feb 07 – Aug 08)
Support a five-terabyte data warehouse; play a lead role in enterprise-wide database optimization and instance and resource monitoring. Perform root cause analysis on failures. Resolve performance tuning related issues, reports, and queries. Work actively on new 10g features such as AWR, ADDM, and ASH, performance statistics collection, and fine tuning database wait events. Provide on-call support for enterprise databases.
Started and managed biweekly optimization meetings with enterprise user groups to address and resolve performance-related issues with a high degree of success.
Successfully set up a four-node cluster and RAC data warehouse on Linux (Oracle UBL) using ASM/ OCFS2.
Identified, led, and established automation of repetitive processes to minimize errors.
Completely eliminated space errors by implementing proactive space monitoring and effective space allocation.
Greatly improved performance in daily transforms by identifying and reorganizing indexes on major tables.
Configured schema level Streams Replication to capture and replicate data between NOAA HQ offices in Silver Spring and regional offices in Seattle. Setup STRMADMIN user, capture, apply queues, db-links and propagation processes. Instantiated objects using SCN flashback/export/import process.
USDA
Snr. Oracle Database Analyst III / AppSrvr Engineer (Jun 03 – Feb 06)
Complete Built of RAC from scratch on Red Hat Enterprise Linux. Experience in Data Center Migration. Experience in setting up and managing Oracle Data Guard.
Worked on 10g & 11g and 11g Grid Control. Experience in setting up ASM disk groups. Set up Materialize View Server. Worked with many
following 11g new features.
Configured disaster recovery databases using data guard and perform switchover & failover and monitor using data guard manager command line.
Configured physical standby for production databases and converted physical standby to snapshot standby and active data-guard.
Creation, configuration and support of oracle database of various sizes in dev, test, prod model and production environments.
Support, maintenance, installed and configured 2 node server-side load balancing oracle RAC 10g, 11g databases on Linux with OCFS.
Proactive monitoring of production databases to find out potential issues that can cause high severity issues and outages.
Performance tuning and troubleshooting of the databases and SQL behaving differently on different environments.
Provided day to day upkeep of Oracle 9i, 10g databases and 10g Application Servers versions (9.0.4.0, 9.0.4.2/3, 10gAS R1,R2). Provided Oracle database administration support and resolve database and Application Server related issues in production environments. Integration of Oracle Application Server 10g components like Single Sign-On/Portal/Discoverer/ Oracle Internet Directory (OID) with Oracle Applications 11.5.10.
USINTERNETWORKING INC
Database Engineer (Oct 02 – Jun 03)
Set up new Oracle 9i/10g databases and provided all database-related support for the production as well as test databases for different ASP ERP markets. Performed space estimation and calculation, application installation, performance /memory tuning, server/ database monitoring, configuration, and troubleshooting. Provided design input and interacted with the design team on the best database practices. Evaluated server/ instance architecture, hardware, system specifications, and capacity planning. Managed, trained, and mentored staff.
Used Explain Plan and Oracle optimizer hints to enhance performance of SQL statements. Performed the user requirements and troubleshooting activities and resolved connectivity issues. Implemented, administrated, and maintained daily backup and archived data on tape. Created user accounts and system-level and user-level database objects.
Formulated recommendations about optimal storage configurations for senior management.
Identified and reduced/eliminated non-idle wait events such as scattered file read, sequential file read wait event, log file completion, in queue, and buffer latch waits.
Provided design input and interacted with the design team on the best database practices. Evaluated server/ instance architecture, hardware, system specifications, and capacity planning. Managed, trained, and mentored staff.
Contact this candidate