Allegion
10,000+ employees
Founded 2013
🔐 Security
🔧 Hardware
🏢 Enterprise
💰 Post-IPO Debt on 2022-06
Security • Hardware • Enterprise
Allegion is a company specializing in security solutions, focusing on security around the door and adjacent areas. They produce a wide range of products from mechanical locks to advanced biometric scanning devices, providing integrated and simple security solutions. Allegion aims to redefine security through innovative technology, ensuring safety wherever customers may be.
Senior SQL Server Database Administrator
Job not on LinkedIn
🔥 0 minutes ago
📊 Check your resume score for this job
Improve your chances of getting an interview by checking your resume score before you apply.
Allegion
10,000+ employees
Founded 2013
🔐 Security
🔧 Hardware
🏢 Enterprise
💰 Post-IPO Debt on 2022-06
Security • Hardware • Enterprise
Allegion is a company specializing in security solutions, focusing on security around the door and adjacent areas. They produce a wide range of products from mechanical locks to advanced biometric scanning devices, providing integrated and simple security solutions. Allegion aims to redefine security through innovative technology, ensuring safety wherever customers may be.
📋 Description
• 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.
🎯 Requirements
• 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 • 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 • Proven experience supporting Microsoft Dynamics AX 2012 databases is a plus.
🏖️ Benefits
• Health insurance • Retirement plans • Paid time off • Flexible work arrangements • Professional development
Apply Now
