PostgreSQL DBA
Prophecy Technologies, Austin, TX, United States
Job Summary
We are seeking an experienced PostgreSQL Database Administrator to manage, maintain, and optimize PostgreSQL databases in a production environment. The role focuses on database performance, availability, security, and reliability while working closely with application, infrastructure, and DevOps teams.
Key Responsibilities Install, configure, and maintain PostgreSQL database systems Monitor database performance and proactively tune queries and indexes Manage database backup, recovery, and disaster recovery strategies Ensure database security, access control, and compliance Perform database migrations, upgrades, and patching Troubleshoot database issues and conduct root cause analysis Support high availability and replication setups (Streaming Replication, Logical Replication, etc.) Collaborate with application, infrastructure, and DevOps teams Required Skills & Experience
5+ years of hands-on experience as a
PostgreSQL DBA Strong expertise in
PostgreSQL architecture and internals Hands-on experience with
performance tuning and optimization Experience with backup and recovery tools ( pg_dump, pg_basebackup, WAL archiving ) Strong knowledge of
replication, clustering, and failover solutions Experience working in
Linux/Unix environments Strong scripting skills ( Shell, Python, or similar ) Competencies
Strong troubleshooting and analytical skills Ability to work independently in a production environment Strong collaboration and communication skills Attention to detail and operational excellence Preferred Skills
Experience supporting large-scale or mission-critical database environments Exposure to DevOps practices and automation Experience with cloud-based PostgreSQL deployments
We are seeking an experienced PostgreSQL Database Administrator to manage, maintain, and optimize PostgreSQL databases in a production environment. The role focuses on database performance, availability, security, and reliability while working closely with application, infrastructure, and DevOps teams.
Key Responsibilities Install, configure, and maintain PostgreSQL database systems Monitor database performance and proactively tune queries and indexes Manage database backup, recovery, and disaster recovery strategies Ensure database security, access control, and compliance Perform database migrations, upgrades, and patching Troubleshoot database issues and conduct root cause analysis Support high availability and replication setups (Streaming Replication, Logical Replication, etc.) Collaborate with application, infrastructure, and DevOps teams Required Skills & Experience
5+ years of hands-on experience as a
PostgreSQL DBA Strong expertise in
PostgreSQL architecture and internals Hands-on experience with
performance tuning and optimization Experience with backup and recovery tools ( pg_dump, pg_basebackup, WAL archiving ) Strong knowledge of
replication, clustering, and failover solutions Experience working in
Linux/Unix environments Strong scripting skills ( Shell, Python, or similar ) Competencies
Strong troubleshooting and analytical skills Ability to work independently in a production environment Strong collaboration and communication skills Attention to detail and operational excellence Preferred Skills
Experience supporting large-scale or mission-critical database environments Exposure to DevOps practices and automation Experience with cloud-based PostgreSQL deployments