MySQL DBA who loves hacking (Hilversum, the Netherlands)
Posted by: Tessa Kaat
Date: December 18, 2013 06:32AM
Date: December 18, 2013 06:32AM
Spil Games is looking for a creative MySQL DBA who enjoys all aspects of working with databases and data architecture.
All the data we use to have a business at all, be it user profiles, high scores, game information, ratings, comments, etc., needs to be stored somewhere. Spil Games has over 80 database servers running, which handle as much as 60.000 queries per second and 3 billion queries a day! We must handle multiple modes of database failure (hardware failure, data corruption, etc.), which makes the setup unique and challenging, and requires advanced techniques that utilize leading edge approaches and tools.
As a DBA (mainly MySQL) you will be part of a department of 8, consisting of both DBA’s and Datawarehouse Engineers who work closely together on different projects. You will be responsible for integrity, confidentiality, and availability of the data, by setting up and maintaining the systems that hold the data and monitor it’s important functions.
Working as a DBA at Spil Games, you’ll be encouraged to be creative and look for innovative solutions. We have hacking days where you can spend time on work related topics that have your own personal interest. Start it up, learn and create new things, and share it with the rest of the world (if not our core business of course). There is an open work environment where you’re allowed to build new things, and expected to take ownership and initiative.
Core tasks and responsibilities of this DBA job
The primary focus of the DBA will be backing up, monitoring, updating, tuning, and automating our databases. You will also work with our architects and developers to improve the architecture of our applications, as well as design and implement future production systems. Your work will be essential to the quality and performance of our global high-traffic websites.
• Performing and automating daily database related tasks;
• Actively monitor our databases and tune our databases to do their task more efficiently;
• Supporting our developers in applying queries and (schema) changes to our databases;
• Setting up new database servers/clusters and improving the existing ones; and
• Proactively solving problems, and suggesting process and project improvement;
• Ensuring business continuity by keeping our database highly available and our data secure.
Your Profile:
• Experience with MySQL and/or other database systems
• Experience in setting up systems/clusters
• Experience with system automation like Puppet, Chef and Ansible
• Experience with database (change) management
• Experience with high availability database systems like MMM, Tungsten and DRBD
• Experience with scripting languages like Bash, Python, Perl and PHP
• In depth knowledge of GNU/Linux
• Problem-solver: candidate should be a strong, analytical problem solver with a common sense and practical solutions orientation
• Professional, proactive, and positive “can-do” attitude
• Excellent communication skills in English, both written and verbal (Dutch and other languages are a plus)
Why Join Spil Games?
Level up your career—be part of a rapidly growing leader in the online gaming industry, where playing games is all part of a day’s work. Spil Games also offers these great benefits:
• A competitive salary and bonus system
• Flexible hours (from 7 AM till 7 PM)
• A pension and collective health insurance plan
• Reimbursement for your daily commute
• Extras, such as a bike plan and canteen
• And, most importantly, training and development programs—because when you grow, we grow with you!
Adventure awaits those up for the challenge. Are you ready to play?
About the Engineering Department
IT Infrastructure & Engineering is a multi-disciplinary department consisting of the following teams: Databases, Performance, Infrastructure, Software, and Operations. At the core of our technology stack you'll find the Spil Hosting Platform, which we as a department jointly develop and operate. It is a geographically distributed, Linux-based, highly available, and highly scalable system, which consists of a large fleet of MySQL servers, private cloud, map/reduce and memcache clusters, lots of webservers, and a bit more thrown in.
We operate on values and principles rather than rules, policies, and procedures. This means you'll have lots of freedom in terms of doing what you think is right, but it also comes with great individual responsibility. We really like people who dare to be different and think for themselves.
Some things we’re big on: innovation, making mistakes (and learning from them), technical challenges and elegant solutions, openness and transparency, open source, lifelong learning, Python, and playing Magic the Gathering.
Some things we’re not so big on: bureaucracy, making the same mistake twice, slowness, corporate politics, repetitive tasks, hierarchy, Internet Explorer, Java, and talking about soccer.
About Spil Games:
Spil Games is an online games publisher scouting the best content from top game developers to entertain the 180 million visitors who play on its sites each month. With over 11 billion gameplays, Spil is the world’s largest independent social-gaming platform. Chances are somebody in your family plays one of our games—every day. Using cutting-edge technology, Spil selects content specifically tailored to the different interests of its three targeted online-gaming audiences: girls (www.girlsgogames.com), women (www.zibbo.com), and guys (www.a10.com). Whether it’s on the web, on mobile phones, or on tablets, you'll find Spil Games wherever people are connecting and playing—it’s all part of our mission to unite the world in play.
Technology
We create portals, payment solutions, APIs, back-end logic, algorithms and widget machines, we master disciplines such as performance engineering, code and product quality, security, scalability and databases, all for the benefit of more than 180 million unique monthly users across more than 40 Web products.
The Agile manifesto is our mantra. We use object-oriented PHP, scalable and powerful Erlang, flexible and logical Python, slick JavaScript, modularized CSS and innovative HTML5. We construct our own tools, from an automated testing framework in Ruby, to a sophisticated deployment system in PHP.
Oh, one last thing. We do not do Excel. Really.
All the data we use to have a business at all, be it user profiles, high scores, game information, ratings, comments, etc., needs to be stored somewhere. Spil Games has over 80 database servers running, which handle as much as 60.000 queries per second and 3 billion queries a day! We must handle multiple modes of database failure (hardware failure, data corruption, etc.), which makes the setup unique and challenging, and requires advanced techniques that utilize leading edge approaches and tools.
As a DBA (mainly MySQL) you will be part of a department of 8, consisting of both DBA’s and Datawarehouse Engineers who work closely together on different projects. You will be responsible for integrity, confidentiality, and availability of the data, by setting up and maintaining the systems that hold the data and monitor it’s important functions.
Working as a DBA at Spil Games, you’ll be encouraged to be creative and look for innovative solutions. We have hacking days where you can spend time on work related topics that have your own personal interest. Start it up, learn and create new things, and share it with the rest of the world (if not our core business of course). There is an open work environment where you’re allowed to build new things, and expected to take ownership and initiative.
Core tasks and responsibilities of this DBA job
The primary focus of the DBA will be backing up, monitoring, updating, tuning, and automating our databases. You will also work with our architects and developers to improve the architecture of our applications, as well as design and implement future production systems. Your work will be essential to the quality and performance of our global high-traffic websites.
• Performing and automating daily database related tasks;
• Actively monitor our databases and tune our databases to do their task more efficiently;
• Supporting our developers in applying queries and (schema) changes to our databases;
• Setting up new database servers/clusters and improving the existing ones; and
• Proactively solving problems, and suggesting process and project improvement;
• Ensuring business continuity by keeping our database highly available and our data secure.
Your Profile:
• Experience with MySQL and/or other database systems
• Experience in setting up systems/clusters
• Experience with system automation like Puppet, Chef and Ansible
• Experience with database (change) management
• Experience with high availability database systems like MMM, Tungsten and DRBD
• Experience with scripting languages like Bash, Python, Perl and PHP
• In depth knowledge of GNU/Linux
• Problem-solver: candidate should be a strong, analytical problem solver with a common sense and practical solutions orientation
• Professional, proactive, and positive “can-do” attitude
• Excellent communication skills in English, both written and verbal (Dutch and other languages are a plus)
Why Join Spil Games?
Level up your career—be part of a rapidly growing leader in the online gaming industry, where playing games is all part of a day’s work. Spil Games also offers these great benefits:
• A competitive salary and bonus system
• Flexible hours (from 7 AM till 7 PM)
• A pension and collective health insurance plan
• Reimbursement for your daily commute
• Extras, such as a bike plan and canteen
• And, most importantly, training and development programs—because when you grow, we grow with you!
Adventure awaits those up for the challenge. Are you ready to play?
About the Engineering Department
IT Infrastructure & Engineering is a multi-disciplinary department consisting of the following teams: Databases, Performance, Infrastructure, Software, and Operations. At the core of our technology stack you'll find the Spil Hosting Platform, which we as a department jointly develop and operate. It is a geographically distributed, Linux-based, highly available, and highly scalable system, which consists of a large fleet of MySQL servers, private cloud, map/reduce and memcache clusters, lots of webservers, and a bit more thrown in.
We operate on values and principles rather than rules, policies, and procedures. This means you'll have lots of freedom in terms of doing what you think is right, but it also comes with great individual responsibility. We really like people who dare to be different and think for themselves.
Some things we’re big on: innovation, making mistakes (and learning from them), technical challenges and elegant solutions, openness and transparency, open source, lifelong learning, Python, and playing Magic the Gathering.
Some things we’re not so big on: bureaucracy, making the same mistake twice, slowness, corporate politics, repetitive tasks, hierarchy, Internet Explorer, Java, and talking about soccer.
About Spil Games:
Spil Games is an online games publisher scouting the best content from top game developers to entertain the 180 million visitors who play on its sites each month. With over 11 billion gameplays, Spil is the world’s largest independent social-gaming platform. Chances are somebody in your family plays one of our games—every day. Using cutting-edge technology, Spil selects content specifically tailored to the different interests of its three targeted online-gaming audiences: girls (www.girlsgogames.com), women (www.zibbo.com), and guys (www.a10.com). Whether it’s on the web, on mobile phones, or on tablets, you'll find Spil Games wherever people are connecting and playing—it’s all part of our mission to unite the world in play.
Technology
We create portals, payment solutions, APIs, back-end logic, algorithms and widget machines, we master disciplines such as performance engineering, code and product quality, security, scalability and databases, all for the benefit of more than 180 million unique monthly users across more than 40 Web products.
The Agile manifesto is our mantra. We use object-oriented PHP, scalable and powerful Erlang, flexible and logical Python, slick JavaScript, modularized CSS and innovative HTML5. We construct our own tools, from an automated testing framework in Ruby, to a sophisticated deployment system in PHP.
Oh, one last thing. We do not do Excel. Really.
Subject
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.