Asonganyi F.

Senior Postgresql Dba @Kaiser Permanente

Oakland, CA, US

PostgreSQL Expertise (Top 10 Highlights)- Deployed and upgraded PostgreSQL versions 9.x to 16 across on-prem and AWS RDS/Aurora PostgreSQL environments- Configured Patroni-based high availability clusters with etcd and streaming replication- Implemented logical replication and pg_upgrade for zero-downtime migrations- Developed automated backup, PITR, and retention strategies using pgBackRest- Tuned PostgreSQL using pg_stat_statements, auto_explain, and pg_partman- Enforced RBAC, SSL/TLS encryption, and enabled pgAudit for compliance and logging- Automated cluster provisioning, patching, and monitoring with Ansible and Bash- Integrated monitoring with Prometheus, Grafana, DataDog, and custom alert scripts- Collaborated with developers for query optimization and schema design- Led migrations of PostgreSQL to AWS with <1% downtime and full data validation.