Marie Hortense Mabou

Sr Postgresql Dba Aws Solutions Architect @Cat Financial

Peoria, IL, US

Installed, configured, and managed PostgreSQL servers and worked recently with PostgreSQL version 12 till 15 on-premises and on AWS platform with RDS for Postgres and Aurora Postgres compatible.• I have migrated Oracle on-premises databases to PostgreSQL using DMS and SCT.• For log analysis I was able to export logs to CloudWatch and used external tools like PgBadger to interpret logs in an HTML format for more detailed visibility • Used custom shell scripts for automated backup with cron jobs and other heavy database operations that require running in the background like indexing and enabling foreign keys on large tables. • Leveraged cloud-based monitoring and logging tools like AWS CloudTrail and Elastic Stack (ELK) for PostgreSQL databases, enabling efficient tracking and analysis of database activities and performance metrics.• • Developed and maintained disaster recovery plans in the cloud and on-premises, including setting up and managing cross-region replication and automated backups in AWS and on-premises, ensuring robust data protection.• Used command line utilities PG_CTL, CREATEDB, SYSTEMCTL, PSQL, INITDB OID2NAME.• Performed routine Postgres database and cluster wide maintenance activities like auto vacuum, vacuum full, Analyze, re-indexing.• Implementing a highly secured environment with the use of config files (Security Group, Hba.conf) and enabling database connections over SSL, enabling data encryptions and deletion protection.• Created users accounts and roles, granted privileges of various levels with recommended best practices and company’s standard.• Experienced in database refreshing/cloning, logical backup using pg_dump/pg_dumpall and physical backup using pg_basebackup with flexible user of Pgbackrest extension used for differential and incremental backups.• I participated in 24/7 on-call rotation for Production Support, Troubleshooting and resolving various types of production issues.

FOTSO VICTOR UNIVERSITY INSTITUTE OF TECHNOLOGIES BANDJOUN

Bachelor's degree