Nielsen - Senior Database Administrator - Mumbai & Bangalore

Job Description

Senior Database Administrator - Mumbai & BangaloreLocation: Mumbai, IndiaTechnology: EngineeringEmployment Type: Full TimeWork Model: HybridGracenote is the content business unit of Nielsen that powers the world of media entertainment. Our metadata solutions help media and entertainment companies around the world deliver personalized content search and discovery, connecting audiences with the content they love.Were at the intersection of people and media entertainment. With our cutting-edge technology and solutions, we help audiences easily find TV shows, movies, music and sports across multiple platforms.As the world leader in entertainment data and services, we power the worlds top streaming platforms, cable and satellite TV providers, media companies, consumer electronics manufacturers, music services and automakers to navigate and succeed in the competitive streaming world.Our metadata entertainment solutions have a global footprint of 80 countries, 100K channels and catalogs, 70 sports and 100M music tracks, all across 35 languages.Job PurposeAs 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/Presto.
• Experience with orchestration tools such as Airflow.
• Comfortable using Docker and Kubernetes for container management.
• DevOps experience deploying and tuning the applications youve 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 blog.
• A personal (Git) repository of side projects.
• Participation in an open-source community.

Qualifications

• B.E / 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 NielsenBy 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 platformsfrom 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 diverse range of thoughts, experiences, skills, and backgrounds. Youll 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!

Keyskills :
database design data pipeline architecting aws cloud deployment devops practices performance monitoring orchestration plsql java pl/pgsql software engineering big data python fundamentals scala storage docker security git debugging sate