Senior Database Engineer
hace 1 día
Ann Arbor
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., • 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., • 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). 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: • 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 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: • Provide a working environment where all employees feel safe, comfortable, and valued., • See diversity, inclusion, and equity as connected to our mission and critical to ensure the well-being of our staff and the agencies we serve., • Examine and dismantle any inequities within our policies, systems, programs, and services, and continually update and report our progress to our employees., • Explore potential underlying, unquestioned assumptions that interfere with inclusiveness., • Encourage company-wide thinking about how systemic inequities impact our organization’s work, and how best to address that in a way that is consistent with our mission., • Help to challenge assumptions about what it takes to be a strong leader at our organization, and who is well-positioned to provide leadership., • Practice and encourage respectful and transparent communication in all interactions., • Commit time and resources to expand more diverse leadership at all levels of our organization. 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.