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).