
The PostgreSQL Database Administrator SME will lead the design, implementation, optimization, and security of enterprise-level PostgreSQL environments. The ideal candidate will serve as a technical authority, supporting mission-critical systems and guiding database strategies, performance tuning, and compliance initiatives. Additionally, the PostgreSQL DBA coordinates changes to computer databases and may plan coordinate and implement security measures to safeguard computer databases.
Responsibilities:
• Serve as the "PostgreSQL Subject Matter Expert", providing architectural guidance and best practices
• Install, configure, upgrade, and maintain PostgreSQL database clusters (including HA/DR setups)
• Design and implement high availability and disaster recovery solutions (streaming replication, logical replication, failover)
• Perform performance tuning, query optimization, and capacity planning
• Manage database security, including roles, permissions, encryption, and auditing
• Support backup and recovery strategies (PITR, WAL archiving)
• Troubleshoot database issues, outages, and performance bottlenecks
• Automate database administration tasks using scripting (Bash, Python, etc.)
• Ensure compliance with security standards (STIG, RMF, NIST, etc.)
Qualifications:
• Minimum 10 years of Excellent experience as a PostgreSQL Database Administrator.
• Deep expertise in PostgreSQL internals (WAL, MVCC, vacuuming, indexing)
• Experience with PostgreSQL replication and clustering technologies
• Strong knowledge of SQL performance tuning and query optimization
• Hands-on experience with backup/recovery and disaster recovery planning
• Familiarity with cloud platforms AWS RDS
• Experience with monitoring tools (Splunk, Cloud watch etc.)
• Strong scripting skills (Bash, Python etc.)
Bachelor's degree required!
Job details
Synergy ECP
IT Services and IT Consulting
About
Welcome to Synergy ECP, the most trusted partner in navigating the complex landscape of cybersecurity and digital transformation. With nearly two decades of dedicated service, we specialize in Cybersecurity, Engineering, Mission IT, and Special Programs Support, delivering mission-critical solutions to defense and intelligence agencies. Our team is counted on to address the most challenging national security issues with precision, leveraging our deep expertise and innovative technologies. Synergy ECP embraces the strategy and focus behind our name offering true collaboration and excellence. Our centralized focus begins with the investment in our Employees alongside our commitments to our Customers – together to improve Performance. We simply cannot have one without the other. Synergy ECP aims to be intentional in our work, our commitment to our employees, and to how to continuously evolve and grow to deliver excellence. Explore our career options on our website and find your path with us!
Company Details
Jobr Assistant extension
Get the extension →


