> Markdown version of [/jobs/ext/3412355-database-architect-defense-health-agency](https://www.wearedevelopers.com/jobs/ext/3412355-database-architect-defense-health-agency). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Database Architect (Defense Health Agency) - **Company:** Pivot Path Solutions - **Location:** Fairfax, VA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Amazon Web Services, Big Data, Business Process Management, Computer Programming, Databases, Extract Transform Load (ETL), Database Schema, Enterprise Content Management, Enterprise Information Management, Microsoft SQL Server, Performance Tuning, SQL Databases, Unstructured Data, Cloud Platform System, Information Technology, OpenText - **Published:** September 28, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=0dcf833fbc981686 ## About the Role * Bachelor of Science (BS) in Computer Science, or equivalent work experience. * Minimum of ten (10) years of database administration and database architecture experience with SQL Server (twelve (12) years without a BS degree)., * Experience performing large data migrations and extract, transform, and load (ETL). * Experience implementing database schemas within SQL Server. * Strong SQL programming and performance tuning skills. Desired Skills * Experience with OpenText databases. * Experience with SQL Server in AWS GovCloud or other cloud environments. * Experience with BOXi or other enterprise reporting tools. * Experience with the Defense Health Agency or Military Health System. ## Description Pivot Path is looking for a Senior Database Architect in support of the Defense Health Agency (DHA) on an important mission. In this role, you will have the opportunity to work with a great team while supporting the sustainment and modernization of DHA's Enterprise Information Management (EIM) platform, an OpenText-based enterprise content and business process management platform, hosted in AWS GovCloud, that supports Military Health System application workflows including HAIMS, SPORTS, SNPMIS, Paper Records Tracking, FILER, and DMACS for service members, veterans, and their families. You will own the design, implementation, and sustainment of the databases behind EIM's application workflows, keeping them fast, available, secure, and ready for reporting. This is a full-time key personnel position based in the National Capital Region, with the ability to reach the Government site in Falls Church, VA within two hours, contingent upon contract award., * 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 extract, transform, and load (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. ## Related Videos - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/100481-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Database Magic behind 40 Million operations/s](https://www.wearedevelopers.com/videos/748-database-magic-behind-40-million-operations-s) - [Testing React Backends Like a Pro: Mocking Databases with SQLite](https://www.wearedevelopers.com/videos/100388-testing-react-backends-like-a-pro-mocking-databases-with-sqlite) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology)