MySQL DBA

Job Summary:

THE JOB:

Join our database team and become an essential member of a team responsible for the largest

ticketing system in the world. We are currently working on creating a set of next generation

database tools to create, manage and operate various databases from AWS and then migrate our cloud databases to AWS. We use various RDBMS and NoSQL database technologies. We support multiple database platforms, running on both private and public cloud infrastructure, while powering the world's largest ticketing system and serving 170 million customers.

YOUR TASKS

• Continuously improve the reliability and performance of existing open source database platforms (including but not limited to MySQL), both cloud and on-premises solutions.

• Adopt self-service tools to make it easier to use data store services to help the technical development team (or developer) succeed.

• Provide appropriate support to users of database systems and database code deployments.

• Plan the growth and manage the capacity and life cycle of open source database platforms currently in production.

• Provide database consulting to collaborating engineering teams (verifying database changes, database architecture solution, benchmark testing, collaborating on proof of concept, performance tuning, troubleshooting, etc. .).

• Troubleshoot database issues in production and investigate external services or other levels of the architecture to analyze root causes.

• Strategize on building proactive monitoring and alerting to pre-empt outages

• Participate in the OnCall rotation, including L1 OnCall for the overall enterprise database stacks, and provide support during scheduled ticketing OnSale hours

KNOWLEDGE (or SKILLS/TECHNICAL SKILLS)

• Knowledge administering and managing OpenSource, MySQL, MariaDB, AWS Aurora, or Percona.

• Knowledge building and maintaining mission-critical database production systems.

• Knowledge and experience in designing and maintaining MySQL databases.

• Knowledge analyzing issues from the application tier to database.

• Experience working directly with cross-functional teams, resolving data or/and database related issues.

• Working knowledge of at least one scripting language (Shell, Python).

• Knowledge of Amazon Web Services (Aurora, RDS, DynamoDB, DMS, Lambda, EC2, EBS, S3, IAM, etc.)

• Knowledge of configuration management systems (e.g. Ansible, Terraform, Chef , Puppet)

• Knowledge and experience with Percona platforms, Xtrabackup and Percona Toolkit.

• Systems engineering experience, including Linux performance, memory management, I/O tuning, configuration, security, networking and troubleshooting

YOURSELF (CAPACITIES/BEHAVIORAL SKILLS)

• Exceptional oral and written communication skills in English.

• Experience working in a remote environment.

• Natural willingness to learn new technologies, participate in proofs of concept and provide the best data storage solutions to meet business needs.

• Willingness to regularly document acquired knowledge or processes and share them within the team, so that others can also contribute, freeing you up to work on other projects.

• Proficiency in Linux and Unix Shell systems.

• Ability to work independently

• Understand and willing to adopt SDLC and Agile best practices.