Start searching
Back to Jobs
Recently postedTechnology

PostgreSQL DBA

Comprehensive Resources Inc.Austin, TX🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationAustin, TX, United States
ShellAWSGoogle CloudPythonPostgreSQLKubernetes

Job description

Job Role: PostgreSQL DBA

Location: Sunnyvale, CA /Austin ,TX

Key Responsibilities & Skills:

  • Strong understanding of PostgreSQL architecture and internal components.
  • Hands-on experience with logical and physical backup and restore strategies, including Point-in-Time Recovery (PITR).
  • Proven experience in performing minor and major PostgreSQL version upgrades.
  • Extensive experience with database replication and high-availability solutions.
  • Responsible for day-to-day database operations, monitoring, and performance troubleshooting (CPU/load, locks, blocking, long-running queries, etc..).
  • Deep knowledge of PostgreSQL configuration parameters, system catalogs, and performance views.
  • Experience with routine database maintenance activities (vacuum, analyze, reindex, patching).
  • Hands-on exposure to cloud-based PostgreSQL deployments on AWS (RDS/EC2) and/or Google Cloud Platform (Google Cloud Platform).
  • Strong experience with HA/DR tools such as Repmgr, Pgpool, and pgBackRest.
  • Solid hands-on experience with containerization and orchestration technologies, including Kubernetes.
  • Strong scripting skills in Shell and/or Python for automation and monitoring.
  • Proven experience administering multi-terabyte, high-performance production databases.
  • Ability to independently learn, adapt, and implement new technologies.
  • Excellent communication skills with the ability to collaborate effectively across business and technical teams.
  • Experience in designing and supporting large-scale, mission-critical database infrastructure with high transaction volumes.

Good to Have:

  • Exposure to Kubernetes platforms such as GKE or EKS.

Similar jobs

Apply