Senior PostgreSQL DBA: HA, Security & Migrations

Cayuse Holdings, LLC; Washington (District of Columbia); On-site; USD 130,000 - 170,000; Full time

Benefits offered by this job

Medical, Dental and Vision Insurance

401(k) Retirement Savings Plan with HR

Paid Time Off

Job summary

Cayuse Holdings, LLC is seeking a senior Database Administrator to design, implement, and maintain PostgreSQL databases (v13+). The role focuses on data integrity, security, performance, and seamless integration with existing IT systems.

You will manage backups, replication, and migrations, including cloud-based PostgreSQL environments. The ideal candidate has 8+ years in DB administration, strong PostgreSQL expertise, and experience with observability tools like Prometheus and Grafana.

Qualifications

• Bachelor’s degree in IT, CS, or related field or equivalent experience.
• 8+ years of professional database administration experience.
• Proven expertise with PostgreSQL v13 in medium to large deployments.
• Strong knowledge of DB design, admin, and optimization for enterprise needs.
• Experience with backup/recovery and high-availability configurations in PostgreSQL.
• Migration experience to/from PostgreSQL, including AWS RDS/Aurora.
• Proficiency in query optimization, indexing, and performance tuning.
• Experience with observability/monitoring tools such as Prometheus and Grafana.

Responsibilities

• Design, implement, and maintain moderately complex databases.
• Ensure efficient configurations and up-to-date database dictionaries.
• Integrate systems through robust database designs.
• Administer and test databases with deep PostgreSQL expertise.
• Plan, coordinate, and implement security measures to protect data.
• Manage PostgreSQL environments (version 13+) and perform patches.
• Configure replication and high availability (physical and logical).
• Develop monitoring and alerting with observability tools.
• Perform migrations to/from PostgreSQL and cloud services like AWS.

Skills

PostgreSQL

Database design

Performance tuning

Security best practices

Observability tooling

Education

Bachelor’s degree in IT/CS

Tools

Prometheus

Grafana

AWS RDS

Aurora PostgreSQL

pg_dump/pg_restore

Job description

Cayuse Holdings, LLC is seeking a senior Database Administrator to design, implement, and maintain PostgreSQL databases (v13+). The role focuses on data integrity, security, performance, and seamless integration with existing IT systems.

You will manage backups, replication, and migrations, including cloud-based PostgreSQL environments. The ideal candidate has 8+ years in DB administration, strong PostgreSQL expertise, and experience with observability tools like Prometheus and Grafana.