Senior Database Administrator
Full-time Not ApplicableJob Overview
About Gracenote :
Gracenote is the top provider of entertainment information, creating industry-leading databases of TV, movie, and music metadata for entertainment guides, applications and in-car entertainment. Our technology serves billions of requests daily to hundreds of millions of devices around the world. Our customers include innovators like Apple, Twitter, Google, Spotify, M-GO and Hulu, top consumer electronics and cable companies, and leading automotive manufacturers such as Ford and Toyota, throughout the US and the world. Simply put, data provides you with an opportunity to impact the evolution of the entire entertainment industry.
Purpose:
As a Senior DBA, your role is to own the databases in our data pipeline and the data governance of our Data Strategy. Our Data Strategy underpins our suite of Client-facing Applications, Data Science activities, Operational Tools and Business Analytics.
Responsibilities:
Architect and build scalable, resilient and cost-effective data storage solutions to support complex data pipelines.
The architecture has two facets: Storage and Compute. The DBA is responsible for designing and maintaining the different tiers of the data storage, including (but not limited to) archival, long-term persistent storage, transactional and reporting storage.
Design, implement and maintain various data pipelines such as self-service ingestion tools, exports to application-specific warehouses, and indexing activities.
The senior DBA is responsible for data modeling, as well as designing, implementing and maintaining various data catalogs, to support data transformation and product requirements.
Configure and deploy databases on AWS cloud, ensuring optimal performance and scalability.
Monitor database activities for compliance and security purposes.
Set up and manage backup and recovery strategies for cloud databases ensuring availability and quality.
Monitor database performance metrics and identify areas for optimisation.
Create scripts for database configuration and provisioning.
Collaborate with Data Science to understand, translate, and integrate methodologies into engineering build pipelines.
Partner with product owners to translate complex business requirements into technical solutions, imparting design and architecture guidance.
Provide expert mentorship to project teams on technology strategy, cultivating advanced skill sets in software engineering and modern SDLC.
Stay informed about the latest technologies and methodologies by participating in industry forums, having an active peer network, and engaging actively with customers.
Cultivate a team environment focused on continuous learning, where innovative technologies are developed and refined through teamwork.
Must Have skills & expeiences:
Experience with languages such as ANSI SQL, TSQL, PL/pgSQL, PLSQL, plus database design, normalization, server tuning, and query plan optimization.
6+ years of professional DBA experience with large datastores including HA and DR planning and support.
Software Engineering experience with programming languages such as Java, Scala, and Python.
Demonstrated understanding and experience with big data tools such as Kafka, Spark and Trino/Presto
Experience with orchestration tools such as Airflow
Comfortable using Docker and Kubernetes for container management.
DevOps experience deploying and tuning the applications you’ve built.
Monitoring tools such as Datadog, Prometheus, Grafana, Cloudwatch.
Desired Skills/Good to Have:
Software Engineering experience with Unix Shell.
Understanding of File Systems.
Experience configuring database replication (physical and/or logical).
ETL experience (3rd party and proprietary).
A personal technical blog
A personal (Git) repository of side projects
Participation in an open-source community