MySQL Database Administrator
Resume:
FIYINFOLUWA LAMIDI
DATABASE ADMINISTRATOR
Page * of 3
CONTACT
*****.******@*****.***
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