Start searching
Back to Jobs
Recently postedRemoteTechnology

PostgreSQL DBA

Rivago infotech incUnited States🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeRemote
LocationUnited States
OracleSQLShellAWSEncryptionSplunkDatadogGoogle CloudGrafanaPrometheusPythonAzurePostgreSQLKubernetesSQL ServerCI/CDLinux

Job description

Role: PostgreSQL DBA

Location: Remote

Persistent System

Role Summary

We are seeking an experienced PostgreSQL Database Expert to provide enterprise-grade PostgreSQL administration, support, performance tuning, and database reliability services. The individual will be responsible for ensuring the availability, performance, security, and scalability of mission-critical PostgreSQL environments while supporting production, non-production, and disaster recovery systems.

Key Responsibilities

Database Administration & Support

  • Administer and maintain PostgreSQL databases across Production, UAT, QA, and Development environments.
  • Monitor database health, performance, capacity, and availability.
  • Perform proactive issue identification and resolution.
  • Manage database upgrades, patching, and version migrations.
  • Implement and maintain backup, recovery, and archival strategies.

Performance Optimization

  • Analyze SQL queries and execution plans.
  • Perform database performance tuning and optimization.
  • Optimize indexing strategies, partitioning, and database design.
  • Identify and resolve database bottlenecks.

High Availability & Disaster Recovery

  • Design and support PostgreSQL HA solutions.
  • Configure and maintain replication environments.
  • Support failover and disaster recovery testing.
  • Ensure RPO/RTO objectives are met.

Security & Compliance

  • Configure database security controls and access management.
  • Implement role-based access controls.
  • Support audit, compliance, and vulnerability remediation activities.
  • Manage encryption and data protection requirements.

Incident & Problem Management

  • Provide L2/L3 production support.
  • Troubleshoot critical database incidents.
  • Perform root cause analysis (RCA) and implement preventive measures.
  • Participate in on-call support and major incident management.

Automation & DevOps

  • Develop automation scripts for monitoring, deployment, backup, and maintenance activities.
  • Support Infrastructure-as-Code and CI/CD initiatives where applicable.
  • Integrate PostgreSQL monitoring with enterprise observability platforms.

Required Skills

  • 10+ years of database administration experience.
  • 6+ years of hands-on PostgreSQL administration experience.
  • HA/DR, performance tuning, and PostgreSQL migration expertise
  • Strong knowledge of:
    • PostgreSQL Architecture
    • WAL, Replication & Streaming Replication
    • Backup & Recovery
    • Performance Tuning
    • Partitioning & Indexing
    • PostgreSQL Security
    • Query Optimization
  • Experience with:
    • pgAdmin
    • pgBackRest / Barman
    • Patroni / RepMgr
    • Linux Administration
    • Shell/Python Scripting
    • Monitoring tools (Grafana, Prometheus, Datadog, Splunk, etc.)

Preferred Skills

  • PostgreSQL on AWS, Azure, or Google Cloud Platform.
  • PostgreSQL migration from Oracle, SQL Server, DB2, or other RDBMS platforms.
  • Experience supporting large-scale banking or financial services environments.
  • Knowledge of Kubernetes/OpenShift-hosted PostgreSQL deployments.
  • Exposure to enterprise data governance and regulatory compliance requirements.

Experience Level

  • Lead PostgreSQL DBA / PostgreSQL Support Lead
  • 10-15+ years overall IT experience
  • 6+ years dedicated PostgreSQL experience

Similar jobs

Apply