Assistant Database Administrator

Martial Duclair Tchoffo Ngougnou II

= Mobile: 908-***-****= Email: ****************@*****.***

POSTGRESQL DATABASE ADMINISTRATOR

Over 6 years of extensive experience as a POSTGRESQL AND ORACLE database administrator, I have hands-on experience in database design, upgrades, migrations, backup and recovery, replication, cloning, monitoring and tuning, networking as well as security implementations. I am proficient in an assortment of technologies including ORACLE PostgreSQL. A dedicated team player with excellent problem-solving skills and interpersonal abilities.

AREAS OF EXPERTISE

Databases: Oracle 10g, 11g, 12c, AWS RDS, POSTGRES 9, 10, 11

Database Tools: SQL*Plus, PGADMIN4, PGPOOL, EFM,PEM,BART,PGBOUNCER, PGBACKREST, PG_REPACK, PG_TOP, DBCA, Toad, OEM, RMAN, MTK, Ora2pg, SQL*Loader, Exp/Imp/DataPump, DBCA, DBUA, ADDM, Oracle Migration, AWS DMS, AWS SCT, AWS KMS, CloudWatch

Operating Systems: Windows Server (2012, 2016), Windows Client (win 7, win 8, Win 10), Linux Red Hat 6,7 CentOS 6,7

Languages: English and French

Inter-personal Skills: Confident, Polite, and Patient, Great team player and very adaptive to changing environments.

PROFESSIONAL EXPERIENCE

BANK of AMERICA – CHARLOTTE, NC SEP 2016– Present

POSTGRESQL DATABASE ADMINISTRATOR

Configured cluster of pgpool for connection pooling and failover.

Configured pgBadger for generating statistic reports.

Experienced of tuning PostgreSQL server settings & Troubleshooting performance issues.

Managing Users and Tablespaces on PostgreSQL Servers.

Using Customized scripts, to monitor database growth, TABLE growth, automated backups using cronjobs.

Checking the AUTO VACUUM jobs, Customized VACUUM on certain tables and columns

Experienced in handling logical and physical database BACKUPS. Assisted in developing and implementing best practices for Disaster Recovery and Backups.

Used restoration techniques like pg_restore and (PITR) Point in Time Recovery.

Performing BACKUPS, and RESTORE, Compressed (gzip) BACKUPS, Database or Schema REFRESHES

Configuring streaming replication (including cascading replication). configured a REPLICATION between MASTER and SLAVE, and monitored On-Going REPLICATION

Successfully upgraded PostgreSQL servers with minimal production impact.

Increased productivity by automating the PostgreSQL installation and configuration using Ansible.

Completed projects by effectively applying engineering, technical and maintenance procedures, and evaluated new technologies plan for growth and change.

UNITEDHEALTH GROUP- Bensalem, PA FEB 2014 – AUG 2016

ORACLE /POSTGRESQL DATABASE ADMINISTRATOR

Participated in 24 X 7 Production & Development database support and administration.

Worked with Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.

Used oracle configuration assistants like: DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases, and NETCA (Network Configuration Assistant) for creating Client-Server environment using Listener, TNS names etc.

Implementing Datapump, conventional export/import utility

Configured Oracle Data guard for Oracle Disaster recovery.

Implemented Flashback technology of the Oracle 12C, 11g along with Recycle bin for a faster recovery of the databases and database objects.

Refreshed/cloned databases using RMAN utility.

Made optimal use of Oracle Support in resolving the SRs

Participated in cross platform migrations such as Oracle to PostgreSQL

Part of the on-call production support team for 24/7 on-call production support.

Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg_basebackup and Pg_backrest.

Support daily administration, monitoring, tuning, and troubleshooting PostgreSQL clusters using custom scripts, PgAdmin, and Cloud Watch

Monitored and solved performance issues.

Performing cluster’s maintenance activities like vacuum, vacuum full, analyze.

Experienced in handling logical and physical database BACKUPS. Assisted in developing and implementing best practices for Disaster Recovery and Backups.

Used restoration techniques like pg_restore and (PITR) Point in Time Recovery.

Performing BACKUPS, and RESTORE, Compressed (gzip) BACKUPS, Database or Schema REFRESHES

Configuring streaming replication (including cascading replication). configured a REPLICATION between MASTER and SLAVE and monitored On-Going replication.

Upgrading database version (pg_dump/pg_restore and pg_upgrade).

Performed database Cloning and Refreshes from production to lower environments

Increased productivity by automating the PostgreSQL installation and configuration using Ansible.

Tested, implemented, tuned, and supported PgBouncer, a lightweight connection pooler for Postgres, in production.

Created, reviewed and implemented maintenance plans on production servers.

EDUCATION

University of Yaoundé 1 – Cameroon

oBachelor’s degree in computer network

Prince George’s Community College – MD

oAssociate of Applied Science: Cybersecurity

CERTIFICATION

Cisco Certified Network Associate (CCNA) Certified.

CompTIA SECURITY+ Certified

Oracle Certified Associate OCA 12c Certified

Oracle 12c SQL Fundamentals certified

Contact this candidate