Summary
Overview
Work History
Education
Skills
Timeline
Generic

HENRY CHAPBEJONG

Columbus,OHIO

Summary

Senior database administration expert with over 5 years of comprehensive experience in PostgreSQL environments. Proficient in database architecture, migration, upgrades, security implementation, backup and recovery procedures, cloning, replication, monitoring, performance tuning, and automation.

Overview

6
6
years of professional experience

Work History

Senior Database Administrator

Landmasters
Newark, OH
01.2023 - 09.2024
  • Deployed, set up, and administered PostgreSQL servers, working with recent versions 15.x and 16.x in both Community and Enterprise editions.
  • Employed native PostgreSQL tools (pgBadger and pgpool/pgbouncer) and AWS features like Performance Insight for database optimization, both on-premises and in the cloud.
  • Contributed to a 4-month migration initiative, transitioning from Oracle to PostgreSQL both on-premises and in AWS cloud, utilizing tools such as Ora2pg, AWS DMS, and SCT.
  • Implemented various backup strategies for PostgreSQL databases, including physical backups with pg_basebackup, incremental and differential backups with pgBackRest, and logical backups using pg_dump and pg_dumpall.
  • Deployed continuous integration/continuous deployment (CI/CD) pipelines for database changes using GitHub Actions.
  • Utilized pg_stat_activity, Pg_view, AWS CloudWatch alarms, Prometheus, and Grafana for resource monitoring. Also, use custom shell scripts deployed on crontab to monitor performance and resources.
  • Managed PostgreSQL database instances on Amazon RDS using the AWS Management Console.
  • Employed client applications like pgAdmin and psql for PostgreSQL database management, both on-premises and in the cloud.
  • Performed maintenance tasks such as vacuum/vacuum full, analyze, reindexing, and monitored space usage in pg_wal/pg_xlog.
  • Gained hands-on experience with various AWS services, including VPCs, IAM Roles, S3 buckets, Ansible, and CloudFormation.
  • Monitored resources and applications using various AWS tools and created alarms/alerting using AWS CloudWatch and SNS.
  • Deployed database security policy and installation, using passwords, privileges, and user profiles. Enabled encryption for databases.
  • Managed AWS IAM for user accounts and policy assignments.
  • Launched PostgreSQL databases on AWS RDS and EC2 instances via Console and CLI.
  • Implemented data encryption at rest using pgcrypto and in transit using SSL.
  • Upgraded PostgreSQL database servers from version 15.x to 16.x.
  • Configured logical replication for specific tables and schemas using publication and subscription.
  • Automated daily full backups and manual snapshot backups for PostgreSQL Advanced Server databases in the cloud.
  • Established read replicas on Amazon RDS PostgreSQL for improved read scalability.
  • Created AWS security groups to regulate network traffic for PostgreSQL instances.
  • Set up Repmgr for streaming replication between primary and standby servers.

Database Administrator

Landmasters
Harbor Springs, MI
07.2020 - 11.2023
  • Deployed, set up, and administered PostgreSQL servers, working with recent versions 13.x, 14.x, and 15.x in both Community and Enterprise editions.
  • Executed maintenance tasks, including vacuuming and reindexing, on specific tables.
  • Conducted minor and major PostgreSQL server upgrades from version 14.x to 15.x, and from 15 to 16.
  • Redesigned and implemented backup strategies adhering to company SLAs, including physical backups (pg_basebackup, pg_backrest), and logical backups (pg_dumpall, pg_dump).
  • Deployed pg_repack for managing dead tuples and bloated tables.
  • Deployed continuous integration/continuous deployment (CI/CD) pipelines for database changes using GitHub Actions.
  • Set up Repmgr for streaming replication between primary and standby servers.
  • Monitored performance of queries and tuned them as needed using Explain Plan tool.
  • Managed user accounts, roles, and privileges in accordance with security policies.
  • Provided support for daily administration, monitoring, tuning, and troubleshooting of database clusters.
  • Participated in database migration projects from Oracle to PostgreSQL, both on-premises and in AWS. Using Ora2pg for on-premises and SCT/DMS for AWS.
  • Utilized Ansible for task automation and application deployment.
  • Monitored AWS resources and applications, creating alarms for various metrics using CloudWatch and SNS.
  • Engaged in capacity planning to address dynamic storage and memory requirements.
  • Analyzed logs using a tool like pgbadger for anomalies and performance issues, taking appropriate actions.
  • Implemented table and index partitioning to enhance query performance.
  • Configured third-party client software like pgAdmin4 and DBeaver for PostgreSQL access.
  • Performed regular health checks on all databases to ensure optimal performance levels are maintained.
  • Coordinated with other teams such as network administrators and system admins for resolving complex issues.
  • Assisted in disaster recovery planning by testing various backup strategies and scenarios.
  • Analyzed database applications and made necessary adjustments to parameters and architecture to improve performance.
  • Communicated with data architects, programmers and engineers to keep projects on track.
  • Provided technical support and training to end-users and junior DBAs.

