Charles Yinka

Phone: 470-***-****

Email: adjsyq@r.postjobfree.com

Database Administrator with more than 11 years experience implementing new technologies and supporting operations on numerous Oracle databases while working closely with internal clients, systems programmers, and application developers to define and resolve information flow and content issues; helping to transform business requirements into environment specific databases.

I am interested working in a dynamic and complex technical environment.

Areas of Expertise include:

GoldenGate

Linux

Patching

Data Guard

Oracle ASM Administration

AWS

RMAN

Storage

APEX

Performance Tunning and capacity Monitoring

Agile Methodology

Migration

VPD

Exadata

Advance Data Security, BackUp and Recovery

Postgres SQL(3)

Azure Devops

Data Warehouse

Oracle RAC Administration

Scripting

Ansible

Technical Skills Set

Database:

Oracle Database 10g, 11g, 12c,18c and 19c Postgres 9.3.25 MySql SQL Server

Operating system:

Unix/Linux Centos Fendora

Languages:

PL/SQL, JAVA, SQL, Visual Basic, C++, Python, Perl

Storage/Software Apps and Tools:

SQL Plus,PL/ SQL Developer, Apex, Toad, Rapid SQL, DBCA, DBUA, WInSCP, Putty, Oracle Data Guard, RMan, Data Modeler, Jira, Secure CRT, Statspack, AWR, OEM/Grid Control, Data Pump, ASM, VCS, Solarwind.

Data Replication:

Oracle GoldenGate 11gR2/12c

MiddleWare:

Oracle Grid Control, Veridata, Weblogic

Core Competencies

Demonstrated advanced skills in Oracle utilities AWR, ASH, ADDM and OSWatcher; strong knowledge of OEM management and administration; proficient in problem diagnosis, shell scripting, performance monitoring and tuning and database backup and recovery.

Developing and administering the DCPS database architecture.

Hands-on experience with Continuous Integration Deployment pipelines and Database Schema as Code tools and approaches.

Working closely with senior leadership, clients, systems programmers, and development staff to define and resolve information flow and content issues.

Working on multiple projects as an Oracle Architect/DBA or SME in database technology.

Configured, administered and implemented complex database infrastructures, multiple replication technologies, multi-directional flows and other high availability architectural topologies. Must have strong SME experience in both Golden Gate and Exadata (CS/CC) systems.

5+ years PostgreSQL 11 and 12 pgAdmin 4.8 - 3+ years Strong SQL for database query and data updates in Production Analyze database changes requested by the Agile development teams for impacts to database designs, naming standards, design standards, data conversions, and documentation.

Good understanding of analytical and troubleshooting skills for complex database performance issues using AWR/ASH/ADDM/TKPROF/SQLT/10046 tracing/OSWatcher/CHM etc.

Replicating to a disaster recovery site for increased server manageability and availability using Oracle GoldenGate.

Configured confidential for active-active configuration in a multi master replication environment.

Migrating codepages objects from dev-qa-production Apex environments.

Independently managed all aspects related to Oracle APEX development and support.

Strong experience in data migration.

Done large scale data migration project from soup to nuts from one platform to anther like Oracle to mysql, etc.

Working with both structured and unstructured data-warehouse; redshift, greenplumb, azure databricks, etc.

Responsible for the daily operations and performance of SQL Database Environments.

Consulting with and advising senior management on high impact database solutions and database management topics.

Performing database enterprise environment capacity planning and availability management.

Documenting technical requirements, architecture, and design of deployment and integration of the Oracle Sales & Service Cloud solutions.

Ability to explain complex technical issues in business terms.

SQL Server Enterprise database architecture experience - sizing version 2014, 2016 and 2017, high-level understanding of how backup, high availability, BCP and capacity planning are designed and implemented in a SQL Server shared consolidated environment.

Experience deploying and managing Mongo DB databases in Linux environment.

Hands on experience with Mongo DB scaling across data centers and/or in-depth understanding of Mongo DB HA strategies, including replica sets and sharing Good Knowledge of JavaScript libraries and frameworks.

