Database Engineer

Ticketmaster; Birmingham; On-site; GBP 45,000 - 65,000; Full time

Job summary

A leading ticketing technology firm in Birmingham seeks an experienced Database Services Engineer to support and enhance database platforms for sports ticketing products. Responsibilities include maintaining high availability solutions, collaborative planning, and fostering automation within the teams. Ideal candidates should possess strong skills in MSSQL, automation tools, and cloud technologies. Competitive benefits include an inclusive work environment.

Qualifications

• Experience troubleshooting logical and physical performance bottlenecks on MSSQL.
• Good knowledge of configuring Microsoft SQL Server (2012 to 2019).
• Good understanding of T-SQL and Query Profiler.
• Knowledge of other RDBMS would be advantageous (MySQL, Postgres, etc.).
• Experience designing, implementing and supporting always-available, cross-datacentre OLTP database environments.

Responsibilities

• Support the current and future database platform(s).
• Maintain existing backup, HA and DR solutions and processes.
• Assist with database architecture planning and implementation.
• Build and maintain CI / CD Database pipelines.
• Collaborate with product engineering to bring new components and features to production.

Skills

Troubleshooting performance bottlenecks on MSSQL

Configuring Microsoft SQL Server (2012 to 2019)

T-SQL and Query Profiler

Knowledge of other RDBMS (MySQL, Postgres)

Designing OLTP database environments

SQL Server monitoring tools

Public cloud (AWS)

Configuration management (Ansible, Chef, Octopus)

Configuring Windows Server

Network Storage (NetApp, Amazon S3)

Virtualization (Hyper-V, XEN, VMware)

Provisioning using Terraform or CloudFormation

Working with APIs

Job description

You will be working as part of a cross functional platform team to deliver infrastructure, platform and database services for the Sports ticketing product(s) in our international markets. You will consult on and help to implement solutions as part of a Product Delivery team, enabling teams to deliver software faster by creation of tooling and automation, providing operational support for a range of products, including the delivery of ticketing and associated solutions for major tournaments and high-profile sports clubs and events. Participate in an out of hours on call rotation, usually one week every month (emergencies only, paid on top).

Responsibilities

• Support the current and future database platform(s).
• Maintain existing backup, HA and DR solutions and processes.
• Assist with database architecture planning and implementation.
• Build and maintain CI / CD Database pipelines.
• Support the implementation and ongoing maintenance of SQL Server Agent jobs and scheduled tasks.
• Maintain, improve and expand existing automation processes.
• Support the current Windows & Linux platform.
• Collaborate with product engineering to bring new components and features to production.
• Experience working directly with cross-functional teams, resolving data or database related issues.
• Automate tasks, deployments, tests and create infrastructure as code.
• Design and implement resilient, highly available systems.
• Plan, organize and communicate project status.
• Continuously improve systems, security and drive new standards meeting PCI requirements.
• Support production database issues and assist in investigation at every level of the technology stack.
• Infrastructure auditing and maintaining a backlog of improvements.

Qualifications & Experience

• Experience troubleshooting logical and physical performance bottlenecks on MSSQL.
• Good knowledge of configuring Microsoft SQL Server (2012 to 2019).
• Good understanding of T-SQL and Query Profiler.
• Knowledge of other RDBMS would be advantageous (MySQL, Postgres etc).
• Experience designing, implementing and supporting always-available, cross-datacentre OLTP database environments.
• Experience using SQL Server monitoring tools.
• Good knowledge of public cloud (AWS).
• Good knowledge of configuration management (Ansible, Chef, Octopus…).
• Good knowledge of configuring Windows Server.
• Good experience with Network Storage (NetApp, Amazon S3).
• Good virtualization experience (Hyper-V, XEN, VMware).
• Experience with provisioning using Terraform or CloudFormation.
• Good knowledge of working with APIs.

Behaviours & Language

• Has advanced troubleshooting techniques and resolves problems as they occur.
• Strong problem solving and analytical skills, frequently identifies enhancements.
• Demonstrates good judgment in selecting methods and techniques for obtaining solutions.
• Actively participates in overall solution and architectural design of the system.
• Pro-actively reviews performance, security and quality data to ensure accuracy and identify issues.
• Is open minded and actively seeks opportunities to try out new ideas and situations.
• Imports good ideas from similar situations experienced within their team or other teams across Technology.
• Ensures all work is performed to high standards.
• Excellent written and verbal English communication skills.
• Experience working in a remote environment.

Company & Equal Opportunity

Ticketmaster Sport is part of Live Nation Entertainment, the world’s leading live entertainment company. Our work is guided by our values: Reliability, Teamwork, Integrity, Belonging. We are committed to equal opportunities and an inclusive environment where everyone can be their authentic selves.