Junior Database Administrator

Eddie Bauer
Seattle, WA
01.2019 - 06.2020
  • Assist in day-to-day management of PostgreSQL databases.
  • Perform basic backup and recovery operations.
  • Monitor database performance and space utilization.
  • Provide first-level support for PostgreSQL databases on cloud platforms (e.g., AWS RDS, DynamoDB for PostgreSQL).
  • Assist in monitoring cloud database instances using CloudWatch and Performance Insights.
  • Help with basic cloud-specific tasks like instance scaling and parameter group management.
  • Help with database migrations between on-premises and cloud environments using tools like Ora2pg, SCT, and DMS. Contribute to testing and validation of migrated data.
  • Help with schema conversions and data transformation.
  • Contribute to the documentation of database processes and procedures.
  • Implement and manage backup strategies for PostgreSQL databases.
  • Assist in disaster recovery planning and testing.
  • Assist in managing database roles and permissions.
  • Monitor database performance using tools like pg_stat_statements and pgBadger.
  • Help develop and maintain scripts for routine PostgreSQL administrative tasks.
  • Assist in implementing automation tools like Ansible for database management.
  • Contribute to continuous integration/continuous deployment (CI/CD) pipelines for database changes using GitHub Actions.
  • Help monitor and troubleshoot replication processes.
  • Contribute to high availability solutions implementation by creating read replicas in different AZs.
  • Help monitor and analyze database resource utilization in cloud environments using CloudWatch.
  • Assist in identifying opportunities for cost savings.

Education

Bachelor of Science - Accounting And Computer Science

University of Buea
Buea, Cameroon
09-2018

Skills

  • PostgreSQL Server Management (Versions 13x, 14x, 15x, 16x)
  • Operating Systems: Linux, Windows; Shell Scripting
  • Performance Optimization, Backup & Recovery, Troubleshooting, Security
  • PostgreSQL Security, Role Management, Row-Level Security, Privileges, Ansible, Terraform
  • High Availability Solutions, Streaming Replication, Logical Replication, Repmgr Configuration
  • Tools: pgBadger, pgbouncer, pg_basebackup, pgBackRest, pg_dump, pg_dumpall, pgAdmin 4, Promatheus, Grafana, pgRepack, pgUpgrade, SCT, DMS
  • Documentation And Reporting
  • Data testing

Timeline

Senior Database Administrator

Landmasters
01.2023 - 09.2024

Database Administrator

Landmasters
07.2020 - 11.2023

Junior Database Administrator

Eddie Bauer
01.2019 - 06.2020

Bachelor of Science - Accounting And Computer Science

University of Buea

Similar Profiles

  • Jared Emory

    Jared EmoryJared Emory

    Employee Safety Manager at Landmasters IncEmployee Safety Manager at Landmasters Inc

    View Profile
  • Linda Grant

    Linda GrantLinda Grant

    Landscape Worker at LandMasters Inc., Gastonia,N.C.Landscape Worker at LandMasters Inc., Gastonia,N.C.

    View Profile
  • Ilyn Mae Giganto

    Ilyn Mae GigantoIlyn Mae Giganto

    Sales Support at Cebu Landmasters Inc.Sales Support at Cebu Landmasters Inc.

    View Profile
HENRY CHAPBEJONG