Senior Database Architect — DHA EIM on AWS GovCloud

pivotpathsolutions; Fairfax (VA); On-site; USD 130,000 - 170,000; Full time

Benefits offered by this job

Health insurance

Life insurance

401(k) plan

HSA

FSA

Education reimbursement

Employee referral

Job summary

Pivot Path Solutions, LLC is seeking a Senior Database Architect to design, implement, and sustain the databases behind DHA’s EIM platform. You will ensure performance, availability, and security, and lead large data migrations across HAIMS, DMACS, and related systems.

The role is based in the National Capital Region with readiness to travel to Falls Church, VA within two hours. Strong SQL Server experience and OpenText familiarity are required.

Qualifications

• Experience with large data migrations and ETL processes.
• Experience implementing database schemas within SQL Server.
• Strong SQL programming and performance tuning skills.

Responsibilities

• Design, implement, and sustain EIM workflow databases for performance and security.
• Provide DBA, SQL programming, schema design, and data migrations.
• Lead large data migrations and ETL efforts across HAIMS, DMACS, and STR datasets.
• Maintain metadata and data dictionaries for releases.

Skills

SQL Server

ETL

Performance tuning

OpenText databases

AWS GovCloud

Education

BS in Computer Science

Tools

BOXi

OpenText Web Reports

Job description

Pivot Path Solutions, LLC is seeking a Senior Database Architect to design, implement, and sustain the databases behind DHA’s EIM platform. You will ensure performance, availability, and security, and lead large data migrations across HAIMS, DMACS, and related systems.

The role is based in the National Capital Region with readiness to travel to Falls Church, VA within two hours. Strong SQL Server experience and OpenText familiarity are required.