Senior Database Engineer

Social network you want to login/join with: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.Participate in an out of hours on call rotation, usually one week every month (emergencies only, paid on top)WHAT YOU WILL BE DOINGSupport 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 MSSQLGood 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 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 situationsImports 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 environmentLIFE AT TICKETMASTERWe are proud to be a part of Live Nation Entertainment, the world’s largest live entertainment company.Our vision at Ticketmaster is to connect people around the world to the live events they love. As the world’s largest ticket marketplace and the leading global provider of enterprise tools and services for the live entertainment business, we are uniquely positioned to successfully deliver on that vision.We do it all with an intense passion for Live and an inspiring and diverse culture driven by accessible leaders, attentive managers, and enthusiastic teams. If you’re passionate about live entertainment like we are, and you want to work at a company dedicated to helping millions of fans experience it, we want to hear from you.Our work is guided by our values:Reliability – We understand that fans and clients rely on us to power their live event experiences, and we rely on each other to make it happen.Teamwork – We believe individual achievement pales in comparison to the level of success that can be achieved by a teamIntegrity – We are committed to the highest moral and ethical standards on behalf of the countless partners and stakeholders we representBelonging – We are committed to building a culture in which all people can be their authentic selves, have an equal voice and opportunities to thriveEQUAL OPPORTUNITIESWe are passionate and committed to our people and go beyond the rhetoric of diversity and inclusion. You will be working in an inclusive environment and be encouraged to bring your whole self to work. We will do all that we can to help you successfully balance your work and homelife. As a growing business we will encourage you to develop your professional and personal aspirations, enjoy new experiences, and learn from the talented people you will be working with. It\’s talent that matters to us and we encourage applications from people irrespective of their gender, race, sexual orientation, religion, age, disability status or caring responsibilities. #J-18808-Ljbffr