Charles Osilesi

***** ****** **** ** **********, MD, 20705

adi338@r.postjobfree.com Phone Number: 240-***-****

Objective:

Seeking Oracle Cloud Engineer position where Hybrid Infrastructure builds, Cloud Platform Operations (Ops), Core admin skills, Programming, Performance Tuning, Securing Data, and Automation experience can be applied.

EXPERIENCE Summary

Over 15+ years of IT experience as a Lead Senior Engineer, Senior Database Administration(DBA), Database Developer, SysOps, Cloud Engineer supporting internal databases and Global customer databases both On-Premise Data Centers and Cloud Based Environments

Strong Database Performance engineering experience improving query join methods, access paths, join ordering, cardinality, efficient join operators, Optimizer internal components, predicate selectivity, statistics, hints and SQL execution model

Data Lifecycle understanding from collection, ingestion, normalization, processing, securing, data recovery concepts, visualization and archiving per compliance retention requirements

Extensive Hands-On experience on Installing, Configuring, Troubleshooting and Maintaining Oracle RAC databases for Application continuity and failover capability to Clustered Standby

Supported Enterprise Application Systems with 300+ databases involving collaboration with Management(PMO), Developers from Project planning, requirements gathering, identify timeline, implementation phase to End-User Acceptance

Applied Agile, Waterfall, and Hybrid methodologies for efficient database released changes

Led Data Migration and Data conversion Projects involving Terabytes(TB) of Data from On-Premise DataCenter into AWS Cloud, OCI Cloud, and Virtualized (VMWare) Infrastructures Streamlined Database Sub-subsystems and Site Reliability using Cluster Groups i.e. RAC, Data Replication Processes, Capacity Planning, High Availability and System Health Monitoring

Acquired Information Security expertise working with ISSO on hardening Data Stores under Federal(DoD), Federal Civilian, Intelligence Community(IC) and National Security Compliance Standards i.e. DISA STIGS, and environment security readiness reviews for ATO.

Results-Driven with skills in team building, problem-solving, effectively working with diverse groups, adaptable to technology refresh using ITIL standards i.e. change control management

Education:

Bachelors, in Computer Science at the University of Maryland, College Park

Oracle Certified Professional (OCP)

AWS Certified Solutions Architect

Microsoft Certified Solutions Associate (MSCA)

Oracle MySQL Certified

Security+

Work Clearance

Active Public Trust Clearance

Completed Final Interview for Secret Clearance

US Citizen

Work Experience:

Verizon – Ashburn, VA Lead Oracle Database Cloud Engineer, July 2019 - Present

Managed and led database migrations to Oracle Cloud Infrastructure (OCI) for consolidation, containerization, traditional data center exits, operations performance gain and shared tenancy model. Stabilized multiple Production Operations Applications in Verizon Business Group (VBG) with Global data stores i.e. Global Customer Hierarchy, Optix Repair iCAD Systems, COGNOS Content engine backend databases post cutover into Cloud Based Platforms.

Technical Summary: Oracle Cloud Infrastructure(OCI), Oracle 11g/12c/19c/20c, OCI SwiftObject Storage(OSS), Oracle GoldenGate 11/12C/19C, Oracle DataGuard(DG), Oracle DG Broker, Oracle GRID, Oracle RAC(4 Node), Oracle OSB, Oracle Restart(HAS), Oracle ASM, Oracle TDE, Oracle DB Vault, JIRA, Confluence, Toad for Oracle, SQL Developer, Oracle Goldengate(GG) 11g/12c/19c, Slack, Jabber, Bluejeans, EXADATA Cloud Service (ExaCS), DBaasCLI, PowerBroker, Oracle Enterprise Manager(OEM) 13c, Bastion Host, Putty

Work Description:

In-depth Knowledge on OCI components and services i.e. Cloud Shell, Cloud Guard, VCN, Security List, NSG(Security Groups), VCN Peering(local/remote), Cloud Guard, Route Table etc.

Developed Migration Plan and BackOut Plan for On Premises databases migration into Oracle Cloud(OCI) using shared tenancy for consolidation, cost effectiveness and data center exits.

Created scripts to monitor and identify Application code points, irregular Bulk Loads, and job scheduling impacting DB runtimes and file deliverables

Identified Problem SQLs causing contention and hogging database resources i.e. TEMP/UNDO impacting concurrent OLTP upstream processes i.e. SOLR, Cognos Content, IBM DataStage etc

Aligned Verizon Security Policies with Cloud migrations strategies i.e. TDE, DB Vault, and SSL, ensuring customer data is monitored for encryption in OCI, and during post migration GO LIVE

Worked with Key stakeholders i.e. App data owners, PMO, of mission critical systems to ensure performance and regression tests where Optimal for new migrated databases in OCI with acceptable Application response times and Job completion times

Re-configured GoldenGate(GG) processes in OCI with requirement to convert Classic to Integrated GG processes for both bi-directional and uni-directional replication

Co-ordinate with OCI Vendor on planned downtimes for hardware replacements, re-imaging of EXADATA binaries post patching, network changes and additional disk sizing for growth

Provided documentation to team members on scripting and configuring OSS Cloud Backups for OCI Clustered Databases

Migrated Oracle GoldenGate bi-replications processes from OnPremise into OCI with NO DATA LOSS

Utilized DataGuard Broker for seamless Databases cutover from OnPremise to OCI with minimal downtime and prompt turnover to Application services

Supported external data sources using SSIS and ETL for digesting data with optimal configurations

Upgraded databases to 19c in OCI Cloud post migration to retain supported and compliant database versions following ExaCS guidelines to ensure proper DB registration with API

Upgraded databases to 19c via Oracle GoldenGate(OGG) methodology that handles target sequence numbering order, data types, table key conflict etc. allowing App to determine 19c performance via split NLB App traffic before cutover to 19c database

Upgraded and Patch OEM component i.e. OMS, WebLogic etc. to maintain compliant versions and resolve SSO bug fixes

Created Object Storage Buckets(OSS) per database via OCI Console and scripted SBT channels for multiple databases running on EXADATA compute shape types

Capacity planning for DATA, RECO and SPARSE Diskgroups with efficient percent allocations during provisioning of EXA Compute Shapes for hosting multiple migrated databases into cloud

Implemented Federated SSO integration into Oracle Cloud Console access and IAM Policies for OCI Tenant resource controls

Reviewed POC of 20c PDB/CDB provisioning requirements in OCI and Non-PDB conversions

Work Experience:

SAP – Herndon, VA Senior Engineer, May 2015 – July 2019

Worked on multiple Database Projects for DoD, Federal Civilian and IC tenants in FedRAMP certified environment i.e. Human Capital Management (HCM) SaaS deployments, Enterprise Business Suite (EBS) components with Infrastructure teams to meet requirements on moving On-Premise Global Client data(150+ DBs) into Secure Cloud Based Environments. Lead Data Engineer on Data Transform, Data Migration, Data Conversion, Multi-Source Data Integration project while ensuring external business modules and agent jobs i.e. HR Interfaces, Analytics, and User Reporting were functional.

Technical Summary: AWS, Oracle 11g/12c, Oracle GoldenGate 11/12, Oracle DataGuard(DG), Oracle DG Broker, Oracle GRID, Oracle RAC(2 Node), Oracle RAC one, Oracle OSB, Oracle Restart(HAS), Oracle ASM, Oracle TDE, MySQL, Ansible, Red Hat Enterprise Linux(RHEL) 6, RHEL 7, Windows Server 2008, Window Server 2012, VMware, Toad for Oracle, SQL Developer, SQL Loader, Solarwinds, Centrify, Splunk, Zabbix, SiteScope, GitHub, JIRA, Confluence, Solman, SAP HANA 11/12, Nessus Scanner, Symantec PGP, Vormetric, Tomcat, Kerberos SSO, Python, SQL Server 2012, SSMS, SQL Server Profiler, OPENVPN, Google MFA

Work Description:

Enhance database performance using Advisors and Execution Plan management features

Hand-On experience in Table Modeling, Index Design, SQL Optimization, isolate bottlenecks in high concurrent Applications and standardize Security Controls across OLTP, OLAP Databases

Optimized Application workloads in Terabyte(TB) databases using Plan Management techniques i.e. SPM, Profiles, Outline, Hints, Object restructuring and query rewrites

Expert Infrastructure knowledge on Storage, Network, Backup, Security and Application integration with Enterprise mission-critical Oracle databases On-Premise and Public Cloud

Utilized Oracle 12c Multi-Tenancy(PDB/CDB) for efficient system resource usage, minimal downtime and fast provisioning of Oracle databases

Utilized 12c Data Recovery Advisor to repair database failures with available backup sets

Configured 12c Far Sync dataguard transport mode for distant networked target standbys

Programmed synchronizing intermediate tables from customer data feeds and automated scheduled data extracts / PII data(PGP encrypted) into SFTP sites for DoD agencies e.g. DISA

Hands on experience on Oracle Dataguard Log shipping in async and sync mode, Oracle Broker automatic failover(FSFO) via Observer process and offloading jobs to standby site

Hands On experience using GoldenGate replication for cross platform replication i.e. Linux to Windows, Solaris to Linux platforms with near zero downtime

Replicated from Oracle 11g database to SQL Server 2012 database, integrated with workforce analytics Application module

Revamped Traditional Data Backup Strategy from Disk / Volume Storage to AWS S3 Storage via automation for efficiency, enhanced cloud capability and cost sustainment

Installed Multi Master GoldenGate(GG) Replication processes using initial load to sync source and target, tuned GG parameters i.e. memory, pump network, table grouping to prevent replication lags and ensure Goldengate process uptime

Expert level troubleshooting of GoldenGate replication lags using LogDump and Process logs

Configured secure GoldenGate(GG) replication using encryption schemes on trail files and Wallets to protect credentials accessing Oracle and Non-Oracle databases

Utilized GoldenGate in an Oracle HA builds with Pump process configured to handle continuous replication across Node failures and dataguard node failovers with reset logs

Configured conflict resolution methods in GoldenGate Replication using Delta resolution methods to avoid transaction loss and data inconsistency in ACTIVE-ACTIVE data stores

Developed Contingency Plan(CP) for Production environments, implemented and performed Bi-Annual Disaster Recovery tests in coordination with multiple technical / functional teams

Scripted secure download from vendor pipelines and uploaded processed, extracted customer data into external SFTP service accounts

Enhanced Operations Security posture via remediating SSLv3 and TLS 1.0/1.1 vulnerability findings in our PaaS components using complaint ciphers and configurable parameters.

Ingested Oracle database audit logs, alert logs, trace files, cluster logs and syslog for monitoring availability, critical issues / errors, and Application failures with Splunk consultant.

Hands On Knowledge on Python Concepts and Object oriented programming(OOP) such as callables, memory referencing, garbage collection, object immutability, interning, annotations, named tuples, importing modules, package types, namespace types

Mentored and trained new Engineer team members on Environment setup and processes

FINRA – Gaithersburg, MD, Senior Data Engineer/ Business Process Support, Jan 2012 – May 2015

Worked with 8 member Engineering Team supporting 300+ databases and 4 Node RAC enterprise-wide tasked to secure and provide 24/7 data access for SEC regulated Financials Market and Securities Applications such as WebCRD, AppWorks, and EWS account admin, with 100,000+ end-users i.e. member firm users. Database sizes ranged from 1TB – 500TB with data replication via SRDF

Technical Summary: AWS, Oracle 11g/12c, Oracle ASM, Oracle Internet Directory(OID), Oracle Enterprise Manager (OEM), Oracle WebLogic, Oracle RAC, Oracle Big Data Connectors(OLH), Oracle XAG, Oracle Gateway, Oracle HTTP Server(OHS), SRDF, Symantec NetBackup, IronMountain (Tapes), Veritas Clusters, BindView, Windows Server 2008 R2, Windows Server 2012 R2, Solaris, Perl, RedHat Enterprise Linux(RHEL), Oracle EXADATA, Oracle Linux(OEL), Toad for Oracle, EMC Data Domain, ITILv3, BMC Remedy, SQL Server 2012/2014, SQL Server Management Studio(SSMS), SSIS, SSDT, SSRS

Work Description:

Introduced XAG managed resources for high availability of replication processes via Oracle RAC Cluster methods

Collected history data for reports on traded securities changes using triggers and GoldenGate replication parameters i.e. INSERTALLRECORDS

Configured GoldenGate database replication into JMS Targets for message queue distribution

Integrated GoldenGate Plugin into OEM for monitoring replication processes in real time

Built Centralized Monitoring Tools i.e. Oracle Enterprise Manager with WebLogic middleware for database availability and notification of planned and unplanned maintenance

Developed PL/SQL code i.e. stored procedures, user defined functions, database triggers, views, materialized views, temporary tables, user defined types, cursors, loops, inline-tables, query transaction hints, distributed transactions(DTC), at an Enterprise scale

Partitioned Large Tables and configured In-Memory Tables in Oracle databases for faster summary data access and aggregations in Application modules

Installed OEM 12c Cloud Control and switched 11g agents via Upgrade Console patch in OMS

Scripted bulk updates of new targets in OEM via EMCLI providing for up-to-date inventory tracking reports

