Database Developer

Development InfoStructure • Washington, DC

14h • Hybrid

About The Position

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.

Requirements

• 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.
• 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.
• 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.

Nice To Haves

• 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.

Responsibilities

• 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.
• 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.
• 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.

Benefits

• Equal employment opportunity without regard to an individual’s race, color, religion, age, gender, sexual orientation, veteran status, national origin or disability.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior