Database Administrator

RAZAQ AFOLABI IBRAHIM

Cell +1-312-***-**** DATABASE ADMINISTRATOR **************@*****.***

Talented Database Administrator with five years of experience implementing, and optimizing PostgreSQL, Oracle, and SQL Server database servers. Razaq has hands-on experience, knowledge and proficiency in database design, monitoring & tuning, migration, upgrades, backup & recovery, cloning, replication, and security implementations in both cloud and on-prime environments. A motivated team player with a proven ability to quickly learn new environments, transfer technical knowledge to others, and remain calm under pressure.

PROJECTS/SKILLS SUMMARY

Installs/Upgrades/Patching

AWS Migration and Services (RDS, EC2)

Performance Tuning

Technical Documentation

Goldengate

RAC Clusters

Scrum Master

Database Security

Postgres Logical/Streaming Replication

Database Scaling

EXPERIENCE

Cox Automotive Atlanta, GA

PostgreSQL/Oracle Database Administrator

06/ 2016 – Present

Install and configure servers for PostgreSQL versions 9.7,10.7 and 11.4 on both Windows and UNIX platforms.

Exposed to cross platform migrations Oracle to PostgreSQL where I documented and assisted during MIGRATION from ORACLE Databases to PostgreSQL database in AWS Cloud.

Championed database migration from Oracle to PostgreSQL on premises and on AWS, using Migration Tool Kit, Ora2pg, DMS and SCT.

Clone databases using creation templates and pg_dump for testing purposes.

Perform database Refreshes from production environments.

Perform PL/PGSQL errors fixes for application issues.

Perform patching and upgrades of Databases using AWS minor versions upgrades, pg_upgrade, pg_dumpall and logical replication.

Configured PgBouncer for connection pooling and PgBadger for generating statistical reports.

Configure a REPLICATION between MASTER and SLAVE, and monitored replication.

Perform maintenance activities like checking on AUTO VACUUM jobs, Customized VACUUM on certain tables and columns.

Experienced in tuning PostgreSQL server settings and troubleshooting performance issues.

Implemented backup schedule for both physical using Pg_base_backup and Pg_backrest and Pg_dumpall and Pg_dump for logical backups.

Support daily administration, monitoring, tuning, and troubleshooting of clusters and single instances on UNIX/Linux and AWS Console.

Monitor CPU utilization, memory, Database Connections and storage space daily using pg_stat_activity, PEM, Pg_view and AWS CloudWatch alarms. Also use customs shell scripts deployed on crontab to monitor performance and resources.

Implement table and index partitioning to improve query speed.

Participate in capacity planning meetings to meet the demands of the dynamic aspects of clusters scaling.

Oracle Experience at Cox Automotive

Deployed Database security policy and installation, using passwords, privileges and user profiles, Enabled Encryption for databases.

Monitored different databases and application servers using oracle enterprise manager (OEM 13c) 10g, 11g grid control, and cloud control 12c.

Implemented and managed optimum physical database design (tablespaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.

Extensively used AWR, ADDM and Explain plan for periodic performance tuning.

Provided instance level performance monitoring and tuning for event waits, sessions, physical and logical I/O and memory usage.

Successfully implemented backup & recovery using RMAN which includes hot backups and cold backups.

TPG CAPITAL Chicago, IL

Oracle Production Support Database Administrator

03/2015– 05/2016

Participated in 24 x 7 production & development database support and administration.

Working experience with latest toad having new features PLSQL & SQL script debugger, database health checkup, ASM manager, diagnose extents, segment advisor, SGA trace and query builder.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implementing data pump, conventional export/import utility

Implemented proactive monitoring using tuning pack, diagnostics pack, and stats pack, SQL Trace & TKPROF.

implemented oracle database 11g two node real application cluster (RAC) using oracle cluster-ware, and responsible for high availability and load balancing. *

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

involved in converting a single instance database to oracle 12c, 11g, 10g RAC databases.

installed ASM environment and migrated databases from NON-ASM to ASM.

made optimal use of oracle support in resolving the SRS

documented the standard processes for peers to follow.

CERTIFICATIONS/EDUCATION

B.Sc. Mass Communication

Oracle Certified Associate (OCA 12C)

SCRUM MASTER accredited CERTIFIED

TECHNICAL SKILLS

Databases

PostgreSQL, SQL Server, Oracle 10g, 11g, 12c, AWS

Tools

Navicat, PgAdmin4, PgBouncer, PgAgent, PgBadger, PgHero, Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, Oracle Enterprise Manager 13C, RMAN, SQL*Loader, Exp/Imp/Data Pump, AWR, DBCA, DBUA, ADDM, Toad, Putty, WinSCP, SQL Developer, OEM 12c, Crontab

Operating Systems

LINUX, UNIX (Solaris 8/9/10, AIX, HP-UX), MS WINDOWS, VMWare, Centos7

Contact this candidate