MS2 is a national leader in transportation data management and analysis. We're seeking a Senior Database Engineer to shape the data foundation of our transportation platform, partnering with product and engineering teams to design, build, and maintain the SQL databases and data services that power MS2’s software used by road agencies across 31 states.
Requirements
- Collaborate with engineers, project managers, business stakeholders, and QA to design and deliver reliable, scalable, and secure database solutions.
- Lead database design efforts, including schema design, data modeling, indexing strategy, and query optimization across transactional, ETL, and reporting workloads.
- Monitor, tune, and improve database performance, scalability, and security in production environments.
- Define, measure, and maintain service-level objectives (SLOs) for key data flows using metrics, logging, tracing, and alerting.
- Review and evolve existing database designs, ensuring safe and consistent schema changes, data migrations, and query updates.
- Execute and guide the full software development life cycle (SDLC), including requirements gathering, feasibility analysis, documentation, implementation, testing, deployment, and post-release evaluation.
- Develop technical documentation, data flow diagrams, and operational procedures to support maintainability and long-term system health.
- Troubleshoot, debug, and upgrade existing systems while proactively identifying opportunities to improve performance, reliability, and operational efficiency.
- Deploy database changes safely in high-uptime environments and partner with application teams to integrate data components into broader systems.
- Mentor engineers and provide database training and guidance to improve overall system design, performance, and data integrity practices.
- Establish and reinforce best practices for version control, deployment, observability, and data integrity validation.
- Conduct system analysis and recommend architectural or process improvements to strengthen platform reliability and scalability.
- Stay current with evolving database technologies, tooling, and industry standards, and apply relevant advancements to improve the platform.
- Demonstrate leadership through initiative, accountability, collaboration, and a focus on team and business outcomes.
Benefits
- Competitive salary
- Annual bonus program
- 401(k) with matching
- Dental insurance
- Employee assistance program
- Flexible schedule
- Flexible spending account
- Health insurance
- Life insurance
- Paid time off
- Professional development assistance
- Referral program
- Disability insurance
- Vision insurance
