Postgres DBA

Overview: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.