Database Engineer

<p><a class="external-link" href="http://alarm.com/" target="_blank" data-ext-link-init="true">Alarm.com</a> is a rapidly expanding technology company developing innovative cloud and device solutions across a wide range of cutting-edge technologies that provide a unified, connected service to millions of residential and commercial properties in the US and abroad. We are seeking a Database Engineer to manage SQL Server databases through multiple product lifecycle environments, from development to life-safety/mission critical production systems. Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.</p> <p> </p> <p><strong>RESPONSIBILITIES:</strong></p> <p>Primary job responsibilities include:</p> <ul> <li>Design and implement multi-site Microsoft SQL Server<strong> </strong>Always<strong> </strong>On<strong>.</strong></li> <li>Own, track and resolve database related incidents and requests within SLAs</li> <li>Plan and perform automated and attended database maintenance activities via planned and unplanned windows</li> <li>Implement monitoring, auditing, data backup and recovery solutions.</li> <li>Maintain the integrity of the company’s security and compliance programs as it relates to the database infrastructure</li> <li>Provide technical direction to Engineering teams on best practices for deploying applications. Serve as the company’s inhouse Microsoft SQL Server evangelist and expert advisor.</li> </ul> <p><strong>REQUIREMENTS</strong></p> <ul> <li>A. or B.S. (or higher-level degree) in Computer Science or a similar engineering</li> <li>10+ years of experience in database implementations and support of Microsoft SQL Server in highly available/highly transactional and OLAP environments</li> <li>Experience in Database Administration in Microsoft SQL Server (2022 and 2025)</li> <li>Mastery in SQL Server Always On and all other high availability database features is a must</li> <li>Experience in troubleshooting and resolving database integrity issues, migration issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.</li> <li>Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tool</li> <li>Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, storage and other resource contention</li> <li>Strong knowledge of backups, restores, recovery models, database shrink operations, Dynamic Management Views, Clustering, Database mirroring, auditing and replication</li> <li>Expert experience in implementing operational automation</li> <li>Strong knowledge of how indexes, index management, integrity checks, configuration, encryption, patching. How statistics work, how indexes are stored, how they can be created and managed effectively</li> <li>SQL Development – ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints)</li> <li>Documentation skills for processes and procedures</li> <li>SQL Database Operational support to tech users</li> <li>On call availability</li> </ul> <p><strong>WHY WORK FOR <a href="http://www.alarm.com">ALARM.COM</a>?</strong></p> <ul> <li><strong>Collaborate with outstanding people:</strong> We hire only the best. Our standards are high and our employees enjoy working