Mission-Critical PostgreSQL Architect (TS/SCI, St. Louis)

Meridian Systematics; St. Louis (MO); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

401(k)

Dental insurance

Flexible schedule

Health insurance

Parental leave

Vision insurance

Job summary

Meridian Systematics in St. Louis, MO seeks an experienced PostgreSQL Database Architect to design, implement, administer, and optimize PostgreSQL database environments for a mission-critical Intelligence Community customer.

The ideal candidate will have hands-on PostgreSQL administration and performance-tuning experience, including high-availability solutions, migrations, backups, and modernization initiatives, while ensuring security and compliance.

Qualifications

• Active TS/SCI clearance.
• 5+ years of database administration experience.
• Hands-on PostgreSQL administration and performance tuning.
• Experience implementing and supporting database high-availability solutions.
• Experience with backup, restore, migration, and snapshot technologies.
• Experience monitoring and managing PostgreSQL environments and alerts.
• Bachelor's degree in Computer Science or related field, or equivalent.
• U.S. Citizenship required.

Responsibilities

• Design, implement, administer, and support PostgreSQL database environments.
• Maintain database availability, integrity, security, and performance.
• Configure RBAC, administrator accounts, and service accounts.
• Monitor database environments and configure PostgreSQL server alerts.
• Perform database performance tuning and troubleshoot issues.
• Plan and execute upgrades, patching, backups, restores, and migrations.
• Implement and support high-availability and recovery solutions.
• Collaborate with developers on schema design, query optimization, and stored procedures.

Skills

PostgreSQL administration

Performance tuning

High-availability

RBAC configuration

Security/compliance

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle

MySQL

PostgreSQL

Job description

Meridian Systematics in St. Louis, MO seeks an experienced PostgreSQL Database Architect to design, implement, administer, and optimize PostgreSQL database environments for a mission-critical Intelligence Community customer.

The ideal candidate will have hands-on PostgreSQL administration and performance-tuning experience, including high-availability solutions, migrations, backups, and modernization initiatives, while ensuring security and compliance.