MySQL Database Administrator
About the Company
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. 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.
About the Role
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 managing massive amounts of data. You will have the freedom to experiment with cutting-edge technologies with the goal of scaling our systems linearly. If you have great ideas and like to think outside the box, we will encourage and support you, providing the tools to succeed as we scale. Your career path is yours to shape, as we encourage cross-training into other technologies.
Responsibilities
- Administer and support multiple MySQL database clusters, including sharded environments
- Manage database capacity, usage, and pro-active capacity planning
- Optimize queries and monitor database performance
- Develop backup and recovery procedures
- Perform essential database administration tasks: install, configure, upgrade, backup, partitioning, and monitoring of MySQL, Postgres, MongoDB, and ClickHouse clusters
- Administer ProxySQL
- Collaborate with developers during the application development lifecycle to design and plan schema, tables, data types, indexes, procedures, and functions
- Proactively identify performance bottlenecks and database risks
- Conduct benchmarking
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 of 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 of experience with Postgres
- 2+ years of experience with ClickHouse
- Experience with ProxySQL 2.x, 3.x / Orchestrator, Percona XtraBackup
- 3+ years of experience writing Linux shell scripts, Perl scripts, Python, etc.
- Experience with High Availability MySQL/Percona environments
- Experience working with large data volumes—100s of terabytes to petabytes
- Strong understanding of InnoDB and InnoDB tuning
- Experience with SingleStore, MongoDB, Percona XtraDB Cluster
- Experience with Puppet, Terraform
Nice to Have
- Affiliate & Partnerships Industry Fundamentals Certification by PXA
Pay
$150,000 - $170,000 per year, plus an additional 5% variable annual bonus contingent on company performance. Eligible to receive a Restricted Stock Unit (RSU) grant.
Benefits
- Medical, dental, and vision insurance
- Office-only catered lunch every Thursday, healthy snack bar, and great coffee
- Flexible spending accounts and 401(k)
- Responsible PTO policy for flexible time off
- Mental health and wellness benefit: up to 12 fully covered therapy/coaching sessions per year, with additional dependent coverage
- Monthly gym reimbursement
- Restricted Stock Units (RSUs) with a 3-year vesting schedule, pending Board approval
- Free Coursera subscription and PXA courses for continuous learning
- Parental leave: 26 weeks fully paid for the primary caregiver and 13 weeks fully paid for the secondary caregiver
- Technology stipend for home office setup and monthly internet allowance