Choisys Technology Inc. · 2 months ago
Senior Database Developer (Hybrid)
Washington, DC
Full-time
Hybrid
Senior LevelCHOISYS TECHNOLOGY INC is seeking an experienced Senior Database Developer to support a critical DOT IT program focused on the Federal Motor Carrier Safety Administration’s data infrastructure modernization. The role involves maintaining and enhancing the FMCSA TruData platform and managing data transition to the AWS cloud.
AnalyticsCyber SecurityE-LearningIT Infrastructure
No H1B
U.S. Citizen Only
Responsibilities
Providing support for the design, development, and maintenance of the database architecture, including new features, security, compliance, auto-scalability, monitoring, and performance for the TruData AWS architecture
Performing complex database design, coding, testing, and debugging using advanced features of database management systems
Developing, enhancing, and maintaining Stored Procedures, Views, Functions, Triggers, and SQL queries
Supporting data integration, including data related to document metadata and contents
Supporting a rapidly growing set of Datamarts, currently approaching 100
Managing and mitigating technical concerns of data migration from FMCSA’s master systems to the TruData Platform, ensuring reliability and availability
Supporting the integration of data and capabilities from Automated Information Systems (AISs)
Addressing applicable technical debt and the Plan of Action and Milestones (POAMs)
Ensuring the performance of database systems and resolving complex operational, data, and data access issues
Utilizing AWS native technology stack (or other provided technology) and supporting the continued modernization of the TruData platform
Qualification
Required
Bachelor's degree in Computer Science, Information Technology, Database Management, or a related field
Extensive experience with the AWS native technology stack
Amazon Redshift (design, performance optimization)
AWS Data Pipeline, AWS Glue, Kinesis
AWS Lake Formation, S3, DynamoDB
Expert-level proficiency with SQL and Python scripting
Extensive experience in database design, development, and administration in large-scale environments
Fluency in computer languages and familiarity with computer hardware and software related to data acquisition and remote sensing
Experience with developing and testing software for the reduction, analysis, and presentation of research data
DOT experience is required
Current knowledge of system reliability, cybersecurity, and DOT IT policies
Prior experience in managing a program and a small team in the data transition to AWS cloud
Company
Choisys Technology Inc.
Choisys Technology (Choisys) is a service disabled veteran-owned small business, headquartered in Northern Virginia.
Founded in 2014
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase