Senior Database Engineer

Job Summary

Title: Senior Database Engineer – Sports Platform Engineering Services

Location: Athens, GR (Flexible with international travel)

Division: Ticketmaster International

Line Manager: Director – Sports Platform Engineering Services

Contract Terms: Permanent Fulltime

THE TEAM

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. partnering with product and software engineering teams to ensure alignment on achieving business goals for the international Sports product suite.

THE JOB

Ticketmaster Sport is part of Live Nation Entertainment which is the world’s leading live entertainment company comprised of global market leaders: Ticketmaster, Live Nation Concerts, LN Media and Artist Nation Management.

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.

Because our business is online 24/7, you will be required to work out of hours and provide on-call duty on a rota basis.

What You Will Be Doing

• Support the current and future database platform(s).
• Maintaining existing backup, HA and DR solutions and processes.
• Assisting with database architecture planning and implementation.
• Building and maintaining CI/CD Database pipelines.
• Supporting the implementation and ongoing maintenance of SQL Server Agent jobs and scheduled tasks.
• Maintaining, improving and expanding our 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/and database related issues.
• Automate tasks, deployments, tests. creating 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 (looking at current system gaps and maintain a backlog of improvements).

WHAT YOU NEED TO KNOW (or TECHNICAL SKILLS)

• Experience of 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 any 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 usage of public cloud (AWS).
• Good scripting (PowerShell, Bash, Python…).
• 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).
• Good use or knowledge of provisioning with Terraform or CloudFormation.
• Good knowledge of working with APIs.

You (behavioural Skills)

• 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 various sources of 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.
• Have excellent written and verbal English communication skills.
• Have experience working in a remote environment