Database Administrator

Key Skills

Apache Airflow, Apache Kafka, Data science techniques, Database, Effective communication skills, Git, Grafana, Java Programming, PLSQL, PostgreSQL, Python Programming, Scala Programming, SDLC, SQL, T-SQL

Job Description

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.