MySQL Database Administrator

MySQL Database Administrator Job Description Template

Our company is looking for a MySQL Database Administrator to join our team.

Responsibilities:

  • Provide Maintenance and Support for Client Reporting Solution;
  • Maintain database design/release documentation;
  • Work with Product teams to enhance the Data warehouse and client reporting solution;
  • Profile server resource usage, optimize and tweak as necessary;
  • Troubleshoot and resolve production database issues;
  • Ensure performance, security, and availability of databases;
  • Work closely with Engineering and DBA Team to design and implement optimal solutions;
  • Liaising with database programmers and IT project managers;
  • Protecting database from threats and unauthorized access;
  • Ensuring proper back up of database is adequate and able to be recovered in the event of memory loss;
  • Recommending changes and improvements for database protection;
  • Creating stored procedures for API’s;
  • Designing databases to reflect the need of front-end and back-end users;
  • Maintaining an awareness of trends and developments in database administration;
  • Monitoring systems performance and identifying problems that may arise.

Requirements:

  • Experience with data modeling in relational databases and writing complex SQL queries;
  • Familiarity with monitoring tools and how to apply to DB environment;
  • ETL / data migration experience with large data sets;
  • Bachelor’s degree in computer science or related IT field preferred;
  • Unix shell scripting and the ability to automate routine tasks;
  • Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM;
  • Knowledge of de-facto standards and best practices in MySQL;
  • Proficient in writing and optimizing SQL statements;
  • Experience with replication configuration in MySQL;
  • Must be ready to support environments remotely while on on-call;
  • Ability to plan resource requirements from high level specifications;
  • Experience with ETL tools and data warehouse concepts is a plus (Talend Preferred);
  • Experience with Percona for MySQL Server;
  • Experience with MySQL Backup tools and Monitoring tools;
  • Experience with Reporting/Visualization tools is a plus (Tableau preferred).