Job Description
Alarm.com is the leading platform for intelligently connected properties.
Key Responsibilities
- 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
Benefits & Perks
- 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.
Ready to Apply?
Join Alarm.com and make an impact in renewable energy
Stay Updated on Sustainability Jobs
Get the latest renewable energy jobs and career tips delivered to your inbox.
Job Alerts
Get notified about new sustainability jobs
More at Alarm.com
More jobs at Alarm.com
Is this your company?Claim your listing — free →