Senior PostgreSQL Database Administrator

SiyanTech Global Innovations; India; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

A global technology solutions provider is seeking an experienced Senior DBA to manage the lifecycle of PostgreSQL clusters. Responsibilities include designing high-availability architectures, monitoring system performance, and implementing advanced data partitioning strategies. The ideal candidate should have 7-10 years of experience, deep technical expertise in PostgreSQL, and familiarity with cloud environments such as AWS or Azure. Join us in driving operational excellence within a dynamic team environment.

Qualifications

• 7–10 years of experience as a production PostgreSQL DBA.
• Deep mastery of MVCC, WAL, and Query Planner behavior.
• Proficiency with cloud-native database environments.

Responsibilities

• Design and manage high-availability PostgreSQL clusters.
• Proactively monitor and resolve performance bottlenecks.
• Implement advanced partitioning strategies for data lifecycle.

Skills

PostgreSQL DBA

Cloud-native environments (AWS/Azure)

Linux skills

Monitoring (Prometheus/Grafana)

Tools

pgBouncer

Patroni

Terraform

Job description

About the Role

As a Senior DBA, you will own the end-to-end lifecycle of our PostgreSQL clusters. This is a hands‑on role focused on operating at scale optimizing complex queries, managing multi‑terabyte partitioned tables, and ensuring our reporting workloads thrive without impacting production stability.

Key Responsibilities

• Cluster Orchestration: Design and manage high‑availability (HA) PostgreSQL clusters (Single‑node, Patroni, or managed cloud) across all environments.
• Performance & Tuning: Proactively monitor and resolve bottlenecks, including vacuum/autovacuum tuning, index bloat, and connection management.
• Data Lifecycle & Partitioning: Implement advanced partitioning strategies (Range, List, Hash) and automated archival policies to maintain performance as datasets grow.
• Resiliency & Security: Own the backup/DR strategy (PITR, pgBackRest), execute zero‑downtime upgrades, and enforce RBAC and encryption standards.
• Analytics Support: Optimize read‑replicas and materialized views to enable high‑performance BI reporting (Tableau/Power BI) without compromising OLTP speed.
• Automation: Utilize Infrastructure as Code (Terraform) and scripting (Python/Shell) to automate provisioning and maintenance.
• High Availability & Disaster Recovery: Design and orchestrate automated failover (Patroni/Cloud HA) to maintain RTO of <15 minutes and near‑zero data loss (RPO).
• Financial Integrity & Compliance: Enforce SOC2/GDPR standards by implementing granular audit logging, encryption, and automated PII masking across all environments.
• Data Lifecycle & Archiving: Architect and execute data retention policies that move aged trade data to lower‑cost storage tiers without sacrificing accessibility for BI or regulatory audits.

Qualifications

• 7–10 years of experience as a production PostgreSQL DBA
• Deep mastery of MVCC, WAL, and Query Planner behavior
• Proficiency with pgBouncer, Patroni, and cloud‑native database environments (AWS/Azure)
• Strong Linux skills and experience with Prometheus/Grafana monitoring