Mugniu Dipo Almaroof

LInkedIn adyrt5@r.postjobfree.com 240-***-****

Areas of Expertise:

●Linus/UNIX/AIX, Windows 2008/2010 server

●SQL Tuning in an Oracle & PostgreSQL

●Oracle RAC & ASM Admin/Installation

●Postgres Database Administration

●AWS cloud solutions architect

●Oracle Forms and Reports Development

●RAC/EXADATA

●Data Security, Backup & Recovery

●Golden Gate/Data Guard configuration

Professional Experience

Database Administrator

Avangrid, Inc. Orange, Connecticut March 2020 – Present

●Upgrade an oracle 11.2.4 Database to 12c Oracle Database. Installation of Dataguard on 6 databases. Upgrade of oracle database from 12c to 19c.

●Configuration of Golden Gate on multiple database lifecycle environments

●Installation of Oracle Enterprise Manager 13c Cloud control on oracle 12c database software

●Prevented Data Loss and reduce data protection overhead for all Oracle databases in our environment

●Database servers joined together to perform a powerful cluster with the Oracle Exadata Cloud

●Manages and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, document

●Administering large PostgreSQL database ability to do performance tuning/ index maintenance experience of backing up and restoring PostgreSQL database schemas experience in Security access control experience with testing experience with configuration management experience with version control

●Migration of Oracle Database to cloud Azure.

●Responsible for all backup, recovery and upgrading of PostgreSQL databases

●Provides appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization

●Recommended architectural improvements, designs solutions and integrations solutions.

●Monitored network performance and provided network performance statistical reports for both real-time and historical measurements

●Maintain the smallword & Esri Gas GIS database as well as quality check the data for inaccuracies

●Utilize smallword modules such as GDO and Designer as well as lean and understand BHE’s WAM platform

Database Administrator

VariQ Corporation · Elizabeth City, NC Aug 2018 - March 2020

●Exposure to cross platform migrations preferably oracle to PostgreSQL.

●Documented and assisted as an oracle dba data migration from oracle databases to PostgreSQL database in AWS cloud

●Installed/configured PostgreSQL (9.5, 9.6. and recently worked with PostgreSQL VERSIONS 10).

●Tuned autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples

●Managed and monitored these databases using pgAdmin, psql,

●Used pg_Hero for Performance TUNING mostly, SQL Tuning using EXPLAIN ANAYZE and PG_STAT_ACTIVITY

●Performed maintenance activities like vacuum, vacuum full, analyze; Checking the auto vacuum jobs, customized vacuum on certain tables and columns.

●Used Pg_Bouncer for connection pooling, pg_Badge for generating statistic reports

●Experienced in tuning PostgreSQL database settings & Troubleshooting performance issues, Managing Users and Tablespace on PostgreSQL Servers.

●Developed customized scripts, to monitor database growth, TABLE growth, automated backups using cronjobs

●Familiar backups (pg_basebackup, pg_backrest, pg_dump,) and restore, compressed (gzip) backups, database or schema refreshes

●Upgraded database version using pg_dump/pg_restore and pg_upgrade tools and updating the latest security patches to the database, which are provided by PostgreSQL open source community

●Additional experience with security encryption of users and password on database. Experience with understanding Tenable Nessus vulnerability scanning on the database level.

●I knowledge on the authorization and accreditation when it comes the CIA integrity of the system.

Additional Experience

Database Administrator EIS North Carolina 2014 -2015

Database Administrator Constellation Energy Baltimore, MD 2015 – 2018

Education, Training & Security Clearance

Bachelor of Science Degree,Washington Adventist University 2015

Public Trust obtained 2020

Oracle Cloud Infrastructure Architect 2022

Amazon Web Services Solutions Architect (AWS) 2023

Certified Scrum Master 2022

Comptia Security plus CE 2023

Active Security Clearance 2028

Contact this candidate