PostgreSQL Database Architect

Meridian Systematics; Springfield (VA); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

401(k)

Dental insurance

Flexible schedule

Health insurance

Paid time off

Parental leave

Vision insurance

Job summary

Meridian Systematics in Springfield, VA seeks a PostgreSQL Database Architect to design, implement, administer, and optimize PostgreSQL environments for a mission-critical Intelligence Community customer.

The ideal candidate delivers hands-on PostgreSQL administration and performance tuning, supports high-availability, backups, migrations, and security, and partners with developers on schema design and query optimization to ensure reliable, scalable data platforms.

Qualifications

• Active TS/SCI clearance.
• 5+ years in database admin/analysis.
• Hands-on PostgreSQL administration and performance tuning.
• Experience implementing and supporting database high-availability solutions.
• Experience with backup, restore, migration, and snapshot technologies and strategies.
• Experience monitoring PostgreSQL environments and alerts.
• Knowledge of database architecture and table structures for transactional and warehouse data.
• 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 database-related issues.
• Plan and execute database upgrades, patching, backups, restores, and migrations.
• Implement and support database high-availability and recovery solutions.
• Collaborate with developers on schema design, query optimization, and stored procedures.
• Design and maintain efficient database structures for transactional and data warehouse environments.
• Develop testing strategies, execute testing, and document results.
• Evaluate open-source and vendor database tools and technologies.
• Support database migration and modernization initiatives involving PostgreSQL, Oracle, and MySQL.
• Maintain technical documentation, configurations, standards, and procedures.
• Ensure database environments comply with applicable security, industry, and regulatory requirements.
• Provide technical guidance and database support to users and project teams.

Skills

PostgreSQL administration

Performance tuning

RBAC configuration

Database security

DR/HA planning

Education

Bachelor’s degree in Computer Science or related field

Tools

PostgreSQL

Oracle

MySQL

Job description

Benefits

• 401(k)


• Dental insurance


• Flexible schedule


• Health insurance


• Paid time off


• Parental leave


• Vision insurance

PostgreSQL Database Architect

Location: Springfield, VA
Clearance: Active TS/SCI Required
Citizenship: U.S. Citizenship Required

Position Overview

We are seeking an experienced PostgreSQL Database Architect to support a mission-critical Intelligence Community customer. This position will be responsible for designing, implementing, administering, and optimizing PostgreSQL database environments while ensuring database availability, performance, integrity, and security.

The ideal candidate has strong hands-on PostgreSQL administration and performance-tuning experience, including high-availability solutions, database migrations, backup and recovery strategies, and database modernization initiatives.

Key Responsibilities

• Design, implement, administer, and support PostgreSQL database environments.


• Maintain database availability, integrity, security, and performance.


• Configure role-based access control (RBAC), administrator accounts, and service accounts.


• Monitor database environments and configure PostgreSQL server alerts.


• Perform database performance tuning and troubleshoot database-related issues.


• Plan and execute database upgrades, patching, backups, restores, and migrations.


• Implement and support database high-availability and recovery solutions.


• Collaborate with developers on schema design, query optimization, and stored procedures.


• Design and maintain efficient database structures for transactional and data warehouse environments.


• Develop testing strategies, execute testing, and document results.


• Evaluate open-source and vendor database tools and technologies.


• Support database migration and modernization initiatives involving PostgreSQL, Oracle, and MySQL.


• Maintain technical documentation, configurations, standards, and procedures.


• Ensure database environments comply with applicable security, industry, and regulatory requirements.


• Provide technical guidance and database support to users and project teams.

Required Qualifications

• Active TS/SCI clearance


• 5+ years of database administration and/or database analysis experience


• Hands-on PostgreSQL administration and performance-tuning experience


• Experience implementing and supporting database high-availability solutions.


• Experience with database backup, restore, migration, and snapshot technologies and strategies.


• Experience monitoring and managing PostgreSQL database environments and alerts.


• Knowledge of database architecture and table structures for transactional and warehouse data.


• Bachelor’s degree in Computer Science or a related technical discipline, or an equivalent combination of education, technical training, military experience, and/or relevant work experience.


• U.S. Citizenship required.

Preferred Qualifications

• Oracle database administration experience.


• Database migration experience involving Oracle, MySQL, and PostgreSQL.


• CompTIA Security+ or equivalent certification.


• Experience supporting database modernization initiatives within government or Intelligence Community environments.