Hi,
Job Title: PostgreSQL Database Administrator (Postgres DBA)
Location: Austin,
TX or
Sunnyvale, CA (Hybrid
– 3 days/week onsite)
Work
Hours: PST hours required for both locations
Duration:
12
Months
Job Summary:
We are seeking an experienced PostgreSQL Database Administrator (DBA) to manage, maintain, and optimize large-scale, mission-critical PostgreSQL environments. The ideal candidate will have deep expertise in Postgres architecture, high availability, performance tuning, and cloud deployments, and will support databases handling high transaction volumes and multi-terabyte datasets.
Key Responsibilities:
- Administer and support PostgreSQL databases in production and non-production environments.
- Perform backup and restore operations, including point-in-time recovery (PITR).
- Execute minor and major PostgreSQL version upgrades.
- Configure and manage database replication and high-availability solutions.
- Monitor and troubleshoot performance issues including:
- Load average
- Locks and blocking sessions
- Long-running SQL queries
- Perform day-to-day DBA operations, maintenance, and health checks.
- Tune PostgreSQL configuration parameters and leverage system catalogs and statistics.
- Manage and support multi-terabyte databases.
- Support PostgreSQL deployments in cloud environments (AWS RDS/EC2, GCP).
- Work with development, infrastructure, and application teams to ensure database stability and scalability.
- Contribute to building and maintaining large-scale database infrastructure for mission-critical systems.
Required Skills & Qualifications:
- Strong understanding of PostgreSQL architecture and internals.
- Hands-on experience with:
- Backup & restore strategies
- PITR
- Replication
- Experience with PostgreSQL HA solutions such as Repmgr, Pgpool, or EFM.
- Strong skills in performance tuning and troubleshooting.
- Experience administering multi-terabyte PostgreSQL databases.
- Exposure to PostgreSQL cloud deployments (AWS RDS/EC2 or GCP).
- Experience with PostgreSQL maintenance tasks (vacuuming, indexing, reindexing).
- Hands-on experience with Kubernetes or containerization technologies.
- Strong communication skills and ability to collaborate across technical and business teams.
- Self-driven with the ability to learn new technologies independently.
Nice to Have:
- Experience supporting high-volume transactional systems.
- Prior exposure to DevOps-driven database environments.
- Experience automating DBA tasks using scripts or tools.
|
Arjun BHATT |
E: arjun.b@noviainfotech.com M: (972) 961 2004 Linkedin: linkedin.com/in/arjun-bhatt-3a86001b5 |
You received this message because you are subscribed to the Google Groups "NoviaJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to noviajobs+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/noviajobs/CANVQszGvRR8W4dhkyKqbgm7Y6V8pRDj04DCxEQj6YBc8KyPW3A%40mail.gmail.com.
No comments:
Post a Comment