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.
Responsibilities
- 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.
Required Skills
- PostgreSQL administration
- Linux administration
- Postgre
- SQL installation and configuration
- Database upgrades and migrations
- Patronietcd
- HAProxy
- Keepalived
- Streaming replicationpg
- Back
- Rest and WAL archiving