For information please e-mail your resume to  recruiting@crossview.com

 

Job Title: MySQL Database Administrator

Employment Type:  Fulltime

Experience Required: 3 years +

MySQL Database Administrator Role:

As a MySQL DBA this position will be responsible to interact with both the Development team as well as the Managed Services team to ensure the database and applications are functiioning correctly.  The Administrator will be responsible for tuning, archiving logs, performing backups, etc.


Responsibilities:
•    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.
•    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.
•    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 back-up, restoration and upgrades of database servers.
•    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.

Requirements:

•    Expert in SQL (including MySQL-specific use)
•    Experience in DB backup, recovery, and optimization techniques
•    Experience with high volume MySQL database administration
•    Experience in administration of InnoDB and MyISAM table types
•    Troubleshooting and problem resolution skills with MySQL
•    Strong communication skills for interaction with other teams and departments



Education and/or Experience
Bachelor's degree (B. A.) from four-year college or university.

Location / Travel Requirement
Santa Clara, CA or Toronto.
This position offers competitive salary and benefits.