PostgreSQL DBA

Database Administrator (GCP):

• Design, build, and maintain PostgreSQL databases in GCP (Cloud SQL, Compute Engine, or GKE-based deployments).

• Perform advDesign, build, and maintain PostgreSQL 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, DevOps, 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.anced 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, DevOps, 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.

Collaboration & SME Leadership:

• Act as the primary SME for PostgreSQL in GCP.

• Provide guidance, mentoring, and knowledge transfer to operations teams.

• Work closely with vendors, engineering teams, and stakeholders to support strategic initiatives.

Required Skills & Experience:

• 8+ years of experience as a PostgreSQL DBA, including deep knowledge of PostgreSQL internals.

• Strong experience working in GCP environments, especially Cloud SQL for PostgreSQL.

• Expertise in performance tuning, explain plans, vacuuming strategies, and connection pooling (pgBouncer/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 PostgreSQL and cloud environments.

• Excellent analytical and communication skills.

Preferred Qualifications:

• Experience with BigQuery, GKE, or hybrid/multi‑cloud PostgreSQL deployments.

• Knowledge of Kubernetes operators for PostgreSQL such as CloudNativePG, Patroni, or CrunchyData.

• Familiarity with CI/CD, DevOps practices, or SRE methodologies.

• Google Cloud certifications (e.g., Professional Database Engineer, Cloud Architect).

Soft Skills:

• Strong analytical and problem solving abilities.

• Excellent communication and stakeholder management skills.

• Ability to work independently and lead technical initiatives.