Hands on experience with automation and configuration management technologies such as Ansible, Puppet or Chef Deep knowledge of DB performance/scaling concepts and tuning best practices.

Researching and implementing performance improvement tools/techniques to our SQL databases including data storage, logging, in-memory object/databases, tuning tools, and performance monitoring tools.

Experienced in Oracle APEX with version 5 or higher and experience with APEX 5x features (Jquery, declarative actions, etc).

Experiences in setting up Oracle GoldenGate one-way, two-way/Bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions. Extensive skills in upgrading OGG 11gR2 to 18c and 19c, configuring OGG in RAC high available environment.

Primary technical resources to upgrade Oracle GoldenGate from 11g to 12c in Exadata machine environment. Design GoldenGate HA solutions by using Oracle 11.2.0.4 Clusterware functionality.

Planning and scheduling Physical Backups and Logical backups.

Experienced with utilizing Flash Back Point Time Recovery.

Ability to communicate in a professional manner when interacting across staff levels and internal/external customers.

Guiding customers on the migration of transactional database systems such as PostgreSQL, MySQL, Oracle, and SQL Server to Google Cloud Platform.

Knowledge of traces, tkprof and finding poorly performing SQL.sql, profiling, rewrite poorly performing SQL.

Experience in User management including Granting and Revoking privileges as needed.

Highly proficient in Space Management through Monitoring and Managing Tablespaces.

Configuring network components of database such as TNSNAMES, Names Server, Connection Manager, etc. Thus, allowing effective management of Oracle Networking.

Experienced with configuring Listener for external procedure calls.

Keeping the database up to date by applying the latest CPU and PSU using the OPATCH utility.

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.

Monitoring Alert Log for any and all issues to the database.

Good Understanding of disk hardware architecture, database design, cache controllers, and disk load balancing for UNIX and Windows Operating Systems.

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.

Experience with Golden Gate replication, including Installation, Upgrade, Configuration, and troubleshooting of the Goldengate Software.

Configured Goldengate High Availability using Oracle DBFS and Active Dataguard. 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

Comcast, Atlanta, GA. Oct. 2018 - Present

Senior DBA

Using Oracle Virtual Private Database to control Data Access.

Used Oracle Virtual Private Database Security Policies work with Applications, using Automatic Reparsing for fine-grained Access control policy functions.

Installing and configuring High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2, 12c and 19c RAC environments.

Configuring and maintaining replication using Oracle Goldengate.

Automating tasks using cron for Oracle GoldenGate restart.

Configuring lag using Oracle GoldenGate script and automated the process to email the user every hour in a high volume multi master replication environment.

Database release automation that support continuous Integration & Delivery.

Handling all activities related to the administration of database schemas.

Backing up and recovering of databases (RDBMS/NoSQL) for production and non-production environments.

Participating in a 24x7 on-call rotation, Building and Deploying schema changes to production and non-production.

Writing and maintaining Unix/Linux shell scripts to Identify Root cause analysis of production-related database issues.

Collaborating with engineering teams for solutions on regular basis to analyze the queries executed across environments, discover bottleneck queries.

Configuring Oracle GoldenGate to achieve unidirectional and bidirectional replication.

Performing DDL and DML replication from test and dev instances using Oracle GoldenGate.

Implementing Oracle GoldenGate for Active-Active replication between the data centers for High availability.

Guiding customers on the migration of transactional database systems such as PostgreSQL, MySQL, Oracle, and SQL Server to Google Cloud Platform.

Supporting High volume, critical VLDB Database Clusters which hold and sustain massive usage processing applications.

Researching and implementing performance improvement tools/techniques to our SQL databases including data storage, logging, in-memory object/databases, tuning tools, and performance monitoring tools.

Maintaining, enhancing and expanding RBIS Oracle CX Sales/Service Cloud platforms for the global commercial sales and service.

Working closely with the commercial (sales & marketing) and customer service leaders to build the roadmap for Oracle CX Sales/Service Cloud platforms to support the business unit strategy and objectives.

