Senior SQL Server Database Administrator

Creating Peace of Mind by Pioneering Safety and Security

At Allegion, we help keep the people you know and love safe and secure where they live, work and visit. With more than 40 brands, 14,000+ employees globally and products sold in 130 countries, we specialize in security around the doorway and beyond.

Additionally, Allegion is proud to be recognized with the 2026 Gallup Exceptional Workplace Award (GEWA) for the third consecutive year, earning distinction in both the employee engagement and strengths categories. This year, Allegion also received Gallup’s With Distinction honor — a designation reserved for a select group of organizations that go above and beyond in building exceptional workplace cultures.

Job Description:

We are seeking a highly skilled Senior SQL Server Database Administrator to support database management initiatives. The ideal candidate will possess extensive knowledge and experience in SQL Server administration across Microsoft Azure and on-premises environments. Proven expertise supporting Microsoft Dynamics AX 2012 databases is a plus. This role involves managing all aspects of database administration, including planning, installation, configuration, security, optimization, monitoring, disaster recovery, and performance tuning of SQL Server databases. The candidate should also have strong T-SQL development skills to maintain, optimize and automate processes.

Key Responsibilities:

• Architect and maintain robust SQL database systems that support application environments, ensuring maximum uptime, performance, and scalability.
• Design and implement fault-tolerant SQL Server solutions using high-availability patterns in on-premises and Microsoft Azure environments.
• Design and deploy Microsoft SQL PaaS solutions in Microsoft Azure.
• Provide SQL Server administration for MS SQL Server versions 2012, 2014, 2016, 2017, 2019 and/or 2022, as well as support for Microsoft Dynamics AX 2012.
• Plan and implement database backup strategies and perform recovery in case of disaster.
• Monitor and maintain database storage, health, performance, sustainability, and security.
• Manage SQL Server high availability, backups, maintenance jobs, encryption, security controls, etc.
• Analyze SQL query plans, suggest optimizations, and support developers in the SDLC process.
• Install, configure, and upgrade database management systems and software, including clustering environments.
• Refine and automate SQLDBA team processes using T-SQL and PowerShell.
• Collaborate with development teams to optimize database queries and schema design, enhancing application performance.
• Provide mentorship and guidance to junior DBAs, fostering a