remote
PostgreSQL, WAL Archiving, Streaming Replication/Senior Consultant Specialist
Software Engineer
Senior consultant specializing in PostgreSQL database administration, focusing on WAL archiving, streaming replication, and cloud infrastructure automation using Ansible, AWS, and Azure.
About the role
Key Responsibilities
- Design, implement, and maintain PostgreSQL high‑availability solutions using WAL archiving and streaming replication.
- Automate database provisioning, configuration, and lifecycle management with Ansible across AWS and Azure environments.
- Develop and enforce access control policies, ensuring compliance with security standards and audit requirements.
- Monitor performance, troubleshoot replication lag, and optimize query execution for large‑scale workloads.
- Collaborate with development and operations teams to integrate database changes into CI/CD pipelines.
Requirements
- 5+ years of hands‑on experience with PostgreSQL administration, including WAL archiving and streaming replication.
- Proficiency in Ansible for infrastructure as code and automation.
- Strong knowledge of AWS and Azure services related to database hosting and security.
- Experience implementing access control, role‑based security, and audit logging in cloud environments.
- Excellent problem‑solving skills and ability to work independently on complex technical challenges.
Skills
postgresqlansibleawsazure