Position: Database Administrator
Company: Product Madness
Experience required: 5y
Category: DevOps
English level: upper
Published: 2023-06-01T00:00:00+03:00

Company Summary
Product Madness is a Global Powerhouse where the greatest mobile games and experiences are crafted by world-class talent. A top-grossing leader in free to play mobile games, we have more than 800 team members working across seven global talent hubs including London (headquarters), USA, Canada, Spain, Poland and Ukraine. With remarkable hit games including Heart of Vegas, Cashman Casino, Lighting Link and Big Fish Casino, we boast more than 50 million active users and 400 million downloads and counting.
We are Mad about games and the way they bring people together, and that passion and culture is what brings us together as a studio, connects us with our partners we collaborate with, and is what links us to our sister studios across the world.
Product Madness is an Aristocrat Technologies company within its digital game’s division of Pixel United.
As a member of the Platform Reliability Team, you will spend most of your time improving database performance, scalability and reliability as well as delivering database services and best practices to our internal customers who range from, architecture, data scientists to software engineers.
Our primary database platform is MySQL which is critical to the running of the Product Madness business and as such we require a database administrator with a high level of expertise in MySQL

As a Database Engineer, you will
● Seek to be constantly improving and moving forward the database environments
● Provide consistent and successful partnerships between Architecture,
Development and Data Science
● Improve processes to make your function more effective
● Proactively identify database performance problems and resolve them by
proposing and delivering changes to the codebase. Own this process end-to-end, from triaging issues to verifying your solution in production
 ● Deliver changes that allow us to scale our games and their database and make sure we're prepared for data growth
● Act as a database maintainer for the Product Madness codebase and review database-related application changes before they are released
● Providing database expertise to our architects, engineering and data science teams through code reviews, pairing and training to help deliver secure and performant database designs and queries
● Review, optimize and refactor the existing database schema
● Create and improve documentation
● Database security best practices
● Database best practices
● Workflows and team processes
● Long term scalability and architecture planning
● Improve tooling to detect performance bottlenecks and security issues, early in
the development cycle
● Participate in the incident management processes to ensure reliability goals
(SLOs) are met by working with the Platform Reliability Team.

What We're Looking For
● Significant experience in using MySQL for mission-critical applications
● In-depth knowledge of MySQL backup/recovery and replication
● It would be desirable to have a knowledge of MySQL clustering technologies like Galera Cluster
● SQL and query optimising techniques with a demonstrable ability to both
diagnose and prevent performance problems
● Assist the development teams with database design and schema modifications
● Expert understanding of high-performance MySQL (50k QPS)
● Working knowledge of PostgreSQL, Redis, MongoDB, Snowflake and Clickhouse.
● Core skills and attributes
● Customer focussed
● Thrive in a highly collaborative and fast-paced organisation that has office-based,
distributed teams and individuals
● Proficiency in the English language, both written and verbal, sufficient for
success in a remote workplace
● You are a good Linux admin

Bonus points if you have knowledge of
○ GCP (We are GCP focussed) or AWS data products and services ○ Ansible
○ Helm
○ Terraform
Commercial experience of working in a regulated environment, such as gaming or PCI-DSS

What we offer:
24 Paid Vacation Days and Additional Days Off Paid Sick Leaves
Learning & Development
English Classes
Comfortable Office Location
Office Wellbeing
Team Building
Travel: Business Trips to UK
Gifts: New Year Gift, Birthday Gift, Welcome Box for New Starters Career Path and Mentorship Program
Parental Leave: Maternity and Paternity Leave Referral Program: Active Program with Great Bonuses Relocation Support
Performance Review and Bonus
Medical Insurance and Sport Activities Compensation