Configured Metric Thresholds in OEM for alert monitoring and installed custom target plugins

Integrated OEM Monitoring with Directory services(AD) for enterprise single sign-on(SSO)

Built Oracle Internet Directory(OID) for centralized LDAP resolution of databases, allowing ease of data access for Enterprise Applications and Client-Side i.e. developers and analysts.

Configured OMS pair for HA and load balancing web traffic access to OEM Web console

STIGed software binaries and databases, applied routine security patches, and enforced user identity lifecycle to meet Federal compliance requirements

Migrated Windows 2008 R2 server hosted databases to new Windows 2012 R2 Servers and upgraded databases when required for Application compatibility

Created SSIS data flow systems for capturing error in flat file destination and sending the errors to required recipients via Send Mail task for correction

Performed Oracle database cross-platform migration (Solaris to Linux) with endian conversion

Configured Oracle Gateway for linking and extracting data between Heterogeneous databases

Utilized BCV clones on backup server after resync and mirror split and worked with Backup Team on restoring the requested date of BCV set for fast recovery of large data sizes(200+ TB)

Data Domain setups with NetBackup Team for database backup policies and scheduling based on finance trade data retention requirements

Implemented year-end trade data maintenance activities in 11g databases e.g. purging partitions, archiving historical tables used for Application report modules

Heavily Contributed to Continuous Integration (CI) / Continuous Delivery (CD) of Enterprise pipeline processes via automating database deployments, daily data refresh automation into lower environments, and automated server patch cycles via Bash, Korn, Perl, Python etc.

Scheduled DBAs for On Call and participated in On-Call rotation during Off-Business hours

Client Network Services Inc. (Rockville, MD) Senior DBA, August 2006 – December 2011

Worked in Health IT Engineering Team supporting Medicaid Management Information Services (MMIS) Production Database environments interfaced with robust Java Applications. Data feeds i.e. EMR, EHR, Provider Claims from external sources were adjudicated and processed daily. Completed the Transfer Agency project which involved migration/re-hosting of client data sources using HL7 exchange standards

Technical Summary: Oracle 10g/11g, Oracle ASM, Oracle RAC, Oracle DataGuard, Toad, Sun Solaris, Oracle Client, SQL Developer, RMAN, IBM ClearCase, ClearQuest, IBM Websphere, Perl, Excel Macros

Work Description:

Developed PL/SQL programs for adjudicating claims, EHR record updates, and built OS scripts for auto-deploy of data, structure, packages, stored procedures change requests to aid efficient batch deployment refreshed locally from ClearCase version control system

Built Oracle RAC clusters with Infrastructure teams and utilized Cluvfy / cluster-aware tools to validate cluster integrity after configuration.

Documented baseline and procedures for new software releases based on infrastructure requirements so that all upgraded or new databases follow the same system and parameter configurations standard enterprise-wide

Supported Application Upgrades using Flashback Technology and remediated data corruption and partial upgrades from restore points

Created Clusterware Services for load balancing workload on preferred nodes and improving database performance. TAF services were setup to enhance Application failover capabilities

Converted single instance to 2 Node Cluster with a corresponding Physical Standby site

Enhance database performance using Advisors and Execution Plan management features

Migrated 10g databases(50+) from old data center to new data center as 11g databases using various data transfer methods with space, downtime, and data size taken into consideration

Upgraded 10g RAC Clusters using Private Bonded NICs to 11g Clusters HAIP interconnect

Applied Patches(One-Off/Quarterly) in Rolling Fashion in RAC environment for bug fixes and critical updates

Cloned Active/Offline production databases into lower environments i.e. Stage

Data comparison at schema level using TOAD and dynamic generated scripts on-demand.

Converted Logical data models into physical structures in OLTP and OLAP databases

LeggMason Inc. (Owings Mills, MD) Database Management / Developer May 2005 – August 2006

Joined 7 members Database Team supporting Financial / Brokerage Systems i.e. ASP/Forms based applications, generating Financial Reports for end-users, Job chain scheduling, and Tier 1 Break Fix.

Technical Summary: Oracle 10g, OEM 10g Grid Control, OAS 10g, Autosys Scheduler, AdDer, ERWin, AIX, Perl, Client tools(ODBC,OLE DB Provider/DSN), Oracle SQL Loader, Windows Server 2008

Awards and Honors

Certification in Computer Science for academic credibility

SAP Human Capital Management (HCM) Honor Role

Possess great interpersonal and communication skills with self learning ability e.g. databases, analytic

References: Available upon request.

Contact this candidate