MySQL Database Administrator (DBA)

  • Denver, CO
  • Full-time

Company Description

Beatport is growing and we are looking for talented people who are passionate about what they do. We have built an amazing business around inspiring people to play with music and everyone's role here plays an important part in this. If you are excited at the prospect of working for a technology company that lives and breathes music, check out our current open positions below. Aside from a competitive salary, Beatport has much more to offer: 

> A fun, collaborative working environment (dog friendly in Denver & Berlin too) 
> Weekly DJ performances broadcast live from Denver & Berlin offices 
> Medical, dental and vision benefits soon after starting 
> 401k plan with employer match 
> Free money to use on Beatport.com 
> VIP access to select music events

Job Description

As a Database Administrator on the Data Services team at Beatport you will work on a 5 to 7 member Agile Scrum team. You will be working with Data Warehouse Developers & Developers to assist with data model changes, be a member of the SQL review process to ensure our applications remain performant, and coordinate with the Infrastructure team for systems changes.

You will also take part in planning sessions at the beginning of each 2 week sprint cycle where you will be responsible for planning, tasking, and estimating user stories. We have a highly collaborative environment where the team works together with their Product Expert and Stakeholders to define solutions. Everyone has the opportunity to contribute to our products and share the success of releasing valuable features on a regular basis.

 

Some of the typical job responsibilities include:

  • Ensure high performance and availability of MySQL instances
  • Installation, configuration, and management of MySQL instances (including replication)
  • Manage backup and restore processes and procedures
  • Disaster recovery planning
  • Member of SQL review process with developers to ensure consistency and performance
  • On call support
  • Coordination and execution of DDL/DML for each environment [development, staging, production]

Qualifications

To land this job you’ll need to have:

      • Solid understanding of performance tuning, capacity planning
      • Solid understanding of MyISAM and InnoDB storage engines
      • Demonstrated experience with replication, configuration, management, and strategies
      • Understanding of triggers
      • Environment management [development, staging, production]
      • Data modeling experience
      • Adequate Linux systems administration experience to perform DBA tasks
      • Experience with large data sets and strategies to deal with them


And it will be an added bonus if you’ve got:

      • Data Warehousing knowledge
      • ETL experience / Pentaho
      • Experience with Python, Java, shell scripting
      • Experience with RHEL/CentOs/Scientific Linux
      • Experience with Git/Mercurial or other source control tools
      • Experience with Puppet
      • Experience with Solr