MySQL Database Administrator

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.

What You’ll Do:

• 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, We invite applicants to share their demographic background. If you choose to complete this survey, your responses may be used to identify areas of improvement in our hiring process. Your responses will also be Confidential and not used whatsoever in “the Company’s” selection process regarding your application. How would you describe your gender identity? (mark all that apply) Select… How would you describe your racial/ethnic background? (mark all that apply) Select… How would you describe your sexual orientation? (mark all that apply) Select… Do you identify as transgender? Select… Do you have a disability or chronic condition (physical, visual, auditory, cognitive, mental, emotional, or other) that substantially limits one or more of your major life activities, including mobility, communication (seeing, hearing, speaking), and learning? Select… Are you a veteran or active member of the United States Armed Forces? Select…

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Impact.com’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law. Gender Select… Are you Hispanic/Latino? Select… Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A “disabled veteran” is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran’s discharge or release from active duty in the U.S. military, ground, naval, or air service.

An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985. Veteran Status Select…

• 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 Have:

• Affiliate & Partnerships Industry Fundamentals Certification by PXA

Salary Range: $150,000 - $170,000 per year, plus an additional 5% variable annual bonus contingent on Company performance and eligible to receive a Restricted Stock Unit (RSU) grant. This is the pay range the Company believes is equitable for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time., Are you able to work in a hybrid onsite/remote model from Columbus, OH? Would you be willing to relocate to Columbus if you’re selected for the position? *, Do you have 3 years’ experience as a (MySQL) Production Database Administrator? If yes, please elaborate. * Do you have 3+ years’ experience in writing Linux shell scripts, Perl scripts, and Python?

At impact.com, we believe that when you’re happy and fulfilled, you do your best work. That’s why we’ve built a benefits package that supports your well-being, growth, and work-life balance.

• 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)
• Flexible Working: Our Responsible PTO policy means you can take the time off you need to rest and recharge. We’re committed to a positive work-life balance and provide a flexible environment that allows you to be happy and fulfilled in both your career and your personal life.
• Health and Wellness: Your well-being is a priority. Our mental health and wellness benefit includes up to 12 fully covered therapy/coaching sessions per year, with additional dependent coverage. We also offer a monthly gym reimbursement policy to support your physical health.
• A Stake in Our Growth: We offer 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.
• Investing in Your Growth: We’re committed to your continuous learning. Take advantage of our free Coursera subscription and our PXA courses.
• Parental Support: We offer a generous parental leave policy, 26 weeks of fully paid leave for the primary caregiver and 13 weeks fully paid leave for the secondary caregiver.
• Technology Financial Support: We provide a technology stipend to help you set up your home office and a monthly allowance to cover your internet expenses.

impact.com is the world’s leading commerce partnership marketing platform, transforming the way businesses grow by enabling them to discover, manage, and scale partnerships across the entire customer journey. From affiliates and influencers to content publishers, brand ambassadors, and customer advocates, impact.com empowers brands to drive trusted, performance-based growth through authentic relationships. Its award-winning products - Performance (affiliate), Creator (influencer), and Advocate (customer referral) - unify every type of partner into one integrated platform. As consumers increasingly rely on recommendations from people and communities they trust, impact.com helps brands show up where it matters most. Today, over 5,000 global brands - including Walmart, Uber, Shopify, Lenovo, L’Oréal, and Fanatics - rely on impact.com to power more than 350,000 partnerships that deliver measurable business results.