Senior SQL Server Database Administrator

Allegion

Senior SQL Server Database Administrator managing SQL databases with a focus on Azure and on-premises. Ensuring performance, security, and disaster recovery for enterprise-level applications.

Posted 7/10/2026full-timeRemote • 🇦🇺 AustraliaSeniorWebsite

Tech Stack

Tools & technologies

AzureMS SQL ServerSDLCSQL

About the role

Key responsibilities & impact

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

What you’ll need

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

Comp & perks

Health insurance
Retirement plans
Paid time off
Flexible work arrangements
Professional development

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQL Server 2016SQL Server 2017T-SQLDatabase DesignDatabase ReplicationClusteringFailover StrategiesDatabase Backup StrategiesPerformance MonitoringDisaster Recovery

Soft Skills

Interpersonal SkillsTeamworkProblem-SolvingAttention to DetailCommunication Skills

Certifications

Bachelor’s Degree in Computer ScienceBachelor’s Degree in Information Technology