Database Administrator Computer Science

Olusola Ajakaiye

Cell Phone: 469-***-**** *** Red Bud Pass

Email: ********@*****.*** Wylie, TX 75098

Education

Prairie View A&M University, Prairie View, TX

Bachelor of Science in Computer Science

Skills

Linux, Mysql, PostgreSQL, DB2, Java, Shell Scripting (BASH), Teraform, Python, PL/SQL, AWS ec2, Ansible, communicative, proactive, intuitive learner, monitoring tools(DB2top, Datadog), Qlik, HTML, CSS, Wireshark, Azure, Kubernetes, Docker.

Professional Experience

AudiPsalm IT Solutions Client: Boeings May 2020 to Present

DB2 LUW Database Administrator

Monitored db2 databases using DMC/DSM for high CPU, Locks, Long Running queries, IOP’s and created custom shell scripts to monitor Unused index, reorg checks, file system spaced, diag error log, backups, replication.

Worked with Developers and Application owners to Tune and Optimize Sql Queries and Stored Procedure.

Took part in Deployment calls to discuss No-Go/Go changes with Database object changes, DML, DDL. Deployed changes from DEV to TEST to Preprod to Prod. Created the change tickets and CAB means for the approvals.

Particpated in Agile PI meetings to plan sprints, pull stories from the backlog and create stories for the sprints and set deadlines.

Updated dbmcfg for the instance and dbcfg for database.

Performed backups, restores and refreshes.

Granted and revoked users access, Created roles for tables and granted/revoked the roles to groups

Worked with the Auditing and compliance team to resolve tenable vulnerabilities, revoked elevated access if not justifiable.

Performed applying special builds,database minor and Major Upgrades using Ansible

Using Ansible to perform Monthly reboots of Database servers.

Ran Tenable scans to detect and remediate vulnerabilities

Performed database maintenance task reorging and updating statistics for tables.

Implemented and Supported Qlik to replicate data from Oracle, SQL, PostgreSQL, Mysql to DB2

Supported DB2 on Redhat Linux and Windows on Prem servers and AWS EC2 instances, Kubernetes/dockers.

Setup LDAP Authentication, Performed encryption at rest and in flight (TDE) and worked with internal Auditors to prepare for external Audits.

Revoked and granted roles to users and groups.

Peformed purging/archiving of data based retention period provided by the business, also created and performed yearly maintenance on partitioned tables.

As part of migration/upgrade task I ceated cutsheets for new builds for database servers and instances, Also performed quarterly capacity planning to add space.

Took part in Yearly DR excercise

I provided on call coverage one week in the month.

Created PMR to IBM and attached db2support files with additional requested logs to issues that needed to be escalated.

DB2 Mainframe Database Administrator

Create/Alter database objects such as table, tablespace, database, index, view, synonym and alias etc.

Creating jobs for mainframe db2 utility such as Reorg, Runstats, and Imagecopy for new tablespace/ database.

Grant/ revoke access to database object, procedure, query.

Performing Binds and Rebinds of plans and packages as per the application need.

Perform the analysis and fixing of DB2 batch job failures.

Performed access path analysis for queries using DB2 Explain before implementing in Production environment.

Worked extensively on BMC Mainview for DB2 for real-time monitoring of threads, locking conflicts and collecting the metrics like CPU usage, buffer pool efficiency, and I/O performance.

Tuning and optimizing the complex Queries for better performance using BMC Apptune tool.

Resolve any database issues in accurate and timely fashion, provided application support and facilitated training to the Development Group.

PostgreSQL Database Administrator

Monitored PostgreSQL databases on Prem/Cloud (AWS) for Long running queries, CPU, Memory, IOPS, connections backups using Datadog, PEM, Cloudwatch, Performance Insight.

Worked with Developers and Application owners to Tune and Optimize Sql Queries and Stored Procedure.

Built Custom shell shell scripts to monitor/alert for long running queries, CPU, unused indexes, table bloats, replication

Used Pg_Stat Activity to query for details of Queries running during high CPU/Memory.

