Database Developer

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., * 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., * 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.

Do you have experience in Virtual Private Clouds?, Do you have a Bachelor's degree?, * 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.

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., * $128,000 - $157,000 commensurate with background and experience.

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.