Talent.com
Database Developer - Senior
Database Developer - SeniorDevelopment InfoStructure • Washington, DC, US
No longer accepting applications
Database Developer - Senior

Database Developer - Senior

Development InfoStructure • Washington, DC, US
16 days ago
Job type
  • Full-time
Job description

Job Description

Job Description

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 Senior Database Developer will serve as the technical lead for database architecture and development supporting the FMCSA TruData Modernization initiative. This role requires deep expertise in AWS native data services, ETL / ELT processes, and enterprise data warehouse solutions to ensure successful migration and modernization of FMCSA's critical safety data infrastructure. The Senior Database Developer will provide hands-on technical leadership in designing, implementing, and maintaining data solutions that support approximately 100 data marts and enable data-driven decision making for motor carrier safety operations nationwide.

This role will be a full-time position with work performed both on-site at DOT Headquarters, 1200 New Jersey Ave SE, Washington, DC 20590 and remotely, with core hours Monday-Friday : 6 : 00 AM - 6 : 00 PM EST. Position is contingent upon award and upon client approval.

What You'll Do

AWS Cloud Data Architecture

  • Design, develop, and maintain data infrastructure using AWS native services including Redshift, Glue, S3, Lake Formation, Kinesis, and DynamoDB
  • Lead technical implementation of data warehouse and data lake architectures supporting FMCSA mission systems
  • Support architecture reviews using AWS Well-Architected Framework principles
  • Implement real-time and batch data pipelines for continuous data ingestion and processing

