The Role
The Database Developer designs and maintains the data layer for low-code platforms and applications, focusing on integration, data migration, and compliance with security standards.
Summary Generated by Built In
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
Education
Security Requirements
Salary
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.
- 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.
- 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.
- 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.
- 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
Required Qualifications- 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.
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
Preferred Qualifications- 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.
- 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.
- 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.
Skills Required
- Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field
- Seven or more years of professional database development experience
- Experience designing relational schemas, writing complex SQL, and building stored procedures or functions
- Experience integrating databases with low-code or BOAT platforms
- Experience building ETL pipelines and data migration assets
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Development InfoStructure, LLC. (Devis) is a leading provider of IT consulting services and solutions to the Federal, State and Local Governments, as well as the international development community. Devis helps maximize your return on IT investment by: 1) working with the best-adapted programming languages, databases and other solutions for your specific project; 2) actively supporting the open source community; and 3) using and promoting open technology standards. Devis has extensive experience with world wide software deployments and support. Our systems operate in more than 80 countries, and in every federal department. Devis-built systems involve the full vertical spectrum of users from data entry clerks to Governement managers to Congress
.png){kind=logo}
