Manager, SQL Server Database Administration

Allegro MicroSystems; Municipio de Esquel; On-site; ARS 181,904,000 - 272,855,000; Full time

Job summary

Allegro MicroSystems seeks a highly skilled SQL Server Database Administration Manager to lead our IT/TDS team. You will ensure performance, integrity, and security of enterprise databases, mentor teammates, and collaborate with developers and stakeholders.

You will install, configure, and optimize SQL Server environments, design HA/DR solutions, enforce security, and automate routine tasks to maximize uptime and reliability across on-prem and cloud platforms.

Qualifications

• Minimum 10 years hands-on SQL Server DBA experience in large enterprises.
• Bachelor’s degree in Computer Science, IT or related field.
• Expert-level SQL Server knowledge with T-SQL optimization.
• Strong HA/DR experience, Always On and clustering.
• PowerShell scripting for automation and database maintenance.

Responsibilities

• Install, configure, upgrade and manage SQL Server environments (on-prem & cloud).
• Monitor performance, optimize complex T-SQL and indexes.
• Design and maintain HA/DR solutions including failover clustering.
• Manage security, user access, encryption and compliance.
• Oversee backups, test recovery, meet RPO/RTO; quarterly drills.
• Develop automation scripts for routine DBA tasks.
• Mentor and guidance to other DBAs and development teams.

Skills

SQL Server

T-SQL

PowerShell

Performance tuning

HA/DR

Education

Bachelor’s degree in CS/IT

Tools

SQL Profiler

Extended Events

Query Store

Always On

Clustering

Azure SQL

MariaDB

PostgreSQL

Job description

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 Window’s 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.