Senior PostgreSQL Database Engineer

Abile Group, LLC; St. Louis (MO); Presencial; USD 140.000 - 190.000; Jornada completa

Descripción de la vacante

Abile Group is seeking a Senior PostgreSQL Database Engineer on a 10-year contract to support an Intelligence Community client. You will administer, design, and optimize PostgreSQL databases across OpenShift environments, ensuring high availability and secure operations.

The ideal candidate holds a Bachelor's Degree with 5+ years in database administration/engineering, plus 8140.01M IAT Level II certification. TS/SCI with CI Poly is required for this role.

Formación

• Bachelor's Degree and 5+ years of experience in database administration, engineering, or architecture.
• 8140.01M IAT Level II certification.
• Hands-on experience administering and supporting PostgreSQL databases.
• Relational database design, data modeling, SQL, schema development, indexing, and query optimization.
• Experience backups, restores, upgrades, and routine maintenance.
• Knowledge of high availability, replication, and disaster recovery concepts.
• Ability to collaborate with developers and infrastructure engineers.
• Strong analytical, troubleshooting, documentation, and communication skills.

Responsabilidades

• Administer PostgreSQL databases and manage configurations, users, roles, and access.
• Design and refine schemas, data models, and indexing to support applications.
• Optimize SQL queries and execution plans for performance.
• Support PostgreSQL in OpenShift environments with other teams.
• Maintain backup and restore procedures and validate recoveries.
• Monitor database health, logging, alerting, and capacity planning.
• Collaborate with software developers on schema design and data access patterns.
• Drive continuous improvement in performance, reliability, and maintainability.
• Plan and execute upgrades, migrations, and modernization.
• Establish and maintain database standards and security controls.

Conocimientos

PostgreSQL administration

Relational design & data modeling

SQL performance tuning

OpenShift integration

High availability & DR

Backup & restore procedures

Monitoring & logging

Collaboration with engineers

Documentation & communication

Security practices & access controls

Educación

Bachelor's Degree

Herramientas

OpenShift

Descripción del empleo

Abile Group has an exciting and challenging opportunity for a Senior PostgreSQL Database Engineer on a 10 year contract providing User Facing and Data Center Services supporting an Intelligence Community customer. All the personnel on the team will work together to support innovative design, engineering, procurement, implementation, operations, sustainment and disposal of user facing and data center information technology (IT) services on multiple networks and security domains, at multiple locations worldwide, to support the IC mission.
The right candidate will possess the below skills and qualifications and be ready to handle all responsibilities independently and professionally.

• Administer PostgreSQL databases Manage database configuration, user accounts, roles, permissions, routine maintenance, patching, upgrades, and operational troubleshooting.
• Design and improve database architectures Develop and refine schemas, data models, indexing strategies, and data access patterns to support application functionality, performance, and evolving system requirements.
• Optimize database performance Analyze SQL queries and execution plans, identify performance bottlenecks, and implement improvements to queries, indexes, database configuration, and resource utilization.
• Support database operations in OpenShift environments Collaborate with platform and application teams to support PostgreSQL deployment, connectivity, configuration, monitoring, and operational integration with OpenShift-based systems.
• Maintain database reliability and recoverability Implement and maintain backup and restore procedures, validate recovery processes, and support existing high-availability, replication, and disaster recovery capabilities.
• Monitor database health Configure and maintain database monitoring, logging, alerting, capacity tracking, and operational reporting to identify and resolve issues proactively.
• Collaborate with software developers Advise on schema design, SQL development, transaction management, data access patterns, and database integration to ensure efficient and reliable application behavior.
• Drive continuous improvement Identify database performance, reliability, scalability, and maintainability improvements; evaluate appropriate tools and approaches; and implement practical solutions.
• Support database lifecycle management Plan and execute database upgrades, migrations, configuration changes, and modernization efforts while minimizing operational risk and service disruption.
• Establish and maintain standards Document database architecture, configurations, security controls, operational procedures, and recommended engineering practices.
• Maintain database security Apply appropriate access controls, least-privilege permissions, auditing, and security practices in accordance with applicable customer and system requirements.
• Provide technical guidance Serve as the primary database technical resource for the engineering team, helping troubleshoot issues and make informed decisions about database design and operational practices.

Clearance Required TS/SCI with ability to obtain a CI Poly.
Degree and Years of Experience Bachelor's Degree and 5+ years of experience in database administration, database engineering, database architecture, or a related technical discipline. (Additional Education, Training, Certifications or Work Experience can be substituted in lieu of degree or work experience).
Required Certifications

• 8140.01M IAT Level II certification.

Required Skills

• Hands-on experience administering and supporting PostgreSQL databases.
• Experience with relational database design, data modeling, SQL, schema development, indexing, and query optimization.
• Experience troubleshooting database issues and managing database users, roles, permissions, and configurations.
• Experience with database backups, restores, upgrades, and routine maintenance.
• Working knowledge of database high availability, replication, and disaster recovery concepts.
• Ability to collaborate with developers and infrastructure engineers to resolve technical issues and improve system performance.
• Strong analytical, troubleshooting, documentation, and communication skills.

Desired Skills

• Experience supporting PostgreSQL in OpenShift, Kubernetes, containerized, or Linux-based environments.
• Experience with PostgreSQL replication, failover, connection pooling, or high-availability technologies.
• Experience with database monitoring, logging, alerting, and performance diagnostics.
• Experience supporting both transactional and analytical data workloads.
• Experience with database automation, scripting, infrastructure as code, or repeatable deployment practices.
• Experience planning and executing database migrations, upgrades, and modernization initiatives.
• Familiarity with database security practices in regulated or classified environments.
• Experience with Oracle database administration or Oracle-to-PostgreSQL migration.

Abile Group, founded in July 2004 to support the Intelligence Community and its contractors across Enterprise Analytics, IT & Systems Engineering, and Program & Project Management, merged with Valiant Solutions in January 2026 - an established provider of cybersecurity technologies and services for Federal Agencies since 2005. Together, this partnership creates a stronger, more integrated cybersecurity organization with expanded opportunities for employees, deeper technical collaboration, and a unified mission. With significant experience serving the Federal Government, we remain dedicated to our employees and clients and seek high‑performing professionals who excel at providing guidance, developing solutions, and delivering implementation support that blends industry best practices with client expertise and Abile’s broad technical capabilities.
Abile is committed to hiring the most qualified and best fit person for the job - always has, always will. Anyone requiring reasonable accommodations should email [e-mail] with requested details. A member of the HR team will respond to your request within 2 business days.