Postgres SME

System One; Herndon (VA); Hybrid; USD 120,000 - 170,000; Full time

Job summary

System One is seeking a Postgres SME in Herndon, VA to design, deploy, and maintain high-performance Postgres environments. You will troubleshoot performance issues, implement security practices, and optimize SQL queries to support cross-functional teams.

The role requires an Active Secret Clearance, US citizenship, a BS in CS or related field, and experience as a Postgres DBA/SME. The position offers hybrid onsite/remote work and a 40-hour week.

Qualifications

• Bachelor's degree in Computer Science or related field.
• US Citizen.
• Security+ or equivalent certification.
• Proven Postgres DBA/SME experience.
• Advanced Postgres administration, tuning, and monitoring.
• Proficient in SQL and PL/pgSQL.
• Strong analytical and problem-solving abilities.
• Excellent communication and collaboration skills.

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.

Skills

PostgreSQL

SQL

PL/pgSQL

Analytical skills

Collaboration

Education

Bachelor's degree in Computer Science

Security+ certification

US Citizen

Job description

Job Title: Postgres SME
Location: Herndon, VA
Type: Direct Hire
Compensation:
Work Model: Hybrid – onsite and remote
Hours: 40.0
Security Clearance: Active Secret Clearance Required

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

Requirements

• Bachelor's degree in Computer Science or related field
• US Citizen
• 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

System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

Ref: #851-Rockville-S1