Title: MySQL DBA
Location: Elk Grove, CA
Duration: 6-9 months
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
Education