Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Oil & Gas Jobs |
Banking Jobs |
Construction Jobs |
Top Management Jobs |
IT - Software Jobs |
Medical Healthcare Jobs |
Purchase / Logistics Jobs |
Sales |
Ajax Jobs |
Designing Jobs |
ASP .NET Jobs |
Java Jobs |
MySQL Jobs |
Sap hr Jobs |
Software Testing Jobs |
Html Jobs |
Job Location | Mumbai City |
Education | Not Mentioned |
Salary | Not Disclosed |
Industry | Media / Dotcom / Entertainment |
Functional Area | General / Other Software |
EmploymentType | Full-time |
SQL DBADate: Jul 13, 2019 Location: Mumbai, IN Company: NielsenGracenote is an entertainment data and technology provider powering the world s 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 world s top engineers with a passion for music, video, sports, and entertainment technology. Founded in 1998, Gracenote is one of America s most iconic and respected media companies.Job PurposeOur database estate consists of SQL Server and Azure Cosmos DB databases in severaldifferent environments.We are in the process of refreshing our technology stack which willresult 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 DBdatabase environments.Job ResponsibilitiesMaintain the integrity and performance of the various environments through maintenanceroutines.Ensure backups and recoverability of databases.Maintain the high availability and disaster recovery (HADR) systems including performingfailover and failback.Troubleshoot SQL Agent jobs and SSIS / DataFactory package failures.Production monitoring of performance, capacity and scalability including raising archivingrequirements.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 optimisationSQL 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 RequirementsE=essential, P=preferredE - 3 - 5 years of Microsoft SQL Server Administration with production support experience.Knowledge of Microsoft Clustering and Hyper - V virtualisation conceptsSQL Server Reporting Services AdministrationSSIS Package AdministrationAlways On Availability GroupsSQL ReplicationP - Familiar with unstructured databases such as CosmosDB.P - Familiar with JSON and XML.P - Familiar with Redgate ToolsE - Familiar with Powershell,
Keyskills :
microsoftsqlserver sqlserveradministration sqlserver sqldatabase disasterrecovery highavailability consumerelectronics qlserverrep tingservices productionsupp perf mancetuning rep tingservices