PostgreSQL Database Architect

Meridian Systematics; Springfield (VA); On-site; USD 120,000 - 190,000; Full time

Benefits offered by this job

401(k)

Dental insurance

Health insurance

Paid time off

Parental leave

Training & development

Job summary

Meridian Systematics in Springfield, VA seeks a highly skilled PostgreSQL Database Architect (TS/SCI) to lead secure, scalable database environments supporting mission-critical applications. The role requires providing technical leadership, planning upgrades, and ensuring reliability across enterprise PostgreSQL deployments.

Responsibilities include performance tuning, DR planning, RBAC security, and collaboration with software and system teams to optimize database schemas and integration.

Qualifications

• Active TS/SCI security clearance is required.
• Bachelor's degree or equivalent in a related technical field.
• Minimum 5 years designing, administering, and supporting enterprise database environments.
• Experience with PostgreSQL high-availability, replication, backup, and disaster recovery.
• Strong SQL performance tuning and schema design skills.
• Experience with RBAC and cybersecurity policy compliance.

Responsibilities

• Architect, design, administer, and sustain enterprise PostgreSQL database environments.
• Develop secure, highly available database architectures with backup and DR solutions.
• Monitor and optimize performance through capacity planning and tuning.
• Plan upgrades, patches, migrations, and modernization efforts with minimal impact.
• Collaborate with developers, sysadmins, and stakeholders on schema design and integration.
• Develop database standards, procedures, and operational documentation.
• Validate backup, recovery, snapshot, and business continuity strategies.
• Evaluate DB technologies and provide modernization recommendations.
• Develop and execute testing strategies for performance, availability, and security.

Skills

PostgreSQL architecture

Database performance tuning

High availability & disaster recovery

RBAC & security controls

Technical leadership

Cross-functional collaboration

Documentation & standards

Education

Bachelor's degree in Computer Science/IT/IS or related field

Tools

Oracle database environments

Job description

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Paid time off
• Parental leave
• Training & development

PostgreSQL Database Architect (TS/SCI)

Location: Springfield, VA

Position Summary

An active Top Secret/Sensitive Compartmented Information (TS/SCI) security clearance is required for this position.

The PostgreSQL Database Architect provides technical leadership in the design, implementation, administration, and modernization of enterprise database environments supporting Department of War and Intelligence Community mission objectives. The incumbent architects and maintains secure, scalable, and highly available PostgreSQL database solutions while supporting database performance, security, disaster recovery, and modernization initiatives. Working collaboratively with software developers, system administrators, and mission stakeholders, this position ensures enterprise database environments are optimized for reliability, scalability, and operational performance.

Essential Duties and Responsibilities

• Architect, design, implement, administer, and sustain enterprise PostgreSQL database environments supporting mission-critical applications.
• Develop and maintain secure, highly available, and scalable database architectures, including clustering, replication, backup, recovery, and disaster recovery solutions.
• Monitor, analyze, and optimize database performance through capacity planning, query optimization, indexing strategies, and performance tuning.
• Plan and execute database upgrades, patching, migrations, and modernization initiatives while minimizing operational impact.
• Design and implement database security controls, including Role-Based Access Control (RBAC), administrative account management, auditing, and compliance with organizational cybersecurity policies.
• Collaborate with software developers and system engineers on database schema design, stored procedures, query optimization, and application integration.
• Develop and maintain database standards, configuration baselines, operational procedures, and technical documentation.
• Implement and validate database backup, recovery, snapshot, and business continuity strategies to ensure system resiliency.
• Evaluate commercial and open-source database technologies and provide technical recommendations supporting enterprise modernization efforts.
• Develop and execute database testing strategies to validate performance, availability, scalability, and security.
• Provide technical guidance, troubleshooting, and performance optimization recommendations to development teams and database users.
• Ensure compliance with enterprise security requirements, configuration management practices, and applicable regulatory and organizational standards.

Required Qualifications

• Active Top Secret/Sensitive Compartmented Information (TS/SCI) security clearance.
• U.S. Citizenship.
• Bachelor's degree in Computer Science, Information Technology, Information Systems, or a related technical discipline; or an equivalent combination of education, military service, and relevant professional experience.
• Minimum of 5 years of experience designing, administering, and supporting enterprise database environments.
• Demonstrated experience administering and architecting PostgreSQL database environments.
• Experience implementing PostgreSQL high-availability, replication, backup, recovery, and disaster recovery solutions.
• Experience monitoring, tuning, and optimizing PostgreSQL database performance.
• Experience configuring and managing PostgreSQL server monitoring, alerts, and operational health.
• Experience with database backup, restore, migration, and snapshot technologies.
• Experience designing efficient database schemas supporting transactional and data warehouse environments.
• Experience performing database migrations involving PostgreSQL, Oracle, and MySQL.
• Experience implementing database security, Role-Based Access Control (RBAC), and administrative account management.
• Strong analytical, troubleshooting, documentation, and communication skills.

Preferred Qualifications

• Experience administering Oracle database environments.
• CompTIA Security+ or equivalent DoD 8570/8140 certification.
• Experience supporting Department of War or Intelligence Community enterprise systems.
• Experience with database automation, scripting, and Infrastructure as Code.
• Experience supporting cloud-hosted or hybrid database environments.
• Experience with database monitoring, performance analytics, and enterprise management tools.

Knowledge, Skills, and Abilities

• Expert knowledge of PostgreSQL architecture, administration, and performance optimization.
• Knowledge of database high-availability, clustering, replication, disaster recovery, and backup strategies.
• Knowledge of SQL optimization, database design principles, and enterprise data architecture.
• Knowledge of database security, RBAC, auditing, and cybersecurity best practices.
• Ability to design, implement, and support highly available enterprise database environments.
• Ability to analyze and resolve complex database performance and operational issues.
• Ability to collaborate effectively with software developers, system administrators, cybersecurity personnel, and government stakeholders.
• Ability to prepare technical documentation, database standards, implementation guides, and operational procedures.
• Ability to evaluate emerging database technologies and recommend solutions supporting enterprise modernization initiatives.