MySQL Database Administrator

Impact.com•Columbus, OH

4d•Hybrid

About The Position

As a Database Administrator at impact.com, you will work with the latest technologies that enable near-real time processing of datasets in the Terabytes range and the exciting challenges that come with working with massive amounts of data. You will have the freedom to experiment with the latest technologies with the ultimate goal of scaling our systems linearly. If you have great ideas and like to think outside the box, we will encourage it and support you, giving you the tools to be successful as we scale Impact. At impact.com, your career path is yours to shape, as we encourage cross training into other technologies.

Requirements

Bachelor's degree in mathematics, statistics, economics, computer science or a related field, or relevant professional experience
Minimum 3+ years’ experience as a production Database Administrator
4+ years experience with MySQL / Percona Server 5.1, 5.5, 5.6, 5.7, 8.0, 8.4 / CloudSQL / AWS RDS MySQL/Postgres and Aurora
2+ years experience with Postgres
2+ years experience with Clickhouse
Experience with ProxySQL 2.x, 3.x / Orchestrator, Percona XtraBackup
3+ years of experience in writing Linux shell scripts, perl scripts, Python etc.
Experience with High Availability MySQL/Percona environments
Experience working with Large Data Volumes - 100’s of Terabytes to Petabytes
Strong understanding of InnoDB and InnoDB tuning.
Experience working with SingleStore, MongoDB, Percona XtraDB Cluster
Experience with Puppet, Terraform

Nice To Haves

Affiliate & Partnerships Industry Fundamentals Certification by PXA

Responsibilities

Administer and support multiple MySQL database clusters
Administer and support sharded MySQL database clusters
Manage database capacity and usage. Pro-active capacity planning.
Query optimization
Monitor and optimize database performance
Develop backup and recovery procedures
Essential Database administration - install, configure, upgrade, backup, partitioning and monitoring of MySQL, Postgres, MongoDB and Clickhouse database clusters
ProxySQL administration
Work with developers during application development life cycle in the design and planning of schema, tables, data types, indexes, procedures and functions
Proactively identify performance bottlenecks and database risks
Benchmarking

Benefits

Medical, Dental, and Vision insurance
Office-only catered lunch every Thursday, a healthy snack bar, and great coffee to keep you fueled
Flexible spending accounts and 401(k)
Responsible PTO policy
Mental health and wellness benefit includes up to 12 fully covered therapy/coaching sessions per year, with additional dependent coverage.
Monthly gym reimbursement policy
Restricted Stock Units (RSUs)
Free Coursera subscription
PXA courses
Parental leave policy, 26 weeks of fully paid leave for the primary caregiver and 13 weeks fully paid leave for the secondary caregiver.
Technology stipend to help you set up your home office
Monthly allowance to cover your internet expenses