Database Engineer (MySQL)

Employer
Alarm.com
Location
Tysons Corner, VA
Posted
Mar 20, 2017
Closes
Mar 21, 2017
Industry
Engineering
Hours
Full Time
POSITION OVERVIEW:The Database Engineer (MySQL) designs, implements and maintains unparalled performance and highly scalable solutions on the MySQL database platform across multiple data centers supporting cloud based life safety, home automation and CRM applications. This position works closely with multiple departments through the entire platform lifecycle including but not limited to orchestrating upgrades, backups, provisioning of database instances and clusters and actively collaborates in complex data integration scenarios. This position is also involved in the physical and logical design of database systems supporting our business and customer facing applications.The top priority for this position is ensuring that they remain stable, reliable, and recoverable as the database platform and applications evolve.RESPONSIBILITIES:Perform health and performance reviews and communicate findings on a regular basis to all levels of business and management.Identify performance indicators to locate and correct code problems.Provision MySQL instances, both in clusters and non-clustered configurations.Work with operations and security teams to ensure security, and availability of databases.Handle common database procedures, such as upgrade, backup, recovery, migration, failover, data cleansing, etc.Profile server resource usage, optimize and tweak as necessary.Leverage both Open Source and Commercial solutions to build tools on an ad-hoc basis.Support application deployments.Prepare documentation and specifications REQUIREMENTS:BA/BS in Computer Science, Management Information Systems, Data Science, Math, Physics, Engineering, Statistics or other technical field. Advanced degrees preferred.Advanced Technical Writing and strong verbal communication skills.Experience developing Standard Operating Procedures (SOPs)5+ years of experience and strong proficiency in MySQL database management and high availability principles, Experience in Microsoft SQL Server is desirable.Experience with replication configuration in MySQLExperience working with MySQL clustering, preferably Galera Cluster or Percona XtraDB Cluster Understanding and practical knowledge of MySQL's InnoDB storage engineWorking knowledge in Server Monitoring & Application Performance Monitoring and performance tuning techniques.Knowledge of de-facto standards and best practices in MySQL.Experience in SQL and familiarity with other programming languages. Some development experience in at least one scripting language (PHP, Python, Perl, etc.).Proficient in writing and optimizing SQL code.Proficient understanding of code versioning tools such as GitExperience with Cloud Platforms and virtualization Technologies: Vmware and Amazon Web Services.Knowledge in networking and storage solutions (SAN, NAS) is preferred.Comfortable with open source configuration management and orchestration tools such as Puppet.Experience in Agile Methodologies and processes is a nice to have.Excellent written/oral communication and interpersonal skillsStrong problem solving skills.Willingness to learn new skills and tools and flexibility to accept a wide range of responsibilities.Highly motivated, self-starter that has ability to operate under minimal supervision.WHY WORK FOR ALARM.COM?Collaborate with outstanding people: We hire only the best. Our quality standards are high and our employees enjoy working alongside other high achievers.Make an immediate impact: New employees can expect to be given responsibility for bringing new technologies to the marketplace within weeks. 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 gain a broad knowledge base across multiple areas of the business.Work with latest technologies: As we continue to lead the industry, we require expertise across a broad spectrum of technologies including short and long-range wireless communication, video surveillance, lighting and HVAC automation, web development, and backend application development and hosting.Focus on fun: Alarm.com places high value on our team culture. We even have a committee dedicated to hosting a stand-out holiday party, happy hours, and an annual corporate retreat.COMPANY INFORMATION Alarm.com is the leading platform solution for the connected home and business. Millions of people depend on Alarm.com's technology to monitor and control their property from anywhere. Centered on security and remote monitoring, our platform addresses a wide range of market needs and enables application-based control for a growing variety of Internet of Things (IoT) devices. Our security, video monitoring, intelligent automation and energy management solutions are available through our network of thousands of professional service providers in North America and around the globe. Alarm.com's common stock is traded on the Nasdaq under the ticker symbol ALRM. Alarm.com earned the Top Workplace (TM) award for its employee culture and the meaningful work we do every day to develop and bring to market new technology that will make millions of people safer and help them use energy more efficiently. COMPANY BENEFITSAlarm.com offers competitive pay and a generous benefits package starting on day one of employment including 100% paid medical for employees, a health savings account option with company contribution, waiver allowance, 401(k) with employer match, paid holidays, paid time off starting at 4 weeks and increasing with tenure and paid maternity/paternity leave. We offer a casual dress work environment, annual company retreat, gym subsidy, education assistance program, and in-suite bike racks and showers.Alarm.com is an Equal Opportunity Employer