Apply Now

Postgres Database Administrator, SME

Washington, DC, US • Posted 2 days ago • Updated 7 hours ago

Full Time

On-site

USD $100,000.00 - 185,000.00 per year

Cayuse Holdings, LLC

Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

Design Management
Optimization
DevOps
Innovation
Adaptability
Collaboration
Teamwork
High Availability
Streaming
Failover
Performance Tuning
Capacity Management
Database Security
Encryption
Auditing
Archiving
Database Administration
Regulatory Compliance
STIG
Risk Management Framework
RMF
Computer Science
Database
PostgreSQL
Replication
Clustering
SQL Tuning
Query Optimization
Backup
Recovery
Disaster Recovery
Amazon Web Services
Remote Desktop Services
Amazon RDS
Splunk
Cloud Computing
Scripting
Bash
Python
Security Clearance
PASS
Conflict Resolution
Problem Solving
Analytical Skill
Communication
Microsoft
Adobe
Microsoft Excel
Microsoft PowerPoint
Adobe Acrobat
Management
Health Care
Insurance
Productivity
System Integration Testing
Professional Development
Law

Summary

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, Cloud watch 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, that can 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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91099930
Position Id: 104382
Posted 2 days ago

Company Info

About Cayuse Holdings, LLC

Founded initially in 2006, Cayuse Holdings is today comprised of a family companies headquartered near Pendleton, Oregon, with offices in the Washington D.C. metro area, and Honolulu, HI. Tribally owned by the Confederated Tribes of the Umatilla Indian Reservation (CTUIR), Cayuse Holdings is a 100% Indian Owned Economic Enterprise and a foremost provider of responsible sourcing/certified diversity solutions for commercial, government, and tribal clients.

Our Mission

To become the #1 American Indian-owned commercial, government, and tribal contractor, providing trusted value for our clients, reliable and rewarding careers for our employees and contributing to the growth of the CTUIR.

Our Vision

Grow the Company, Grow the People!

Šapásttawaxt kutkutpama,́ Šapásttawaxt natítayt

Go to company profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

iData System Engineer

Washington, District of Columbia

•

Today

Overview The iData System Engineer is responsible for providing in-depth subject matter expertise in the development, design, implementation, and analysis of technical systems, and solutions. This role evaluates complex challenges, proposes innovative solutions, and guide teams to execute advanced technical strategies. This position aligns with Cayuse's core values of Innovation, Excellence, Collaboration, Adaptability, and Integrity by fostering technical solutions that meet customer needs, p

Full-time

USD 135,000.00 - 141,489.00 per year

Senior Cloud Developer

Washington, District of Columbia

•

Today

Overview The Senior Cloud Developer will serve as a technical architect and security gatekeeper for an AWS cloud hosting platform. They ensure platform readiness to intake containerized applications and develop automated pipelines to build, deploy and monitor with "security-by-design" principles This position performs all duties and responsibilities in accordance with the Mission, Vision, and Core Values of Cayuse. Responsibilities Develop and implement cloud infrastructure for applications

Full-time

USD 150,000.00 - 169,790.00 per year

Systems Administrator

Hurlburt Field, Florida

•

Today

Overview Employment in this role is conditional upon successful execution of the contract by the client. The Work The Systems Administrator is responsible for the effective provisioning, installation, configuration, operation, and maintenance of systems hardware, software, and related infrastructure in support of the client's missions and operational requirements. This position aligns with Cayuse's core values of Innovation, Excellence, Collaboration, Adaptability, and Integrity by fostering te

Full-time

Database Administrator

Austin, Texas

•

Today

Overview JOB TITLE: Database Administrator CAYUSE COMPANY: Cayuse Civil Services, LLC DEPT/CONTRACT TX DIR LOCATION Hybrid in Austin, TX SALARY: $108,160.00-$153,920.00 EMPLOYEE TYPE: Full-Time Salary Exempt TRAVEL No RELOCATION No Employment in this role is conditional upon successful execution of the contract by the client. The Work The Database Administrator will perform advanced database administration and management functions in support of highly complex applications characterized by sophis

Full-time

USD 108,160.00 - 153,920.00 per year

Search all similar jobs