Associate MySQL Database Administrator

impact.com; Cape Town; Hybrid; ZAR 350,000 - 600,000; Full time

Job summary

impact.com is seeking an Associate MySQL Database Administrator to manage and optimize database clusters. The role involves working with large datasets and requires a strong background in MySQL and database administration. Join a dynamic team that values innovation and offers opportunities for career growth.

Benefits

Medical Aid and Provident Fund

Stock Options

Casual work environment

Training & Development

Qualifications

• Minimum 2+ years’ experience as a Associate MySQL Database Administrator.
• Experience with MySQL / Percona Server 5.1 to 8.0.
• Strong understanding of InnoDB and InnoDB tuning.

Responsibilities

• Administer and support multiple MySQL database clusters.
• Develop backup and recovery procedures.
• Proactively identify performance bottlenecks.

Skills

Database administration

Query optimization

Performance tuning

Linux shell scripting

Python

Education

Bachelor's degree in mathematics, statistics, economics, computer science or a related field

Tools

MySQL

MongoDB

Clickhouse

Percona Server

Job description

At impact.com we are passionate about our people, our technology, and are obsessed with customer success. Working together enables us to grow rapidly, win, and serve the largest brands in the world. We use cutting edge technology to solve real-world problems for our clients and continue to pull ahead of the pack as the leading SaaS platform for businesses to automate their partnerships and grow their revenue like never before. We have an entrepreneurial spirit and a culture where ambition and curiosity is rewarded. If you are looking to join a team where your opinion is valued, your contributions are noticed, and enjoy working with fun and talented people from all over the world, then this is the place for you!

impact.com, the world’s leading partnership management platform, is transforming the way businesses manage and optimize all types of partnerships—including traditional rewards affiliates, influencers, commerce content publishers, B2B, and more. The company’s powerful, purpose-built platform makes it easy for businesses to create, manage, and scale an ecosystem of partnerships with the brands and communities that customers trust to make purchases, get information, and entertain themselves at home, at work, or on the go. To learn more about how impact.com’s technology platform and partnerships marketplace is driving revenue growth for global enterprise brands such as Walmart, Uber, Shopify, Lenovo, L’Oreal and Fanatics visit www.impact.com .

Your Role at Impact:

As a Associate MySQL Database Administrator at Impact, 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, 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 in a sharded environment
• 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, MongoDB and Clickhouse database clusters
• 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

What You Have:

• Bachelor's degree in mathematics, statistics, economics, computer science or a related field
• Minimum 2+ years’ experience as a Associate MySQL Database Administrator
• Experience with MySQL / Percona Server 5.1, 5.5, 5.6, 5.7, 8.0 / CloudSQL / AWS RDS
• Experience with ProxySQL 2.x / Orchestrator, Percona XtraBackup
• 2+ 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, Clickhouse, Percona XtraDB Cluster, Spanner and Postgres
• Take the time off that you need. We are truly committed to a positive work-life balance, recognising that it is important to be happy and fulfilled in both
• Training & Development
• Learning the advanced partnership automation products
• Medical Aid and Provident Fund
• Group schemes with Discovery & Bonitas for medical aid
• Group scheme with Momentum for provident fund
• Stock Options
• Casual work environment

Impact is proud to be an equal opportunity workplace. All employees and applicants for employment shall be given fair treatment and equal employment opportunity regardless of their race, ethnicity or ancestry, color or caste, religion or belief, age, sex (including gender identity, gender reassignment, sexual orientation, pregnancy/maternity), national origin, weight, neurodivergence, disability, marital and civil partnership status, caregiving status, veteran status, genetic information, political affiliation, or other prohibited non-merit factors.

#LI-Hybrid

Create a Job Alert

Interested in building your career at Impact.com? Get future opportunities sent straight to your email.

Apply for this job

*

First Name *

Last Name *

Email *

Phone *

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Do you have Java experience? *

Why should Impact consider you for the Associate MySQL Database Administrator position? *

Do you have 2+ years of experience in writing Linux shell scripts, perl scripts, Python etc? *

Do you have minimum 2+ years experience as a Associate MySQL Database Administrator? *

Are you eligible to live and work in South Africa or would you need sponsorship? *

Are you willing to relocate to Cape Town at your own cost? *Only answer if you live outside of Cape Town Select...

What is your expected annual salary in ZAR? *

What is your contractual notice period? *