MySQL DBA
We're looking for an experienced MySQL DBA to join our client's team on a full-time, permanent basis.
Our client is undergoing major growth. They are an international company that is huge in Europe and other markets and will be re-launching soon. This is a great opportunity to join a tightly knit team. The compensation packages are extremely attractive. Additionally, there is great opportunity for international travel if you desire.
Duties
-Work with Director of Database Infrastructure to maintain/improve and support a high traffic, fine-tuned, scalable and reliable database environment on a day-to-day basis.
-Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues.
-Optimize and tune contentions within the database environment
-Create logging environment(s) to log usage statistics about the environment
-Regularly monitor and periodically conduct random tests of restoration from backups generated within the environment
-Participate in large storage engine migrations
-Compile/patch/install MySQL
-Work closely with operations, development and product teams to ensure smooth deployment of new iterations and availability of database services.
-Create scripts for monitoring key server utilization indicators using DTrace/Perl etc.
-Migrate production systems from MySQL 4.x to 5.x
Relevant Skills/Experience:
- BS in Computer Science or equivalent
- Minimum 3 years experience with Linux, Unix or Solaris
- Minimum 2 years of MySQL experience in production environment
- Experience with Partitioned architecture(s) and data shards
- Production experience with tuning and administering moderate-large scale mission critical MySQL/InnoDB environments.
- Experience with optimizing InnoDB for both OLTP and DW queries
- Experience with estimating database capacity planning
- Passion for hunting bottlenecks and optimizing IO operations
- Solid experience with both SQL and MySQL internals
- Experience with performance analysis tools for MySQL
- In-depth experience with storage engines
- Experience with backup methodologies for MySQL
- Document best practices and routine procedures
- In-depth knowledge of MySQL tuning parameters and performance strategies
- Experience with MySQL replication
- Excellent communication and problem solving skills with attention to detail without losing the big picture
- Must be a team player as well as able to tackle projects on your own upon assignment.
- Able to handle high stress situations without losing calm and focus.
- Comfortable with carrying a pager and participating in "on call" assignments with other members of the operations team and willing to provide 24/7 escalated on-call support
- Experience with creating and deploying scripts to automate tasks wherever possible.
- Experience with benchmarking methodologies / tools / best practices
- Experience in supporting MySQL for production / development and QA environment(s).
Desired Skills/Experience:
- Experience with storage arrays / 3Par
- Experience with master/master replication
- Experience with Hibernate
- Alumni of MySQL Conference
- Active MySQL community member
- MySQL Proxy experience
- Experience with disaster recovery
Please send resumes to:
Carl Grover
To Apply to this job go to http://www.GadBall.com or click here