TS/SCI PostgreSQL Architect - Mission-Critical DB Design

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

Benefits offered by this job

Health/Dental/Vision

401(k) match

Accrued PTO

Life insurance

Referral bonuses

Job summary

D2 Technical Services is seeking a PostgreSQL Database Architect to analyze, design, implement, and support database infrastructure for sensitive government-related workloads in St. Louis, MO.

This role requires deep PostgreSQL expertise and an active TS/SCI clearance. You will collaborate with developers and operations teams to optimize schemas, perform migrations, and ensure high availability, security, and regulatory compliance.

Qualifications

• Bachelor’s degree in Computer Science, or related technical discipline, or equivalent experience.
• 5+ years of related database analysis and/or administration experience.
• PostgreSQL experience required; Oracle DB admin is a plus.
• Experience in PostgreSQL administration, tuning, HA solutions, and performance tuning.
• Experience with backups, restores, migrations, and snapshot technologies.
• Knowledge of efficient database table structures for transactional and warehouse data.
• Migration experience with Oracle, MySQL, and PostgreSQL.
• TS/SCI clearance required.

Responsibilities

• Manages the functionality and efficiency of servers running on one or more operating systems.
• Maintains database integrity and security, configures RBAC, and sets up administrative accounts.
• Sets up, administers, and services accounts.
• Maintains documentation for configurations, standards, and procedures.
• Interacts with users and evaluates vendor products.
• Develops and monitors policies for resource allocation.
• Develops testing strategies and documents results.
• Provides advice on performance tuning and end-user training.
• Keeps current knowledge of relevant technologies.
• Evaluates open-source or vendor tools and participates in migrations.
• Collaborates with developers on schema design, query optimization, and stored procedures.
• Plans and executes database upgrades, patching, and migrations.
• Ensures compliance with industry standards and regulatory requirements.

Skills

PostgreSQL administration

RBAC

Security best practices

Database tuning

Vendor/product evaluation

Education

Bachelor's degree in Computer Science

Tools

Oracle database administration

Job description

D2 Technical Services is seeking a PostgreSQL Database Architect to analyze, design, implement, and support database infrastructure for sensitive government-related workloads in St. Louis, MO.

This role requires deep PostgreSQL expertise and an active TS/SCI clearance. You will collaborate with developers and operations teams to optimize schemas, perform migrations, and ensure high availability, security, and regulatory compliance.