Job Description
Alarm.com is the leading cloud-based platform for smart security and the Internet of Things.
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
- B.A. or B.S. (or higher-level degree) in Computer Science or a similar engineering
- 15+ 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 (2019, 2022 and 2025)
- Mastery in SQL Server AlwaysOn 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 have a strong focus on teamwork, and we work to create a collaborative and welcoming environment that enables our teams to excel.
- Make an immediate impact: You can expect to be given real responsibility for bringing new technologies to the marketplace. You will be empowered to perform as soon as you join the team!
- Be Empowered: We don't want to micro-manage you. We want you to own stuff and bring your experience to make those products the best in class.
- Long-term employment based on a permanent employment contract (CoE).
- Attractive benefits package: including medical care, life insurance, sports package, annual budget for professional development ($2,000).
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