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
Additional Information
Education
Skills Required
- Strong proficiency in MySQL database management
- Experience with recent versions of MySQL (5.6+)
- Understanding of MySQL storage engines, particularly InnoDB
- Experience with replication configuration in MySQL
- Knowledge of de-facto standards and best practices in MySQL
- Proficient in writing and optimizing SQL statements
- Ability to plan resource requirements from high level specifications
- Familiarity with MongoDB
- Using scripting languages for ETL (PHP, etc)
- Knowledge of MySQL limitations and workarounds versus other RDBMS
What We Do
Founded in 2005, WinMax Systems Corporation is a professional services firm specializing in IT recruiting, technology talent acquisition, and management consulting. They provide value-driven talent and managed services, offering expertise in technology and business consulting across various verticals, including program, project, and financial management. They focus on connecting top tech talent with innovative organizations to maximize efficiency and complete projects on time and budget.
