Disaster Recovery Client Service
Resume:
EMMANUEL ANSELME CHEDOM
Email: *********@*****.***
Mobile: +1(202-***-****
SUMMARY:
I have over 12 years of extensive experience as an Oracle Database admin, MYSQL and PostgreSQL DBA. I have knowledge and hands-on experience in database design, migration, upgrades, database security, backup and recovery, cloning, replication, performance monitoring and tuning. I am proficient in an assortment of technologies including Oracle 11g TO 19c and PostgreSQL 10 – 16 An efficient and effective Management professional with several years of vital experience and expertise creating resolutions that encourage innovation and growth. A leader with strong verbal and technical skills, personalized client service experience, decisive decision-making skills and successful track record performing under pressure in a fast-paced, rapid changing environment.
SKILLS:
Design And implement database architecture on premise to avoid single point of failure
Migrations from Oracle to PostgreSQL on premise
Migrations from Oracle to PostgreSQL on AWS RDS Aurora
Disaster recovery- Logical and Physical backups also PITR
High Availability- (Streaming and logical replication, AWS Multi-AZ)
Implement multi-master replication with EDB Postgres Distributed (PGD)
Worked with AWS Cloud Services (EC2, RDS, AURORA POSTGRES)
Golden Gate/Logical-Streaming Replication
Performance Tuning (Partitioning, indexing, Pl/pgsql query optimization, Server tuning)
Postgres security.
Creating a postgres AWS RDS databases and connect..
Troubleshooting connection to the postgres instance.
Implement RDS security and encryption.
Monitor backup in AWS RDS.
AWS RDS replication (read replica) configuration.
Design, configure, and manage EDB Postgres Distributed (PGD) clusters for high availability and disaster recovery
Upgrade in AWS RDS.
TECHNICAL EXPERTISE:
Platforms/Operating Systems •Linux, Solaris, Windows
Backup and Recovery •RMAN, pg_dump, pg_dumpall, Barman, Pgbackrest, Exp,imp,Expdp,impdp
Database Administration •Oracle v11g - 19c /Aurora PostgreSQL/ PostgreSQL EDE-PostgreSQL
language •PL/SQL, python Fundamental, shell scripting, SQL, pg/sql
High Availability/Disaster Recovery •Streaming replication, Pgbouncer with F5, EFM, pgpool,RDS PROXI,v
Applications •Pg_stat_activity, Postgis, pg_class, vacuum, vacuum full, pg_repack, pg _
Cloud •Amazon Web Services(AWS),Iaas,Paas(RDS), SCT, DMS,Lambda function
Knowledge on DevOps tools •Terraform, Ansible, Gitlab,
Monitoring tool •Nagios, Zabbix, PEM, PGbager, cloud wacth, performance insight, DRITA, Dynatrice
EDUCATION:
Bachelor’s (Bachelor's in Mathematics)
PROFESSIONAL EXPERIENCE:
General Dynamic Information Technology GDIT, Windsor Mill MD Jan 2024 – Apr 2025
PostgreSQL / Mysql / Oracle Database Administrator
EnterpriseDB Postgres Distributioed PGD
Design, configure, and manage EDB Postgres Distributed (PGD) clusters for high availability and disaster recovery.
Implement multi-master replication
conflict resolution strategies, and cross-datacenter failover solutions.
Monitor PGD replication performance and troubleshoot issues related to consistency, latency, and node
synchronization.
Optimize distributed database architectures to ensure data consistency and minimal downtime
Work with DevOps and cloud teams to integrate PGD with Debezium Kubernetes, AWS, Azure, and Google
Cloud environments.
Trusted Postgres Architect (TPA):
Deploy and configure EDB Trusted Postgres Advisor (TPA) to automate
Design And implement database architecture on premise to avoid single point of failure
Configured Pg Bouncer for connection pooling and Pg Badger for stats reports.
Participated in 24 X 7 Production & Development database support and administration.
Configured and monitored streaming replication between master and slave.
Ran maintenance auto vacuum jobs and customized vacuum on certain tables.
Creating Postgres RDS and EC2 databases and connect.
Good understanding in Troubleshooting connection to the postgres instance.
Excellent understanding and Implementation of RDS security and encryption.
Monitoring backup in AWS RDS.
Monitoring PostgreSQL database Using ZABBIX
Creating and monitoring AWS RDS replication (read replica).
Monitoring lags in Postgres AWS RDS databases.
Creation of bucket in S3 buckets for data storage.
Management of IAM role.
Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg base backup and Pg backrest and Pg dumpall and Pg dump for logical backups.
Deployed Database security policy and installation, using passwords, privileges and user profiles, Enabled Encryption for databases.
Cloned databases using creation templates and pg dump for testing purposes.
Performed database Refreshes from production environments
Performed PL/PGSQL errors fixes for application issues.
Tuning of SQL statements, optimize stored procedures, analyze query plans, write advanced PL/pgSQL
Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg_base_backup and Pg_backrest and Pg_dumpall and Pg_dump for logical
Cloned databases using creation templates and pg_dump for testing purposes.
Performed patching and upgrades of Databases using AWS minor versions upgrades, pg_upgrade, pg_dumpall and logical replication
Participated in a weekly on call rotation and run packages during off peak hours.
Installed and configured PG versions 9.7, 10.7 and 11.4
Configured PgBouncer for connection pooling and PgBadger for stats reports
Configured and monitored streaming replication between master and slave.
Ran maintenance auto vacuum jobs and customized vacuum on certain tables.
Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg_base_backup and Pg_backrest and Pg_dumpall and Pg_dump for logical backups.
Supported daily administration, monitoring, tuning, and troubleshooting of clusters and single instances on Unix/Linux and AWS Console (Database sizes range 100GB to 25TB)
Monitored CPU utilization, memory, Database Connections and storage space daily using pg_stat_activity, PEM, Pg_view and AWS CloudWatch alarms. Also use customs shell scripts deployed on crontab to monitor performance and resources.
Revised logs for unusual events and performance issues and took appropriate action
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
Automated the provisioning and management of AWS RDS instances using Terraform, ensuring consistent deployments and improving infrastructure as code practices.
Managed AWS RDS instances (PostgreSQL, MySQL, Oracle), including configuring parameter groups, security groups, and automatic backups, optimizing database performance and availability.
Implemented and automated RDS backup processes using Terraform to adhere to company SLAs, ensuring regular and reliable backup schedules for AWS RDS instances.
Configured AWS RDS Read Replicas for performance optimization and disaster recovery, and set up multi-AZ deployments for high availability with automatic failover for PostgreSQL databases.
Ensured AWS RDS security by configuring IAM roles for access control, enabling encryption at rest and in transit, and applying best practices for securing database instances.
Integrated AWS CloudWatch with Terraform for real-time monitoring of RDS performance metrics, ensuring efficient resource utilization and timely alerts.
Credit one Bank Cimarron Rd, Las Vegas, Nevada Nov 2021 – Dec 2023
PostgreSQL / Mysql Database Administrator
Design And implement database architecture on premise to avoid single point of failure
Configured PgBouncer for connection pooling and PgBadger for stats reports.
Participated in 24 X 7 Production & Development database support and administration.
Configured and monitored streaming replication between master and slave.
Ran maintenance auto vacuum jobs and customized vacuum on certain tables.
Championed database migration from Oracle to Azure sql database using ASSM and ADF.
Creating postgres RDS and EC2 databases and connect.
Create endpoint for connection and monitoring in pgadmin.
Good understanding in Troubleshooting connection to the postgres instance.
Excellent understanding and Implementation of RDS security and encryption.
Monitoring of backup in AWS RDS.
Monitoring PostgreSQL database Using ZABBIX
Creating and monitoring AWS RDS replication (read replica).
Monitoring lags in postgres AWS RDS databases.
Creation of bucket in S3 bucket for data storage.
Management of IAM role.
Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg_base_backup and Pg_backrest and Pg_dumpall and Pg_dump for logical backups.
Deployed Database security policy and installation, using passwords, privileges and user profiles, Enabled Encryption for databases.
Cloned databases using creation templates and pg_dump for testing purposes.
Performed database Refreshes from production environments
Performed PL/PGSQL errors fixes for application issues.
Tuning of SQL statements, optmize stored procedures, analyze query plans, write advanced PL/pgSQL
Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg_base_backup and Pg_backrest and Pg_dumpall and Pg_dump for logical
Cloned databases using creation templates and pg_dump for testing purposes.
Performed patching and upgrades of Databases using AWS minor versions upgrades, pg_upgrade, pg_dumpall and logical replication
Participated in a weekly on call rotation and run packages during off peak hours.
Installed and configured PG versions 9.7, 10.7 and 11.4
Configured PgBouncer for connection pooling and PgBadger for stats reports
Configured and monitored streaming replication between master and slave.
Ran maintenance auto vacuum jobs and customized vacuum on certain tables.
Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg_base_backup and Pg_backrest and Pg_dumpall and Pg_dump for logical backups.
Supported daily administration, monitoring, tuning, and troubleshooting of clusters and single instances on Unix/Linux and AWS Console (Database sizes range 100GB to 25TB)
Monitored CPU utilization, memory, Database Connections and storage space daily using pg_stat_activity, PEM, Pg_view and AWS CloudWatch alarms. Also use customs shell scripts deployed on crontab to monitor performance and resources.
Revised logs for unusual events and performance issues and took appropriate action
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
EnterpriseDB Postgres Distributioed PGD
Design, configure, and manage EDB Postgres Distributed (PGD) clusters for high availability and disaster recovery.
Implement multi-master replication,
conflict resolution strategies, and cross-datacenter failover solutions.
Monitor PGD replication performance and troubleshoot issues related to consistency, latency, and node
synchronization.
Optimize distributed database architectures to ensure data consistency and minimal downtime
Work with DevOps and cloud teams to integrate PGD with Debezium Kubernetes, AWS, Azure, and Google
Cloud environments.
Trusted Postgres Advisor (TPA):
Deploy and configure EDB Trusted Postgres Advisor (TPA) to automate
Implemented Dynatrace for proactive database monitoring and performance analysis across Oracle and PostgreSQL environments.
Set up custom dashboards and alerts in Dynatrace to track query performance, memory usage, and system health.
Integrated Dynatrace with incident management tools to enable real-time issue detection and root cause analysis.
Used Dynatrace metrics and logs to support capacity planning and performance tuning for high-availability systems.
.
ISD Los Angeles county - Downey, CA Feb 2020 – Nov 2021
postgresql / Mysql / Mongo DB Database Administrator
Participated in cross platform migrations such as Oracle to PostgreSQL
Documented and assisted in Data MIGRATION from ORACLE Databases to PostgreSQL database on premises and in AWS Cloud.
Involved in Installing/configuring PostgreSQL VERSIONS 9.6 to 14
Manage and monitor databases using pgAdmin and queried using tools like DBeaver and Sql workbench.
Used Ansible tool for automation
Good understanding of Infrastructure as Code (Programmable Infrastructure), and how you can achieve that by using tools Ansible etc.
Proficient in developing Continuous Integration/ Delivery pipelines
Used pgBadger, for Performance TUNING as well as SQL Tuning using EXPLAIN ANAYZE and PG_STAT_ACTIVITY.
Monitoring PostgreSQL database Using ZABBIX
Backup using Commvault
Used shell scripting for repetitive tasks.
Performing BASIC TASKS on OBJECTS such as, creating roles, granting privileges, creating tables.
Implementing the use of indexes, and primary & foreign key constraints as required
Providing PRODUCTION SUPPORT based on a ticketing system.
Specific hands-on experience includes administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full text indexing, and Database Application Development using varied development tools.
Hot and Cold Backups, Disaster Recovery Planning, Security Management, Managing server and clients, Pg/pgsql, Stored Procedures, Functions and Cursors and Triggers etc.
Assisted in defining and implementing MAINTAINANCE PLAN for the database systems.
Performing maintenance activities like vacuum, vacuum full, analyze etc.
Configured PgBouncer for connection pooling and 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
Upgrading database version (pg_dump/pg_restore and pg_upgrade).
Migration of databases from Oracle10G,11g and 12c to PostgreSQL and applied patches whenever required.
Implemented Data Pump, conventional export/Import Utility of Oracle 11G,10G for reorganizing and cloning/databases in 10G/11G/12C environments.
Performed databases refreshes from Production to UAT and DEV
Monitored different databases and applications servers using ORACLE ENTERPRISE MANAGER (OEM) 10G, 11G GRID CONTROL, AND CLOUD CONTROL 12C
Worked extensively on performance tuning of queries by maintaining aggregates, compression, partition, indexing, hints, store procedures and statistics.
Experienced in writing UNIX/SHELL SCRIPTS for reports and custom jobs.
Successfully implemented hot and cold backups& recovery using RMAN.
Performed monthly and annual performance reports for trend analysis and capacity planning.
Pfizer - Peapack, NJ Feb 2012 – Jan 2019
Oracle/Postgresql DBA
Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production Postgresql databases within the organization.
Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within and outside the database environment.
Migration of Data from Reports generated by various vendors into Postgresql Databases using Postgresql Export/Import Procedures.
Maintaining custom vacuum strategies for high volume databases.
Experience with ORA2PG, a tool for migrating database from oracle to PostgreSQL.
Database migration while upgrading databases versions .
Extensive experienced with warm standby and hot standby.
Ability to proactively identify, troubleshoot and resolve live database systems issues.
Configured PostgreSQL databases to replicate across multiple sites using REPMgr and streaming replication
Hand on experience on performance tuning, index maintenance on Postgresql database on a regular daily basis.
Linked database security controls to external authorization sources to provide row-level security.
Ability to efficiently database code without compromising data quality, privacy or security.
Responsible for regular backups and recovery of databases in Postgresql environment
Responsible for regular maintenance on databases (e.g, vacuum, reindexing, archiving) .
Responsible for query tuning and preventative maintenance
Performing other duties as assigned
Participate in a 24H * support rotation
Responsible for pro active remediation of database operational problems in Postgresql environment
Responsible for the monitoring and uptime of all production databases.
Upgrade and migration of database from 10g 11g and then 12c and also applying patches whenever required
Implementing datapump conventional import/export utility of oracle of oracle 11g, 10g for re-organizing database /schema/tables to improve the performance and cloning/migration of database in 10g /11g and 12c environments
Performed database refresh from production to QA, UAT, and development database
Loading data from flat files to database using sql*loader, external tables.
Monitored different databases and application server using oracle enterprise manager (OEM) 10g, 11g control and cloud control 12C
Implemented and managed optimum physical database design (tablespaces, data files, extents, redo logs, archive logs) and assessed data capacity by monitoring online storage,growth and files system space
Worked on automatic storage management (ASM) with EMC storage for managing data in san
Worked extensively on performance tuning of query by maintaining aggregate, compression, partition, indexing and use of stored outlines, statistics.
Extensively used AWR, ADDM and explain plan for periodic performance tuning
Provided instance level performance monitoring and tuning for event waits sessions physical and logical I/O and memory usage
Experience in writing Unix/shell scripts for providing the reports
Created a clone database using RMAN on remote server and used SRVCTL commands for real application cluster (RAC) databases
Successfully implemented backup & recovery using RMAN which includes hot backups and cold backups
Implemented DATA GUARD with high availability and performance configurations and participated in DATA GUARD FAIL OVER tests
Responsible for the smooth functioning of all ecommerce activities of the organization
Performing monthly and annual performance reports for trend analysis and capacity planning
Contact this candidate