Job Description:

Company Nielsen

Gracenote is an entertainment data and technology provider powering the worlds top music services, automakers, cable and satellite operators, and consumer electronics companies At its core, Gracenote helps people find, discover and connect with the entertainment they love Daily, Gracenote processes 35 billion rows of data and is quickly becoming a world-leader in return path big data Over the past 3 years, the company has grown to more than 2000 employees in 17 countries, including over 600 of the worlds top engineers with a passion for music, video, sports, and entertainment technology Founded in 1998, Gracenote is one of Americas most iconic and respected media companies

Job Purpose

Our database estate consists of SQL Server and Azure Cosmos DB databases in several different environments
We are in the process of refreshing our technology stack which will result in greenfield project work
The database administrator will be responsible in maintaining performance, security, integrity, recovery and scalability of the SQL Server, Azure SQL Database and Cosmos DB database environments

Job Responsibilities

Maintain the integrity and performance of the various environments through maintenance routines
Ensure backups and recoverability of databases
Maintain the high availability and disaster recovery (HADR) systems including performing failover and failback
Troubleshoot SQL Agent jobs and SSIS/DataFactory package failures
Production monitoring of performance, capacity and scalability including raising archiving requirements
Software release deployment and operational script deployment from other IT teams
Database code review
Database source control governance
Responsible for environment database refreshes
Control access permissions and privileges
Continual performance tuning and optimisation
SQL patching and version upgrades
Project work such as disaster recovery site upgrades and database migrations
Maintain and enhance technical documentation
Providing operational DBA support in our near 24/7 environment

Role Requirements E=essential, P=preferred

E -3-5 years of Microsoft SQL Server Administration with production support experience

Knowledge of Microsoft Clustering and Hyper-V virtualisation concepts
SQL Server Reporting Services Administration
SSIS Package Administration
Always On Availability Groups
SQL Replication

P - Familiar with unstructured databases such as CosmosDB
P - Familiar with JSON and XML
P - Familiar with Redgate Tools
E - Familiar with Powershell

#LI-GN

#NLSN

Our passion for music, TV and sports is at the heart of everything we do But what really makes us tick is our people From Emeryville to Tokyo and Queensbury to Copenhagen, we are building the team thats going to disrupt the digital universe This starts by creating a workplace where all things entertainment are celebrated and innovation can come from anyone If you are interested in being mission critical and on the leading edge of global entertainment technology then please contact us today!

Nielsen is committed to hiring and retaining a diverse workforce We are proud to be an Equal Opportunity Employer, making decisions without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, marital status, protected veteran status or any other protected class

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Research/Surveyor/MR
Functional Area : IT Software : Software Products & Services
Role : Database Administration (DBA)
Salary : As per Industry Standards
Deadline : 22nd Jul 2020

Key Skills:

These are some of our most popular tutorials

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status