MySQL DBA

Responsibilities:

Work with operations team to enhance the systems performance;

Troubleshoot and resolve production database issues;

Profile server resource usage, optimize and tweak as necessary;

Ensure performance, security, and availability of databases;

Implement the security policy and audit requirements

Coordinating with database programmers and IT project managers;

Protecting database from threats and unauthorized access;

Recommending changes and improvements for database protection;

Work closely with the backup admin to ensure healthy backups are available at all times;

Execute periodic restoration testing and submit related reports

Review the database architecture

Monitoring systems performance and identifying problems that may arise proactively

Requirements:

Bachelors degree in computer science or related IT field preferred;

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;

Unix shell scripting and the ability to automate routine tasks;

Understanding of MySQLs underlying storage engines, such as InnoDB;

Knowledge of standards and best practices in MySQL;

Proficient in writing and optimizing SQL statements;

Experience with replication configuration in MySQL;

Experience with routers and database clusters

Must be ready to support environments remotely while on-call;

Ability to plan resource requirements from high level specifications;

Experience with ETL tools and data warehouse concepts is a plus

Experience with MySQL Backup tools and Monitoring tools;

Experience with Reporting/Visualization tools