PostgreSQL Database Architect

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., * 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.

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

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