BRICA NGHOMBUOCHE
DATABASE ADMINISTRATOR
Bamenda,Cameroon
Summary
With over 4 years of experience as a PostgreSQL database administrator in a production environment, I possess extensive knowledge and hands-on expertise in all facets of database management. From design to migration, upgrades, and security, I have successfully handled tasks including backup and recovery, cloning, replication, monitoring, and tuning. My daily activities focus on ensuring database security, managing replication processes, implementing PITR (Point-in-Time Recovery), executing smooth migrations and upgrades, applying patches, and optimizing performance.
Overview
4
4
years of professional experience
Work History
PostgreSQL Dba
Afriland First Bank
02.2020 - 09.2024
- Configured Repmgr for streaming replication between primary and standby
- Installed and configured PostgreSQL versions 9, 10, 11 and 12
- Ran maintenance jobs like vacuum, reindexing on certain tables
- Performed minor and major upgrade of the PostgreSQL server
- Rewrite and implemented a backup strategy following company SLA; execution of backup schedule for both physical backups using Pg_basebackup and Pg_backrest and Pg_dumpall and Pg_dump for logical backups
- Supported daily administration, monitoring, tuning, and troubleshooting of clusters
- Monitored CPU utilization, memory, Database Connections and storage space daily using pg_stat_activity, and Pg_view
- Also use customs shell scripts deployed on crontab to monitor performance and resources
- Done database migration from Oracle to PostgreSQL on premises and on AWS, using Ora2pg, DMS and SCT
- Configuring third client software pgadmin4 and Dbeaver to access the PostgreSQL server
- Revised logs for unusual events and performance issues and took appropriate actions
- Implemented table and index partitioning to improve query speed
- Participated in capacity planning meetings to meet the demands of the dynamic aspects of storage and memory for the databases
- Hands on experience on Ansible to automate repetitive tasks, quickly deploy critical application, and proactively manages change
- Monitored Resources and Applications using AWS Cloud Watch, Performance Insight, and Enhanced monitoring, including creating alarms to monitor metrics such as EBS, EC2, , RDS, S3 Create users, roles and grant necessary privileges, revoke privileges and expire passwords as necessary.
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Optimized database performance by monitoring health and implementing tuning recommendations.
- Trained junior team members on best practices for database administration, promoting a culture of continuous learning within the organization.
- Set up and controlled user access levels across databases to protect important data.
- Built databases and table structures for web applications.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Maintained high levels of customer satisfaction by consistently meeting service level agreements for database performance and availability.
- Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions as necessary.
- Created a robust disaster recovery plan to ensure business continuity in the event of hardware failures or natural disasters.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Standardized database object naming conventions across multiple systems, resulting in easier management of objects during troubleshooting sessions.
- Ensured high availability and disaster recovery capabilities, establishing and testing robust backup and failover strategies.
- Facilitated seamless migrations and upgrades, meticulously planning and executing database changes with minimal impact on users.
- Reduced system downtime significantly, employing proactive monitoring and maintenance of database systems.
- Implemented security measures to protect vital business data.
DATABASE ADMINISTRATOR
Afriland First Bank
1 2018 - 03.2020
- Installed, configured, and managed PostgreSQL servers and worked recently with PostgreSQL Version 10.x, 11.x and 12.x Community and Enterprise editions
- Participated in a 3months Migration project from Oracle to PostgreSQL on premise and in AWS cloud using tools, Ora2pg, AWS DMS to Migrate data/databases
- Used Postgres native tools like pgBadger, pgpool/pgbouncer, as well as AWS feature like AWS performance Insight to tune my Postgres Databases running on-prem and in cloud
- Backup PostgreSQL databases using tools like pg_basebackup for physical backups and pgBackRest for incremental and differential backups as well as pg_dump and pg_dumpall for logical backups and Refreshes
- Setup EnterpriseDB Failover Manager (EFM) on a PostgreSQL server to monitor streaming replication Between Setup HA solution Streaming Replication (including cascading replication) between Master and two slaves on a PostgreSQL Server for disaster recovery, high availability, and load balancing
- Pg_stat_activity, Pg_view and AWS Cloud Watch alarm
- SAlso use customs shell scripts deployed on crontab to monitor performance and resources
- Performed Complete and PIT recovery on PostgreSQL cluster
- Used AWS Management console to Configured and Managed PostgreSQL database instances on Amazon RDS
- Vacuum/vacuum full, Analyze, reindexing and monitor space utilization on pg_wal/pg_xlog
- Used client-side applications like pgAdmin and psql to connect and manage PostgreSQL databases on-premise and on cloud
- Create Security groups to control incoming and outgoing traffic from PostgreSQL Database Instances in AWS cloud
- Automate daily full backup and manual snapshot backups
- Optimize postgres instances in AWS cloud Using native tool and AWS performance insight Setup logical Replication on a PostgreSQL Cluster to replicate specific tables and schemas, using publication and subscription
- Upgraded PostgreSQL database servers from Version 10.x to 11.x and from 11.x to 12.x using pg_dump, pg_restore and pg_upgrade
- Experienced in launching the PostgreSQL database on AWS RDS and EC2 instances from Console and CLICreated and used AWS Identity and Access Management (IAM) to maintain user accounts (IAM) and assigned restricted policies to users and groups as needed
- Used AWS Data Migration Service (DMS) and Schema Conversion Tool (SCT) to migrate database and schemas/schema objects from local datacenters to RDS in AWS cloud as well as migration of database from oracle in RDS to PostgreSQL running on an EC2 instance in AWS cloud
- Monitored Resources and Applications using AWS Cloud Watch, Performance Insight, and Enhanced monitoring, including creating alarms to monitor metrics such as EC2, RDS, S3
- Hands on experience deploying and configuring AWS VPCs, IAM Roles, S3 buckets, Ansible, CloudFormation and other services.
FedEx
01.2014 - 01.2015
- Installing and Configuring PostgreSQL from source or packages on Linux machines
- Experience designing database structures, indexes, views, partitioning
- Implementing backup and recovery (Logical and Online)
- Controlling migrations of programs, data base changes, reference data changes and menu changes through the development life cycle
- Setup and maintenance of Postgres master-slave clusters utilizing streaming replication Cross-datacenter disaster recovery and backup architecture Performing schema management, database sizing, maintaining privileges
- Data migration while upgrading database versions ranging from 8.2 to 9.5
- Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater)
- Scheduled maintenance activities to vacuum, analyze to improve the query response time
- Pg_stat_activity, Pg_view and AWS Cloud Watch alarms
- Also use customs shell scripts deployed on crontab to monitor performance and resources.
Education
BBA - Accounting And Finance
University of Bamenda
Bamenda, Cameroon 05.2001 -
Skills
Installed, configured, and managed PostgreSQL servers, PostgreSQL Version 10x,11x,12x, 13x
PostgreSQL Security, roles, group roles and row level security, privileges, Ansible
HA solution, Streaming Replication, Setup logical Replication, configure Repmgr
pgBadger, pgbouncer, Teradata, pg_basebackup, pgBackRest, pg_dump, pg_dumpall, pgAdmin 4
Linux Operating System
Database Performance Tuning
Database Security Management
Documentation And Reporting
Database Troubleshooting
Backup and Recovery Strategies
SQL Query Optimization
Running backups
Cloud Database Management
Performance monitoring tools
Database Administration
Relational Database Management
High Availability Solutions
Implementing security measures
Disaster Recovery Planning
Database Schema Design
Indexing and Partitioning
Teamwork and Collaboration
Problem-Solving
Time Management
Excellent Communication
Team Collaboration
Critical Thinking
Timeline
PostgreSQL Dba
Afriland First Bank
02.2020 - 09.2024
FedEx
01.2014 - 01.2015
BBA - Accounting And Finance
University of Bamenda
05.2001 -
DATABASE ADMINISTRATOR
Afriland First Bank
1 2018 - 03.2020
Languages
English
Advanced (C1)