Senior PostgreSQL DBA

Robotics Technologies LLC

New Jersey

On-site

USD 92,000 - 131,000

Full time

3 days ago
Be an early applicant

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Robotics Technologies LLC in the United States seeks a Senior PostgreSQL DBA to design, manage, and optimize production PostgreSQL databases on Microsoft Azure. You will implement HA/DR, manage replication, perform performance tuning, and ensure security.

The role covers administration across Linux and Windows, automation with Terraform, Bicep, Ansible, and cloud tooling. You will lead incidents, migrations, and upgrades, and collaborate with security and operations teams from Basking Ridge, NJ.

Qualifications

  • Experience designing HA/DR for PostgreSQL on Azure.
  • Hands-on PostgreSQL administration and upgrades.
  • Experience with streaming and logical replication.
  • Knowledge of Azure networking, encryption, and security.
  • Experience with backups, PITR, WAL archiving.

Responsibilities

  • Design, implement, and maintain HA and DR for PostgreSQL on Azure.
  • Manage active-passive and active-active replication incl. streaming and logical.
  • Configure automated failover, read replicas, backups, and recovery.
  • Administer Azure PostgreSQL Flexible Server and PostgreSQL on Azure VMs.
  • Manage PostgreSQL on Linux (RHEL/CentOS) and Windows Server.
  • Configure Azure networking, auth, encryption, and private endpoints.
  • Tune performance with EXPLAIN ANALYZE, indexing, partitioning.
  • Monitor health with Azure Monitor, Log Analytics, Prometheus, Grafana.
  • Lead incidents, root cause analysis, and post-incident improvements.
  • Plan migrations and major version upgrades.
  • Automate with Terraform, Bicep, Ansible, Azure CLI, PowerShell.
  • Develop runbooks for failover, backups, upgrades.

Skills

PostgreSQL HA
Disaster recovery
Replication
Azure PostgreSQL
Linux admin
Windows Server
Streaming replication
Patroni
pgBackRest
Performance tuning
Query optimization
Terraform
Bicep
Ansible
PowerShell
Security/encryption

Tools

Azure Database for PostgreSQL Flexible Server
Azure VMs
Azure CLI
Terraform
Bicep
Ansible
PowerShell
Prometheus
Grafana
Azure Monitor
Log Analytics

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: Senior PostgreSQL DBA
Location: Basking Ridge NJ
Duration: 6 Months + Extension
Bill Rate: $81/hour
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US-Citizen, H-1B, OPT-EAD, GC-EAD

Job Description

We are seeking an experienced Senior PostgreSQL DBA to design, manage, optimize, and secure production PostgreSQL databases hosted on Microsoft Azure. The ideal candidate will have strong hands‑on expertise in PostgreSQL administration, high availability, disaster recovery, performance tuning, cloud infrastructure, and database security.

Key Responsibilities:
  • Design, implement, and maintain high-availability (HA) and disaster recovery (DR) solutions for PostgreSQL databases on Azure.
  • Manage active-passive and active-active replication architectures, including streaming and logical replication.
  • Configure automated failover, read replicas, cross-region replication, backup strategies, and recovery procedures.
  • Administer Azure Database for PostgreSQL Flexible Server and self-managed PostgreSQL environments on Azure VMs.
  • Manage PostgreSQL installations and upgrades across Linux (RHEL, CentOS Stream) and Windows Server environments.
  • Configure Azure networking, private endpoints, VNet integration, authentication, managed identities, and encryption.
  • Perform database performance tuning using EXPLAIN ANALYZE, pg_stat_statements, indexing, partitioning, and query optimization.
  • Manage database backups, point-in-time recovery, WAL archiving, and restore testing.
  • Implement database security, access controls, TLS, encryption, auditing, and compliance requirements.
  • Monitor database health, replication lag, performance, and availability using Azure Monitor, Log Analytics, Prometheus, and Grafana.
  • Lead critical database incidents, troubleshooting, root cause analysis, and post-incident improvements.
  • Plan and execute database migrations and major PostgreSQL version upgrades.
  • Automate database infrastructure and administration using Terraform, Bicep, Ansible, Azure CLI, and PowerShell.
  • Develop and maintain technical runbooks for failover, backup, recovery, and upgrade procedures.
Required Skills:
  • Strong expertise in PostgreSQL high availability, disaster recovery, and replication.
  • Experience with Azure Database for PostgreSQL Flexible Server.
  • Experience managing self-hosted PostgreSQL on Azure Virtual Machines.
  • Strong knowledge of Linux (RHEL/CentOS) and Windows Server administration.
  • Expertise in streaming replication, logical replication, Patroni, and etcd.
  • Experience with backup and recovery tools such as pgBackRest, Barman, and pg_basebackup.
  • Strong database performance tuning, query optimization, indexing, and partitioning skills.
  • Knowledge of Azure networking, security, authentication, and encryption.
  • Experience with database monitoring, incident management, migrations, and version upgrades.
  • Infrastructure automation using Terraform, Bicep, Ansible, or PowerShell.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior PostgreSQL DBA
Senior PostgreSQL DBA

Valiant Technologies LLC • New Jersey

On-site
USD 92,000 - 131,000
Senior PostgreSQL DBA
Senior PostgreSQL DBA

Robotic Process Automation LLC • New Jersey

On-site
USD 92,000 - 131,000
Senior PostgreSQL DBA
Senior PostgreSQL DBA

Ethereum Technologies LLC • New Jersey

On-site
USD 92,000 - 131,000
Senior PostgreSQL DBA
Senior PostgreSQL DBA

Quantum Technologies LLC • New Jersey

On-site
USD 95,000 - 128,000
Senior PostgreSQL DBA — Azure HA/DR & Cloud Automation
Senior PostgreSQL DBA — Azure HA/DR & Cloud Automation

Ethereum Technologies LLC • New Jersey

On-site
USD 92,000 - 131,000
Postgres DBA
Postgres DBA

Ethereum Technologies LLC • Sunnyvale (CA)

On-site
USD 140,000 - 210,000
Senior PostgreSQL DBA - Azure HA/DR Expert (NJ)
Senior PostgreSQL DBA - Azure HA/DR Expert (NJ)

Valiant Technologies LLC • New Jersey

On-site
USD 92,000 - 131,000
PostgreSQL Database Engineer
PostgreSQL Database Engineer

Ethereum Technologies LLC • Hartford (CT)

On-site
USD 90,000 - 140,000
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Atser, Lp • Houston (TX)

On-site
USD 100,000 - 130,000
PostgreSQL Database Engineer
PostgreSQL Database Engineer

Valiant Technologies LLC • Hartford (CT)

On-site
USD 95,000 - 150,000