Job Summary:We are seeking an experienced Postgres DBA to join our team. The ideal candidate will have strong expertise in Postgres database administration, including logical and physical backup and restore strategies, database replication and high-availability solutions, and day-to-day database operations and performance troubleshooting.
Key Responsibilities:- Design and implement Postgres database architectures and internal components.
- Perform minor and major Postgres version upgrades and ensure seamless database operations.
- Administer multi-terabyte, high-performance production databases with high transaction volumes.
- Develop and implement database replication and high-availability solutions using tools such as Repmgr, Pgpool, and pgBackRest.
- Monitor and troubleshoot database performance issues, including CPU load, locks, blocking, and long-running queries.
- Develop and implement routine database maintenance activities, including vacuum, analyze, reindex, and patching.
- Develop and implement cloud-based Postgres deployments on AWS (RDSEC2) and Google Cloud Platform (GCP).
- Develop and implement containerization and orchestration technologies, including Kubernetes.
- Develop and implement strong scripting skills in Shell and Python for automation and monitoring.
- Collaborate effectively with business and technical teams to design and support large-scale, mission-critical database infrastructure.
Required Technical Skills:- Strong understanding of Postgres 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 Postgres version upgrades.
- Extensive experience with database replication and high-availability solutions.
- Responsible for day-to-day database operations, monitoring, and performance troubleshooting.
- Deep knowledge of Postgres configuration parameters, system catalogs, and performance views.
- Experience with routine database maintenance activities, including vacuum, analyze, reindex, and patching.
- Hands-on exposure to cloud-based Postgres deployments on AWS (RDSEC2) and 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 Python for automation and monitoring.
- Proven experience administering multi-terabyte, high-performance production databases.
Required Qualifications:- Proven experience in Postgres database administration.
- Strong understanding of Postgres 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 Postgres version upgrades.
- Extensive experience with database replication and high-availability solutions.
- Responsible for day-to-day database operations, monitoring, and performance troubleshooting.
- Deep knowledge of Postgres configuration parameters, system catalogs, and performance views.
- Experience with routine database maintenance activities, including vacuum, analyze, reindex, and patching.
- Hands-on exposure to cloud-based Postgres deployments on AWS (RDSEC2) and 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 Python for automation and monitoring.
- Proven experience administering multi-terabyte, high-performance production databases.
Preferred Qualifications:- Exposure to Kubernetes platforms such as GKE or EKS.
- Strong communication and collaboration skills.
- Ability to independently learn, adapt, and implement new technologies.
