Who are we looking for?

We are looking for an experienced MySQL database developer/administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances within our AWS cloud based platform. You will also be responsible for maintaining the database as our product suite grows, administrating upgrades, backups, provisioning of database instances and creating stored procedures for business/operational reports. You will also work in tandem with the other teams, preparing documentations and specifications as required.

What is the role and what are your responsibilities?

· Design/develop database schema

· Provision MySQL instances, both in clustered and non-clustered configurations

· Ensure performance, security, and availability of databases

· Prepare documentations and specifications

· Handle common database procedures, such as upgrade, backup, recovery, migration, etc.

· Profile server resource usage, optimize and tweak as necessary

· Collaborate with other team members and stakeholder.

What experience do I need?

· Strong proficiency in MySQL database management

· Experience with recent versions of MySQL

· Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM

· Experience with replication configuration in MySQL

· Knowledge of de-facto standards and best practices in MySQL

· Proficient in writing and optimizing SQL statements

· Knowledge of MySQL features, such as its event scheduler

· Ability to plan resource requirements from high level specifications

· Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc

What competencies do I need?

  • Detail oriented
  • Initiative
  • Motivation
  • Problem Solving
  • Teamwork