Senior PostgreSQL Architect - TS/SCI Eligible

Abile Group, LLC; St. Louis (MO); On-site; USD 140,000 - 190,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

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

Education

Bachelor's Degree

Tools

OpenShift

Job description

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.