Database Administrator

Join to apply for the Database Administrator role at illumin At illumin, we are transforming the advertising landscape. Our platform offers an integrated space for journey planning, execution, and reporting. It empowers marketers to connect with their audiences in powerful ways through real‑time data and easy‑to‑use visual tools. By seamlessly combining media planning and buying in an intuitive interface, marketers can take complete control of their campaigns, meeting customers wherever they are in the buying journey and maximizing the impact of their ad spend through personalized insights for smarter decision‑making. We are at a pivotal moment, evolving into a product‑led company with a team of over 100 skilled professionals and new leadership guiding our path forward. By harnessing the power of data, advancing our AI capabilities, and deeply investing in our people, we are preparing for a future that will redefine what’s possible in journey advertising. Our work is guided by two beliefs: that the ability to execute is paramount to success and that we are only as good as our people. As we grow and transform, we are looking for team members (illumineers) who share our bias for speed, delivery over perfection, and an entrepreneurial mindset. Joining us now is a chance to be part of our transformation. Who we need Reporting to the Director of Infrastructure, Operations, and Security, our growing engineering team is seeking a Database Administrator – MySQL to architect, manage, and optimize our Percona‑based MySQL clusters in a high‑throughput, ultra‑low‑latency environment. The successful candidate will demonstrate mastery in query tuning, high availability design, and database automation, supporting mission‑critical services without reliance on public cloud infrastructure. You will be responsible for a multi‑master, multi‑cluster on‑prem architecture, ensuring stability, performance, and scalability across all environments. Full‑time, hybrid opportunity working Mondays, Tuesdays, and Thursdays in our downtown Toronto office. Our headquarters are located within minutes of St. Andrew and Union subway stations. What’s in it for you Impact and influence: As part of a small team within a publicly traded, product‑led company, you will play a pivotal role in optimizing our on‑premises database systems to add redundancy and resiliency in a multi‑data‑centre environment. You will lead the design and implementation of new management solutions that improve performance, stability, and observability across our infrastructure. Technical exposure: Our platform processes nearly 150 billion requests daily, driving programmatic traffic globally across all devices, streaming services, and out‑of‑home targeted advertising. Working with data and infrastructure at this scale is a rare opportunity. Professional development: You want to grow your skills, your influence, and your career. We push the limits to improve and to reach our full potential, individually and as a company. You will be supported by your manager and have access to one‑on‑one coaching. How you will make an impact Architect. Design, operate, and optimize multi‑master MySQL Percona clusters to meet strict SLAs for throughput, latency, and uptime. Define and implement replication topologies across multiple data centres to ensure consistency, fault tolerance, and seamless failover. Troubleshoot. Diagnose and resolve complex locking, replication, transaction conflicts, and query performance issues under high load. Identify and address root causes quickly to maintain system stability. Manage databases. Responsible for the health, maintenance, and performance of our MySQL environments. Oversee schema migrations, plan and execute backup strategies, and maintain disaster recovery processes. Automate. Script database tasks using Python, Bash, or similar tools to automate routine processes, reduce manual effort, and improve efficiency across environments. Monitor. Proactively monitor database health and performance using PMM and Netdata. Detect trends, address anomalies, and prevent failures. Collaborate. Work closely with developers to improve schema design and optimize application queries. Analyze execution plans and indexing strategies to support performance at scale. Improve processes. Maintain and continuously enhance database lifecycle practices across development, staging, and production environments, ensuring consistency and reliability. Ensure security. Enforce security and compliance protocols, including encryption, auditing, and access control. Ensure all data is protected and handled in accordance with company policy. What you bring The MySQL expertise. In‑depth experience administering MySQL databases, including Percona Server and XtraDB Cluster. Proven skills in query optimization, slow query analysis, index tuning, and execution plan optimization. Knowledge of MySQL replication models, GTID, clustering for high availability, and containerized deployment using Kubernetes. The technical experience. Strong experience in Linux environments and CLI‑based management. Automated scripting solutions and performance monitoring with PMM and Netdata. Experience with high‑throughput, real‑time applications where database latency is critical. Comfortable with on‑premise environments with virtual and physical hardware. The extra technical skills. Familiarity with MySQL 8.x features such as invisible indexes, histograms, and CTEs. Experience with backup and restore strategies using Percona XtraBackup. Exposure to ETL processes, time‑series databases, or event logging systems. Basic understanding of HAProxy or ProxySQL for query routing and load balancing. The ownership. Ability to review, approve, and offer feedback on plans and designs created by others. Define runbooks that improve efficiency across teams. Confidence and technical knowledge to make informed decisions in emergencies. Skill in mining information from documentation and the internet. The interpersonal skills. Excellent written and verbal communication. Build trust and collaborate with cross‑functional teams, effectively conveying complex data concepts to technical and non‑technical stakeholders. Supportive, innovative, and open to diverse perspectives. What else should you know about us? We are undergoing a transformative shift. We are embracing change and the opportunities that come with it, empowering every illumineer to innovate, experiment, and bring forward new ideas. Whether accessing new technology, restructuring workflows, or expanding your team, you will have full support if you can make the business case. Apply now If you want to seize the opportunity to impact a company and influence an industry, and you have 70% of what we are looking for, apply now. We can’t promise an interview, but we will consider your whole application. What you can expect from our interview process A virtual interview with a Talent Advisor to discuss your experience and interest in the role and an online technical assessment. The conversation will be recorded using BrightHire, an AI‑powered video interview tool. A technical interview with the DevOps Manager and a Database Administrator to understand your strengths and discuss your experience. An interview with the Director, Infrastructure, Operations, and Security to further explore your experience and discuss how it aligns with the needs of the team and our clients. Equal Opportunity Employment We are firmly committed to diversity within its community and welcome applications from racialized persons/persons of colour, Indigenous People of North America and the world, persons with disabilities, 2SLGBTQIA+ persons, and those who may contribute to further diversification of ideas. We are committed to providing equitable opportunities in employment and to providing a workplace which is free from discrimination and harassment. We are equally committed to providing an inclusive and accessible workplace. If you require accommodations at any stage of the interview process, please email us at hr@illumin.com. #J-18808-Ljbffr