Senior PostgreSQL Database Engineer

Valiant Solutions is seeking a Senior PostgreSQL Database Engineer to join our rapidly growing, innovative team!

The Senior PostgreSQL Database Engineer will join a program providing User-facing and Data Center Services supporting an Intelligence Community customer. The team will work together to support innovative design, engineering, procurement, implementation, operations, sustainment, and disposal of user-facing and data center information technology (IT) services across multiple networks and security domains, at multiple locations worldwide, to support the IC mission.

Named one of the Washington Business Journal's
Best Places to Work every year since 2014, Valiant is proud of our employee-centric culture and commitment to excellence. If you are interested in learning more about Valiant and this opportunity.

Location: Onsite in St. Louis, MO pr Springfield, VA

Required Clearance: TS/SCI with the ability to obtain and maintain a CI Polygraph.

Required Education and

Certifications:

• Bachelor's Degree and 5+ years of experience in systems administration. (Additional Education, Training, certifications, or Work Experience can be substituted in lieu of a degree or work experience).
• 8140.01M IAT Level II certification.

Required Skills:

• 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.

Desired

Skills:

• Experience supporting PostgreSQL in Open Shift, 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 databases:
  Manage database configuration, user accounts, roles, permissions, routine maintenance, patching, upgrades, and operational troubleshooting.
• Design and improve database architectures:
  Develop and refine schemas, data models, indexing strategies, and data access patterns to support application functionality, performance, and evolving system requirements.
• Optimize database performance:
  Analyze SQL queries and execution plans, identify performance bottlenecks, and implement improvements to queries, indexes, database configuration, and resource utilization.
• Support database operations in Open Shift environments:
  Collaborate with platform and application teams to support PostgreSQL deployment, connectivity, configuration, monitoring, and operational integration with Open Shift-based systems.
• Maintain database reliability and recoverability:
  Implement and maintain backup and restore procedures, validate recovery processes, and support existing high-availability, replication, and disaster recovery capabilities.
• Monitor database health:
  Configure and maintain database monitoring, logging, alerting, capacity tracking, and operational reporting to identify and resolve issues proactively.
• Collaborate with software developers:
  Advise on schema design, SQL development, transaction management, data access patterns, and database integration to ensure efficient and reliable application behavior.
• Drive continuous improvement:
  Identify database performance, reliability, scalability, and maintainability improvements; evaluate appropriate tools and approaches; and implement practical solutions.
• Support database lifecycle management:
  Plan and execute database upgrades, migrations, configuration changes, and modernization efforts while minimizing operational risk and…