Database Developer

Company OverviewDevelopment 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 OverviewThe 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 DutiesData Modeling and Schema DevelopmentDesign 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 integrationsAuthor the data dictionary, entity-relationship diagrams, and schema documentation that flow into the Detailed Technical Design Document deliverablePartner with FMCSA stakeholders during Discovery to surface data-side requirements earlyData Platform IntegrationIntegrate the BOAT low-code platform with FMCSA's data platform to store and retrieve informationBuild and maintain APIs and connectors that consume data from external sources, including the State PCR Repository, SafeSpect, and the CCFP Analysis DatamartCoordinate with Enterprise Information Technology Shared Service (EITSS) on AWS VPC dependenciesData Migration and Environment SetupOwn delivery of the Data Migration Plan, where applicableBuild migration scripts, ETL pipelines, and reconciliation reports that move legacy application data into BOAT-hosted applications during onboardingStand up development and test database environments inside DOT/FMCSA-licensed environmentsFile and Metadata Storage SupportImplement the metadata model that associates uploaded narrative reports, images, and videos with case recordsDesign role-based access for authenticated users at the data layerBuild audit, retention, and disposition controls that meet DOT and FMCSA records retention policyPerformance, Reliability, and OptimizationTune queries, indexes, and database configuration to support the end-to-end response time benchmarksBuild and run performance and load tests against the data layer during the PoC and during onboarding releasesMaintain high availability, backup, and recovery posture consistent with FMCSA system categorizationSecurity, Privacy, and ComplianceApply NIST SP 800-53 and FIPS 200 controls to the data layer, with emphasis on Sensitive PII protection for federal IT systemsImplement FIPS 140-2 validated encryption in transit and at restSupport the Security Assessment and Authorization (A&A) process for ATOCoordinate Certification of Data Removal at task terminationAgile Delivery and Configuration ManagementParticipate in sprint planning, standups, reviews, and retrospectives as a member of the single integrated software development teamMaintain database schema, migration scripts, and seed data under source control with the same pull request and review standards used for application codeProduce sprint-level demos of data layer changes and contribute to the Detailed Technical Design DocumentRequired QualificationsEducationBachelor's degree required in Computer Science, Information Systems, Data Engineering, or a related technical fieldEquivalent combinations of vendor certifications and demonstrated professional experience will be considered in place of a degreeExperience LevelsSeven or more years of professional database development experience, including a minimum of three years on federal or regulated-industry programsDemonstrated experience designing relational schemas, writing complex SQL, and building stored procedures or functions on SQL Server, Oracle, or PostgreSQLDemonstrated 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 proceduresExperience supporting Security Assessment and Authorization (A&A) artifacts at the data layer for a FISMA Moderate or higher systemTechnical KnowledgeWorking knowledge of AWS data services applicable to FMCSA's AWS VPC environment, including RDS, Aurora, S3, and RedshiftWorking knowledge of REST and SOAP API design, OAuth 2.0, and API gateway patterns for external data consumptionFamiliarity with infrastructure-as-code (Terraform, CloudFormation) and CI/CD pipelines (Azure DevOps, Jenkins, or GitHub Actions) applied to database changesWorking knowledge of FIPS 140-2 cryptographic modules, FIPS 199 categorization, and NIST SP 800-53 data protection control familiesFamiliarity with JIRA and agile delivery practices in line with federal IT modernization programsPreferred QualificationsAWS Certified Database Specialty or AWS Certified Data Engineer AssociateMicrosoft Certified: Azure Database Administrator Associate, where Azure is part of the proposed solutionOracle Database SQL Certified Associate or higher, where Oracle is part of the proposed solutionPlatform-specific data integration certification on the proposed BOAT platformSecurity RequirementsMust pass and maintain the background investigation required by DOT and FMCSA for contractor personnel with access to Sensitive PII, consistent with DOT Order 1630.2BCompletion of annual DOT Security Awareness Training and any FMCSA-mandated specialized trainingU.S. citizenship may be required, consistent with FMCSA contractor policy and access to Sensitive PII systemsExecution of the Non-Disclosure Statement (NDS) before assignmentSalary$128,000 - $157,000 commensurate with background and experienceDevis 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.Powered by JazzHRRvxbQ3vNc0