Database Architect - Software

Live Nation, INC Chantilly , VA 22022

Posted 4 weeks ago

Job Summary:

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.

The Role:

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

Requirements:

  • 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

Desired:

  • Experience with Service Oriented Architecture (SOA), web services, enterprise data management, information security, applications development, and cloud-based architectures.

  • Transact-SQL experience.

  • Bachelor's degree in Computer Science or equivalent.

Equal Employment Opportunity

Ticketmaster 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 Practices

The 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.


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Software Architect

Engineering Consulting Services, Ltd.

Posted 3 weeks ago

VIEW JOBS 10/26/2018 12:00:00 AM 2019-01-24T00:00 STRENGTH OF CHARACTER Why ECS? We have grit. What does that mean for you? That one descriptive word defines our company culture. At ECS, GRIT is made up of four characteristics: guts, resilience, initiative and tenacity. Our boots are made for working. Click here to get an idea of what we're all about. PERSEVERANCE WITH PASSION We focus on developing the people, systems and expertise that allow us to be the consulting firm of choice. Our footprint spans the nation and countless sectors, making us flexible and giving you options. Our passion is to provide high quality services and innovative approaches to our clients. We are looking for problem solvers. Do you have your boots ready? DRIVE AND DETERMINATION As a Software Architect, you provide a lead role as the senior technical expert defining and maintaining the architectural frameworks, processes, and standards related to systems, business, and data architecture. You are comfortable interacting with the Business, IT Development Operations, Quality Assurance, and IT Operation team members. Communicating effectively and customer service are just a few of the skills you have that make you a successful team player. You know how to set the bar high and not only achieve that goal yourself – but bring others along with you. You get the "big" picture and want to contribute accordingly – and that's why you'll have all the opportunity for career growth within our company you'll want. For highlights of others who have taken their amazing skills and grown their careers with ECS, click here. RESPONSIBILITIES You will be part of a dynamic, growing and energized team – and your role is key to the success of ECS. While your job duties may fluctuate day to day, here are some areas we expect to see you proficient in: * Serving as the senior technical expert to define and maintain the architectural frameworks, processes, and standards and guidelines related to systems, business, or data architecture * Defining core and support technology, data entities, business functions, and/or subject areas that transcend organizational and functional boundaries * Providing technical and architectural subject matter expertise to the various development teams, including communicating architectural decisions and mentoring other technical staff around the various development technologies and decisions * Developing, gaining consensus for, and maintaining and 3-year technology roadmap with consideration of business requirements and technology life cycles and including transition state architectures * Identifying core common data shared across the enterprise and participating in enterprise wide efforts to reach common understanding of those data * Serving as the senior technical expert to team(s) concerned with development, networking, and/or project management to coordinate changes and support enterprise technology initiatives * Overseeing multiple projects to preserve the architectural vision and protect stakeholder interests as well as to meet operation and financial reporting requirements * Conferring with business units and application development staff to understand both the business and technical requirements and to define architectural constraints * Eliciting, defining, and documenting requirements for key priority features as determined by the governing committees and matching the most appropriate technologies and approaches to meet the design requirements * Developing project scope, timeline, tasks, milestones, and development estimates working closely with the product and delivery management teams QUALIFICATIONS If you can accomplish the above, your boots are probably ready for walking right into this role. Realistically though, you need the following to be considered: * BS degree in Computer Science, Computer Engineering, or a related technical discipline * 5+ years of experience in .NET technologies, software system development process, SQL relational database, and writing SQL queries * 5+ years of analyzing system requirements, design, and implementation * 5+ years as a technical leader of software engineering or computer professionals * 5+ years of experience with Visual Studio, TFS, IIS, Windows Server * 5+ years building scripts and continuous integration, using Gitlab and/or Team Foundation Server (TFS) * 9+ years developing systems architecture, designing and developing web-based systems in a Microsoft environment using .NET technologies * 9+ years of experience in data modeling, data warehousing, distributed processing, utilization of tolls for data modeling and logical and physical database design, software integration, and/or security issues and techniques PEOPLE ARE OUR FOUNDATION We love our employees and we show this through providing some great benefits. Click here to see how we show our passion for our people. Engineering Consulting Services, Ltd. Chantilly VA

Database Architect - Software

Live Nation, INC