Security-Cleared PostgreSQL Database Architect

D2 Consulting; 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

STD/LTD/Life Insurance

Referral Bonuses

Professional development reimbursement

Job summary

D2 Consulting seeks a PostgreSQL Database Architect in St. Louis, MO to analyze, design, implement, and support database infrastructure. The role emphasizes high-availability, security, and scalable data solutions for mission-critical applications.

The ideal candidate has a BS in CS or related field, 5+ years of PostgreSQL administration and tuning, experience with backups, migrations, RBAC, and an active TS/SCI clearance. On-site work with competitive compensation and benefits awaits.

Qualifications

• Bachelor’s degree or equivalent in CS or related field.
• 5+ years of database analysis/administration experience.
• Strong PostgreSQL experience and tuning.
• Backups, migrations, and snapshot technologies knowledge.
• Experience building efficient transactional and warehouse schemas.
• RBAC and security practices knowledge.
• Migration experience: Oracle, MySQL, PostgreSQL.
• Active TS/SCI clearance required.

Responsibilities

• Manage group of servers running on one or more operating systems.
• Maintain database integrity, RBAC, and admin accounts.
• Set up, administer, and service accounts.
• Maintain configuration docs and procedures.
• Collaborate with developers on schema design, queries, and stored procedures.
• Plan upgrades, patching, migrations.
• Ensure compliance with standards and regulations.
• Provide performance tuning advice and training to end-users.

Skills

PostgreSQL administration

Database tuning

High-availability databases

RBAC and security

Migration experience (Oracle/MySQL)/PG

Education

Bachelor’s degree in Computer Science or related

Tools

Oracle DB

MySQL

PostgreSQL

Job description

D2 Consulting seeks a PostgreSQL Database Architect in St. Louis, MO to analyze, design, implement, and support database infrastructure. The role emphasizes high-availability, security, and scalable data solutions for mission-critical applications.

The ideal candidate has a BS in CS or related field, 5+ years of PostgreSQL administration and tuning, experience with backups, migrations, RBAC, and an active TS/SCI clearance. On-site work with competitive compensation and benefits awaits.