I will provide postgresql dba support and patroni high availability
Oracle and SQL Server DBA, RAC and HA specialist
About this Gig
Need a PostgreSQL DBA for setup, tuning, or high availability? I build and support PostgreSQL clusters on RHEL 9 using Patroni 4.x, etcd, HAProxy, PgBouncer, and streaming replication.
I configure automated failover, connection pooling, read/write routing, database roles and secure access. I troubleshoot replication, node synchronization, and service issues, and provide query tuning, backup and restore, WAL archiving, point-in-time recovery (PITR), and disaster recovery planning.
My hands-on work includes air-gapped deployments and production-ready clusters. I validate failover and recovery procedures against agreed RTO/RPO targets.
Send your PostgreSQL and Patroni versions, operating system, node count, symptoms, and target outcome. Remove passwords and sensitive data. I will confirm scope, access, deliverables, and timing before production changes.
FAQ
Can you troubleshoot slow PostgreSQL queries?
Yes. I can review a PostgreSQL performance issue and provide findings or tuning recommendations. Share the query, execution plan, PostgreSQL version, and relevant context with sensitive data removed.
Can you configure PostgreSQL high availability with Patroni?
Yes. I can help deploy or troubleshoot a PostgreSQL HA cluster using Patroni and the agreed components, such as etcd, HAProxy, PgBouncer, and streaming replication. Scope depends on your nodes and access requirements.
Do you support PostgreSQL backup and point-in-time recovery?
Yes. I can help with PostgreSQL backup and restore, WAL archiving, and point-in-time recovery (PITR). Share your current backup method, retention needs, PostgreSQL version, and recovery objectives so we can confirm scope.
Can you troubleshoot PostgreSQL replication or failover issues?
Yes. I can investigate PostgreSQL replication, Patroni failover, node synchronization, and related etcd or service dependency issues. Please share symptoms and logs with credentials and sensitive data removed.
What details do you need before starting PostgreSQL work?
Please share PostgreSQL and Patroni versions, operating system, cluster node count, the issue or goal, relevant logs or query plans, and your RTO/RPO if applicable. Remove passwords and sensitive data.

