FIYINFOLUWA LAMIDI

DATABASE ADMINISTRATOR

Page * of 3

CONTACT

adgqjs@r.postjobfree.com

860-***-****

Atlanta, GA 30312

linkedin.com/in/fiyinfoluwa-lamidi

■ US Citizen

PROFILE

Lead Oracle/MySQL DBA with AWS and

Azure experience in an Agile Production

environment.

EDUCATION

2009

UNIVERSITY OF LAGOS [LAGOS, NIG]

Bachelor of Science in Biochemistry

TECHNICAL SKILLS

Cloud Services: AWS, Azure

RDBMS: MySQL 5.5, 5.6, 5.7, AWS

RDS, AWS Aurora, Oracle 11Gr2,

12c, Azure SQL

Languages: SQL (Oracle, MySQL),

Bash, Powershell, Azure Command

Line

Oracle RAC, MySQL Replication

Oracle GoldenGate, Data Guard

AWS EC2, VPC, IAM, DMS, SCT

Azure VM, VNet, AD, Migrate

EXPERIENCE

March 2017 - PRESENT

Senior Oracle & MySQL DBA Cox Enterprises

Led a multi-part project to migrate the production database using GoldenGate One-way replication from 11.2.0.3 Standard Edition RAC to 11.2.0.4 Enterprise Edition RAC in a Cloud-connected Datacenter

Setup SSL connection restriction on AWS Aurora users to ensure TLS encryption communication for all users

Generate SQLT, AWR, ASH reports to drill into slow queries and database issues

Installed and configured password validation plugin on AWS Aurora instance to enforce strong password to meet security compliance

Worked with solution architect to discover, assess, migrate Oracle and MySQL databases on VMs On-prem to Azure SQL and Azure MySQL

Installed OEM agent on EC2 instance to monitor AWS Aurora databases to resolved Self-Identified Issues (SIIs)

Queried Cloud Watch log insight and Performance Insight to view slow queries during slow batch processing

Played a lead role in the planning, implementation and migration of the Oracle and MySQL databases to AWS Aurora using AWS DMS and SCT; SQL Server database to Azure SQL using Azure Migrate

Migrated MySQL pre-production databases to EC2 instances using mysqldump

Created Aurora Global databases, Cross-Region Read Replica to meet disaster recovery requirement

Worked with system admin team to setup AWS IAM users, groups, roles and permissions as well as setting up Azure AD and syncing with the on-prem identities from Microsoft Active directory

Implemented and scheduled the Oracle database backup and disaster recovery policy on Azure VMs using RMAN, Azure VM backup and disaster recovery policies

Configured bidirectional GoldenGate replication with CDR timestamp column to migrate individual application to ensure the least business disruption

Configured Master-Master MySQL replication to migrate an application to a different data center

Created Oracle and MySQL user accounts and reset expired and forgotten passwords for engineers

Installed Oracle Veridata on-prem to confirm replication synchronization

Worked with Platform engineering to troubleshoot and fix OS issues affecting database performance

Configured TDE Encryption on Enterprise edition databases on-prem to encrypt PII data

FIYINFOLUWA LAMIDI

DATABASE ADMINISTRATOR

Page 2 of 3

MANAGEMENT SKILLS

AWS Console and CLI

Azure Portal and CLI

Oracle Enterprise Manager (OEM)

Oracle Veridata

MySQL Workbench

DBeaver

Putty, Mobaxterm

GGSCI, logdump

May 2013 – February 2017

Oracle DBA Stack IT Inc

Installed Oracle 11g and 12c software on multiple Red Hat Linux

(RHEL 5,6) Operating Systems

Support Company’s client in rotated schedule to meet project demands

Worked with Platform engineering and Delivery team on DR testing

Migrated Oracle 11g, 12c databases to Azure VM using Golden Gate

Wrote stored procedure to recompile invalid database objects like packages, views, triggers and other stored procedures

Configured Oracle audit on user session to identify failed logins for management report

Setup instance templates on Amazon EC2 and created multiple instance from the template for test and dev environments

Worked with the offshore team during database release

Controlling and monitoring user access to the database using roles and profiles

Performed database refreshes on non-critical production databases using Datapump Export/Import utilities to the scrub server in the production environment and dev, test and staging servers in the dev environment

April 2016 – July 2016

MySQL DBA Everest Technologies

Monitored the MySQL and Innodb health for 12 instances using Innotop Monitoring tool ensuring 99.999% Uptime

Configured Master-Slave MySQL replication for disaster recovery

Installed MySQL Audit plugin to audit user activity to meet audit requirements

Worked with 2 members of the QA team to benchmark the activity of long-running queries which showed the need to increase RAM for some servers to improve performance

Recommended and organized a lunch and learn with all lead and junior developers to explain the types and uses of indexes to ensure proper index creation

Wrote Stored Procedure to generate DDLS for triggers on newly created tables to load historical data into history tables January 2015 – March 2016

MySQL DBA Pacific Corporation

Created and granted appropriate privileges to 21 user accounts and maintained database security using password rotation FIYINFOLUWA LAMIDI

DATABASE ADMINISTRATOR

Page 3 of 3

Wrote stored procedure to audit admin user activity on database

Used pt-duplicate-key-checker to find duplicate index to reduce bloated database size

Upgraded MySQL 5.5.56 to MySQL 5.6.10

Migrated MySQL 5.6.10 to RDS Aurora for MySQL

Modified and revoked the access and privileges of users

Reconfigured memory parameters including Innodb buffer pool, Key buffer and Query cache size to allocate more memory for data caching and indexing

Contributed in capacity planning & system architecture meetings involving Project Managers, Network admins and Lead developers

Configured Master-Slave MySQL replication

November 2010 – May 2013

Oracle DBA MkIT Inc

Applied obfuscation script to encrypt data in data files

Controlling and monitoring user access to the database using roles, and profiles

Used RMAN to restore the control and data files and recover the database due to the system admin’s error

Installed and configured single node and multi-node RAC instances in production and dev environment

Acquired knowledge of Oracle Data Guard installation and configuration

Upgraded Oracle 11.2.0.3 database RAC cluster to 11.2.0.4 database RAC cluster

Worked on database scripts during application releases between environments

Created and incremented Oracle datafiles and tablespaces to ensure database availability

Work with Oracle support on database issues during Oracle RAC installation

Work with Oracle support on database memory issues

Contact this candidate