Fabrice Ngouze

• Planning, Installation, configuration and maintenance of PostgreSQL 12, 14 and MySQL 8 series on EC2, RDS, and Linux (Cent-OS, Debian).
• Taking Backup of PostgreSQL, MySQL Databases running on AWS RDS using pg_dump, mysqldump, mydumper, AWS Lambda & AWX Backup, RDS Snapshot. pg_backrest.
• Configuration of MS SQL Server Option group called "Native-backup -restore" to backup MS SQL databases running on AWS RDS. and store in S3 bucket.
• Creating IAM Users, KMS Keys, VPC, Security group, Parameter group etc.
• Cross-datacenter disaster recovery and backup architecture
• In place upgrade PostgreSQL /MySQL databases from version 10 to 12, 12 to 14, 5.7 to 8.0.2.
• Monitoring my databases using Dynatrace, Performance Insights, Enhanced monitoring, CloudWacth.
• Troubleshooting and resolving database integrity issues, performance issues associated with cache missed, bloat, temp_files, deadlocks, locks, frequent checkpoints, index corruption, latency due to table size, full storage, extension not present in rsd.allow_extensions, CPU spike, conflicts, Index fragmentation using

Performance Insights, Pg_stat_activity, pg_locks, pg_stat_database,

pg_stat_bgwriter, pg_stat_user_index, pg_stat_all_tables, EXPLAIN, performance and sys schemas.

• Reviewing of scripts submitted by development team and working Data analysts, developers, and project managers to perform capacity planning required to create and maintain databases.
• Managing and providing end-to-end support and problem resolution for SQL Server, MySQL & PostgreSQL databases through multiple lifecycle environments such as Sandbox, development, staging and production systems.
• Controlling and establish appropriate database security best practice.
• Enable login and configure pgbadger to analyze results of benchmarks in order to proactively address potential and existing database issues.
• Modification of RDS databases.
• Documenting resolved issues and update our Confluence as needed to help CloudOps Team with how to database resolve known issues.
• Moving data using COPY Commands,
• Using GitLab for CI/CD, Terraform to build and manage RDS MySQL/PostgreSQL.
• Working with DEVOPS Team to address database readiness after a new deployment.
• Memory management, thread and tasks managements, buffer management and configure tempdb, MAXDOP, MAX Server Memory, Min memory per query etc. for MSSQL Server database optimization.
• effectively configured MySQL and PostgreSQL replication as part of HA/DR Staging/Production.
• MySQL / PostgreSQL RDS Backup to S3 using native tools to s3 bucket, RDS point in time restore, RDS Snapshots.
• Handling replication and failover with Patroni for PostgreSQL.
• MySQL/PostgreSQL/MSSQL performance tuning on Daily basis.
• Building AWS RDS read replica and cross region replication HA, DR.
• Configuration of pg_cron extension to automate our AWS RDS db maintenance tasks like VACUUM ANALYZE, REINDEX, CLUSTER.
• Write Ansible playbooks as needed to automate database maintenance activities (ANALYZE, OPTIMYZE, VACUUM, REINDEX) and backups of PostgreSQL, MySQL, MSSQL.
• Cross datacenter migration,
• Experience using Thales Encryption.
• Scheduled SQL agents to resolve issues with Index fragmentation & kill sleeping processes on MSSQL SERVER databases.
• On 24X7 call rotation for database support using PagerDuty.
• Using Jira software on daily basis.

