MySQL DBA

Description

Qualifications Responsibilities/skills/experience requirements Research and explore other database alternatives (mysql cluster/max, etc.).Make sure that tables are optimized and analyzed to ensure the best performance possible.Keep the developers up to speed on the changes that occur with each release of the database.Help communicate with the developers the impact changes have on the database. ie adding columns and indexes. How/when should they be done to have the least affect on the Web sites.Assist in the design of separate read/write servers to help in performance.Create/Maintain/Test mySQL master/slave replication both on the ecash side and the Web sites.Research and deploy fine tuning methods to increase the performance of the server without having to spend more on hardware.Assist in creating a new set of database users to aide in better logging of errors along with better overall security.Assist with backups of data.Create a test routine to ensure backups are working in the result of a failure.Aid in database creation/analysis.Assist in create adhoc reports to keep the developers focused on new business development and maintenance.Work with hosting and development groups to create the process to gracefully failover to our disaster recovery site.Install, configure, manage and maintain multiple MySQL servers and databases.Perform appropriate backup, restoration and upgrades of database servers.Perform database health monitoring and diagnostics.Work with development teams for performance tuning and optimization, query optimization, index tuning, caching and buffer tuning.Work with development teams to introduce and control structural changes to databases.Ability to work in a fastpaced environmentAbility to work well with both business and technical partnersCreative approach to problem solving, innovation and issue resolution.Superior interpersonal skills and the ability to collaborate actively and proactively with others in a crossfunctional team.Selfmotivated and selfmanaged with a high degree of analytical ability and intellectual curiosity.Able to set and meet specific external and internal deadlines, and follow through with quality work products.