Design and implement multi-site Microsoft SQL Server Always On .
Own, track and resolve database related incidents and requests within SLAs
Plan and perform automated and attended database maintenance activities via planned and unplanned windows
Implement monitoring, auditing, data backup and recovery solutions.
Maintain the integrity of the company's security and compliance programs as it relates to the database infrastructure
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.
Requirements
A. or B.S. (or higher-level degree) in Computer Science or a similar engineering
10+ years of experience in database implementations and support of Microsoft SQL Server in highly available/highly transactional and OLAP environments
Experience in Database Administration in Microsoft SQL Server (2022 and 2025)
Mastery in SQL Server Always On and all other high availability database features is a must
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.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tool
Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, storage and other resource contention
Strong knowledge of backups, restores, recovery models, database shrink operations, Dynamic Management Views, Clustering, Database mirroring, auditing and replication
Expert experience in implementing operational automation
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
SQL Development - ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints)
Documentation skills for processes and procedures
SQL Database Operational support to tech users
On call availability
WHY WORK FOR ALARM.COM ?
Collaborate with outstanding people: We hire only the best. Our standards are high and our employees enjoy working alongside other high achievers.
Make an immediate impact: New employees can expect to be given real responsibility for bringing new technologies to the marketplace. You are empowered to perform as soon as you join the Alarm.com team!
Gain well rounded experience: Alarm.com offers a diverse and dynamic environment where you will get the chance to work directly with executives and develop expertise across multiple areas of the business.
Community and Camaraderie: One of our core values is to 'Keep It Fun,' which to us means fostering a strong sense of community. Our culture is built on collaboration and connection, where we celebrate our successes and believe that a positive, engaging environment is key to doing our best work.
COMPANY INFO
For more information, please visit www.alarm.com .
Alarm.com is an Equal Opportunity Employer
Benefits
Health insuranceEquity / stock options
Additional Information
Alarm.com 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.
Alarmcom · Taoyuan, Taiwan