Manager, SQL Server Database Administration

The Allegro team

The Allegro team is united by a clear purpose—advancing technologies that make the world safer, more efficient, and more sustainable. With over 30 years of experience in semiconductor innovation, we bring that purpose to life across every part of the business—from breakthrough product development and customer success to how we show up for each other and the communities we serve.

The Opportunity

Allegro MicroSystems is seeking a highly skilled and experienced SQL Server Database Administration Manager to join our IT/TDS team. In this role, you will be responsible for the performance, integrity, and security of our enterprise databases. You will take a lead role in database troubleshooting, and optimization, ensuring that our critical data systems operate at peak efficiency with maximum up time. You will also mentor other team members and collaborate closely with software developers, system administrators, and business stakeholders.

What You Will Do

• Database Management & Maintenance: Install, configure, upgrade CU patches and manage Microsoft SQL Server environments (on-premises and cloud). This not only includes SQL but Windows cluster configuration as well.
• Performance Tuning & Optimization: Proactively monitor database performance, identify bottlenecks, and optimize complex T-SQL queries, indexes, and database configurations.
• High Availability & Disaster Recovery: Design, implement, and maintain high availability (HA) and disaster recovery (DR) solutions, including Always On Availability Groups, failover clustering, as well as Standalone servers.
• Security & Compliance: Implement and manage database security policies, manage user access/permissions, and ensure data encryption and compliance with corporate and regulatory standards.
• Backup & Recovery: Oversee routine database backups, test recovery plans, and ensure databases are meeting their RPO/RTO specifications. In could quarterly test recovery drills.
• Automation: Develop and maintain automation scripts using PowerShell or T-SQL for routine DBA tasks, deployments, and monitoring alerts.
• Mentorship: Provide technical guidance and best practices to other database administrators and development teams.

What You Will Bring

• Minimum of 10 years of hands-on experience as a SQL Server DBA in a medium to large enterprise environment.
• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent work experience)
• Expert-level knowledge of Microsoft SQL Server (versions 2008 through current).
• Strong proficiency in writing and optimizing complex T-SQL.
• Extensive experience with HA/DR technologies (Always On Availability Groups, Clustering).
• Solid understanding of database performance troubleshooting tools (SQL Profiler, Extended Events, Query Store).
• Experience with PowerShell scripting for database automation.
• Nice to have, experience with MariaDB and PostgreSQL
• Familiarity with Azure SQL Database.
• Strong analytical and problem-solving skills, excellent communication abilities, and a proven track record of working effectively in a collaborative team environment.

Why Allegro?

Join Allegro and become part of a team where your contributions truly matter.

We foster a culture of Real Innovation, empowering you to push boundaries, develop cutting-edge solutions, and drive continuous improvement. Your work will create a Real Impact by solving complex real-world challenges that fuel our success and shape the future of technology. You’ll experience Real Connection, collaborating with talented colleagues around the globe in an environment built on trust, respect, and a shared purpose. Join us—and help build what’s next.

About Us

Allegro MicroSystems is a global leader in sensing and power semiconductor solutions, committed to driving e-mobility, clean energy, automation, and robotics forward. Through Real Innovation, we're developing intelligent technologies that move the world toward a safer, more sustainable, and autonomous future. Our acquisition of Crocus Technology further strengthens our leadership in magnetic sensing, bringing cutting-edge TMR technology to our world-class portfolio.

At Allegro, your work creates Real Impact. Our advanced magnetic position and current sensors, power management ICs, brushless motor drivers, and LED lighting drivers are at the heart of critical systems worldwide. From extending the range of electric vehicles and enabling smarter factories to powering efficient data centers and enhancing autonomous driving, our solutions touch lives every day. If you're driving a car, using cloud services, or receiving a package, you're interacting with Allegro's technology in action.

We believe in Real Connection. With a diverse team of over 4,400 employees across 17 countries and headquartered in Manchester, NH (USA), Allegro fosters a truly global and collaborative environment. Our engineering, manufacturing, and support teams worldwide are united by a shared mission, working together with trust, respect, and purpose. We encourage you to think differently, take informed risks, and build what's next. Our dedication to pioneering solutions is reflected in our extensive portfolio of over 1,400 worldwide patents.

Allegro is not just building technology; we're building careers where your contributions matter, your growth is valued, and you can make a lasting difference. Our unwavering commitment to excellence is underscored by our IATF16949:2016 and ISO14001:2015 certifications and the quality awards we've received globally.

Join us and help shape the future – where your innovation, impact, and connection will drive what's next!