Senior PostgreSQL Database Administrator

Join Allstate’s Database Engineering team to build, operate, and modernize enterprise PostgreSQL platforms across on-premises and cloud environments. Design and support database infrastructure, high availability, disaster recovery, security, performance, automation, and production operations while partnering with engineering teams. Design, deploy, administer, and support PostgreSQL environments across production and non-production systems. Lead PostgreSQL installation, configuration, patching, upgrades, migrations, and lifecycle management. Design and test high-availability, disaster-recovery, backup, and recovery solutions. Monitor database health, capacity, and performance; optimize SQL, indexes, execution plans, and configurations. Implement database security controls, access management, encryption, auditing, and compliance support. Develop operational automation and documentation, respond to incidents, and mentor engineers. PostgreSQL administration Linux administration PostgreSQL installation and configuration Database upgrades and migrations Patroni etcd HAProxy Keepalived Streaming replication pgBackRest and WAL archiving