PosgresSQL DBA

Insight Global; Austin (TX); On-site; USD 96,432 - 110,208; Full time

Job summary

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