Sr Postgres Database Administrator

AIS (Applied Information Sciences) • Washington, DC

1d

About The Position

As your initial project assignment, you will support the unique needs of our client as a Sr Postgres Database Administrator. The PostgreSQL Database Administrator (DBA) SME will serve as the technical authority for enterprise PostgreSQL environments, leading the design, implementation, optimization, and security of mission‑critical database systems. This role supports high‑availability architectures and compliance‑driven environments, guiding database strategy, performance tuning, and data protection initiatives across the organization.

Requirements

• Bachelor’s degree in Information Technology, Computer Science, or a related field (or equivalent experience)
• Minimum 10 years of experience as a PostgreSQL Database Administrator
• Deep expertise in PostgreSQL internals, including WAL, MVCC, vacuuming, and indexing
• Strong experience with PostgreSQL replication and clustering technologies
• Advanced knowledge of SQL performance tuning and query optimization
• Hands‑on experience with backup, recovery, and disaster recovery planning
• Experience administering PostgreSQL in cloud environments, including AWS RDS
• Familiarity with monitoring and logging tools such as Splunk and AWS CloudWatch
• Strong scripting and automation skills (Bash, Python, or similar)
• Top Secret Clearance is required.

Nice To Haves

• Experience supporting large‑scale or mission‑critical enterprise environments
• Familiarity with compliance‑driven or regulated systems
• Experience documenting database architectures, standards, and operational procedures
• Exposure to DevSecOps or Infrastructure‑as‑Code practices

Responsibilities

• Serve as the PostgreSQL Subject Matter Expert SME, providing architectural guidance, standards, and best practices
• Install, configure, upgrade, and maintain PostgreSQL database clusters, including high availability (HA) and disaster recovery (DR) environments
• Design and implement HA/DR solutions using streaming replication, logical replication, and automated failover
• Perform database performance tuning, query optimization, and capacity planning for enterprise systems
• Coordinate changes to computer databases and ensure operational stability
• Manage database security, including roles, permissions, encryption, and auditing
• Develop and support backup and recovery strategies, including WAL archiving and Point‑In‑Time Recovery (PITR)
• Troubleshoot and resolve database issues, outages, and performance bottlenecks
• Automate database administration tasks using scripting languages such as Bash and Python
• Plan, coordinate, and implement security measures to safeguard databases
• Ensure compliance with applicable security and regulatory standards (e.g., STIG, RMF, NIST)

Benefits

• Competitive Salaries
• Qualified Overtime
• Paid Time Off (PTO)
• Flexible Holiday Leave (88 hours per year)
• Parental Leave
• Immediate Healthcare: Medical, Dental, Vision, and Life Insurance
• Employee Stock Ownership Plan (ESOP)
• 401(k) Retirement Plan (5% match on base compensation, immediate 100% vesting)
• Tuition Reimbursement & Learning Allowance
• Referral Bonus Program (up to $5k)

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Number of Employees: 251-500 employees