MySQL DBA

WinMax Systems Corporation; Elk Grove (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

WinMax Systems Corporation in Elk Grove, California is seeking an experienced MySQL database administrator to ensure the performance, availability, and security of MySQL instances. You will provision MySQL environments from development to production and work directly with teams on optimizing query performance.

The ideal candidate will have strong proficiency in MySQL, knowledge of recent versions, and experience with database procedures. Responsibilities include database management and collaborating on optimization strategies.

Qualifications

• Strong proficiency in MySQL database management.
• Experience with recent versions of MySQL (5.6+).
• Understanding of MySQL’s underlying storage engines particularly InnoDB.

Responsibilities

• Provision MySQL instances for multiple environments.
• Ensure performance, security, and availability of databases.
• Handle database procedures like upgrade, backup, recovery.

Skills

MySQL database management

SQL statement optimization

MySQL replication configuration

Understanding of InnoDB

Scripting languages for ETL

Familiarity with MongoDB

Job description

We are looking for an experienced MySQL database administrator to directly ensure the performance, availability, and security of MySQL instances. You will also be responsible for managing version upgrades, backups, and provisioning of database instances. You will also work directly with our development teams to educate and partner on query performance optimization.

Responsibilities

• Provision MySQL instances for multiple environments from development to production.
• Ensure performance, security, and availability of databases.
• Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary.
• Partner with and educate developers on query optimization.
• Perform profiling of the database environment to spot bad queries and suggestions to improve query performance.
• Collaborate with other team members and stakeholders.

Skills and Qualifications

• Strong proficiency in MySQL database management.
• Experience with recent versions of MySQL (5.6+).
• Understanding of MySQL’s underlying storage engines particularly InnoDB.
• Experience with replication configuration in MySQL.
• Knowledge of defacto standards and best practices in MySQL.
• Proficient in writing and optimizing SQL statement.
• Ability to plan resource requirements from high level specifications.
• Familiarity with MongoDB a plus.
• Using scripting languages for ETL (PHP, etc).
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational database.