A leading staffing solutions provider located in Austin, Texas is seeking an experienced Database Administrator to optimize high-volume PostgreSQL systems and design Terraform modules for GCP databases. The ideal candidate should have over 8 years of experience in database administration and be comfortable managing large transactional replications. This role offers competitive compensation at $70 - $80 per hour for a 12-month contract with a focus on collaboration and support responsibilities.
Qualifications
8+ years of prior work experience required.
Experience administering PostgreSQL server environments and transactional replication.
Knowledge of GCP and cloud-based database technologies preferred.
Responsibilities
Administer and optimize high-volume PostgreSQL systems.
Design and own Terraform modules for GCP databases.
Manage large transactional replication with low-latency delivery.
Skills
PostgreSQL
Terraform
BigQuery
Analytical skills
Collaboration
Education
8+ years of experience in database administration
Tools
Cloud SQL
Memorystore for Redis
GCP
GitHub
Job description
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.
Education and/or Experience
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.
Required Skills/Abilities
Ability to work independently and manage multiple priorities in a fast-paced environment.
Excellent verbal and written communication skills.
Strong analytical and troubleshooting skills with attention to detail.
Strong collaboration skills and the ability to work effectively with cross-functional teams.
Expertise in Memorystore for Redis, AlloyDB, Spanner and BigQuery preffered.
Familiarity with cloud-based database systems, preferably Google Cloud Platform (GCP).
Familiarity with DevOps methodologies, Terraform and CI/CD pipelines.
Knowledge of GCP BigQuery, including performance tuning and administrative capabilities.
Knowledge of programming and scripting knowledge for automation.
Willingness to provide on-call and off-hours technical support as required.
Compensation
$70-$80 per hour for the 12 month contract duration