Working with customers to explain technical requirements and assist in designing, planning, managing, and troubleshooting the data migration process.

Implementing multiple replication sites for Oracle migration project using GoldenGate Software to migrate five multiple terabyte enterprise Oracle 11g to Oracle 12c databases on Sun Solaris UNIX platform with minimal downtime. Met all service level agreements on time and under budget. Tested and certified that all GoldenGate replication environments were operational and high performance throughput at 50 Gb/hour. Trained and mentored GoldenGate customers on replication basics and GoldenGate operations.

Migrating of large data from Exadata to RAC clustered environment

Installing, configuring Oracle 11gr2, 12C and 19c on Linux and HP servers.

Migration of standalone databases to RAC and ASM.

Designing and brainstormed Database upgrade from 11g to 12c in Single Instance to Multi-Tenancy.

Creating login triggers to monitor users access in the database using VPD technology

Creating synonyms, objects and grants on security packages to users

Creating and applied security policies to VPD tables

Creating duplicate databases for RAT Testing and moving databases from EXADATA to RAC environment.

Installing, configuring and maintained Oracle 11g/12c/19c Databases on Linux, UNIX and Windows Platforms.

Involved in the complete SDLC, Database design, System analysis, design and development.

Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.

Installation and Configuration of 11g and 12c Grid Control.

Installed OEM Grid Agents on UNIX, LINUX and Windows for monitoring of production databases.

Implementing Oracle Database 11g/12c 2 to 4 node Real Application Cluster (RAC) using Oracle Cluster ware for achieving high Availability on ASM.

Setup and maintained RMAN backup and recovery strategy for RAC and Single instance Databases.

Worked on Oracle 11g migration projects with low maintenance window and applied patches to various databases.

Worked on OEM Grid Control 11g and OEM Cloud Control 12c scheduling and troubleshooting OEM jobs and deploying OEM agents. Scheduling Backup Jobs and troubleshooting failed jobs through OEM GC.

Worked for Incident & Problem Management and Change Release Management to meet business SLAs (Service Level Agreement).

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.

Maintenance of 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.

Applied OS patches and upgrades on a regular basis and upgrade administrative tools and utilities. Configure / add new services as necessary.

Performed 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.

Performed daily backup operations, ensuring all required file systems and system data are successfully backed up to the appropriate media, recovery tapes or disks are created, and media is recycled and sent off site as necessary.

Provided Tier III/other support per request from various constituencies. Investigate and troubleshoot issues.

ScienceSoft Corporation Dallas, TX Dec 2015 – Sep 2018

DATABASE ADMINISTRATOR

Configured and installing Oracle Enterprise Manager (OEM) / Grid Control

Used RMAN for database backup as well as recovery. Also used Data pump, Import and Export utilities.

Modified database object structures as required by developers based up necessary business or application requirements.

Cloned as well as replication of production environment for testing purposes

Installed, configuration, troubleshooting and maintenance of Oracle Goldengate in production environment.

Extraction and replication design for Oracle GoldenGate.

Proposed and implementation of Initial Load strategy for Goldengate

Using Goldengate to maintain Live Standby Database

Using Oracle GoldenGate for Active-Active Synchronization(Bi-Directional Replication)

Configuration of Oracle GoldenGate Security

Configuration of Oracle GoldenGate in Heterogenous Environment (Operating system and Databases).

Developing solutions for handling high TPS transaction load using Oracle GoldenGate

Migration of data from one technology to another without downtime using Oracle GoldenGate

Troubleshot Goldengate extract processes and Replication related issues (Table DDL changes, remove/add tables between replication group) during code deployment and data refresh activities.

Supported and maintained Oracle Golden Gate for data replication and high availability databases.

Debugged Goldengate replication issues.

Sent daily or weekly operational reports to management in regard to my day to day including any concerns or issues that I have related to the system.

Identified and resolved various cases of performance issues both at the Database and the I/O level.

Provided DBA support for complex software installation and maintenance, including major upgrades.

