Learfield

  • Database Administrator

    Req No.
    2018-2294
    Location Name
    Paciolan
    Location
    US-CA-Irvine
    Category
    Product Engineering
    Type
    Full-Time
  • Overview

    Paciolan is the #1 primary ticketing company in college athletics, and the #2 largest primary ticketing provider in the US including performing arts, arenas, and professional sports. As a leader in ticketing, fundraising, marketing, analytics, and technology solutions, we power more than 500 live entertainment organizations, selling over 120 million tickets a year.

    While we are the market leader in many areas, we will never act too big or move too slow as a company. At Paciolan, we come to work ready to innovate and succeed, and we always have fun doing it. You may not recognize our name, because we white-label our consumer channels, but we create great products at scale…not just once a year Black Friday, but every day our events go on sale!

    As we continue to grow, we need an outstanding DevOps Engineer to travel on our journey together. Our DevOps Engineers influence the technology growth that impacts millions of customers across the entertainment space. Opportunities abound to grow our products - and grow your career!

    Responsibilities

    What you’ll do

    • Install, configure and monitor MySQL and Cassandra servers
    • Configure, monitor, and troubleshoot replication
    • Analyze query performance and provide solutions
    • Support development and production environments
    • Review of any code that will be deployed to or access data from the Data Platform.
    • Work with DevOps to ensure our non-Production environments are refreshed and consistent with Production.
    • Define and implement backup strategies to keep us within our data retention requirements, to diagnose and resolve as needed.
    • Configure and troubleshoot existing ansible automation
    • Evaluate new DBMS and related technologies
    • Provide on-call support to support heavy usage, high traffic databases.
    • Production DBA assistance as deemed necessary, including but not limited to on-call support rotation and maintenance windows. 

    Qualifications

    What to bring

    • 5+ years RDBMS DBA experience. At least 3 years of supporting MySQL in live and development environments. Experience with Percona XtraDB is a big plus.
    • Minimum of 1 year experience working as a Cassandra DBA in a high throughput, web-scale environment.
    • Knowledge of Cassandra best practices and data modeling.
    • Knowledge of automation and its tools like Ansible, Git, and Kubernetes.
    • Demonstrable experience in physical and logical DB design
    • Experience with managing Linux system and able to write/maintain Shell/Python scripts.
    •  

    Knowledge, Skill and Abilities 

    • Database architectures
    • MySQL/MariaDB (preferred)
    • NoSQL Cassandra (preferred)
    • Database optimization techniques
    • Execution plan analysis
    • Index maintenance and tuning
    • Applied knowledge of memory and physical storage with RDBMS and NoSQL
    • Database Maintenance Tasks
    • Backup & Restore
    • Storage Management
    • Patch Management
    • HA/DR functionality, specifically Always On / Mirroring

    Attention Getters

    • Analytical Skills: DBAs monitor a lot of information and need to be able to think of solutions as problems arise.
    • Communication Skills: DBAs are part of a team, working with other DBAs, data analysts and management and need to be effective communicators.
    • Attention to Detail: Databases are complex, and a minute error can cause huge problems.
    • Logical Thinking: DBAs take code and data and turn it into logical patterns, so that it can be analyzed.
    • Problem-Solving Skills: As problems come up, DBAs must come up with solutions quickly.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.