PostgreSQL Database Architect — High-Availability & Tuning

D2 Technical Services; Springfield (VA); On-site; USD 130,000 - 140,000; Full time

Benefits offered by this job

Health/Dental/Vision

401(k) match

Accrued PTO

STD/LTD/Life Insurance

Referral Bonuses

Professional development reimbursement

Job summary

D2 Technical Services is seeking a PostgreSQL Database Architect to analyze, design, implement, and support database infrastructure. You will work with cross-functional teams to ensure performance, security, and reliability across PostgreSQL environments.

The role requires a TS/SCI clearance and 5+ years of database experience, with strong emphasis on high availability, backups, and migrations. On-site in Virginia with competitive compensation and benefits.

Qualifications

• Bachelor's degree or equivalent in CS or related field.
• 5+ years of database analysis/administration experience.
• PostgreSQL experience required; Oracle DB experience a plus.
• Experience with high-availability setups and performance tuning.
• Experience with backups, migrations, and snapshot technologies.
• Experience with RBAC, security and access control.
• Experience migrating across Oracle, MySQL, PostgreSQL.

Responsibilities

• Manages the functionality and efficiency of a group of servers running on one or more operating systems.
• Maintains database integrity and security, configures RBAC, and sets up administrative accounts.
• Sets up, administers, and services accounts.
• Maintains documentation for configurations, standards, and procedures.
• Interacts with users and evaluates vendor products.
• Develops and monitors policies and standards for allocation related to computing resources.
• Develops and implements testing strategies and document results.
• Provides advice on performance tuning and training to end-users.
• Maintains current knowledge of relevant technologies as assigned.
• Evaluates open-source or vendor tools and participates in database migration/special modernization projects.
• Collaborates with developers on schema design, query optimization, and stored procedures.
• Plans and executes database upgrades, patching, and migrations.
• Ensures compliance with industry standards and regulatory requirements.

Skills

Database analysis

Schema design

Performance tuning

Security RBAC

On-call support

Education

Bachelor’s degree in CS or related field

Tools

PostgreSQL

Oracle

MySQL

RBAC configuration

Migration tooling

Job description

D2 Technical Services is seeking a PostgreSQL Database Architect to analyze, design, implement, and support database infrastructure. You will work with cross-functional teams to ensure performance, security, and reliability across PostgreSQL environments.

The role requires a TS/SCI clearance and 5+ years of database experience, with strong emphasis on high availability, backups, and migrations. On-site in Virginia with competitive compensation and benefits.