Senior Database Administrator

Senior Database Administrator (DBA)

Key Responsibilities:

• Design and maintain

  PostgreSQL clusters

  with HA, replication, and failover (e.g., Patroni, repmgr, pgpool-II).
• Implement

  automated backup and disaster recovery

  strategies ensuring point-in-time recovery (PITR).
• Perform

  performance tuning, query optimization, and capacity planning

  .
• Manage

  monitoring and alerting

  using Prometheus, Grafana, and pg_stat_statements.
• Ensure

  zero downtime

  during upgrades, schema changes, and maintenance.
• Enforce

  security, access control, and compliance policies

  (encryption, auditing, masking).
• Collaborate with DevOps to automate database provisioning and CI/CD pipelines.
• Troubleshoot complex database issues and ensure

  24x7 system reliability

  .

Required Skills:

• Expert in

  PostgreSQL administration

  , HA, replication, and failover.
• Strong knowledge of

  Linux systems

  ,

  Shell scripting

  , and

  performance diagnostics

  .
• Experience with

  pgBackRest

  ,

  barman

  , or similar backup tools.
• Proficient in

  monitoring tools

  (Prometheus, Grafana, pgBadger).
• Familiarity with

  Docker

  , and

  cloud-based DB deployments

  (AWS RDS).
• Understanding of

  SQL tuning, indexing

  , and

  query optimization

  .
• Strong problem-solving, documentation, and automation skills.
  

Preferred:

• Experience in

  zero-downtime migrations and upgrades

  .
• Knowledge of

  logical replication

  ,

  streaming replication

  , and

  partitioning

  .
• Prior experience managing

  multi-region or distributed clusters

  .

Why Join Us:

mission-critical systems never go down