Senior PostgreSQL DBA | High Availability & Security

Cayuse Holdings; Washington (District of Columbia); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical Insurance

401(k)

Paid Time Off

Wellness Program

Flexible Spending Accounts

Disability insurance

Life Insurance

Job summary

Cayuse Holdings in Washington, DC is seeking a Senior Database Administrator to design, implement, and maintain PostgreSQL databases, ensuring security, integrity, and optimal performance across the enterprise.

The ideal candidate has 8+ years of experience in database administration, strong PostgreSQL expertise (v13+), and proven skills in backup/recovery, high availability, migrations to AWS, and observability tools. You will partner with IT teams to deliver reliable data services.

Qualifications

• Bachelor’s degree in IT/CS or related field, or equivalent experience.
• 8+ years of professional database administration and management.
• Proven PostgreSQL (v13+) experience in medium to large deployments.
• Strong knowledge of database design, administration, and optimization.
• Experience with backup/recovery and high-availability in PostgreSQL.
• Experience migrating databases to/from PostgreSQL, including AWS.
• Proficiency in query optimization and performance tuning.
• Experience with observability and monitoring tools (Prometheus/Grafana).
• Active Top Secret Security Clearance; ability to pass background checks.

Responsibilities

• Design, implement, and maintain moderately complex databases to meet business and operational needs.
• Ensure efficient database configurations and maintain up-to-date database dictionaries.
• Integrate various systems seamlessly through effective and reliable database designs.
• Administer and test computer databases, leveraging deep technical knowledge of advanced database management systems like PostgreSQL.
• Perform thorough database testing to ensure optimal functionality and efficiency.
• Plan, coordinate, and implement robust security measures to safeguard computer databases from unauthorized access and potential data breaches.
• Administer, monitor, and maintain PostgreSQL environments, specifically version 13 or higher.
• Conduct environment setup, configuration, patching, performance tuning, and capacity planning.
• Implement and validate comprehensive backup and recovery procedures using tools such aspg_dump/pg_restoreand WAL archiving.
• Configure, monitor, and manage PostgreSQL replication and ensure high availability through physical and logical replication techniques.
• Optimize database queries and indexing with advanced tools and techniques (e.g., EXPLAIN/ANALYZE, partitioning,pg_stat_statements).
• Plan and execute migrations to and from PostgreSQL instances, including transitions involving cloud-managed services such as AWS RDS or Aurora PostgreSQL, and migrations from Oracle databases.
• Ensure seamless integration of PostgreSQL within existing IT infrastructures.
• Develop, configure, and deploy monitoring and alerting systems using observability tools (e.g., Prometheus, Grafana, or similar platforms).
• Continuously monitor and troubleshoot database performance metrics to proactively address potential bottlenecks.
• Other duties as assigned.

Skills

Database design

Database administration

Performance tuning

Security best practices

Backup/Recovery

High availability

Cloud migrations

Observability

Cross-team communication

Problem solving

Education

Bachelor’s degree in Information Technology/Computer Science or related field

Tools

PostgreSQL

AWS RDS/Aurora PostgreSQL

pg_dump/pg_restore

Prometheus/Grafana

SQL optimization tools

Job description

Cayuse Holdings in Washington, DC is seeking a Senior Database Administrator to design, implement, and maintain PostgreSQL databases, ensuring security, integrity, and optimal performance across the enterprise.

The ideal candidate has 8+ years of experience in database administration, strong PostgreSQL expertise (v13+), and proven skills in backup/recovery, high availability, migrations to AWS, and observability tools. You will partner with IT teams to deliver reliable data services.