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]
To land this job youll 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 youve 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