Database programmer [h1.location_city]

Job Description

Job Description

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.

Responsibilities :

• 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

Requirements

Preferred skills / abilities :

Benefits

We offer a competitive salary and benefits package.

We promote a strong work / life balance at MS2. We encourage our employees to pursue their professional interests and take ownership of projects from start to finish. You’ll be working with big data and cloud-based solutions using the latest technologies as part of a fun and energetic team. It’s a great place to work.

Salary :

$95,000 - $145,000 a year, commensurate with skills and experience of the specific applicant

Benefits :

We Want You to Be You at MS2.

At MS2 a diverse, inclusive, and equitable workplace is one where all employees, whatever their race, gender, color, ethnicity, national origin, age, sexual orientation or identity, education, disability, religion, or veteran status, feel valued and respected. We are committed to a nondiscriminatory approach and provide equal opportunity for employment and advancement in all of our departments and programs. We respect and value diverse life experiences and heritages and ensure that all voices are valued and heard.

MS2 is committed to maintaining a welcoming environment with equitable treatment for all, and we strive to :

MS2 wants every employee to feel our commitment to showing respect for everyone, and we encourage open communication that enables each person to be their best self.

MS2 is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.

Hybrid work

We expect staff to work from our office in Ann Arbor generally at least one day per week. Relocation assistance is available to successful candidates who are interested in moving to the Ann Arbor area.