Postgres SME

Open Systems Technologies Corporation; Fort Belvoir, Northern (VA, KY); Hybrid; USD 110,000 - 165,000; Full time

Benefits offered by this job

Paid time off (3 weeks)

11 Federal Holidays

Medical & dental coverage

STD, LTD, Life Insurance

AD&D

401k with employer match

Profit sharing

Job summary

Open Systems Technologies Corporation is seeking a Postgres SME to design, deploy, and maintain high-performance PostgreSQL environments. You will troubleshoot performance issues, implement security, and optimize SQL queries while supporting data integrity across enterprise systems.

The ideal candidate holds a CS degree, is a US citizen with an active Secret clearance, and has hands-on PostgreSQL administration experience. Certificates like PostgreSQL Certified Professional are a plus.

Qualifications

• Bachelor's degree required in CS or related field.
• US Citizen and Active Secret Clearance required.
• Security+ or equivalent certification preferred.
• Proven experience as Postgres DBA or SME.
• Advanced PostgreSQL administration, tuning, and monitoring.
• SQL/PLpgSQL programming proficiency.
• Strong analytical and problem-solving abilities.
• Excellent written and verbal communication and collaboration.

Responsibilities

• Design, deploy, and maintain high-performance Postgres 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 database solutions.
• Manage backups and recovery procedures.
• Stay current with PostgreSQL trends and best practices.

Skills

SQL & PL/pgSQL

Analytical skills

Communication & collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

PostgreSQL

Job description

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 to work on, and robust benefits to include technical training and certifications, relocation assistance and a 401K match with immediate vesting.

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 and Duties:

• 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
• US 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

OST is an Equal Opportunity Employer and has been operating since 1996 providing support on various contracts with Government agencies. We offer a comprehensive benefits package that includes 3 weeks paid time off, 11 Federal Holidays, medical/dental coverage, STD, LTD, Life Insurance, AD&D, 401k with up to 4% match, and end-of-year profit sharing.