• Created IAM user accounts and role-based policies for access to AWS Postgres on Both RDS and EC2 Instances,Compared custom and default parameters group
• Defined AWS Security Groups which acted as virtual firewalls that controlled traffic allowed to reach one or more AWS EC2 instances;
• Managed Space and Storage of Databases through various Shell Scripts scheduled in crontab periodically in regular intervals;
• Performed database Refreshes and monitored replication delays;
• Highly experienced in Configuration, Implementation and Maintenance of Log Shipping;
• Moved data using COPY COMMAND
• Database security with Row level security, search path, pg_hba.conf and postgresql.conf, my.cnf and GLOBAL Variables.
• Installed and configured MTK for migration from MySQL to PostgreSQL and EDB advance server;
• Maintained PostgreSQL with PgAdmin 4, psql, mysql.
• Created tablespace, databases, indexes, moving data, granting of necessary privileges in PostgreSQL and EDB advance server from 9.6 to 12.x.
• Performed backup, restore, and created databases using PgAdmin 4, pg_dump and pg_basebackup, pg_backrest, Mydumper, Mysqldump, RDS Snapshots etc.
• Tuned autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
• Provided response for all system / database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours;
• Worked with development and operations teams to tune production queries for optimal performance;
• Configuring monitoring tools for better performance like PEM, CloudWatch, Performance Insight, PostgreSQL logs.
• Proactive in updating latest security patches to database, which are provided by PostgreSQL open-source community;
• Monitored database for Index, partitioning Memory and I/O utilization;
• Converted databases from MyISAM format to Innodb storage engine for databases that needed greater referential integrity.
• Configured Enterprise Failover Manager for fast database failover, and integrate that with pg_pool-II for connection pooling and load balancing to resolve issues with locks and deadlocks.
• Experience using ansible for backups automation, GitLab for CI / CD, terraform to build, manage and destroy EC2 and RDS databases
• Instance type recommendation for cost optimization,
• RDS Read replicas creation, cross region replication for DR.
• Parameter Group, postgresql.conf, my.cnf codification for database optimation and cost optimization.
• upgraded various databases from MySQL 5.7.* to MySQL 8.0/8.2.*
• upgraded PostgreSQL from 9.6 to 11, from 11 to 13 on RHEL7/AWS RDS
• Homogeneous migration from RHEL7 on-prem and EC2 to AWS RDS for PostgreSQL and MySQL to RDS MySQL, RDS PostgreSQL and RDS Aurora PostgreSQL compatible using Data Migration Service and Migration Tool-kits (MTK).
• contribution in designing database, creating database schema, tables, indexes, Views and Materialized Views.
• Used SNOW (Service Now) for queue system.
• 24/7 on-call rotation
• Performance tuning on daily basis.
• Production support.

• Maintained detailed technical documentation of database architecture and modeling as per business requirements;
• Provided technical assistance for preparation of shell scripts for tasks automation;
• Conducted complete analysis of database capacity and performance requirements;
• Implemented procedures for analysis, consolidation and tuning of

databases for efficiency;

• Implemented Database replication for PostgreSQL HA/DR.
• Configure EFM (Enterprise Failover Manager) to manage and monitor replication and auto-Failover.
• Configured pgbouncer for connection pooling, pg_bacrest for backups.
• Experience using HA proxy for connection pooling and load-balancer.
• Performed database maintenance tasks like vacuum, analyze vacuum full, reindex, cluster, create indexes etc.
• Monitored database and performance using Datadog;
• scheduled my jobs using crontab.
• Plans and coordinates administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines
• Establish and maintain security and integrity controls
• Provides appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization
• Prepares and/or reviews activity, progress, and performance reports

• Set up and controlled user profiles and access levels for each database segment to protect important data.
• Tested programs and databases to identify issues and make necessary modifications.
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
• Created and implemented database designs and data models.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and production PostgreSQL databases within organization;
• Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access;
• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures;
• Manage Space and Storage of Databases through various Shell Scripts scheduled in crontab periodically in regular intervals;
• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures;
• During production hours, resolved lock/deadlocks and resource contention issues;
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• pg_dump, pg_basebackup, X-TRA backup, mydumper and msqldump for logical and physical backups.
• Monitored my databases using solarwinds;
• created MySQL and PostgreSQL Databases;
• Familiarity with psql, DML, DDL, DCL etc.
• Performed MYSQL daily Maintenance tasks and performance tuning.
• reload/refresh privileges or grants tables;
• started, stopped and reloaded my databases.
• Database security with row level security, search_path, pg_hba.conf and Postgresql.conf.