Senior PostgreSQL Cloud Architect – AWS HA/DR

ETHOS - Talent & Advisory; Washington (District of Columbia, MD); On-site; USD 140,000 - 190,000; Full time

Job summary

ETHOS - Talent & Advisory seeks a Senior Database Architect to own the PostgreSQL estate on AWS for a federal IT client in Washington, DC. You will ensure high availability, patching, monitoring, and recovery while mentoring junior engineers.

You will implement backup and disaster recovery with Multi-AZ and read replicas, optimize SQL for analytics, and integrate with AWS services like Lambda, S3, EC2, and Glue. Public sector experience and strong security practice are preferred.

Qualifications

• Master's degree or higher with 5+ years experience or Bachelor's with 7+ years in IT.
• 10+ years as a Database Administrator or Architect.
• Deep PostgreSQL administration: installation, configuration, backup and recovery.
• Logical/physical data modeling and schema design.
• Advanced SQL and performance tuning.
• HA/DR and failover design (Multi AZ, read replicas).
• Server patching experience and ability to obtain Public Trust; onsite five days a week.

Responsibilities

• Manage and tune PostgreSQL databases on AWS RDS for high availability and performance.
• Run health checks, installations, upgrades, configuration, and patching.
• Design and own backup, DR, and failover strategies.
• Write and optimize complex SQL for analysis and reporting.
• Architect scalable, secure database solutions integrating with Lambda, S3, EC2, and Glue.
• Apply AWS security practices and agency data compliance policies.
• Monitor with Splunk, CloudWatch, and CloudTrail.
• Mentor junior and mid level engineers.

Skills

PostgreSQL

AWS RDS

HA/DR design

SQL tuning

Data modeling

Mentoring

Education

Master's degree or higher

Bachelor's degree with extensive experience

13+ years of experience in lieu of degree

Tools

Splunk

CloudWatch

CloudTrail

Job description

ETHOS - Talent & Advisory seeks a Senior Database Architect to own the PostgreSQL estate on AWS for a federal IT client in Washington, DC. You will ensure high availability, patching, monitoring, and recovery while mentoring junior engineers.

You will implement backup and disaster recovery with Multi-AZ and read replicas, optimize SQL for analytics, and integrate with AWS services like Lambda, S3, EC2, and Glue. Public sector experience and strong security practice are preferred.