Postgres SME

Open Systems Technologies Corporation is a leader in the government contracting marketplace, providing Enterprise Security and Cloud Computing solutions to support large organizations. Our capabilities include supplying federal government entities and private businesses with software development, scientific and engineering technical assistance, systems integration, and enterprise security. Since its founding in 1996, OST has been committed to delivering high‑quality, best‑in‑class results that bring added value to our clients while investing in our employees’ futures by providing exciting projects, technical training and certifications, relocation assistance, and a 401(k) match with immediate vesting.

About the role

Open Systems Technologies is looking for a Postgres SME. The ideal candidate will have in‑depth knowledge and expertise in all aspects of Postgres database administration and management. The Postgres SME will be responsible for ensuring the efficiency, security, and optimization of our database systems to support our organization’s data‑management goals.

Responsibilities

• Design, deploy, and maintain high‑performance Postgres database environments
• Troubleshoot and resolve database performance issues
• Implement database security best practices and ensure data integrity
• Develop and optimize SQL queries and stored procedures
• Collaborate with cross‑functional teams to design and implement database solutions
• Manage database backups and recovery procedures
• Stay current with industry trends and best practices in Postgres database technology

Qualifications and Skills

• Bachelor’s degree in Computer Science or related field
• U.S. Citizen
• Active Secret Clearance required
• Possession of Security+ or equivalent
• Proven experience as a Postgres database administrator or SME
• Advanced knowledge of Postgres database administration, including configuration, tuning, and monitoring
• Proficiency in SQL and PL/pgSQL programming
• Strong analytical and problem‑solving skills
• Excellent communication and collaboration abilities
• Relevant certifications (e.g., PostgreSQL Certified Professional) a plus

Benefits

• 3 weeks paid time off
• 11 Federal holidays
• Medical and dental coverage
• Short‑term disability (STD) and long‑term disability (LTD)
• Life insurance and AD&D
• 401(k) with up to 4% match
• End‑of‑year profit sharing