Postgres DBA
Posted Updated
Description
- 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.
- Responsible for day-to-day database operations| monitoring| and performance troubleshooting (CPUload| locks| blocking| long-running queries| etc..).
- Deep knowledge of PostgreSQL configuration parameters| system catalogs| and performance views.
- Experience with routine database maintenance activities (vacuum| analyze| reindex| patching).
- Hands-on exposure to cloud-based PostgreSQL deployments on AWS (RDSEC2) andor 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 andor 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.
- Good to Have Exposure to Kubernetes platforms such as GKE or EKS.
Skills
Sign in to read and join the discussion.