ERNESTINE NGWATUNG N.

Email: adjuzg@r.postjobfree.com

Contact: 240-***-****

POSITION: POSTGRESQL DATABASE ADMINISTRATOR / CONSULTANT

Professional Summary

I have spent the last 5+ years performing installations and configurations of different PostgreSQL versions such as 9.6, 10, 11 and 12. I also have hands on experience in database administration with an extensive knowledge of both Oracle and PostgreSQL database administration and database design, supporting large and small databases sizes in both the production and test environment. She is experienced in configuring backup and recovery using logical and physical backups tool.

Hands on experience in both PostgreSQL Community and EDB edition.

Used shell scripting to run cron jobs on servers.

Expert in implementing High Availability using Streaming Replication and repmgr.

Experienced in Disaster Recovery and PITR using pgbasebackup.

Performed Database tuning to maximize application performance, reliability, and scalability.

Knowledgeable in Database Upgrade, migration of databases from on-prem to cloud and from on-prem to on-prem

Performance Tuning and Troubleshooting, automation, and shell scripting.

Monitored database jobs and supported other projects requirements as needed.

Deployment of databases from on premises to AWS cloud.

Experienced in setting and managing PostgreSQL on AWS RDS and EC2 instance.

Strong organization, communication, and analytical skills. Team player and ability to lead.

Projects Worked / Skills Used

High Availability

Disaster Recovery

System Upgrades

UNIX shell scripting

Migration from Oracle to PostgreSQL

Streaming Replication

Excellent Diagnostic skills

Performance Tuning and Optimization

Backup & Recovery

Network Maintenance

Linux/Unix/Centos/Windows

Oracle RAC, Data Guard, RMAN, ASM

Automation, implementation, and Testing

AWS RDS & EC2 instance

Amazon Aurora

Work Experience

PRIORITY HEALTH – GRAND RAPIDS, MI

November 2017 – January 2021

POSITION: PostgreSQL Database Administrator

Installed and configured PostgreSQL versions such as 9.6, 10, 11 and 12 on Linux Operating System.

Performed database upgrades from 9.6 to 10, 10 to 11 and from 11 to 12 using pg_upgrade utility and pg_logical with minimal downtime by prior testing in test servers.

Review database design and integration of systems and makes recommendations of emerging technologies regarding enhancements and/or improvements.

Performed schema deployment from one database to another and across different servers.

Performed database and schema refreshes using pg_dump.

Extensive knowledge with pgAdmin 4.8 and use as a monitoring tool for PostgreSQL.

Maintained security by using the authentication and authorization methods, creating roles for users, and assigning least privileges to users and auditing for integrity control.

Configure and automate DBA related tasks and cron jobs on crontab using shell scripting.

Provides appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activities and utilization.

Prepared documentation report for reviews activity, progress, and performance reports.

Configured log analysis tools using pgbadger for better visualization of server activity.

Set up and monitor High Availability Solutions using Streaming Replication and repmgr.

Performed database PITR to recover data quickly in case of a disaster.

Configured logical backup using pg_dump, pg_dumpall and physical backup using pgbasebackup and pgbackrest for routine weekly full and incremental backup. Testing backup on test servers.

Knowledgeable on deployment of AWS Cloud Infrastructure.

Performed migration from Oracle to PostgreSQL using ORA2pg (on-prem to on-prem).

Performed database migration from on-premises to cloud using AWS SCT, DMS tools.

Installed and configured connection pooling tools like pgbouncer and pgpool for load balancing.

Automated maintenance activities like vacuum, analyze, to improve query performance.

Run analyze to update the stats on bloated tables and run vacuum on tables when needed.

Experienced setting up and managing PostgreSQL Databases on AWS RDS and EC2 server.

Create and manage PostgreSQL Databases on Amazon Aurora.

Used cloudwatch to monitor databases on AWS cloud.

FANNIE MAE –WASHINGTON,DC

December 2015 – October 2017

POSITION: PostgreSQL Database Administrator

Applied minor patches on PostgreSQL servers.

Installed and configured PostgreSQL versions 9.6 and 10 on Linux Operating System.

Configure and automate backups and cron jobs on crontab.

Performed database upgrades from versions 9.6 to 10 and from versions 10 to 11 using pg_upgrade utility.

Performed migration from Oracle to PostgreSQL using AWS DMS and SCT.

Performed full, incremental backups as regular operations by using third party tool, pgbackrest and automation using shell scripting.

Created and automated database maintenance activities like vacuuming, explain analyze, checking database integrity tasks and rebuild index task.

Monitored the health of databases and analyze performance metrics for performance monitoring.

Managed security using roles and auditing users on a day-to-day access for new users, expiring and resetting passwords of users thus making sure servers are safe and secured.

Impacted system performance by creating indexes, rewriting queries, and adding partitioning on tables.

Configured and monitor High Availability solutions using streaming replication, from one primary to multiple standby servers.

Experienced with analyzing database performance and the ability to recommend enhancements to increase application efficiency, capacity, and responsiveness to users.

Developed, implemented, and documented database architecture and policies to ensure the security and integrity of the databases.

ALLSTATE INSURANCE – NORTHFIELD TOWNSHIP, IL

August 2014 – November 2015

POSITION: Oracle Database Administrator

Successfully installed, configured, and managed Oracle 11.2.0.4, Oracle 10.2.0.5 databases on linux and windows platforms.

Excellent knowledge in Backup and Recovery using RMAN. Experience in applying quarterly patches.

Installed and Configured Oracle a 3 node RAC using ASM.

Upgrade/Migration of Databases from Oracle 11.2.0.1 to 11.2.0.3. and from 11G to 12c.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Performed Database Maintenance Tasks, Rebuilding Fragmented tables, gathering statistics, refreshing materialized views, created partition on tables and maintaining indexes.

Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.

Migrated databases from 10g to 11g R2 and 12C using utilities like export/import, datapump and transportable tablespace.

Implemented replication on databases using Golden gate between homogeneous and heterogeneous databases.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR).

Education and Certifications

AWS Certified Solutions Architect Associate (SAA-C02)

Oracle Certified Associate (OCA 12c)

SQL Fundamentals

BSc. in Sociology, University of Buea- Cameroon (2001)

Contact this candidate