Datto protects business data and provides secure connectivity for tens of thousands of the world's fastest growing companies. Datto's Total Data Protection solutions deliver uninterrupted access to business data on site, in transit and in the cloud. Thousands of IT service providers globally rely on Datto's combination of pioneering technology and dedicated services to ensure businesses are always on, no matter what. Datto is headquartered in Norwalk, Connecticut and has offices in Rochester, Boston, Portland, Toronto, London, Singapore and Sydney. Learn more at www.datto.com. 

Primary Responsibilities:

• Work with application developers to design and implement efficient schemas and optimize queries and connection management
• Enable database users in Development, Marketing and Finance to write efficient SQL
• Develop scripts and packages that synchronize schemas and core data with new application code as it is elevated to Production
• Grant restricted database access to new applications and users
• Enhance database monitoring and backups as new database systems are added

Desired Skills and Experience:

• 5+ years of experience writing SQL, including stored programs and views, optimizing queries, and backing up, restoring and replicating MySQL databases in a production environment
• Understanding of and ability to apply the relational model
• Appreciation of ACID compliance and differences between various isolation levels and locking algorithms
• Familiarity with Linux on Production systems
• Ability to
• write scripts in bash, perl or python to automate database maintenance
• use a configuration management system, like Salt, Chef or Puppet, to install and configure databases
• configure a monitoring system, like Nagios or Zabbix, to watch database servers
• Experience with
• standard MySQL replication, Galera Cluster and MySQL Cluster
• PostgreSQL replication
• Cassandra schema modeling and cluster tuning
• Experience with ZFS filesystem is a plus
• Experience with ZFS, Docker and various virtualization technologies is a plus
• Enthusiasm for working with new technologies related to and beyond the database

Here at Datto our people are our greatest asset, which is why we offer a comprehensive and unique benefits package. Above and beyond the typical medical, dental and vision, we also offer a generous 401k plan with a significant employer match, unlimited paid time off, educational reimbursement, fitness reimbursement, and travel subsidies for commuters. We have a patent rewards program and various other fun perks and fringe benefits, including free lunch every Friday in all of our offices globally.