Postgres Database Administrator, SME
Cayuse Holdings, Washington, District of Columbia, United States
Overview
The Postgres Database Administrator will lead the design, management, and optimization of Postgres database systems, ensuring their performance, reliability, and security in support of mission-critical applications. This role will play a key role in providing database expertise for development, operations, and modernization initiatives, working collaboratively with cross-functional teams to deliver robust database solutions.
This position aligns with Cayuse’s core values of Innovation, Excellence, Collaboration, Adaptability, and Integrity by fostering technical solutions that meet customer needs, promoting teamwork, and prioritizing quality in deliverables.
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.).
Other duties as assigned.
Qualifications
A strong foundation in Computer Science with a Bachelor’s or Master’s degree in the field.
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, CloudWatch, etc.).
Strong scripting skills (Bash, Python, etc.).
Active Top Secret Security Clearance is required.
Must be able to pass a background check. May require additional background checks as required by projects and/or clients at any time during employment.
Minimum Skills Required
Excellent problem-solving and analytical skills.
Strong communication and interpersonal skills.
Ability to respond effectively to customers with a sense of urgency.
Proficient in Microsoft and Adobe toolsets, including Excel, Word, PowerPoint, Acrobat, etc.
Highly motivated with the ability to handle and manage multiple tasks at any one time.
Ability to forge new relationships, individual and teaming in nature.
Must be a self-starter, able to work independently and as part of a team.
Our Commitment to you / overview of benefits
Medical, Dental and Vision Insurance; Wellness Program
Flexible Spending Accounts (Healthcare, Dependent Care, Commuter)
Short-Term and Long-Term Disability options
Basic Life and AD&D Insurance (Company Provided)
Voluntary Life and AD&D options
401(k) Retirement Savings Plan with matching after one year
Paid Time Off
Reports to: Program Manager
Working Conditions
Professional office environment with the ability to work on-site.
Must be physically and mentally able to perform duties extended periods of time.
Ability to use a computer and other office productivity tools with sufficient speed to meet the demands of this position.
Must be able to establish a productive and professional workspace.
Must be able to sit for long periods of time looking at computer screen.
May be asked to work a flexible schedule which may include holidays.
May be asked to travel for business or professional development purposes.
May be asked to work hours outside of normal business hours.
Other Duties: Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Cayuse is an Equal Opportunity Employer. All employment decisions are based on merit, qualifications, skills, and abilities. All qualified applicants will receive consideration for employment in accordance with any applicable federal, state, or local law.
Pay Range
USD $100,000.00 - USD $185,000.00 /Yr.
Location: US-DC-Washington
截至ID: 104382
Category: Information Technology
Position Type: Full-Time Salary Exempt
Remote: No
Clearance Required: Top Secret
#J-18808-Ljbffr
The Postgres Database Administrator will lead the design, management, and optimization of Postgres database systems, ensuring their performance, reliability, and security in support of mission-critical applications. This role will play a key role in providing database expertise for development, operations, and modernization initiatives, working collaboratively with cross-functional teams to deliver robust database solutions.
This position aligns with Cayuse’s core values of Innovation, Excellence, Collaboration, Adaptability, and Integrity by fostering technical solutions that meet customer needs, promoting teamwork, and prioritizing quality in deliverables.
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.).
Other duties as assigned.
Qualifications
A strong foundation in Computer Science with a Bachelor’s or Master’s degree in the field.
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, CloudWatch, etc.).
Strong scripting skills (Bash, Python, etc.).
Active Top Secret Security Clearance is required.
Must be able to pass a background check. May require additional background checks as required by projects and/or clients at any time during employment.
Minimum Skills Required
Excellent problem-solving and analytical skills.
Strong communication and interpersonal skills.
Ability to respond effectively to customers with a sense of urgency.
Proficient in Microsoft and Adobe toolsets, including Excel, Word, PowerPoint, Acrobat, etc.
Highly motivated with the ability to handle and manage multiple tasks at any one time.
Ability to forge new relationships, individual and teaming in nature.
Must be a self-starter, able to work independently and as part of a team.
Our Commitment to you / overview of benefits
Medical, Dental and Vision Insurance; Wellness Program
Flexible Spending Accounts (Healthcare, Dependent Care, Commuter)
Short-Term and Long-Term Disability options
Basic Life and AD&D Insurance (Company Provided)
Voluntary Life and AD&D options
401(k) Retirement Savings Plan with matching after one year
Paid Time Off
Reports to: Program Manager
Working Conditions
Professional office environment with the ability to work on-site.
Must be physically and mentally able to perform duties extended periods of time.
Ability to use a computer and other office productivity tools with sufficient speed to meet the demands of this position.
Must be able to establish a productive and professional workspace.
Must be able to sit for long periods of time looking at computer screen.
May be asked to work a flexible schedule which may include holidays.
May be asked to travel for business or professional development purposes.
May be asked to work hours outside of normal business hours.
Other Duties: Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Cayuse is an Equal Opportunity Employer. All employment decisions are based on merit, qualifications, skills, and abilities. All qualified applicants will receive consideration for employment in accordance with any applicable federal, state, or local law.
Pay Range
USD $100,000.00 - USD $185,000.00 /Yr.
Location: US-DC-Washington
截至ID: 104382
Category: Information Technology
Position Type: Full-Time Salary Exempt
Remote: No
Clearance Required: Top Secret
#J-18808-Ljbffr