Gracenote, a Nielsen company, provides music, video, and sports content along with technologies to the world's hottest entertainment products and brands, which is also a global standard for music and video recognition which is supported by the largest source of entertainment data. Gracenote features descriptions of more than 200 million tracks, TV listings for 85+ countries, and statistics from 4,500 sports leagues and competitions. Our team views diversity as a strength and we are looking for people who will help support an inclusive culture of belonging where everyone feels empowered to bring their full, authentic selves to work.
Job Purpose
We are looking for an experienced DBA to join our team which provides a spectrum of services and expertise to all business verticals within Gracenote. This person will collaborate with other Data Engineers, DBAs, SQL/ETL Developers, DevOps Engineers, Security professionals and Data Science team members, to architect, build, and deploy the platform solutions on which our entertainment metadata pipelines thrive.
As a 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.
Job 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 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.
Role Requirements / Desired Skills
5+ years of professional DBA experience with large datastores including HA and DR planning and support.
A degree in Computer Science or related technical field.
Strong Computer Science fundamentals.
Experience with languages such as ANSI SQL, TSQL, PL/pgSQL, PLSQL, plus database design,normalization, server tuning, and query plan optimization.
