Jacques Fozao

Sr Postgresql Database Administrator @DailyPay

Birmingham, GB

As a Senior PostgreSQL and SQL Server DBA, I led cloud and on-premises database initiatives to ensure high availability, performance, and security for mission-critical systems. I collaborated with Engineering, DevOps, and Technical Operations teams to design, deploy, and optimize scalable database solutions across AWS.Key Responsibilities:• Led migrations from EC2-hosted PostgreSQL to AWS Aurora and RDS using DMS and SCT• Designed and implemented streaming replication, logical replication, and disaster recovery strategies, including backup and restore testing.• Conducted query analysis, schema optimization, indexing, and performance tuning for PostgreSQL and SQL Server.• Automated provisioning, monitoring, and deployments using Terraform, Bash, and CI/CD pipelines.• Implemented monitoring with pganalyze, CloudWatch, and DataDog; performed log management, disk space optimization, and bloat monitoring.• Performed logical and physical backups, restored PROD backups to UAT/DEV, and maintained data integrity.• Installed, configured, and managed database instances, schemas, tables, users, and security.• Authored runbooks and operational guides, and collaborated with DevOps and developers to optimize queries and deployments.• Maintained uptime and ensured compliance with security and performance standards.

Birmingham City University

Master's degree, Mathematics

Birmingham City University

Master’s Degree, MATHEMATICS