MySQL Database Administrator

About impact.com
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.

Your Role at impact.com:

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

What You Bring:

• 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, qualificatio