TS/SCI PostgreSQL Database Architect & Ops Lead

D2 Technical Services; St. Louis (MO); On-site; USD 140,000 - 150,000; Full time

Benefits offered by this job

Health/Dental/Vision

401(k) match

Accrued PTO

STD/LTD/Life Insurance

Referral Bonuses

Professional development reimbursement

Job summary

D2 Technical Services is seeking a PostgreSQL DBA with an active TS/SCI clearance to join our team onsite in Missouri. You will serve as the team''s primary database SME, partnering with software developers and systems engineers to maintain reliable operations while improving performance, design, security, and maintainability.

The role covers administration, architecture design, performance optimization, OpenShift deployment, backups, disaster recovery, monitoring, and collaboration.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related technical discipline, or equivalent education, training, certifications, and experience.
• Five or more years of experience in database administration, database engineering, database architecture, or a related technical discipline.
• Hands-on experience administering and supporting PostgreSQL databases.
• Experience with relational database design, data modeling, SQL, schema development, indexing, and query optimization.

Responsibilities

• Administer PostgreSQL databases: manage configuration, users, roles, permissions, maintenance, patching, upgrades, and troubleshooting.
• Design and improve database architectures: develop schemas, data models, indexing strategies, and data access patterns.
• Optimize database performance: analyze queries and execution plans, implement improvements to queries, indexes, and configurations.
• Support database operations in OpenShift environments: collaborate with platform/application teams for deployment, connectivity, configuration, and monitoring.
• Maintain database reliability and recoverability: implement backup/restore procedures, validate recovery, support high availability and replication.
• Monitor database health: configure monitoring, logging, alerting, capacity tracking, and reporting.

Skills

PostgreSQL expertise

Analytical reasoning

Troubleshooting

Collaboration

Education

Bachelor's degree in Computer Science / IT or equivalent

Tools

OpenShift

SQL

Replication / HA tools

Job description

D2 Technical Services is seeking a PostgreSQL DBA with an active TS/SCI clearance to join our team onsite in Missouri. You will serve as the team''s primary database SME, partnering with software developers and systems engineers to maintain reliable operations while improving performance, design, security, and maintainability.

The role covers administration, architecture design, performance optimization, OpenShift deployment, backups, disaster recovery, monitoring, and collaboration.