Senior PostgreSQL DB Architect - High Availability & Security

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

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.