Senior SQL Server DBA

Posted Date:1/4/2018 4:29:38 PM
Job Type: Full Time
Req #: JR-04480
Location: Rolling Meadows, IL
Job Category:Engineering

Job Summary:

Senior SQL Server DBA

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 our people. We offer comprehensive health benefits and 401k matching, student loan assistance, plus career-boosting opportunities like tuition reimbursement and targeted development sessions to help all eligible employees thrive. At Ticketmaster, 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:

We are seeking a Sr Microsoft/ SQL Server DBA who has a passion for databases in a fast-paced environment.  The job responsibilities include database upgrades, database administration of backups, HA, security, DR, installations of databases and tools, transactional replication maintenance, system monitoring, and performance tuning.  The candidate should also be able to handle database deployments with scripting tools and automated methods.  The candidate should have experience working in virtual environments. Experience in the cloud a plus.  Experience with MySQL or AWS Aurora databases a plus.  Excellent communication and team building skills required.

What a qualified candidate should possess:

  • Database administration in a virtual environment
  • Database upgrade experience
  • Performance investigation at the database, virtual, and SAN level
  • Experience with Microsoft SQL Server 2008, 2014, 2016
  • Transactional replication support
  • Knowledge of sql auditing requirements
  • Disaster Recovery
  • Powershell scripting
  • Windows batch scripting
  • Backup and restore procedures and monitoring
  • Experience using data sync database tools such as Idera or Red Gate
  • Experience monitoring systems to ensure uptime and identify issues proactively
  • Excellent communication skills.  This position interfaces with development, QA, other DBAs, and operational staff.   Must be able to understand requirements and communicate solutions that help meet the goals of projects or issues
  • This position requires after-hours on-call duties on a rotating basis. 
  • Nice to have:

  • Experience in AWS or Azure environments
  • Experience with MySQL/AWS Aurora DB

Equal Employment Opportunity
Ticketmaster strongly supports equal employment opportunity for all applicants regardless of age (40 and over), ancestry, color, religious creed (including religious dress and grooming practices), family and medical care leave or the denial of family and medical care leave, mental or physical disability (including HIV and AIDS), marital status, domestic partner status, medical condition (including cancer and genetic characteristics), genetic information, military and veteran status, political affiliation, national origin (including language use restrictions), citizenship, race, sex (including pregnancy, childbirth, breastfeeding and medical conditions related to pregnancy, childbirth or breastfeeding), gender, gender identity, and gender expression, sexual orientation, or any other basis protected by applicable federal, state or local law, rule, ordinance or regulation. 

We will consider qualified applicants with criminal histories in a manner consistent with the requirements of the Los Angeles Fair Chance Ordinance, for applicants in Los Angeles, California, and consistent with applicable laws in other areas.

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.

Link for schema