Researched and implemented performance improvement tools/techniques to our SQL databases including data storage, logging, in-memory object/databases, tuning tools, and performance monitoring tools.

Reviewed backup and recovery strategy quarterly, and works with Operations to maintain and test disaster recovery databases.

SQL Server Enterprise database architecture experience - sizing version 2014, 2016 and 2017, high-level understanding of how backup, high availability, BCP and capacity planning are designed and implemented in a SQL Server shared consolidated environment.

Managed database security. Performed such tasks as creating new users, roles, profiles, and provide required user privileges based upon business requirements.

Administering and maintaining databases including daily monitoring and performance analysis using ADDM, AWR Report, Statpack, Etc.

Worked in team environment in order to complete other business goals, designs and reviews. Maintained database integrity within team dynamic by troubleshooting, patching, updating, and performance enhancing,

Enhanced SQL statements using Oracle Optimizer hints.

Ability to manage high availability solution centers using Oracle Real Application Clusters (RAC) with several nodes.

Creating database that meet the constantly changing requirement and need of the company and clients.

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.

Collaborating closely with teams, analyzing problems, recommending solutions and delivering technology results.

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.

Assisted in designing new and redesigning of old data marts in Oracle data warehouse environment and troubleshoot loading and business reporting related performance issues.

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).

Configuring the Oracle Network environment including Oracle Net Services and Listeners, configuring and managing oracle network.

Developing SQL scripts to carry out routine checks on databases. This include checking if the Listener is running, optimal running of all databases, Unix error messages, disk space availability etc.

Worked and provided reliable assistance within a 24/7 rotational shift.

Hewlett Packard San Jose, CA Oct 2014 – Nov 2015

Database Administrator

Involved in coding of backout scripts using shell scripts and deployment on Unix server.

Partnered with operations engineers, designed, developed and implemented improvements to existing infrastructure to increase system stability and performance.

Assisted in performance tuning of Database

Involved in Defect fixing, delivery of Database patches, creation of Database upgrade document, creation of release notes, Database releases

Involved in Database environments maintenance at offshore.

Worked on backups using data Pump and RMAN

Configured and set up both networks and servers.

Firewall installation as well as maintenance.

Installed and trouble shoot switches.

Troubleshoot and resolve complex issue for all supported services non-hosted environment.

Designed (logically and physically) large, complex, business-critical databases based on business requirements gathered from application development teams and business users.

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.

Worked with software vendors and Oracle support to ensure all database and application related issues are resolved timely and efficiently.

Worked on OEM Grid Control 11g and OEM Cloud Control 12c scheduling and troubleshooting OEM jobs and deploying OEM agents. Scheduling Backup Jobs and troubleshooting failed jobs through OEM GC.

Disaster recovery implementation using physical standby databases for high availability.

Provided hands on technical expertise, provides senior level technical guidance to staff, project leaders and other teams as necessary.

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.

Supporting High volume, critical VLDB Database Clusters which hold and sustain massive usage processing applications.

Supported and maintained Oracle Golden Gate for data replication and high availability databases.

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.

Administered Delphix virtualization and masking engines and customize virtual database provisioning using hook scripts.

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.

Assisted developers in detecting performance problems.

Respond to customers with analysis of their needs through qualifying questions both over the phone as well as in person in order to diagnose their needs.

Work with Tier I support in order to handle escalated technical issues in a timely and complete manner.

Secure Network via Active Directory and Antivirus Server.

Resolved Network Connectivity issues.

Converted physical servers to virtual servers via VMware.

Managed Virtual Server (containing Backup Server, Antivirus, and File Server)

Utilized Operating systems such as Windows 10 and XP Professional.

Responsible for installation, configuration, troubleshooting, support and maintenance of PC hardware and peripherals including desktop computers, laptop computer, modems, etc.

Synchronized Lotus Notes with Windows.

Assisted System Administrator with managing portals via SharePoint.

Assisted System Administrator by creating end user accounts via Active directory.

Assisted System Administrator with configuring all new servers.

