Database Developer
Share
Job Location:
Washington, AR - USA
Yearly Salary:
USD 128000 - 157000
Posted on:
3 hours ago
Vacancies:
1 Vacancy
Job Summary
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 FMCSAs 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 FMCSAs 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 FMCSAs 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
- Bachelors 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 FMCSAs 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
- $128000 - $157000 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 individuals race color religion age gender sexual orientation veteran status national origin or disability.
Required Experience:
Senior IC
About Company
Development InfoStructure Inc. (Devis) is a leading provider of IT consulting services and solutions that specializes in the global development space. Since 1992, Devis has worked at the intersection of technology and global development, providing solutions to federal, state, and loca ... View more
