PostgreSQL Database Administrator

8+ years of prior work experience Experience in administering and optimizing PostgreSQL Server environments, including expertise in transactional replication. Experience with GCP CloudSQL PostgreSQL and knowledge of PostgreSQL database management. Experience in Memorystore for Redis, AlloyDB, Spanner and BigQuery preferred. Experience with other cloud-based database technologies or platforms, such as Azure SQL or AWS RDS, preferred. Experience with Infrastructure as Code tools such as Terraform and version control systems like GitHub for managing database infrastructure changes. Experience with high-availability architectures, disaster recovery planning, and execution. Duties/Responsibilities Administer and optimize high‑volume PostgreSQL systems (including Cloud SQL) in highly available environments. Design and own Terraform modules for GCP databases: Cloud SQL (PostgreSQL), Memorystore (Redis/Valkey), AlloyDB, Spanner, and BigQuery. Manage large transactional replication with low‑latency delivery; use BigQuery as a replication target and tune performance/cost. Implement database changes via IaC (Terraform with GitHub PRs) following performance, security, and reliability best practices. Establish backup/restore, PITR, HA/failover testing, DR runbooks, and an overall database support plan. Collaborate with engineering teams on schema reviews, query optimization, and BigQuery governance. Handle security and audit tasks; respond to support requests and data change needs promptly. Support incident response and participate in on‑call rotations (including off‑hours, Central Time) and scheduled maintenance such as patching, large data scripts, VLDB index work, and DR testing. #J-18808-Ljbffr Insight Global