Senior PostgreSQL Database Engineer

Valiant Solutions, LLC • St. Louis, MO

6d • $97,400 - $139,200 • Onsite

About The Position

Valiant Solutions is seeking a Senior PostgreSQL Database Engineer to join a program providing user-facing and data center services for an Intelligence Community customer. The team supports the design, engineering, procurement, implementation, operations, sustainment, and disposal of user-facing and data center IT services across multiple networks, security domains, and worldwide locations.

The engineer administers and improves PostgreSQL databases, supporting database architecture, performance, reliability, recoverability, monitoring, security, and lifecycle management. The role collaborates with developers, platform teams, and infrastructure engineers, including support for PostgreSQL deployment and operations in OpenShift environments. The engineer also serves as a primary database technical resource for the engineering team.

This position is onsite in St. Louis, Missouri. A TS/SCI clearance and the ability to obtain and maintain a CI Polygraph are required. The anticipated salary range is $97,400–$139,200.

Requirements

• Bachelor's degree and 5+ years of systems administration experience; additional education, training, certifications, or work experience may be substituted for a degree or work experience.
• 8140.01M IAT Level II certification.
• Hands-on experience administering and supporting PostgreSQL databases.
• Experience with relational database design, data modeling, SQL, schema development, indexing, and query optimization.
• Experience troubleshooting database issues and managing database users, roles, permissions, and configurations.
• Experience with database backups, restores, upgrades, and routine maintenance.
• Working knowledge of database high availability, replication, and disaster recovery concepts.
• Ability to collaborate with developers and infrastructure engineers to resolve technical issues and improve system performance.
• Strong analytical, troubleshooting, documentation, and communication skills.
• TS/SCI clearance and ability to obtain and maintain a CI Polygraph.

Nice To Haves

• Experience supporting PostgreSQL in OpenShift, Kubernetes, containerized, or Linux-based environments.
• Experience with PostgreSQL replication, failover, connection pooling, or high-availability technologies.
• Experience with database monitoring, logging, alerting, and performance diagnostics.
• Experience supporting both transactional and analytical data workloads.
• Experience with database automation, scripting, infrastructure as code, or repeatable deployment practices.
• Experience planning and executing database migrations, upgrades, and modernization initiatives.
• Familiarity with database security practices in regulated or classified environments.
• Experience with Oracle database administration or Oracle-to-PostgreSQL migration.

Responsibilities

• Administer PostgreSQL database configuration, user accounts, roles, permissions, routine maintenance, patching, upgrades, and operational troubleshooting.
• Develop and refine schemas, data models, indexing strategies, and data access patterns to support applications, performance, and evolving system requirements.
• Analyze SQL queries and execution plans, identify performance bottlenecks, and improve queries, indexes, database configuration, and resource utilization.
• Collaborate with platform and application teams to support PostgreSQL deployment, connectivity, configuration, monitoring, and operational integration with OpenShift-based systems.
• Implement and maintain backup and restore procedures, validate recovery processes, and support high availability, replication, and disaster recovery capabilities.
• Configure and maintain database monitoring, logging, alerting, capacity tracking, and operational reporting to identify and resolve issues proactively.
• Advise software developers on schema design, SQL development, transaction management, data access patterns, and database integration.
• Identify and implement practical improvements to database performance, reliability, scalability, and maintainability.
• Plan and execute database upgrades, migrations, configuration changes, and modernization efforts while minimizing operational risk and service disruption.
• Document database architecture, configurations, security controls, operational procedures, and recommended engineering practices.
• Apply access controls, least-privilege permissions, auditing, and security practices in accordance with applicable customer and system requirements.
• Serve as the primary database technical resource for the engineering team, providing troubleshooting support and guidance on database design and operations.

Benefits

• Choice of medical plans, including an HSA option and PPO, with company contributions.
• Dental and vision coverage for employees and their families.
• Company-paid life, short-term disability, and long-term disability insurance.
• Optional supplemental life, accident, and critical illness coverage.
• 401(k) retirement plan with company match.
• Paid time off that grows with years of service and paid federal holidays.
• Paid certifications, professional development, and access to the Valiant University training portal.
• Flexible spending accounts.
• Wellness and fitness program.
• Referral bonuses.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior