PostgreSQL DBA

Overview

Design, build, and maintain Postgre

SQL databases in GCP (Cloud SQL, Compute Engine, or GKE-based deployments). Perform advanced design, build, and maintenance of Postgre

SQL databases in GCP.

• Design, build, and maintain Postgre
  
  SQL databases in GCP (Cloud SQL, Compute Engine, or GKE-based deployments).
• Perform advanced performance tuning, query optimization, index management, and capacity planning.
• Implement and maintain high availability (HA), replication (logical/physical), and failover strategies.
• Manage backup, recovery, and disaster recovery solutions, including PITR in GCP.
• Enforce database security best practices, access management, encryption, and network policies.
• Automate operational tasks using Terraform, Python, Bash, or Cloud Functions.
• Monitor and troubleshoot database performance using Cloud Monitoring, Cloud Logging, or third‑party tools.
• Collaborate with application, Dev Ops, and platform teams to support database integration and CI/CD pipelines.
• Perform root‑cause analysis on database incidents and implement long‑term fixes.
• Ensure compliance with data governance, regulatory policies, and audit requirements.
• Act as the primary SME for Postgre
  
  SQL in GCP.
• Provide guidance, mentoring, and knowledge transfer to operations teams.
• Work closely with vendors, engineering teams, and stakeholders to support strategic initiatives.

• 8+ years of experience as a Postgre
  
  SQL DBA, including deep knowledge of Postgre
  
  SQL internals.
• Strong experience working in GCP environments, especially Cloud SQL for Postgre
  
  SQL.
• Expertise in performance tuning, explain plans, vacuuming strategies, and connection pooling (pg Bouncer/pgPool).
• Strong understanding of GCP networking, IAM roles, VPC, and private services.
• Hands‑on experience with backup/restore tools, WAL archiving, logical replication, and high‑availability setups.
• Proficiency in Terraform (or other IaC tools), and scripting (Python/Bash).
• Experience with monitoring and alerting for Postgre
  
  SQL and cloud environments.
• Excellent analytical and communication skills.

• Experience with Big Query, GKE, or hybrid/multi‑cloud Postgre
  
  SQL deployments.
• Knowledge of Kubernetes operators for Postgre
  
  SQL such as Cloud
  
  Native
  
  PG, Patroni, or Crunchy Data.
• Familiarity with CI/CD, Dev Ops practices, or SRE methodologies.
• Google Cloud certifications (e.g., Professional Database Engineer, Cloud Architect).

• Strong analytical and problem solving abilities.
• Excellent communication and stakeholder management skills.
• Ability to work independently and lead technical initiatives.