Senior Database Administrator - Mumbai

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.

Job 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 optimization
• .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:

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

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 blogA personal (Git) repository of side projectsParticipation in an open-source community

Qualifications

• B.E / B.Tech / BCA/ MCA in Computer Science, Engineering or a related subject.
• Strong Computer Science fundamentals.
• 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.

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!