Home ›
MySQL DBA
Submitted by sukla on Fri, 2009-07-03 13:51
Additional skills:
• Strong attention to detail and willingness to take ownership for their domain
• Ability to diagnose and resolve a broad range of technical problems, including those not specifically attributed to the DB itself, in person, over the phone, and via email
• High degree of independence and exceptional work ethic
• Knowledge/experience in Linux, scripting, (Perl, ksh, etc.) and creating automated tools and custom handlers
• Strong teamwork, leadership and collaboration skills.
• Must be willing and able to provide 24 x 7 production support on a rotating basis
• Excellent verbal, technical writing and documentation skills are necessary for interaction with other teams and departments
PLEASE SEND RESUME TO: rita.hatzimimis@modis.com
Skills/Requirements:
3-5 years minimum experience with MySQL (multiple versions).
Candidate must have deep hands-on knowledge of MySQL internals, monitoring, tuning, setting up and administering databases
Demonstrated database design and SQL programming skills to perform troubleshooting and data manipulation tasks PLUSES:
Experience with multi-master clustering (HA) and MySQL replication, experience with cloud environments a plus.
Experience with performance tuning and optimization. (Query optimization, index tuning, caching and buffer tuning)
Experience with deployment and management of grid technologies a plus
Experience with other relational databases a plus
Team leadership or management a plus
Functions/Responsibilites:
Works as member of team of our team with primary responsibilities for designing, installing and maintaining MySQL for application and data warehousing.
Proactive maintenance and monitoring of all instances of the MySQL databases servers
Works with application development projects to evolve the database architecture and design
Participates in the creation of development, staging & production database instances, and the migration of those instances from one environment to another
Serves as the point of contact for advanced level troubleshooting issues, and performs hands-on systems administration as required
Provides tools, alerts, and monitoring capabilities for automating database operations
Analyzes and responds to performance and other maintenance issues
Tests and corrects errors and refines changes
Tunes the performance of all the staging and production database instances
Designs and performs, or automates, back-up and recovery processes with other support teams and ensures they are functioning correctly
Plans and executes tests of fault tolerance capabilities, including: backup/recovery; replication; cluster failover and disaster recovery
Maintain data standards and security, including adherence to the Data Protection Act, PCI, and/or other requirements as needed
Writes database related documentation, including data standards, procedures, and definitions for the data dictionary
Work closely with Systems, QA and Development teams on designs, SQL development and performance.
Provide after hours and weekend support as needed.
Hands-on background with backup, recovery and upgrade procedures
Extensive experience interpreting data models and developing database structures for scalable applications, specifically web driven structures, data profiling, meta data analysis, data modeling and relational schema design
Experience with design and maintenance of large-scale, multi-faceted environments
Location
Wake Forest
United States
Job Type:
Contract
Website:
http://www.modis.com/Jobs/Display.asp?JobId=9727503&JobsPerPage=100&StartWithJob=0&SortBy
0
Your rating: None