Zeno Makoliakunu

715-***-**** adit3a@r.postjobfree.com

oak creek,WI.

DATABASE ADMINISTRATOR

Experienced Database Administrator with over 6 years of hands-on experience, including complete life cycle knowledge. Skilled at analyzing Pg_stat_actvity, pg_stat_statement, pg_views, PEM reports in order to troubleshoot performance issues. Highly detailed, with a drive to contnually expand and update knowledge to better service PostgreSL Databases and assist in solving problems. ooking to apply skills learned through experience in assistng another company as a Database Administrator. Areas of expertse include:

Development

Testng

LAT

Project & Producton Support

PostgreSL 9.6, 10 and 11

Installaton & Confguraton

Upgrades & Patches

Migraton of Systems

Backup & Recovery (BART)

Performance Tuning

Streaming Replicaton

ogical replicaton

xDB

EFM-2.1, 3.9

Creaton of Conceptual, ogical,

& Physical Data Models

BART

Explain Analyzed

Optmizaton of SL & P SSL

Scripts

Database Security

Administraton

Pg_views, pg_stat_actvity

AWR Report

Basic programing knowledge in

java, Matlab,c+,c++ etc.

inux OSSCentOS

Fine Grain Auditng

Flashback

SL -Trace

TKPROF

SHE Scripts

OEM Database & Grid Control

OCFS

SL SERVER (2 years)

POSTGRESL

PGADMIN 4

P SpgSL

Pgpool-II3.5

Skills in SQL & PL/SQL Scriptnn.

I have written bash shell scripts to automate most of my day actvites. I wrote scripts to automate database and archive logs backup. I wrote a script that will alert whenever the are queries that run more that threshold ( long running queries). I wrote a script that will monitor the replicaton setup and report when there is a lag. I wrote a script that will perform daily maintenance tasks such as vacuuming and statstcs gathering. I wrote a script that will check the database system catalogue for any corrupton. I wrote a script that will be triggered when one of the Postgres instance go down. I wrote a script that will report whenever the load in the server exceeds the threshold. I wrote a script that will be triggered when the number of actve connectons in the database have reached the threshold. I have had a great scriptng experience during my 6 years as a DBA. PROFESSIONAL EXPERIENCE

Vectren Evansville, IN

Database Administrator

June 2017– current.

● Confguring PostgreSL Streaming Replicaton and Pgpool for load balancing. Managing the monitoring tools for better performance like PgBadger, PEM, SolarWinds.

● Experience in upgrading and migratng various versions of PostgreSL database on diferent platorms.

● Responsible for all backup, recovery of PostgreSL databases using BART and pg_dump.

● Responsible for confguring, integratng, and maintaining all Development, LA, Staging and Producton PostgreSL databases within the organizaton.

● Implement, confgure, and troubleshoot database instances, replicaton, backup, parttons, storage, and access. Set user privileges within and outside the database environment

● Migraton of Data from Reports generated by various vendors into PostgreSL Databases using PostgreSL ExportSImport Procedures.

● Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the cronjob periodically in regular intervals.

● Experience Migratng data from Oracle to PostgreSL using MKT and EDB Migraton Portal.

● Extensively investgated and followed-up with applicaton teams, and proposed solutons to resolve slowness and performance issues.

● Troubleshootng PostgreSL database using Explain, explain analyzed.

● During producton hours, resolved lockSlatch and resource contenton issues

● the Databases through various Shell Scripts scheduled in the corncob periodically in regular intervals.

● Extensively investgated and followed-up with applicaton teams, and proposed solutons to resolve slowness and performance issues. Experience in upgrading and migratng various versions of PostgreSL database on diferent platorms.

● Responsible for confguring, integratng, and maintaining all Development, LA, Staging and Producton PostgreSL databases within the organizaton.

● Implement, confgure, and troubleshoot database instances, replicaton, backup, parttons, storage, and access. Set user privileges within and outside the database environment

● Migraton of Data from Reports generated by various vendors into PostgreSL Databases using PostgreSL ExportSImport Procedures.

● Troubleshootng PostgreSL database using Explain, explain analyzed.

● Managed the monitoring and troubleshootng of database replicaton issues

● Collaborated with applicaton development teams to support and resolve any issues encountered

● Assisted in convertng Power Builder code to P SSL

● Installed pg_bouncer for connecton pooling for all PostgreSL databases running on AWS RDS. Honor Health Phoenix, AZ

Database Administrator (PostnreSQL DBA) Jan. 2014 – May 2017 Responsibilities:

● Experienced in administering and maintaining medium enterprise database servers on Linux servers.

● Participating in daily meetings to discuss about the new database design, modeling and creation.

● Installing and Confguring PostgreeSQL from source or packages on Linux machines.

● Experience designing database structures, indexes, views, partitioning.

● Implementing backup and recovery (Logical and Online).

● eSetup and maintenance of postgres master-slave clusters utilizing streaming replication

● Cross-data center disaster recovery and backup architecture

● Performing schema management, database sizing, maintaining privileges.

● Data migration while upgrading database versions.

● Extensive experience with Warm eStandby (PostgreeSQL 8.x and earlier), and Hot eStandby

(PostgreeSQL 9.x and greater).

● Performance monitoring and optimization

● Installing and confguring Obbect level replication like eSlony etc.

● Installing and confguring connection pooling tools like Pgbouncer and pgpool etc.

● Installing and monitoring PostgreeSQL database using the standard monitoring tools like efm etc.

● Confguring log analyzation tools like pgbadger etc.

● Removing the Index bloat Concurrently to improve the performance.

● eScheduled maintenance activities to vacuum, analyze to improve the query response time.

● Maintaining custom vacuum strategies at table and db level.

● Query optimization and troubleshooting

● Close collaboration with engineering on schema additions and updates utilizing Liquibase Participation in week-long on-call rotations

EDUCATION & CERTIFICATION

● Bachelor’s Degree in Petroleum technology and Geology.

● PostgreSL 10, 11 Certfed Associate

INTEREST

● Reading and research

● volleyball games

● football games

● traveling

● dancing

● running

Contact this candidate