House of Blues Database Architect - Software in Chantilly, Virginia
Who we are.We’re fans who help fans everywhere get in to the live events they love. A proud division of Live Nation Entertainment, Ticketmaster has changed the way the world connects with their favorite artists, teams, and shows, and we continue to shape innovation every day. We’re not just selling tickets (though we do that better than anyone else), we’re enriching lives one amazing experience at a time. And we think that’s pretty amazing. If you’re passionate about the magic of 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.
Why you should work with us.Our biggest investment is in people like you. We offer comprehensive health benefits and 401k matching, student loan assistance, plus career-boosting opportunities like tuition reimbursement and targeted development sessions to help you thrive. At Ticketmaster you can expect the fast-paced excitement of a startup with the rock-solid support from an industry leader – with plenty of ticket perks on the side.
See what it’s like working at Ticketmaster.
As our Database expert, you will be part of a large DevOps team working on modernizing an enterprise-scale system, actively collaborating with Product Owners, Enterprise Architects, and development team members to create high-performance, scalable database solutions. You will be a key player in developing the vision and direction for large or complex initiatives, evaluating technologies and/or alternate approaches, working with stakeholders to estimate and design approaches, and support program-level trade-offs on priorities.
The position also requires someone with great collaboration skills with a strong technical background who can work and communicate effectively with technical and nontechnical stakeholders to continually ensure the product is of the highest quality. The DB architect will also be able to work easily between legacy and next generation applications, providing technical guidance to all teams and peripheral products in an Agile environment.
In this role, you will be responsible for the performance, tuning, scripting, and scalability for all the production databases supporting our APIs and production applications:
Design and develop database objects, tables, stored procedures, views and triggers
Provide performance optimization through query and stored procedure tuning and code/schema (indexes) refinements
Independently analyze, solve, and correct issues in real time, providing problem resolution. Diagnose system failures to isolate the source of problems between equipment, software, and applications.
Take part in maintenance and bug fixing.
Assist with database upgrades and database backup tasks.
Evaluate new database technologies and tools to meet growing challenges.
Support business teams with SQL queries for analysis and reporting
Minimum of ten (10) years of experience in development working with large scale relational database clusters (Sybase, Oracle, SQL Server, or DB2)
Experience with DB mirroring, copy node, high availability, disaster recovery
Experience coding complex stored procedures
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
Strong knowledge of database design principles
Must know SQL inside and out.
Strong attention to detail with an ability to follow-up and follow-through on project actions and tasks
Ability to produce clean, well-documented, efficient, and standards-compliant code with an eye towards performance optimization and stability
Knowledge of Agile development methodology and concepts.
Proven analytical problem solving and debugging skills
Experience with Service Oriented Architecture (SOA), web services, enterprise data management, information security, applications development, and cloud-based architectures.
Bachelor’s degree in Computer Science or equivalent.
Equal Employment OpportunityTicketmaster strongly supports equal employment opportunity for all applicants regardless of race, color, religion, sex, gender identity, pregnancy, national origin, ancestry, citizenship, age, marital status, physical disability, mental disability, medical condition, sexual orientation, genetic information, or any other characteristic protected by state or federal law.
Hiring PracticesThe preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.
Ticketmaster recruitment policies are designed to place the most highly qualified persons available in a timely and efficient manner. Ticketmaster may pursue all avenues available, including promotion from within, employee referrals, outside advertising, employment agencies, internet recruiting, job fairs, college recruiting and search firms.
Named us as one of the Top 40 North American companies in attracting and keeping top talent by LinkedIn, Live Nation is the global leader in live entertainment and ticketing, and we offer a world of opportunity. Our Ticketmaster team doesn't just embrace new technology, we develop ground-breaking software and applications to support our world-leading ticketing platform. Our mix of legendary and brand new venues and restaurants, including the House of Blues, offer an array of hospitality careers. And our unparalleled roster of artists are supported by diverse professionals in all facets of finance, marketing and other corporate operations.
Generous vacation, healthcare and retirement benefits are just the foundation of supporting our full-time, global workforce of more than 10,000. We offer continuing professional development in addition to tuition reimbursement. We also provide paid time off to bond with a new child (plus a bonus to help with expenses); paid time off to care for a sick child and to volunteer for causes that are important to you. Plus, working for the world's largest live event and ticketing company means you'll have access to concerts, festivals, sports games and other events through our exclusive employee ticket concierge.
There is no bigger stage for your career. See what your future looks like at Live Nation Entertainment.