Trained new employees.

Acted as team lead.

Hardware troubleshooting with both Dell and HP systems.

Troubleshot software such as Lotus Notes, Lexis Nexis, SharePoint, MS office suite, QuickTime, and Adobe Acrobat reader.

Vistex Chicago, IL Jan 2013 – Oct 2014

System Engineer

Coordinated and implemented updates to network hardware, operating systems, and attached devices; This includes investigation, analysis, recommendation, configuration, installation and testing of new network hardware and software.

Supported daily operations on network hardware and operating systems; this includes evaluation of system utilization, monitoring response time, and primary support for detection and correction of operational problems.

Lead the design, development, installation, configuration, and upgrading activities across enterprise server infrastructure.

Designed, installed, configured, tested and maintained operating systems and system management tools.

Guided IT team in monitoring and testing application performance for potential bottlenecks, identifying possible solutions, and implementing solutions.

Developed and maintained relationships with new and existing vendors providing managed services for infrastructure support, ensuring adherence to established SLAs and other agreements.

Partnered with operations engineers, designed, developed and implemented improvements to existing infrastructure to increase system stability and performance.

Creating technical support documentation for systems and applications.

Testing release of products to minimize user impact and ensure compatibility.

Maintaining servers and associated hardware, applications, services, and settings

Developing and monitoring policies for the use of network resources.

Assist in network design and implementation.

Maintain network connectivity of all computer workstations.

Create and maintain network users/permissions.

Monitor network to ensure optimal performance.

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.

Identifying opportunities for automation and lead the creation and implementation of custom automation scripts.

Researching security issues, standards, and products as required.

Developed, maintained, and enhanced systems using next generation technologies such as Artificial Intelligence (AI), data science, data analytics, or machine learning.

Key contributor to the maintenance and optimization of the client's network and wireless infrastructure.

Handled and checked all installed systems and infrastructure.

PSL Group Houston, TX May 2010 – Dec 2012

Technical Support Specialist

Responded to a range of customer issues based on priority via email, chat, and phones.

Identified and analyzed issues, patterns, and trends in customer requests & product performance.

Identified and evaluated opportunities to increase customer satisfaction.

Crafted well-written professional responses.

Demonstrated empathy and patience in every customer interaction.

Achieving monthly goals of solved tickets without compromising quality.

Finding solutions and resolved issues while always adhering to company policies and guidelines.

Learned, utilized and multitasked across a variety of tools to view account information, troubleshoot, and solve complex issues.

Identified and escalated bugs to the appropriate internal teams.

Communicated effectively with internal teams to identify pain points and provide product feedback.

Researched, diagnosed, troubleshoot and identifying solutions to resolve customer issues related to application use, design and configuration.

Took ownership of and resolve customers' product issues via telephone, email, or in-person, while meeting or exceeding stated service level agreement (SLA) timeframes.

Reproduced technical problems, diagnose causes, identify temporary and interim-term solutions and communicate status updates to clients.

Documented, route, tracked, escalated and updated customers, as well as RMS management, on status of issues as required.

Provided general process analysis and make recommendations for improvements.

Built rapport and elicit problem details from non-technical or technical customers.

Used approved protocol to communicate with development engineers on the analysis of software issues providing detail description of problems along with steps taken to analyze the problem.

Performed system testing as a final validation before release to customer.

Contributed to the body of knowledge by creating and maintaining knowledge base articles and other technical documents.

Provided senior-level support and guidance for Level 1 Customer Care staff.

Maintained an in-depth understanding of RMS’ products and support protocols.

Performed other support and operational tasks as required.

Participated in weekend on-call rotation for critical issues escalation.

EDUCATION

Bsc. Accounting & Computer Science

Lagos State University [2000]

Msc. Computer and Information Sciences and Support Services

Dowling College

Certifications

Oracle Database SQL Certified Associate

Oracle Cloud Infrastructure Certified Architect Associate

Microsoft Azure Administrator

AWS Certified Solution Architect

Contact this candidate