Senior Database Architect

Our federal IT client supports one of the largest public service agencies in the country, and its PostgreSQL estate on AWS sits underneath systems that millions of Americans depend on. We are looking for a senior database architect who is equally comfortable designing for high availability and getting hands on with patching, monitoring, and recovery. You will own the health of the platform and help shape where it goes next.

What You Will Do

• Manage, secure, monitor, and tune PostgreSQL databases on AWS RDS for high availability and performance
• Run database health checks, installations, upgrades, configuration, and server patching
• Design and own backup, disaster recovery, and failover using Multi AZ deployments and read replicas
• Write and optimize complex SQL for analysis, transformation, and reporting; manage indexing, caching, and scaling
• Architect scalable, secure database solutions and integrate them with Lambda, S3, EC2, and Glue
• Apply AWS security practices (IAM, encryption, VPC, security groups) and agency data compliance policies
• Monitor with Splunk, CloudWatch, and CloudTrail
• Mentor junior and mid level engineers

Required

• Master's and 5+ years, Bachelor's and 7+ years, or 13+ years of experience in lieu of a degree; 10+ years as a Database Administrator or Architect
• Deep PostgreSQL administration: installation, configuration, backup and recovery, replication
• Logical and physical data modeling, normalization, and schema design
• Advanced SQL query writing and performance tuning
• AWS RDS PostgreSQL (or comparable cloud PostgreSQL) in production
• Designing HA, DR, and failover solutions (Multi AZ, read replicas)
• Server patching experience
• Splunk experience
• Ability to obtain and maintain a Public Trust; onsite five days a week

Preferred

• Linux scripting to automate ETL and data migration jobs
• Leading requirements, design, and implementation on project work
• Architecture road maps and recommendations
• Federal agency or public sector experience
• Strong communication with analysts, data scientists, and business stakeholders

Interested or know someone who would be a strong fit? Reach out directly or apply below. Interviews are being scheduled now.