Database Developer

Washington, DC
Full Time
Experienced
Company Overview
Development InfoStructure LLC., (Devis) is a leading provider of innovative software development, management, and consulting services, specializing in cutting-edge technologies such as DevSecOps, AI, and Machine Learning. With over 30 years of experience, we have established ourselves as a trusted partner for government agencies, delivering tailored, mission-critical solutions that drive digital transformation and operational excellence. Our client-centric approach, coupled with our deep domain expertise and technical prowess, enables us to forge enduring relationships and consistently deliver high-impact, adaptive solutions that resonate with the unique needs of the public sector.

Job Overview
The Database Developer designs, builds, and maintains the data layer that supports the FMCSA BOAT low-code platform and the modernized applications onboarded onto it. The role partners directly with the Senior Software Developer, the Senior Project Manager, and FMCSA's data and infrastructure stakeholders to deliver the data models, integrations, and migration assets needed for the Crash Causal Factors Program Proof of Concept and follow-on application onboarding work.

This is a full-time, hybrid role aligned to core business hours of 8:00 AM to 5:00 PM Eastern. Primary work happens at a contractor facility in the National Capital Region; on-site presence at DOT Headquarters, 1200 New Jersey Ave SE, Washington, DC, is required within one business day of Government request.

Primary Duties
Data Modeling and Schema Development
  • Design and implement relational and document-based data models that support the Crash Causal Factors Program PoC, including the Initial Incident Form, Post-Crash Investigation Form, ELD data, and PCR repository integrations.
  • Author the data dictionary, entity-relationship diagrams, and schema documentation that flow into the Detailed Technical Design Document deliverable.
  • Partner with FMCSA stakeholders during Discovery to surface data-side requirements early.
Data Platform Integration
  • Integrate the BOAT low-code platform with FMCSA's data platform to store and retrieve information.
  • Build and maintain APIs and connectors that consume data from external sources, including the State PCR Repository, SafeSpect, and the CCFP Analysis Datamart.
  • Coordinate with Enterprise Information Technology Shared Service (EITSS) on AWS VPC dependencies.
Data Migration and Environment Setup
  • Own delivery of the Data Migration Plan, where applicable.
  • Build migration scripts, ETL pipelines, and reconciliation reports that move legacy application data into BOAT-hosted applications during onboarding.
  • Stand up development and test database environments inside DOT/FMCSA-licensed environments.
File and Metadata Storage Support
  • Implement the metadata model that associates uploaded narrative reports, images, and videos with case records.
  • Design role-based access for authenticated users at the data layer.
  • Build audit, retention, and disposition controls that meet DOT and FMCSA records retention policy.
Performance, Reliability, and Optimization
  • Tune queries, indexes, and database configuration to support the end-to-end response time benchmarks.
  • Build and run performance and load tests against the data layer during the PoC and during onboarding releases.
  • Maintain high availability, backup, and recovery posture consistent with FMCSA system categorization.
Security, Privacy, and Compliance
  • Apply NIST SP 800-53 and FIPS 200 controls to the data layer, with emphasis on Sensitive PII protection for federal IT systems.
  • Implement FIPS 140-2 validated encryption in transit and at rest.
  • Support the Security Assessment and Authorization (A&A) process for ATO.
  • Coordinate Certification of Data Removal at task termination.
Agile Delivery and Configuration Management
  • Participate in sprint planning, standups, reviews, and retrospectives as a member of the single integrated software development team.
  • Maintain database schema, migration scripts, and seed data under source control with the same pull request and review standards used for application code.
  • Produce sprint-level demos of data layer changes and contribute to the Detailed Technical Design Document.
Required Qualifications
Education
  • Bachelor's degree required in Computer Science, Information Systems, Data Engineering, or a related technical field.
  • Equivalent combinations of vendor certifications and demonstrated professional experience will be considered in place of a degree.
Experience Levels
  • Seven or more years of professional database development experience, including a minimum of three years on federal or regulated-industry programs.
  • Demonstrated experience designing relational schemas, writing complex SQL, and building stored procedures or functions on SQL Server, Oracle, or PostgreSQL.
  • Demonstrated experience integrating databases with low-code or BOAT platforms (for example, Appian, Pega, ServiceNow, Microsoft Power Platform, OutSystems, Mendix, or Unqork).
  • Experience building ETL pipelines and data migration assets, including reconciliation and rollback procedures.
  • Experience supporting Security Assessment and Authorization (A&A) artifacts at the data layer for a FISMA Moderate or higher system.
Technical Knowledge
  • Working knowledge of AWS data services applicable to FMCSA's AWS VPC environment, including RDS, Aurora, S3, and Redshift.
  • Working knowledge of REST and SOAP API design, OAuth 2.0, and API gateway patterns for external data consumption.
  • Familiarity with infrastructure-as-code (Terraform, CloudFormation) and CI/CD pipelines (Azure DevOps, Jenkins, or GitHub Actions) applied to database changes.
  • Working knowledge of FIPS 140-2 cryptographic modules, FIPS 199 categorization, and NIST SP 800-53 data protection control families.
  • Familiarity with JIRA and agile delivery practices in line with federal IT modernization programs.
Preferred Qualifications
  • AWS Certified Database Specialty or AWS Certified Data Engineer Associate.
  • Microsoft Certified: Azure Database Administrator Associate, where Azure is part of the proposed solution.
  • Oracle Database SQL Certified Associate or higher, where Oracle is part of the proposed solution.
  • Platform-specific data integration certification on the proposed BOAT platform.

Security Requirements
  • Must pass and maintain the background investigation required by DOT and FMCSA for contractor personnel with access to Sensitive PII, consistent with DOT Order 1630.2B.
  • Completion of annual DOT Security Awareness Training and any FMCSA-mandated specialized training.
  • U.S. citizenship may be required, consistent with FMCSA contractor policy and access to Sensitive PII systems.
  • Execution of the Non-Disclosure Statement (NDS) before assignment.

Salary
  • $128,000 - $157,000 commensurate with background and experience.

Devis is an AA/EOE/M/F/Disabled/VET Employer committed to providing equal employment opportunity without regard to an individual’s race, color, religion, age, gender, sexual orientation, veteran status, national origin or disability.

Share

Apply for this position

Required*
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status


Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 05/31/2026
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Please check one of the boxes below:

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

You must enter your name and date
Human Check*