Database Administrator

Tech Kings Cross, London Req. UMG-3363


Description

Job title: Database Administrator
Responsible to: Database Administration Manager
Department: UMPG Global Technology
Location of work: 4 Pancras Square, Kings Cross


Music is Universal

 

It’s the passionate and dedicated team at Universal Music who help make us Britain’s leading music company. From A&R to finance, legal to digital, sales to marketing, Universal Music is the place to grow and develop your career within a truly commercial and innovative business that leads in everything it does.

Everyone is welcome to apply for our roles, and we are determined to ensure that no applicant or employee receives less favourable treatment because of gender, race, disability, sexual orientation, religion, belief, age, marital status, background, pregnancy or caring responsibilities. We also recognise the importance of diversity of thought within our teams and are fully committed to embracing the talents of people with autism, dyslexia, ADHD and other forms of neurocognitive variation.

We will always seek to make appropriate adjustments to recruitment, workplaces, and work processes to be fully inclusive to people with different needs and working styles. If you need us to make any reasonable adjustments for you from application onwards, including alternatives to the online form or to disclose a neurocognitive condition, please email Helen@umusic.com

 
The A Side: A Day in The Life


This position is for a Database Administrator to work on application development projects. The individual will work closely with technical leads and developers to assist in both logical and physical database design along with database & SQL performance tuning.



The B Side: Skills & Experience

 

Be Technical
 

  • Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure
  • Design databases to support business applications, ensuring system scalability, security, performance and reliability
  • Review and or Develop data models for applications, metadata tables, views or related database structures
  • Design and Develop extract load and transform (ETL) and Database design for data warehouse
  • Develop or maintain backup processes, archived procedures, procedural codes, or queries for applications
  • Develop and document database architectures
  • Develop database architectural strategies at the modelling, design and implementation stages to address business or industry requirements
  • Create and enforce database development standards and ensure cross-team coordination
  • Demonstrate database technical functionality, such as performance, security and reliability
  • We expect everyone on our team to present creative solutions to our technology problems
  • Perform work in development environment, test in staging environment and work with other groups to push changes to production

 

Be Collaborative

 

  • Collaborate with solution architects, developers, business analysts, and others to understand business or industry requirements
  • Coach and mentor other developers in our team. Ensure that our ways of working are consistent across the teams
  • Integration with other groups in the company related to hosting, DBA support, Server upgrades and server support
  • Maintain balanced relationships across the business community, technical and scrum team and IT vendors
  • Manage client requests and expectations
  • Proactively and consistently communicate task status
  • Communicate risks, assumptions, issues, and dependencies to appropriate stakeholders and escalate if necessary, to ensure the project’s success

 

Be Organised

  

  • Account for time spent on activities using time tracking application

  

Personal Specification

 

 Necessary  

 

  • Ability to communicate with user community, project management, developers, contractors, and all levels of management
  • Strong Database Development experience
  • Significant SQL Server experience in a Development environment responsible for design, build and configuration
  • Significant developing in SQL Server Stored Procedures
  • Data warehouse experience using SSIS
  • Jira Experience
  • Worked in Web/Internet, Intranet and/or Extranet development teams
  • Knowledge of logical and technical database application design
  • Critical thinking and problem-solving skills
  • Strong technical writing ability using department templates and tools
  • Knowledge of NoSQL and other cloud databases such as Cassandra or AWS RDS
  • Knowledge of the software development life cycle
  • Database modelling
  • SQL Performance tuning
  • Excellent communication skills in English in written and spoken form
  • Proven track record of working in an agile environment, preferably in a variety of situations

Desirable 
  
  • Strong Agile (SCRUM) experience
  • Music industry royalty/copyright or other entertainment industry participation experience


Bonus Tracks: Your Benefits

 

  • Group Personal Pension Scheme (between 3% and 9%)
  • Private Medical Insurance
  • 25 paid days of annual leave
  • Interest Free Season Ticket Loan
  • Holiday Purchase scheme
  • Dental and Travel Insurance options
  • Cycle to Work Scheme
  • Salary Sacrifice Cars
  • Subsidised Gym Membership
  • Employee Discounts (Reward Gateway)


Just So You Know…

The company presents this job description as a guide to the major areas and duties for which the jobholder is accountable. However, the business operates in an environment that demands change and the jobholder's specific responsibilities and activities will vary and develop. Therefore, the job description should be seen as indicative and not as a permanent, definitive and exhaustive statement.