SQL Database Administrator, Enterprise Systems Warner Music Group
New York, NY

Job Description

SQL Database Administrator, Enterprise Systems

Job Description:

With its broad roster of new stars and legendary artists, Warner Music Group is home to a collection of the best-known record labels in the music industry including Asylum, Atlantic, Big Beat, Canvasback, East West, Elektra, Erato, FFRR, Fueled by Ramen, Nonesuch, Parlophone, Reprise, Rhino, Roadrunner, Sire, Warner Records, Warner Classics, and Warner Music Nashville; Warner Chappell Music, one of the world's leading music publishers, with a catalog of more than one million copyrights worldwide.

For more than four decades, WMG has been an industry-leading force in providing a world-class array of services designed to help artists and labels grow their careers and their businesses. Artist & Label Services is the umbrella for WEA (Warner-Elektra-Atlantic) - the pioneering WEA distribution and marketing network - and Alternative Distribution Alliance (ADA) - the groundbreaking global distribution company for independent artists and labels.

Job Title: SQL Database Administrator, Enterprise Systems

A little bit about our team:

Global team of dynamic, creative and collaborative problems solvers working together to build highly secure and scalable solutions to drive innovation and operational excellence. Be responsible for the health, performance, and continuous improvement of the applications and systems that IT is responsible for. This group is the digital thought and technology collective working with world class creative Media & Entertainment executives and their teams; acting as the trusted operators and strategic partners with them to deliver the best possible outcomes.

Why this could be your next big break:

This is an opportunity to move the needle and make a significant impact within a large global enterprise. Responsibilities include coordinating projects and resources as new business offerings and technologies are developed and implemented within Warner Music Group. Requires excellent communication and technical skills, while working closely with all business units within Warner Music Group in determining design criteria and proof of concept as they relate to each business offering. Other functionality includes acting as engineering liaison to outside engineering entities, project budget management, staffing development and vendor management. Collaborate, design and implement ideas with business leaders from whiteboard to digital delivery and be a true partner with our business leaders. Recognize that as a Service Organization we're there to partner and steward the organization to operate efficiency, drive revenue and manage risk.

Here you'll get to:

* Install, monitor and support SQL server instances including various SQL components i.e. SSIS, SSRS, and SSAS.
* Install, monitor, and support various SQL High Availability and Disaster Recovery solutions
* Database migration (i.e., to new servers), user access administration
* Support client application installations
* Create new databases and overwrite test databases with copies of production databases
* Backup/Recovery/Rollback Production, Test, and Development Databases
* Troubleshoot application database connectivity, SQL server issues, query performance, SQL HA/DR (i.e. SQL Cluster, AlwaysOn, Log Shipping, DB replication) and other issues in production and development. Coordinate/implement production fixes, or advise the application owner/administrator/developer, as appropriate.
* Monitor & manage data storage capacity of production and test/development SQL Servers to support DB growth; coordinate drive expansions with Operations & Change Management Team.
* Complete and maintain inventory documentation of all SQL databases at the data center and cloud. Work with DB/application owners to update status and complete missing information.
* Decommission Databases: proactively identify obsolete DBs, obtain DB owner's approval, archive & delete DB.
* Write T-SQL code and stored procedures to monitor, automate and support DBA tasks.
* Maintain and improve upon systems availability. Evaluates, and make recommendations on new technology and takes part in vendor selection.
* Ensure alignment between business and technical objectives
* Work in a highly creative environment and solve new problems everyday
* Set policy and governance to evolve with the ever-changing threat and compliance landscape
* Collaborate across multiple technology and business disciplines globally
* Be a leader in a global team where all options are on the table
* Have a place to go beyond "thinking your thoughts", but be able to shape them, stretch them, land and fly them

Rockstar candidates will be able to:

5-8 years previous hands-on Database Administration using the following skills:

* Strong analytical and problem-solving skills
* Strong knowledge of SQL Server database administration and best practices
* General understanding of object-oriented software architecture, design, and implementation
* General understanding of programming techniques and practices
* Experience with Windows PowerShell Programming
* Experience with SQL Server Reporting Services and SQL Server Analysis Services
* Able to exercise good judgment, resolve issues, and facilitate successful resolution of operational or application issues and constraints.
* Able to obtain, understand and interpret performance data.
* Exceptional communication skills, both written and oral.
* Ability to multi-task and adjust priorities based on workload.
* Incident management and response, post mortem follow-ups/root cause analysis

It would be music to our ears if you also had:

* Microsoft Office 365: SharePoint, Teams, Forms, Power BI
* Familiarity with Exchange Online, Active Directory and Active Directory Federation Services (ADFS), Active Directory Synchronization
* Knowledge of cloud system engineering principles and considerations

Why join us?

Warner Music Group is all about our people. We are one global company made up of the most knowledgeable, passionate, and creative people in our business.

It is the mission of every member of the WMG team around the world to create a nurturing environment for artists, songwriters, and the people behind the music, every stage of their career. We strive to set WMG apart from the rest of the industry by embracing a philosophy of innovation that is part of our company's DNA.

Consider a career at WMG and be a part of one of the biggest forces in music today.

Love this job and want to apply?

Click the "Apply" link at the top of the page or apply directly with your LinkedIn. Applying with LinkedIn will import all of the information you put in your profile but will still allow you to upload a resume and cover letter.

Don't be discouraged if you don't hear from us right away. We're taking our time to review all resumes, and to find the best people for WMG.

Thanks for your interest in working for Warner Music Group. We love it here and think you will too.

Warner Music Group is an equal opportunity employer. We enthusiastically accept our responsibility to make employment decisions without regard to race, religious creed, color, age, sex, sexual orientation, gender, gender identity, gender expression, national origin, ancestry, marital status, medical condition as defined by state law (genetic characteristics or cancer), physical or mental disability, military service or veteran status, pregnancy, childbirth and related medical conditions, genetic information or any other classification protected by applicable federal, state or local laws or ordinances.

Copyright © 2018 Warner Music Inc.