IMCS Group is seeking a skilled engineer with strong experience in PostgreSQL-based HA systems and automation to support Google AlloyDB Omni on VMs. The role involves automating deployment and management of PostgreSQL HA clusters, cluster orchestration, and providing operational support using various tools.
Responsibilities:
- Automate deployment and management of AlloyDB Omni / PostgreSQL HA clusters
- Hands-on experience with:
- Cluster setup, teardown, upgrades & rollback
- HA switchovers, failover & promotion
- DR setup, sync & promotion
- Logical & streaming replication
- Read replicas
- Backup & restore (RTO/RPO focused)
- Start/stop clusters, replace nodes, obtain cluster health/status
- Load balancing and connection pooling
- Performance testing (latency, responsiveness, recovery time)
- Metrics, alerts, dashboards (Prometheus, Grafana)
- Logging (ELK stack)
- SSL certificates, encryption, AD integration
- Execute and validate critical user journeys (CUJs)
- End-to-end testing for reliability, availability & scalability
- Create user guides, playbooks, and technical documentation
- Debug and troubleshoot OSS tooling issues
- Provide deployment and operational support
Requirements:
- PostgreSQL (HA experience mandatory)
- AlloyDB Omni or strong PostgreSQL HA equivalent
- Patroni, etcd
- pgBackRest, pgBouncer
- HAProxy / vip-manager
- Linux (Debian / RHEL)
- Shell scripting
- Python
- Golang
- YAML
- Ansible / Puppet / Terraform
- RPMs, Debian packages
- Linux-based environments
- Prometheus
- Grafana
- ELK (Elasticsearch, Logstash, Kibana)
- Google Cloud exposure
- gRPC / Protobuf
- Experience working with OSS database products at scale
- Prior customer-facing or product engineering collaboration experience