Great MySQL Cluster DBA Opportunity
Tuesday, November 25, 2008 11:47 AM
Justin Day from Spartan Resources has an opening for a MySQL Cluster DBA. Please contact him directly at
Position Title: Database Administrator (MYSQL)
Job Title: Database Administrator (MYSQL)
Salary: $80K - $100k/ Permanent
CMDBA: Certified MySQL Database Administrator (Required)
CMCDBA: Certified MySQL Cluster DBA (Preferred)
Shell or Perl scripting experience would be a great bonus.
Must be a Linux person
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following:
. Ensures the database environment is designed and managed to
meet business and IT demands for availability, performance and
. Ensures implementation of industry best practices in systems
. Serves as the point of contact for advanced level
troubleshooting issues, and performs hands-on systems
administration as required.
. Manages lower level database administrators.
. Involved in application development projects to evolve the
database architecture and design.
. Monitors database operations and replication.
. Analyzes and responds to performance and other maintenance
. Inventories and documents forms, reports, notices, etc.
. Participates in the creation of development, staging &
production database instances, and the migration of those
instances from one environment to another.
. Tests and corrects errors and refines changes.
. Tunes the performance of all the staging and production
. Performs back-up and recovery.
. Plans and executes disaster recovery.
. Performs complex query development.
. Performs complex replication troubleshooting
. Other duties that are within education and experience or the
incumbent may be assigned for the betterment of the company.
. Demonstrated exceptional database design and SQL programming
skills to perform data
. Troubleshooting and data manipulation tasks.
. Administering of InnoDB and MyISAM table types.
. Experience with MYSQL replication.
. Experience with multi-master clustering (HA).
. Experience with MYSQL performance tuning and optimization
(query optimization, index tuning, caching and buffer tuning).
. Experience with data profiling, meta data analysis, data
modeling and relational schema design.
. Ability to troubleshoot problems in person, over the phone,
or via email.
. Solid understanding and experience in disaster recovery,
planning and implementation.
. Experience with backup and recovery process.
. Knowledge/experience creating automated reports using Perl is
. Must have hands on experience in Linux and be a certified DBA
. Attention to detail.
. Ability to diagnose and resolve a broad range of technical
. Strong teamwork, leadership and collaboration skills.
. Strong communication skills are necessary for interaction
with other teams and departments.