MySQL DBA

Job Description

THE JOB:

Join our database team and become an essential member of a team responsible for the largest ticketing system in the world. We are currently working on creating a set of next generation database tools to create, manage and operate various databases from AWS and then migrate our cloud databases to AWS. We use various RDBMS and NoSQL database technologies. We support multiple database platforms, running on both private and public cloud infrastructure, while powering the world's largest ticketing system and serving 170 million customers.

YOUR TASKS
• Continuously improve the reliability and performance of existing open source database platforms (including but not limited to MySQL), both cloud and on-premises solutions.
• Adopt self-service tools to make it easier to use data store services to help the technical development team (or developer) succeed.
• Provide appropriate support to users of database systems and database code deployments.
• Plan the growth and manage the capacity and life cycle of open source database platforms currently in production.
• Provide database consulting to collaborating engineering teams (verifying database changes, database architecture solution, benchmark testing, collaborating on proof of concept, performance tuning, troubleshooting, etc. .).
• Troubleshoot database issues in production and investigate external services or other levels of the architecture to analyze root causes.
• Strategize on building proactive monitoring and alerting to pre-empt outages
• Participate in the OnCall rotation, including L1 OnCall for the overall enterprise database stacks, and provide support during scheduled ticketing OnSale hour

TECHNICAL SKILLS
• Knowledge administering and managing OpenSource, MySQL, MariaDB, AWS Aurora, or Percona.
• Knowledge building and maintaining mission-critical database production systems.
• Knowledge and experience in designing and maintaining MySQL databases.
• Knowledge analyzing issues from the application tier to database.
• Experience working directly with cross-functional teams, resolving data or/and database related issues.
• Working knowledge of at least one scripting language (Shell, Python).
• Knowledge of Amazon Web Services (Aurora, RDS, DynamoDB, DMS, Lambda, EC2, EBS, S3, IAM, etc.)
• Knowledge of configuration management systems (e.g. Saltstack, Ansible, Terraform)
• Knowledge and experience with Percona platforms, Xtrabackup and Percona Toolkit.
• Systems engineering experience, including Linux performance, memory management, I/O tuning, configuration, security, networking and troubleshooting

YOU
• Exceptional oral and written communication skills in English.
• Experience working in a remote environment.
• Natural willingness to learn new technologies, participate in proofs of concept and provide the best data storage solutions to meet business needs.
• Willingness to regularly document acquired knowledge or processes and share them within the team, so that others can also contribute, freeing you up to work on other projects.
• Proficiency in Linux and Unix Shell systems.
• Ability to work independently
• Understand and willing to adopt SDLC and Agile best practices

LIFE AT TICKETMASTER

We are proud to be a part of Live Nation Entertainment, the world's largest live entertainment company.
Our vision at Ticketmaster is to connect people around the world to the live events they love. As the world's largest ticket marketplace and the leading global provider of enterprise tools and services for the live entertainment business, we are uniquely positioned to successfully deliver on that vision.

We do it all with an intense passion for Live and an inspiring and diverse culture driven by accessible leaders, attentive managers, and enthusiastic teams. If you're passionate about live entertainment like we are, and you want to work at a company dedicated to helping millions of fans experience it, we want to hear from you.
Our work is guided by our values:

Reliability - We understand that fans and clients rely on us to power their live event experiences, and we rely on each other to make it happen.

Teamwork - We believe individual achievement pales in comparison to the level of success that can be achieved by a team

Integrity - We are committed to the highest moral and ethical standards on behalf of the countless partners and stakeholders we represent

Belonging - We are committed to building a culture in which all people can be their authentic selves, have an equal voice and opportunities to thrive

e

The expected compensation for this position in Colorado is:
$96,000.00 USD - $120,000.00 USD
**Please note that the compensation information provided is a good faith estimate for this position only and is provided pursuant to the Colorado Equal Pay for Equal Work Act and Equal Pay Transparency Rules. It is estimated based on what a successful Colorado applicant might be paid. It assumes that the successful candidate will be in Colorado or perform the position from Colorado. Similar positions located outside of Colorado will not necessarily receive the same compensation. Live Nation takes into consideration a candidate's education, training, and experience, as well as the position's work location, expected quality and quantity of work, required travel (if any), external market and internal value, including seniority and merit systems, and internal pay alignment when determining the salary level for potential new employees. In compliance with the CO EPEWA, a potential new employee's salary history will not be used in compensation decisions.

Jobcode: Reference SBJ-d2e7bm-3-144-46-149-42 in your application.