Handled Servicenow tickets to create users and grant/revoked roles to user/groups for select, update, delete, insert to tables.

Supported Deployment of DDL/DML/functions/Triggers from Dev, Test, Production and planning backout plans.

Installed PostgreSQL on an amazon Redhat EC2 instance and on prem servers.

Implemented HADR by Setting up Streaming and Logical replication between the Primary and the Standby.

Handled maintenance task by tuning Autovacuum, Autoanalyze, performing Analyse,online vacuums (pg_repack) and offline vacuums for bloated table.

Performed backups using pg_basebackup and pgdume and also did restores/refreshes from prod to Test.

Used DMS to perform zero downtime upgrade from PostgreSQL 10 to 13.

Performed Vulnerability remediation Java update, applying database special builds, minor and Major Upgrades using Ansible

Using Ansible to perform Monthly reboots of Database servers.

Ran Tenable scans to detect and remediate vulnerabilities

Tuned Auto-Vacuum Parameters for tables with High Volume DML transactions

Supported PostgreSQL on Redhat Linux and Windows on Prem servers and AWS cloud EC2 instance

Created Terraform scripts for Provisioning of PostgreSQL aurora, EC2 and RDS instances.

Setup LDAP Authenticaiton and Performed encryption at rest and in flight (TDE) and worked with internal Auditors to prepare for external Audits.

As part of migration/upgrade task I ceated cutsheets for new builds for database servers and instances, Also performed quarterly capacity planning to add space.

Peformed purging/archiving of data based retention period provided by the business, also created and performed yearly maintenance on partitioned tables.

Used Pgbadger and Log_min_duration_statement to troubleshoot overall Application/database/OS Performance issue.

Worked on POC for PostgreSQL Kubernetes/Dockers

Created a Python API bridging Qlik and other system APIs for data extraction without duplicating or rewriting logic

MySQL Database Administrator

Handled Servicenow tickets to create users and grant/revoke access for select, update, delete, insert to tables.

Worked on troubleshooting and optimizing long running SQL/Stored Procedures raised by alerts in monitoring or by the application team and developers. Also reviewed the error logs in /var/log/mysqld.log for database issues.

Supported Deployment of DDL/DML/functions/Triggers from Dev, Test, Production and planning backout plans.

Handled maintenance task for Optimize for high Fragmentated tables, Analyze to collect start, Check to find corrupted database objects.

Implemented and configured HADR between master and salve using binary log file and Transaction based replication.

Monitored Mysql databases using Performacne insight (AWS ), Innodbtop, Percona, custome shell scripts for long running query, fragmented tables and indexes, unused indexes, replication.

Monitored and resolved Mysqldump issues, performed refresh from Production to lower environments quarterly. Performed table level Mysqldumps or export/import as requested by developers or as part of backout plans for deployments.

Performed applying special builds, database minor and Major Upgrades

Worked on POC for implementing Mysql on Kubernetes/Dockers

Supported Mysql on Prem, AWS EC2 instances, Aurora, RDS instances

Used Mysqlslowdump and the Global Slow Query log parameter to troubleshoot overall Application, Database, OS performance issues.

Used Show Processlist to investigate queries running at the time of high database resource constraint issues.

Peformed purging/archiving of data based retention period provided by the business, also created and performed yearly maintenance on partitioned tables.

As part of migration/upgrade task I ceated cutsheets for new builds for database servers and instances, Also performed quarterly capacity planning to add space.

MySQL Developer

Created stored procedures and functions for multiple use cases.

Worked on enhancing existing procedures and functions for new client requirements.

Worked on rewriting and optimizing long running queries.

Used utilities like EXPLAIN FORMAT and EXPLAIN ANALYZE to analyze the query plan and take actions.

Experience in using CTE and temporary tables.

Involved in code reviews and code refactoring.

Created triggers for audit and security purposes on certain tables.

Used aggregate functions and window functions extensively in queries.

Created stored procedures to speed up bulk data deletion tasks.

Have performed impact analysis on DB object changes.

Have created indexes to improve query performances.

Used appropriate hints in queries wherever necessary.

Contact this candidate