Senior Database Administrator
16 days ago
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.
Job Posting Title
Senior Database AdministratorSummary
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 MySQLWhat You'll Do
What You'll Do
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
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
Why Product Madness ?
Product Madness is so much more than just a Pool table and a foosball game.
We believe in an honest and transparent approach with our teammates. Company wide weekly Town Halls, All Hands and strategy meetings are just a few ways in which we encourage an open and honest path to achieving complete transparency.
Despite a pandemic, there isn’t a day where we don’t feel connected to one another.
With frequent events, workshops, giveaways, slack coffee and donut sessions we have definitely brought on our office culture to this new virtual world of zoom calls.
We also try to cater for all our staff’s needs – be that a freshly brewed cappuccino made by our professional barista in our free coffee shop or by providing a bountiful supply of tasty snacks to keep us refueled and buzzing.
We love to organise plenty of social get-togethers and action-packed activity days, be it slipping inside an inflatable bumper ball for a mad session of football zorbing or throwing caution to the wind and traversing giddy treetop rope courses at Go Ape. On top of these team-building activities, our lunch and learn workshops, not to mention the lavish Christmas and summer parties, foster that ‘work hard, play hard’ mantra. Our offices are based in the heart of the metropolises of London and Lviv, surrounded by an abundance of diversity and inspiration to keep those ideas flowing.
Our Values
People First
We have the deepest respect for our people and their well being. We know they are exceptionally talented and will always have a choice. We want them to re-choose us every day. We are committed to building a culture where each person's voice will always be heard and addressed.
MAD for More
Always improving, innovating and never settling for the existing. We push all boundaries with courage and ambition to become the world’s best games company.
Globally Inclusive
We are all Equal - regardless of the language we speak, where we live, our gender, religion or culture we come from. We want to build a global home, where everyone has the equal opportunity to make an impact.
Customer Focused
We always think from the customer's perspective - be it players or internal customers.Improving their experience and joy is what drives us. Every client's success is our big win!
Create Your Profile — Game companies can contact you with their relevant job openings.