> Markdown version of [/jobs/ext/3070412-senior-database-architect](https://www.wearedevelopers.com/jobs/ext/3070412-senior-database-architect). 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). --- # Senior Database Architect - **Company:** Bart & Associates - **Location:** Washington, DC, 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, Desktop Computing, Enterprise Content Management, Enterprise Information Management, Microsoft SQL Server, Performance Tuning, SQL Databases, Unstructured Data, Automated Data Processing (ADP), Cloud Platform System, Information Technology, OpenText, 3-tier Architectures - **Published:** September 25, 2026 - **Apply:** https://www.clearancejobs.com/jobs/9193109/senior-database-architect ## 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. Security Clearance * No security clearance required. This is a Public Trust position. * Must be able to obtain and maintain a favorably adjudicated background investigation for an ADP/IT-I or ADP/IT-II position designation (Tier 5 or Tier 3), and a DoD Common Access Card (CAC). * Must complete DoD/DHA-required HIPAA and Privacy Act training and sign a DHA Non-Disclosure Agreement before starting work. Physical & Work Environment Requirements Employees must be able to perform the essential functions of this position, with or without reasonable accommodation. * Ability to remain stationary for extended periods while working at a computer. * Frequently operate standard office equipment, including computers and telephones. * Ability to communicate effectively in person, by telephone, video conference, and email. * Occasionally move about the office and lift up to 20 pounds. * Ability to work the assigned schedule with regular and reliable attendance. * Ability to travel up to 10% as required. ## Description B&A is looking for a Senior Database Architect in support of the Defense Health Agency (DHA) Care and Benefits Integrated Systems (CBIS) Program Management Office 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. 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 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., B&A has launched several programs to focus on employee engagement, wellness, and assistance. These include: * The B&A Cares program: 30/60/90-day wellness check ins, personal development, financial management, and stress management seminars, and more * A formal mentorship program * Job shadowing and cross training opportunities * Brand Ambassador program * Employee Assistance Program (EAP) - Access to various support resources to include counseling, legal guidance, financial planning, and more * Monthly teambuilding events * B&A Annual Wellness Challenges: #StepWithB&A, #WalkDuringLunchWithB&A, #VolunteeringWithB&A, #ExerciseDuringLunchWithB&A, and more At B&A, we place significant importance on improving the communities and lives of citizens across the nation through our involvement, technology expertise, and employees. B&A puts an emphasis on charitable efforts in the Northern Virginia area, including Capital Area Food Bank pantry drives, book donations, Hope for Henry Foundation events, and many more. In recognition of all these efforts, B&A has been named a Companies as Responsive Employers (CARE) award recipient by Northern Virginia Family Services and nominated by the Northern Virginia Chamber of Commerce for Outstanding Corporate Citizenship Award. ## Related Videos - [Database DevOps with Containers](https://www.wearedevelopers.com/videos/145-database-devops-with-containers) - [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) - [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) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [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) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)