MySQL Database Administrator
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) as part of our total compensation, giving you a stake in the company's growth with a 3-year vesting schedule, pending Board approval.
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
