Midwestern Software Solutions, LLC ("MS2")-posted 21 days ago
$95,000 - $145,000/Yr
Full-time • Mid Level
Hybrid • Ann Arbor, MI
11-50 employees

MS2 is a national leader in transportation data management and analysis and has the largest traffic count database in North America. More than 270 agencies in 31 US States, and 3 Canadian Provinces, including 28 state Departments of Transportation, are using MS2 software to manage their transportation data. MS2 is located in the beautiful city of Ann Arbor, Michigan, the home of high-tech industries and the University of Michigan. Residents of the city enjoy beautiful parks, mature neighborhoods, amenities of the Huron River and easy access to downtown Detroit or to colorful “Pure Michigan” woods and waterways. MS2 is a friendly, open, team working to support our clients' software needs. Staff members work on a variety of tasks and are given a high degree of responsibility. We offer an excellent environment for transportation professionals and Software Engineers with competitive compensation and benefit packages. We're a small team and you'll have an opportunity to make a big impact! We are seeking a Senior Database Engineer to shape the data foundation of our transportation platform. You will partner 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. The role emphasizes performance, reliability, and clear ownership of production data flows. You will solve problems independently and collaborate with an experienced, supportive team.

  • Collaborate with engineers, project managers, and stakeholders to deliver reliable, scalable database solutions.
  • Mentor peers and share best practices for database design and performance.
  • Monitor and tune performance, scalability, and security across transactional, ETL, and reporting workloads.
  • Review and improve existing designs while ensuring safe, consistent schema, and query changes.
  • Define, measure, and maintain service-level objectives (SLOs) for key data flows using metrics and alerts.
  • Work closely with application and QA engineers to validate data integrity and maintain clear boundaries between services
  • 5+ years of progressive experience as a SQL Database Administrator or Database Engineer maintaining production environments.
  • Bachelor’s degree in Computer Science, Computer Engineering, or related field (or equivalent experience).
  • Strong technical knowledge of SQL Server installations, configuration, and maintenance.
  • Strong T-SQL skills, including indexing, execution plans, statistics, partitioning, concurrency control, and performance tuning.
  • Experience deploying and evolving databases safely in high-uptime environments.
  • Practical experience with observability; metrics, logs, tracing, and alerting tied to SLOs.
  • Proven track record designing, scaling, and maintaining mission-critical SQL database systems.
  • Effective communication and collaboration across engineering and product teams, with strong written and verbal communication.
  • Familiarity with .NET / C# application stacks and sound judgment on SQL versus application-tier logic.
  • Experience with AWS-hosted SQL Server, including backup, restore, and capacity planning.
  • Exposure to job orchestration or data processing workflows (e.g., ETL scheduling, messaging, or queueing systems).
  • Exposure to Powershell scripting.
  • Participation in the company's 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
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service