Database Administrator
Universal Music Group
Kings Cross, UKThis was removed by the employer on 5/14/2020 12:52:00 PM PST
Not to worry we have many other jobs on the site;
Browse all jobs
Browse the IS/IT Category
Search for Database Administrator jobs in Kings Cross-UK
Search all Database Administrator postings
Full Time Job
Description
Job title: Database Administrator
Responsible to: Database Administration Manager
Department: UMPG Global Technology
Location of work: 4 Pancras Square, Kings Cross
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.