Urgent Job opening - PostgreSQL DBA- Austin, TX

Cystems Logic IncAustin, TX
8dOnsite

About The Position

The Postgres DBA will be responsible for managing and supporting high-performance PostgreSQL databases in a production environment. This role involves hands-on administration, performance tuning, backup and recovery, high availability configuration, cloud deployments, automation and collaboration with cross-functional teams to support mission-critical systems with high transaction volumes.

Requirements

  • 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
  • Deep knowledge of PostgreSQL configuration parameters system catalogs and performance views.
  • Hands-on exposure to cloud-based PostgreSQL deployments on AWS (RDS EC2) and or Google Cloud Platform (GCP).
  • Strong experience with HADR 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.

Nice To Haves

  • Exposure to Kubernetes platforms such as GKE or EKS.

Responsibilities

  • Responsible for managing and supporting high-performance PostgreSQL databases in a production environment.
  • Hands-on administration, performance tuning, backup and recovery, high availability configuration, cloud deployments and automation
  • Collaboration with cross-functional teams to support mission-critical systems with high transaction volumes.
  • Day-to-day database operations monitoring and performance troubleshooting (CPU load locks blocking long-running queries etc.)
  • Routine database maintenance activities (vacuum analyze reindex patching)

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume

What This Job Offers

Career Level

Mid Level

Education Level

No Education Listed

Number of Employees

51-100 employees

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service