Data Migration & ETL / ELT Development

  • Develop and optimize ETL / ELT scripts for data migration from legacy MCMIS and other source systems
  • Ensure data platform operates in parallel with legacy systems until complete sunset of deprecated infrastructure
  • Maintain connectivity with identified data sources and manage data ingestion processes
  • Support transition of data sources from legacy to modernized applications
  • Data Mart Development & Management

  • Create and maintain state-specific data marts supporting SafeSpect, PRISM, and ITD program requirements
  • Support approximately 100 data marts currently approaching full capacity
  • Optimize data sharing between applications and standardize reference data across systems
  • Develop reports and dashboards for data visualization and analytics using business intelligence tools
  • Database Performance & Optimization

  • Perform database performance tuning, query optimization, and capacity planning
  • Implement advanced SQL and stored procedure development
  • Conduct data quality validation and implement validation frameworks
  • Execute database administration and optimization for Amazon Redshift
  • Production Support & Maintenance

  • Provide Tier III production support for delivered capabilities and critical issue resolution
  • Respond to vulnerabilities remediation activities to assure identified issues are resolved in DOT mandated timelines
  • Support and maintain current and future datasets to the Datahub
  • Perform corrective, adaptive, perfective, and preventative maintenance activities
  • Collaboration & Documentation

  • Collaborate with MC-I team to establish baseline documentation and mature technical specifications
  • Ensure all database solutions comply with Section 508 accessibility requirements
  • Develop and maintain technical documentation for data systems and processes
  • What We're Looking For

    Required Qualifications

    Education & Experience

  • Bachelor's degree in Computer Science, Information Systems, Database Management, or related field
  • Minimum of seven (7) years database development experience
  • Minimum of three (3) years hands-on AWS data services experience
  • Demonstrated experience with large-scale data migrations
  • AWS Data Services Expertise

  • Amazon Redshift : Administration, optimization, and performance tuning
  • AWS Glue : ETL job development and orchestration
  • S3 : Data lake design and implementation
  • AWS Lake Formation : Governance and security implementation
  • Kinesis : Real-time data streaming configuration and management
  • DynamoDB : NoSQL database management and optimization
  • Database Development Skills

  • Expert-level proficiency with SQL and Python programming
  • Advanced stored procedure development and optimization
  • Data modeling and schema design
  • ETL / ELT pattern implementation and optimization
  • Performance tuning and query optimization
  • Data Integration & Architecture

  • Legacy system data migration strategies
  • API development and integration
  • Change data capture techniques
  • Data pipeline orchestration
  • Master data management
  • Data warehouse architecture patterns
  • Business intelligence and analytics
  • Metadata management
  • Data governance frameworks
  • Security & Compliance

  • Knowledge of data security and encryption standards
  • Understanding of NIST and FedRAMP security frameworks
  • Experience with federal data compliance requirements
  • Preferred Qualifications

  • Federal agency experience with government data systems
  • Transportation or motor carrier industry knowledge
  • Master's degree in Data Science or related field
  • AWS Database Specialty or Data Analytics certification
  • Experience with MCMIS or similar compliance systems
  • Snowflake or similar cloud data platform experience
  • Apache Spark or similar big data processing frameworks
  • Performance Expectations

    Success in this role means :

  • Successfully migrate and modernize legacy MCMIS data systems
  • Maintain 99.9% uptime for critical data platforms
  • Support approximately 100 data marts with optimal performance
  • Ensure compliance with all federal security and accessibility requirements
  • Deliver high-quality technical documentation and knowledge transfer
  • Special Requirements

  • Ability to obtain and maintain DOT / FMCSA security clearance
  • PIV card eligibility for facility and system access
  • Compliance with all FMCSA security protocols and requirements
  • Must pass pre-employment suitability checks
  • Working Conditions

  • Location : Hybrid - DOT Headquarters and remote work capability
  • Hours : Core hours Monday-Friday : 6 : 00 AM - 6 : 00 PM EST
  • Environment : Secure government facility and remote work environment
  • Security : Access to sensitive PII and government data systems
  • Salary Range

  • $130,000 to $140,000
  • Devis 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 JazzHR

    EMxF1zuqtJ

    Create a job alert for this search

    Database Developer • Washington, DC, US

    Related jobs
    Senior DB2 Database Administrator

    Senior DB2 Database Administrator

    VirtualVocations • Alexandria, Virginia, United States
    Full-time
    A company is looking for a Senior DB2 Database Administrator to manage and support critical DB2 environments.Key Responsibilities Administer, configure, and tune IBM DB2 in various environments ...Show more
    Last updated: 2 days ago • Promoted
    Database Administrator SME

    Database Administrator SME

    Leidos Inc • Chantilly, VA, United States
    Full-time
    Leidos is seeking a Database Administrator for a technical development program supporting the Sponsor's Entitlement Programs as well as IdAM / ICAM, Authentication, Authorization, Attributes and Dig...Show more
    Last updated: 23 days ago • Promoted
    Senior Database Architect

    Senior Database Architect

    VirtualVocations • Baltimore, Maryland, United States
    Full-time
    A company is looking for a Senior Database Architect to design and maintain scalable database solutions.Key Responsibilities Collaborate with stakeholders to translate business requirements into ...Show more
    Last updated: 30+ days ago • Promoted
    Senior Database Architect - 100% Remote (REF1607W)

    Senior Database Architect - 100% Remote (REF1607W)

    Citizant • Chantilly, VA, United States
    Remote
    Full-time
    Citizant is a leading provider of professional IT services to the U.We seek to address some of our country's most pressing challenges in the areas of Agile application development, Enterprise Data ...Show more
    Last updated: 4 days ago • Promoted
    Senior SQL Server Developer

    Senior SQL Server Developer

    VirtualVocations • Alexandria, Virginia, United States
    Full-time
    A company is looking for a remote Senior SQL Server / Power BI Developer.Key Responsibilities : Implement a functional SSAS environment Build and redesign reports for an analysis services environme...Show more
    Last updated: 30+ days ago • Promoted
    Senior SQL Database Administrator

    Senior SQL Database Administrator

    VirtualVocations • Baltimore, Maryland, United States
    Full-time
    A company is looking for a Senior SQL Database Administrator.Key Responsibilities Monitor daily operations and perform critical Oracle patching Conduct database security assessments and address ...Show more
    Last updated: 30+ days ago • Promoted
    Database Designer

    Database Designer

    VirtualVocations • Baltimore, Maryland, United States
    Full-time
    A company is looking for a Database Designer responsible for creating and implementing database schemas and data models for a SaaS platform. Key Responsibilities Analyze and resolve design flaws i...Show more
    Last updated: 10 days ago • Promoted
    PostgreSQL Database Engineer (Senior)

    PostgreSQL Database Engineer (Senior)

    Donan Consulting • Washington, DC, United States
    Full-time
    THE OVERALL PURPOSE OF POSITION : .The purpose of this position is to perform and manage tasks related to the operation, support, administration,. USAC owned databases and database tools.The position’...Show more
    Last updated: 30+ days ago • Promoted
    Database Architect

    Database Architect

    Leidos Inc • Ashburn, VA, United States
    Full-time
    Leidos is looking for a Database Architect to provide leadership on a mission-critical program supporting assigneddivision within Passenger Systems Program Directorate (PSPD) in Customs and Border ...Show more
    Last updated: 30+ days ago • Promoted
    Senior Lead Database Engineer

    Senior Lead Database Engineer

    Lumen • Washington, DC, United States
    Full-time
    We are igniting business growth by connecting people, data and applications – quickly, securely, and effortlessly.Together, we are building a culture and company from the people up – committed to t...Show more
    Last updated: 30+ days ago • Promoted
    Lead Database Engineer

    Lead Database Engineer

    VirtualVocations • Washington, District of Columbia, United States
    Full-time
    A company is looking for a Lead Database Engineer who will design, build, and oversee the deployment and operation of technology architecture and solutions for data management.Key Responsibilities ...Show more
    Last updated: 30+ days ago • Promoted
    Senior Database Administrator

    Senior Database Administrator

    VirtualVocations • Washington, District of Columbia, United States
    Full-time
    A company is looking for a Senior Database Administrator (SQL / Oracle).Key Responsibilities Administer, maintain, and optimize SQL Server and Oracle databases and clustered environments Troublesh...Show more
    Last updated: 30+ days ago • Promoted
    Database Developer - Senior

    Database Developer - Senior

    Development InfoStructure • Washington, DC, US
    Full-time
    Quick Apply
    Company Overview Development InfoStructure LLC.Devis) is a leading provider of innovative software development, management, and consulting services, specializing in cutting-edge technologies such a...Show more
    Last updated: 30+ days ago
    Senior Database Engineer

    Senior Database Engineer

    VirtualVocations • Baltimore, Maryland, United States
    Full-time
    A company is looking for a Senior Database Engineer (Remote).Key Responsibilities Architect and build relational and NoSQL database systems that are performant, highly available, and scalable Pe...Show more
    Last updated: 30+ days ago • Promoted
    Senior SQL Developer

    Senior SQL Developer

    VirtualVocations • Rockville, Maryland, United States
    Full-time
    A company is looking for a Senior SQL Developer responsible for designing, developing, optimizing, and maintaining data architecture for Medicaid programs. Key Responsibilities Design, develop, an...Show more
    Last updated: 30+ days ago • Promoted
    Senior Oracle Database Administrator

    Senior Oracle Database Administrator

    VirtualVocations • Alexandria, Virginia, United States
    Full-time
    A company is looking for a Senior Oracle Database Administrator.Key Responsibilities Monitor daily operations and perform critical Oracle patching Conduct database security assessments and addre...Show more
    Last updated: 30+ days ago • Promoted
    Senior DataBricks Developer

    Senior DataBricks Developer

    VirtualVocations • Rockville, Maryland, United States
    Full-time
    A company is looking for a Senior DataBricks Developer in the healthcare sector.Key Responsibilities Build and maintain robust ETL pipelines and optimize data workflows in Databricks on AWS Coll...Show more
    Last updated: 4 days ago • Promoted
    Sr. Database Engineer

    Sr. Database Engineer

    CodeHunter • McLean, VA, US
    Full-time
    CodeHunter is an enterprise-grade malware threat hunting platform.In seconds, we identify unknown malware threats that are undetectable to current cybersecurity solutions.By automating the analysis...Show more
    Last updated: 30+ days ago • Promoted