Sr. Database Engineer + Data Ops

Company Description

Senior Database Engineer & Data Ops

About TuneCore:

Before TuneCore, artists needed a label to sell their music online. In 2006, we changed the game by partnering with digital stores and streaming platforms to enable any musician to sell their songs worldwide while keeping 100% of their sales revenue. Today, TuneCore is the leading music distribution service for independent artists worldwide. Headquartered in Brooklyn, NY, TuneCore is owned by Paris based, global digital music company Believe. A member of the 'Next 40' index, Believe is the first IPO of a 'unicorn' on Euronext Paris. The company raised €300 million when it went public on June 10, 2021 and is now actively investing in the continued growth of the business.

We have made it our mission to best serve artists and labels at each stage of their development in the digital world. We are a company who cares deeply about our people and our creator community, advocating for diversity, equity, and inclusion across all of our platforms and throughout our business. Innovation keeps us working hard for our artists and collaboration drives the way we work, as well as the way we approach our company’s social responsibility.

Join TuneCore as we embark on the next phase of innovation in the music industry. Be part of a team that is bridging creators’ unmet and evolving needs by building the tools and services that they can’t live without and make their lives better.

Job Description

Job Description:

TuneCore Engineering develops web applications in the music space, supporting both our talented customers, and internal operations. Our Data Ops / Database Engineer is a hybrid role: part database expert, part ETL pipeline automation, and optimization expert.

You will spend the majority of your time creating pipelines and tooling to automate data production and analytics development workflows, and making application changes to improve database performance, scalability, and reliability, to help deliver foundational data solutions and best practices for our teams.

The ideal candidate will have experience working in cloud-based environments supporting customer-facing web products and services, love solving complex problems, strive to automate “all the things”, and bring a "DataOps culture mindset.” You’ll be mindful of best design practices, fault-tolerance, and performance, and have the ability to learn on the fly. You’ll be an excellent communicator who is able to collaborate across multiple teams, and will enjoy and contribute to working in a fun and diverse team environment. We work hard, and like to have fun while we do it!

As a Senior Database Engineer & Data Ops at TuneCore, you will:

● Join our growing database team and assist in the maintenance and growth of our cloud-based database infrastructure, data warehouse, and data pipelines

● Implement processes for optimizing database integrity and performance

● Collaborate closely with our Engineering Team to design data models and schemas for our applications, and deliver application changes that allow us to scale our platform to make sure we're prepared for data growth

● Build automation for database tasks to promote reuse and reliability of code

● Improve tooling to detect performance bottlenecks early in the development cycle

● Highlight gaps in TuneCore’s data stacks and improve testing of data pipelines ● Support our Data and Engineering teams on ETL and Data Warehousing initiatives

● Diagnose and troubleshoot critical Production incidents within the platform

● Create and manage database reports, visualizations, and dashboards

Requirements:

● Hands-on experience with MariaDB, MySQL, PostgreSQL, and Amazon RDS, Snowflake (or relevant Data Warehousing platform), Matillion (or other ETL tooling)

● Strong SQL query tuning experience: Adding/removing indexes, rewriting queries for better performance, InnoDB and myISAM tuning and migrations

● Experience with DataOps tools (DataKitchen, Unravel, Airflow etc.)

● Must have Demonstrated Bash/Python scripting experience

● Direct experience creating observability of relevant database metrics to make sure we reach our database objectives (Prometheus instrumentation, workload analysis etc.)

● Comfortable operating in a Linux environment (we're a 100% Linux shop)

Nice to Have:

● Work on automation of database infrastructure and implementation of Implement self-service tools

● Experience working with Clickhouse, Kafka, Spark, Databricks or similar technologies

● Implement solutions that provide resiliency for disaster recovery

● Exposure to NoSQL Databases (MongoDB, Dynamo, Redis, Couchbase etc.)

● Deep knowledge of Linux OS in