Job Description

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 30 brands, 12,000+ employees globally and products sold in 130 countries, we specialize in security around the doorway and beyond. Additionally, in 2024 we were awarded the Gallup Exceptional Workplace Award, which recognizes the most engaged workplace cultures in the world.
:
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, as well as expertise in supporting Microsoft Dynamics AX 2012. 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 culture of knowledge sharing and continuous improvement.

Required Qualifications:

• Bachelor's degree in Computer Science or Information Technology (advanced degree preferred).
• Minimum of five (5) years of experience managing and administering enterprise-level SQL databases in SQL Server 2016 or 2017.
• Minimum of two (2) years of experience designing and deploying Azure SQL Database PaaS solutions in Microsoft Azure.
• Minimum of five (5) years of experience planning and implementing MS SQL database disaster recovery for enterprise-level applications.
• Proven experience supporting Microsoft Dynamics AX 2012 databases.
• Proficiency in physical database design, database changes, enforcement of data integrity, and security management.
• Strong knowledge of query languages, particularly T-SQL, with the ability to write and optimize complex queries and stored procedures.
• Familiarity with database replication, clustering, and failover strategies.
• Ability to troubleshoot and resolve complex database-related issues, collaborating effectively across functional teams.
• Experience installing, configuring, and patching database management systems and software.
• Excellent interpersonal skills, initiative, teamwork, and problem-solving abilities.
• Strong attention to detail, with good oral and written communication skills.

Preferred Qualifications:

• Knowledge of PowerShell and database automation scripting.
• SolarWinds DPA Tool experience, monitoring, and tunning.
• Certifications such as Microsoft Certified: Azure Database Administrator Associate or similar.

Technical Skills and Relevant Technologies:

• Advanced knowledge of SQL Server database architecture and administration.
• Experience with tools such as SQL Profiler, Performance Monitor, SQL Server Management Studio (SSMS), and Azure Data Studio.

Soft Skills and Cultural Fit:

• Exceptional problem-solving skills, with the ability to navigate complex database issues and provide effective solutions.
• Strong communication skills, capable of conveying technical information to non-technical stakeholders.
• Ability to work independently while collaborating effectively with distributed teams.
• A proactive mindset, with a passion for continuous learning and staying updated on database technologies and trends.

We Celebrate Who We Are!
Allegion is committed to building and maintaining a diverse and inclusive workplace. Together, we embrace all differences and similarities among colleagues, as well as the differences and similarities within the relationships that we foster with customers, suppliers and the communities where we live and work. Whatever your background, experience, race, color, national origin, religion, age, gender, gender identity, disability status, sexual orientation, protected veteran status, or any other characteristic protected by law, we will make sure that you have every opportunity to impress us in your application and the opportunity to give your best at work, not because we're required to, but because it's the right thing to do. We are also committed to providing accommodations for persons with disabilities. If for any reason you cannot apply through our career site and require an accommodation or assistance, please .
Allegion plc, 2023 | Block D, Iveagh Court, Harcourt Road, Dublin 2, Co. Dublin, Ireland
REGISTERED IN IRELAND WITH LIMITED LIABILITY REGISTERED NUMBER 527370
Allegion is an