Concept Plus Logo

Concept Plus

Postgres Database Administrator

Posted 12 Days Ago
Remote
Hiring Remotely in United States
Senior level
Remote
Hiring Remotely in United States
Senior level
The PostgreSQL Database Administrator focuses on database performance optimization, schema design, and supports PGLite deployments for low-bandwidth operations, ensuring secure and compliant database management.
The summary above was generated by AI

About Concept Plus
Concept Plus is a mission-focused technology solutions provider that transforms IT concepts into impactful solutions for federal agencies. Headquartered in Fairfax, VA, we bring the agility, responsiveness, and customer intimacy of a small business combined with the quality and infrastructure of a larger firm.


Recognized as an award-winning Oracle partner, we have delivered innovative solutions across Defense, Intelligence, Civilian, Health IT, and Tribal sectors. Our highly certified experts build systems that drive efficiency, accelerate modernization, and ensure mission outcomes with certainty.


We offer competitive pay, comprehensive health, dental, and vision insurance, paid life insurance, paid time off, 11 paid holidays, performance bonuses, tuition reimbursement, unlimited training, and the opportunity to thrive in a collaborative, flexible, and innovative environment.


For more information, visit www.conceptplus.com.


About the role

Concept Plus is seeking a PostgreSQL Database Administrator (DBA) with at least 7 years of database engineering and administration experience to support a mission-critical, enterprise-scale client application. This role focuses heavily on Postgres SQL performance optimization, schema design, database reliability, and support for PGLite deployments—used to enable disconnected, low-bandwidth, and DDIL (Denied, Degraded, Intermittent, Limited) operations. The ideal candidate brings strong expertise in secure database operations, Cloud One environments, Zero Trust practices, and DevSecOps-aligned data management.


What you'll do

  • Core PostgreSQL Administration:
    • Administer, configure, and optimize PostgreSQL databases for secure DoD applications.
    • Design, maintain, and version-control Postgres SQL schemas, stored functions, triggers, indexes, roles, and extensions.
    • Conduct advanced SQL optimization: query tuning, indexing strategies, partitioning, and performance diagnostics.
    • Monitor and resolve database issues including slow queries, lock contention, replication concerns, and latency.
    • Maintain secure backup/restore strategies and participate in continuity of operations (COOP) planning.
    • Support ingestion and stabilization of inherited databases during transition-in activities.
  • PGLite / DDIL Data Operations:
    • Manage and maintain PGLite (embedded PostgreSQL) instances used in disconnected or low-connectivity operational environments.
    • Support synchronization strategies between PGLite and central PostgreSQL systems, ensuring data integrity during DDIL conditions.
    • Troubleshoot data serialization, compression, and synchronization workflows for offline-first usage.
    • Assist with field deployment preparation, including performance testing, data seeding, and reliability validation for PGLite nodes.
  • DevSecOps & CI/CD Integration:
    • Integrate database migration scripts, schema validations, and regression checks into secure CI/CD pipelines.
    • Address SAST/DAST/SCA scan findings related to database components, SQL vulnerabilities, and ORM/library exposures.
    • Collaborate with DevSecOps teams to enable secure, automated deployments and database lifecycle operations.
    • Support build packaging, release readiness, and participation in JITC/DT&E test cycles.
  • Security, Compliance & ATO Responsibilities:
    • Apply DoD cybersecurity frameworks (NIST SP 800 53, 800 7, CMMC, DISA STIGs) to secure PostgreSQL environments.
    • Implement and enforce database encryption (in transit and at rest), auditing, logging, and least privilege access controls.
    • Document and remediate vulnerabilities, maintain POA&Ms, and support ongoing ATO compliance.
    • Maintain secure handling of PII, PHI, and CUI across all database operations.
  • Integration & JOMIS Data Interoperability
    • Maintain and enhance database structures supporting integrations across TBLD M, TMDS, OMDS, MedCOP, and other JOMIS systems.
    • Support data ingestion, transformations, and exchange based on ICDs and system-to-system interface requirements.
    • Troubleshoot data flow issues and collaborate with cross functional development teams.
  • Additional Responsibilities
    • Maintain database operational documentation including runbooks, installation guides, upgrade steps, and migration procedures.
    • Support Tier 1–3 troubleshooting during integration testing, fielding events, and production operations.
    • Participate in Agile ceremonies: planning, stand-ups, backlog refinement, sprint reviews, and retrospectives.
    • Collaborate across multi-vendor teams, government stakeholders, and cloud/security engineering groups.
    • Contribute to risk identification, performance tuning, and continuous improvement initiatives.


Required Qualifications

  • US Citizen
  • Ability to obtain and/or maintain a government clearance.
  • 7+ years of professional PostgreSQL administration experience, including secure production environments.
  • Bachelors Degree
  • Experience managing PGLite or embedded PostgreSQL databases for offline or DDIL operations.
  • Strong understanding of schema design, normalization, indexing, partitioning, query tuning, and database performance optimization.
  • Experience managing PostgreSQL in cloud environments such as Cloud One, AWS GovCloud, or OCI.
  • Hands-on experience with schema versioning tools and migration frameworks aligned with MOSA principles.
  • Familiarity with DevSecOps practices and integration of database components into CI/CD pipelines.
  • Experience supporting secure environments governed by DoD cybersecurity and ATO requirements.
  • Strong analytical, troubleshooting, and documentation skills.
  • Ability to work collaboratively across multi-vendor and government-integrated teams.


Preferred Qualifications

  • Experience with the Cloud One platform
  • Experience supporting OPMED systems · Familiarity with Defense Health Agency systems such as (OMDS, MedCOP, MHS GENESIS)
  • Experience with micro-frontend architecture
  • Familiarity with GraphQL and Apollo Client
  • Contributions to open-source projects or a demonstrable public portfolio


Concept Plus is an Equal Opportunity Employer. As such, we will give your application full consideration without regard to your race, color, religion, sex, age, national origin, disability, veteran status, sexual orientation, gender identity, or any other classification protected by federal, state, or local law.


Similar Jobs

2 Days Ago
Remote
United States
150K-165K Annually
Expert/Leader
150K-165K Annually
Expert/Leader
Cloud • Information Technology • Consulting
The PostgreSQL Technical Solution Architect will lead architectural design, manage database lifecycle, optimize performance, troubleshoot issues, and guide customer engagements while mentoring junior staff.
Top Skills: AnsibleAWSAzureBarmanCrunchy DataEdbElkGCPGrafanaHaproxyKubernetesLinuxPatroniPgbackrestPgbouncerPostgresPrometheusTerraform
5 Hours Ago
In-Office or Remote
91K-141K Annually
Mid level
91K-141K Annually
Mid level
Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
The Experienced Staff Analyst manages staffing reporting, coordinates facility needs, conducts data analysis, and facilitates onboarding for the Space and Intelligence team.
Top Skills: Adaptive PlanningMS OfficeMylearning
5 Hours Ago
Remote
North Carolina, USA
118K-160K Annually
Senior level
118K-160K Annually
Senior level
Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
The Senior Flight Engineer will perform inspections, instruct aircrew, and develop curriculum for V22 aircrew training.
Top Skills: Federal Aviation Administration (Faa) Class 2 Medical Examination

What you need to know about the Austin Tech Scene

Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.

Key Facts About Austin Tech

  • Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
  • Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
  • Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
  • Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account