Postgres Senior Engineer - DBA

Ventures Unlimited Inc; Austin (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

A tech company based in Texas is looking for a PostgreSQL Database Administrator to manage day-to-day PostgreSQL operations, troubleshoot performance issues, and perform maintenance tasks. Candidates should have strong knowledge of Postgres architecture, experience with database backups and restores, and exposure to cloud deployments such as AWS or GCP. Strong communication skills and the ability to work across multiple teams are essential for success in this role.

Qualifications

• Strong knowledge of Postgres architecture required.
• Experience with various types of Postgres backups and restores is necessary.
• Hands-on experience with Kubernetes or other containerization technologies.

Responsibilities

• Manage day-to-day PostgreSQL operations and performance issues.
• Troubleshoot performance issues like locks and blocking queries.
• Perform PostgreSQL maintenance tasks and deployments in cloud environments.

Skills

Postgres Architecture

Backup and restores in Postgres

Database upgrade experience

Database replication

Kubernetes

Communication skills

Job description

Responsibilities and Qualifications

• Strong knowledge of Postgres Architecture.
• Experience with different types of backup and restores in Postgres.
• Experience with database upgrade on minor and major versions.
• Hands-on experience on Database replication and point-in-time-recovery.
• Day to Day operations and troubleshooting performance issues like load average, locks, blocking and long running sqls.
• Commonly used PostgreSQL configuration parameters and common system tables usage.
• Exposure to PostgreSQL maintenance tasks.
• Exposure to PostgreSQL deployments in cloud like AWS(RDS or EC2) or GCP.
• High-availability like Repmgr or pgpool or efm
• Exceptional experience administering multi-terabyte databases
• Aptitude to independently learn new technologies
• Strong communication skills and ability to work effectively across multiple business and technical teams
• Background in building large database infrastructure supporting a high volume of transactions in a mission-critical environment
• Hands on experience on Kubernetes or any containerization technologies.