Senior Database Architect - EIM & AWS GovCloud

Bart & Associates, LLC; United States; On-site; USD 120,000 - 170,000; Full time

Benefits offered by this job

Health insurance

401(k) plan

Paid time off

Job summary

Bart & Associates, LLC seeks a Senior Database Architect to support the DHA CBIS program. You will own the design, implementation, and sustainment of enterprise databases, focusing on SQL Server, OpenText-based workflows, and reporting across EIM in AWS GovCloud.

Based in the National Capital Region, the role requires a strong background in large migrations, data modeling, security patches, and performance tuning to ensure fast, available, and auditable data.

Qualifications

• BS in Computer Science or equivalent work experience.
• 10+ years of database administration/architecture experience with SQL Server (12+ years without BS).
• Experience with large data migrations and ETL.

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 and DMACS archive migration into HAIMS.
• 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 scripting

Performance tuning

Education

BS in Computer Science

Tools

SQL Server

OpenText

Content Server

AWS GovCloud

Job description

Bart & Associates, LLC seeks a Senior Database Architect to support the DHA CBIS program. You will own the design, implementation, and sustainment of enterprise databases, focusing on SQL Server, OpenText-based workflows, and reporting across EIM in AWS GovCloud.

Based in the National Capital Region, the role requires a strong background in large migrations, data modeling, security patches, and performance tuning to ensure fast, available, and auditable data.