Why work for DreamHost?

We help people own their digital presence. It's not just wishful thinking. It's our noble cause an idea that drives everything we do.

When you put your dreams online your words, your photos, your creations you shouldn't have to worry about your service provider mining that data for marketing purposes.

Those are your dreams not ours! DreamHost's open platform gives you the power to share your data and the freedom to control how it's used.

Working for DreamHost you can be a steward of your own career. We invest in our people, we promote from within the organization when possible and we offer extensive training to aid in your success.

In this role, we offer the flexibility to work from home and during local business hours. We are proud to be a US employer with a fantastic culture and the ability to offer so much to our employees.

Benefits Offered

Overview

DreamHost’s MySQL Database Engineer’s role is to design, install, monitor, and maintain databases while ensuring high levels of data availability.

This individual is responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Responsibilities

Manage MySQL on Linux in Production / QA / Development environments utilizing open source technologies

Implement redundant systems :

policies, procedures for disaster recovery

data archiving to ensure effective protection

integrity of data assets

plan and coordinate data migrations

Design all aspects of data architecture, including data models, data flows, aggregations, clustering, and replication

Proficient in backup and recovery strategies (mysqldump, mydumper, xtrabackup)

Multisource replication to integrate copies of tables from disparate sources for analytical use

Respond to and resolve database access and handle performance issues such as slow queries using partitioning, indexing, query rewrites

Implement checks for monitoring mysql databases and their hosts using Zabbix

Be part of a 24x7 on-call during your day-time hours

5 years of experience with MySQL

Experience with Linux system administration and Linux virtualization technology (KVM, VServer, LXC)

Willingness to learn new technologies and maintain industry knowledge

Ability to write scripts to support database administration activities in Perl, Bash, or similar

Experience with configuration management systems, specific experience with Ansible, Chef, or similar

Bachelor's degree in Computer Science, Engineering or similar, or equivalent experience

Preferred

Experience with data warehousing technologies (Clickhouse or similar) plus

Experience with managing databases in cloud (GCP, AWS, or similar) plus