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.

Lead SQL Database Administrator

The Lead SQL Database Administrator (DBA) is responsible for leading the SQL Server DBA team that is part of Allegions Site Reliability Engineering team. The person in this role will manage and maintain Allegion’s SQL database systems both in the cloud and on-premise as a member of that team. This role plays a critical role in ensuring the security, integrity, and performance of the database environments across the Allegion landscape.

The successful candidate will also be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills with teammates, other Allegion teams, management, and vendors.

What You Will Do:

• Designs and implements database structures and schemas to meet business requirements.

• Installs, configures, and upgrades SQL database software and related products in the cloud and on-premise.

• Monitors database performance and optimizing SQL queries, indexes, and database configurations for optimal performance.

• Implements and maintains database security measures, including access control, authentication, data encryption, unauthorized access and cyber threats.

• Implements and manages database backup and recovery strategies to ensure data integrity and availability.

• Identifies and resolves database issues, such as connectivity problems and data corruption.

• Estimates future database storage requirements and plans for scalability and growth.

• Creates and maintains technical documentation, including database schemas, configurations, diagrams, and procedures.

• Respond to incidents and events with a methodical approach to assess and troubleshoot all types of production (performance, access, accuracy, etc.) issues.

• Collaborate with cross-functional teams to design and implement IT solutions that meet business requirements and provides efficient and effective use of database resources.

• Provide on-call support for critical production system within a team environment.

• Improve system related processes, and automate non-value add activities.

• Define and apply best practices and standardizations for on-premise and cloud environments and implementations.

• Lead, plan and execute database migrations, upgrade projects and any database activities stemming from mergers or acquisitions.

What You Need to Succeed:

• Bachelor’s degree required or equivalent experience.

• 7+ years of experience in managing SQL Server database systems.

• Certification in SQL Server administration is preferred.

• Proven experience in using and managing SQL Server on premise and Azure SQL, SSMS, SSIS and SSRS systems.

• Understanding of database security principles and best practices, including user management, access controls and data encryption.

• Ability to identify and resolve database issues using monitoring tools and performance metrics.

• Knowledge of scripting languages to automate tasks and database administration activities.

• Strong problem-solving skills to identify and resolve complex database related issues in a timely manner.

• Excellent communication skills to effectively collaborate with team members and stakeholders.

• Ability to Lead

• Proven experience in managing large-scale SQL Server databases in a production environment.

• Understanding of relational database management systems and their principles.

• Ability to drive change and influence without managerial authority.

• Ability to work in a remote setting while performing duties on multi-national systems, teams and environments.

• Familiarity with industry best practices and emerging trends in SQL Server database administration.

• Ability to work independently and effectively prioritize and manage multiple tasks.

• Attention to detail and strong organizational skills.

Why Work for Us?

Allegion is a Great Place to Grow your Career if:

You're seeking a rewarding opportunity that allows you to truly help others. With thousands of employees and customers around the world, there’s plenty of room to make an impact. As our values state, “this is your business, run with it”.

You’re looking for a company that will invest in your professional development. As we grow, we want you to grow with us.

You want a culture that promotes work-life balance. Our employees enjoy generous paid time off, because at Allegion we recognize that you have a full life outside of work!

Join our team of experts today and help us make tomorrow’s world a safer place!

Not sure if your experience perfectly aligns with the role? Studies have shown that some people are less likely to apply to jobs unless they meet every single qualification and every single preferred qualification of a job posting. At Allegion, we are dedicated to building a diverse, inclusive, and authentic workplace. So, if you’re excited about this role but your past experience doesn’t align perfectly with every item in the job description, we encourage you to apply anyway. You may be just the right candidate for this role.

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 contact our Talent Acquisition Team (Careers@Allegion.com) .

© 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 equal opportunity and affirmative action employer (https://www.allegion.com/corp/en/careers/equal-opportunity.html)

Privacy Policy

We are Allegion.

A team of experts.

United under a common desire;

Protect today innovate for tomorrow.

And never settle for the status quo.

We believe in anticipating opportunities

by sharpening our skills

and finding new answers

through collaboration.

We believe in a safer, more secure world.

We believe in providing peace of mind.

We believe in being true to ourselves and to those

who trust-in our protection.

We are many. We are one.

We are Allegion.