Database Administrator

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.
• Software Engineering experience with Unix Shell.
• Understanding of File Systems.
• Experience configuring database replication (physical and/or logical).
• ETL experience (3rd party and proprietary).
• Comfortable with version control systems such as git.
• A thirst for learning new Tech and keeping up with industry advances.
• Excellent communication and knowledge-sharing skills.
• Comfortable working with technical and non-technical teams.
• Strong debugging skills.
• Comfortable providing and receiving code review feedback.
• A positive attitude, adaptability, enthusiasm, and a growth mindset.