DBA

Job Description PostgreSQL Database Administrator

We are looking for a PostgreSQL Database Administrator (DBA) with 4+ years of hands-on experience in managing PostgreSQL databases in cloud environments (AWS, GCP, or Azure). The role involves administering, monitoring, and supporting PostgreSQL databases to ensure high availability, performance, security, and reliability in line with business requirements.

The ideal candidate will have strong experience in PostgreSQL administration, backup and recovery, performance tuning, and operational support, along with exposure to managed cloud database services.

Key Responsibilities

Cloud PostgreSQL Deployment & Lifecycle Management

• Deploy, configure, patch, and upgrade PostgreSQL instances on AWS (RDS/Aurora), GCP (Cloud SQL), or Azure (Database for PostgreSQL).
• Manage database provisioning via IaC tools (e.g., Terraform, CloudFormation, ARM/Bicep) and integrate with CI/CD pipelines.
• Monitor and optimize cloud cost/usage (e.g., storage auto-scaling, instance resizing, reserved instances).
• Perform routine database maintenance activities, including patching, upgrades, and health checks.
• Manage database objects, users, roles, and permissions.
  
  

High Availability, Disaster Recovery & Backup/Recovery

• Design and implement HA/DR strategies:
• Streaming replication, logical replication, read replicas
• Failover automation (e.g., using repmgr, Patroni, or native cloud failover)
• Point-in-Time Recovery (PITR) via WAL archiving (e.g., to S3/GCS/Azure Blob)
• Configure and test robust backup strategies using pg_dump, pg_dumpall, pg_basebackup, and cloud-native snapshots.
• Document and regularly validate RTO/RPO compliance.
  
  

Performance Tuning & Capacity Planning

• Proactively monitor and tune database performance using tools like:
• pg_stat_statements, pgBadger, EXPLAIN (ANALYZE, BUFFERS), CloudWatch/Metrics Explorer/Monitor
• OS-level metrics (CPU, I/O, memory pressure)
• Optimize queries, indexing (B-tree, BRIN, partial, expression), partitioning, and vacuum/autovacuum settings.
• Forecast capacity needs (storage, compute, connections) and right-size cloud instances.
  
  

Security, Compliance & Governance

• Implement and audit security controls:
• Role-based access (RBAC), row-level security (RLS), encryption (at-rest & in-transit)
• VPC/Network security (security groups, private endpoints, firewall rules)
• Integration with IAM (e.g., AWS IAM DB Auth, Azure AD)
• Ensure compliance with internal policies and external regulations (e.g., GDPR, SOC 2, HIPAA).
  
  

Automation & Operational Excellence

• Automate routine DBA tasks (backups, patching, user management, health checks) using scripts (Bash/Python) and tools (Ansible, custom CLIs).
• Maintain up-to-date runbooks, architecture diagrams, and operational documentation (e.g., Confluence, Wiki).
  
  

Required Qualifications

• 4+ years of hands-on PostgreSQL DBA experience, including installation, configuration, backup/recovery, replication, and performance tuning.
• 2+ years managing PostgreSQL in at least one major cloud platform:
• AWS: RDS for PostgreSQL, Aurora PostgreSQL (preferred)
• GCP: Cloud SQL for PostgreSQL
• Azure: Azure Database for PostgreSQL (Single/Flexible Server)
  
  

Nice To Have

• Familiarity with automation and scripting (Shell, Python).
• Exposure to database migrations or upgrade projects