Database Administrator(AWS, DB Replication)

At Nielsen, we believe that career growth is a partnership. You ultimately own, fuel and set the journey. By joining our team of nearly 14,000 associates, you will become part of a community that will help you to succeed. We champion you because when you succeed, we do too. Embark on a new initiative, explore a fresh approach, and take license to think big, so we can all continuously improve. We enable your best to power our future. 

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. 

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.

Purpose:

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.

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.

Qualifications:

• A degree in Computer Science or related technical field.
• Strong Computer Science fundamentals.
• 5+ years of professional DBA experience with large datastores including HA and DR planning and support.
• 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.

Nice to have:

• A personal technical blog
• A personal (Git) repository of side projects
• Participation in an open-source community

Preferred skills:

• 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.

ABOUT THE TEAM

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.

ABOUT NIELSEN

By connecting clients to audiences, we fuel the media industry with the most accurate understanding of what people listen to and watch. To discover what audiences love, we measure across all channels and platforms⁠—from podcasts to streaming TV to social media. And when companies and advertisers are truly connected to their audiences, they can see the most important opportunities and accelerate growth. Do you want to move the industry forward with Nielsen? Our people are the driving force. Your thoughts, ideas, and expertise can propel us forward. Whether you have fresh thinking around maximizing a new technology or you see a gap in the market, we are here to listen and act. Our team is made strong by a diversity of thoughts, experiences, skills, and backgrounds. You’ll enjoy working with smart, fun, curious colleagues, who are passionate about their work. Come be part of a team that motivates you to do your best work!