Description

You own the administration and operations of PostgreSQL databases.

Responsibilities

  • Install, configure, upgrade, and patch PostgreSQL databases across production, DR, and non-production environments.
  • Manage high availability (HA) and disaster recovery (DR) architectures using streaming and logical replication.
  • Monitor and tune SQL queries, indexes, memory, I/O, and vacuum processes to resolve performance bottlenecks.
  • Implement database security practices, including RBAC, encryption, auditing, and logging.
  • Serve as the L3 escalation point for complex incidents, performing root cause analysis.

Required Skills

  • 5+ years of hands-on experience with PostgreSQL.
  • Experience managing PostgreSQL on AWS RDS (PostgreSQL, Aurora), Azure Database for PostgreSQL, or GCP Cloud SQL.
  • Proficiency in automation using Shell, Python, or Ansible.
  • Knowledge of CI/CD Pipelines and DevOps integration.
  • Experience with database backup and recovery using Barman or native utilities.
  • Familiarity with compliance standards such as HIPAA, SOX, and PCI-DSS.
  • Proven ability to perform capacity planning and growth forecasting.

Key Skills
Education

Any Gradute

Back To Jobs