Senior Database Architect – DHA EIM, SQL Server, AWS GovCloud

Pivot Path Solutions, LLC; Fairfax (VA); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Health insurance

Dental and vision insurance

Employer-paid life insurance

Short-term and long-term disability

Safe Harbor 401(k) plan

Health Savings Account (HSA)

Flexible Spending Account (FSA)

Education reimbursement

Employee referral program

Job summary

Pivot Path Solutions, LLC is seeking a Senior Database Architect to support the Defense Health Agency (DHA) in designing, implementing, and sustaining databases behind EIM’s OpenText-based platform hosted in AWS GovCloud.

You will own data models, performance tuning, migrations, and reporting infrastructure to ensure secure, available, and auditable information flows across HAIMS, SPORTS, SNPMIS, and related systems.

Qualifications

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

Responsibilities

• Design, implement, and sustain EIM application workflow databases to ensure performance, reporting capability, availability, and security.
• Provide database administration, SQL programming, database structure and schema design, table configuration, problem solving, and related database communications.
• Perform routine and preventive database maintenance during planned downtime, including performance tuning, index rebuilds, and data and log cleanup.
• Lead large data migrations and ETL efforts, including HAIMS records migration, DMACS Archive migration into HAIMS, and STR records migration from VA.
• Consolidate structured and unstructured data and metadata into EIM’s shared SQL Server and Content Server instances.
• Maintain metadata values in line with MHS data standards, including mapping old values to new ones so users can still retrieve older records.
• Sustain and update reporting databases and tools (BOXi and OpenText Web Reports) so canned and ad hoc reports stay timely and accurate.
• Apply database IAVA patches and STIGs, and support backup, failover, and continuity of operations testing.
• Maintain data dictionaries and data models for each release.

Skills

ETL

SQL performance tuning

SQL Server design

Database administration

Education

BS in Computer Science

Tools

SQL Server

OpenText

BOXi

AWS GovCloud

Job description

Pivot Path Solutions, LLC is seeking a Senior Database Architect to support the Defense Health Agency (DHA) in designing, implementing, and sustaining databases behind EIM’s OpenText-based platform hosted in AWS GovCloud.

You will own data models, performance tuning, migrations, and reporting infrastructure to ensure secure, available, and auditable information flows across HAIMS, SPORTS, SNPMIS, and related systems.