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 Memory store for Redis, AlloyDB, Spanner and Big Query 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 Git Hub 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), Memory store (Redis/Valkey), AlloyDB, Spanner, and Big Query.
• Manage large transactional replication with low‑latency delivery; use Big Query as a replication target and tune performance/cost.
• Implement database changes via IaC (Terraform with Git Hub 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 Big Query 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.