Nod CareersAuto-apply free

Senior MySQL Database Administrator

impact · Cape Town · Cape Town, Western Cape, South Africa
Auto-apply to this job with Nod →
<p><strong>About <a href="https://impact.com/">impact.com:</a></strong></p> <p><a href="https://impact.com/">impact.com</a> 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 <a href="https://cts.businesswire.com/ct/CT?id=smartlink&url=http%3A%2F%2Fimpact.com&esheet=54399906&newsitemid=20260120914149&lan=en-US&anchor=impact.com&index=38&md5=c467739484a5a8610aff0747572ac8cb">impact.com</a> to power more than 350,000 partnerships that deliver measurable business results.</p> <p><strong>Your Role at impact.com:</strong></p> <p>We are seeking an experienced Senior MySQL Database Administrator to manage and optimize our large-scale, mission-critical database infrastructure. You will lead the administration, performance tuning, high-availability, and disaster recovery operations of our diverse MySQL ecosystem running across Google Cloud and AWS environments. This role requires deep expertise in Percona Server for MySQL, advanced query optimization, infrastructure-as-code, and modern DevOps practices.</p> <p>As a Senior MySQL Database Administrator at <a href="https://cts.businesswire.com/ct/CT?id=smartlink&url=http%3A%2F%2Fimpact.com&esheet=54399906&newsitemid=20260120914149&lan=en-US&anchor=impact.com&index=38&md5=c467739484a5a8610aff0747572ac8cb">impact.com</a>, 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 <a href="https://cts.businesswire.com/ct/CT?id=smartlink&url=http%3A%2F%2Fimpact.com&esheet=54399906&newsitemid=20260120914149&lan=en-US&anchor=impact.com&index=38&md5=c467739484a5a8610aff0747572ac8cb">impact.com</a>, your career path is yours to shape, as we encourage cross training into other technologies.</p> <p> </p> <p><strong>What You'll Do:</strong></p> <ul> <li>Manage and maintain Percona Server for MySQL (5.7, 8.0, 8.4 and later versions) across production, staging, and development environments, including multi-terabyte instances</li> <li>Design and implement ProxySQL configurations for high availability, load balancing, query routing, and connection pooling at scale</li> <li>Manage MySQL and PostgreSQL topology using GitHub Orchestrator, including automated failover and orchestration workflows</li> <li>Design, implement, and maintain backup and disaster recovery strategies using XtraBackup, binary log replication, and point-in-time recovery (PITR) procedures</li> <li>Perform comprehensive SQL query analysis and optimization using pt-query-digest, EXPLAIN analysis, and query profiling to identify bottlenecks and improve performance</li> <li>Optimize and tune database performance, including InnoDB configuration, buffer pool settings, query execution plans, and index strategies for workload efficiency</li> <li>Administer secondary database engines (ClickHouse, Cloud SQL, RDS MySQL, Aurora, SingleStore) and evaluate their optimal use cases within our architecture</li> <li>Implement and maintain Infrastructure-as-Code using Terraform and Puppet for database infrastructure provisioning and configuration management</li> <li>Architect and manage multi-region/multi-cloud database deployments across Google Cloud and AWS, balancing cost, latency, and resilience requirements</li> <li>Develop and execute runbooks for common database operational procedures, incident response, and disaster recovery scenarios</li> <li>Monitor database health using Percona Monitoring and Management (PMM), custom alerting, and observability tools; investigate and resolve performance degradation</li> <li>Manage database access controls, user provisioning, privilege auditing, and security hardening in compliance with principle of least privilege</li> <li>Conduct capacity planning and growth projections based on usage trends, workload analysis, and business requirements</li> <li>Lead database upgrade initiatives, testing, planning, and execution while minimizing downtime using automated tooling and blue-green deployment strategies</li> <li>Collaborate with application engineering teams to optimize data models, query patterns, and integration with database infrastructure</li> <li>Mentor junior DBAs and engineers on database best practices, troubleshooting methodologies, and operational excellence</li> </ul> <p> </p> <p><strong>Preferred Qualifications:</strong></p> <ul> <li>Bachelor's degree in mathematics, statistics, e

Let Nod apply for you →

More jobs at impact

RVP of Sales, SMB — impactGenAI Engineer - Product Marketing & Adoption — impactAssociate Manager, Accounting (Statutory reporting, Acquisitions & Tax) — impactChannel Partnership Manager - Agency - ANZ — impactSenior Fraud Prevention Analyst — impactSr. Data Scientist, Programmatic Algorithms — impact