Title:
Senior MySQL Database Administrator

Job Summary:
Designs, analyzes, deploys, monitors, maintains and optimizes MySQL5 database servers.  Analyzes requirements and produces optimal database schema.  Maintains complex replication setup and manages data partitioning across multiple clusters/data centers.  Refactors databases as needed to accommodate functionality changes.  Works with application development to successfully implement new or modify existing features.

Mission/Vision of the Department
Community systems are the natural evolution of the Internet.  The Internet removed all physical barriers to communication.  The job of the Technology Department is to build systems that facilitate communication and create systems that will democratize and provide access to information as well as a platform for everyone to have a voice.

Key Functions:
• Install, configure, manage and maintain multiple MySQL servers and databases using InnoDB & MyISAM storage engines.
• Data model design and recommendations: optimize DB schema, normalization, denormalization, query analysis and index optimization; database refactoring
• MySQL5 replication: multi-master, scripted role change (promotion, demotion, change master), utility scripts, mysql5 clustering; ability to work at binlog level
• Business Resumption Processes: automated failover and recovery
• Performance optimization at schema level, service level, OS level, hardware level
• Perform appropriate back-up, restoration and upgrades of database servers.
• Create processes to ensure the data quality of the information by identifying potential data errors.
• Capacity planning, health monitoring and diagnostics
• Act as lead on database systems
• Provide assistance to developers, recommending best practices
• Creation and development of ad hoc and customized reports

Supervisory Responsibilities:
No direct reports, must be able to work effectively with all levels within the company

Physical Demands:
• Long hours sitting and typing at a computer
• May require long hours during key development periods

Reasoning ability:
• Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram or schedule form.
• Ability to quickly comprehend new technologies and techniques and apply them. 

Language skills:
• Ability to read, analyze and interpret general business periodicals, professional journals, technical procedures or governmental regulations.
• Ability to write reports, business correspondence, and procedure manuals.
• Ability to effectively present information and respond to questions from groups or manager, clients, customers and the general public.

Mathematical Skills:
Ability to apply mathematic skills for analysis of data, programming logic and implement mathematic functions as needed.

Knowledge, Skills and Abilities/Equipment used:
• UNIX, Linux systems
• MySQL5
• PHP, Perl, C, monitoring & utility scripts
• Tuning and Optimization for high transaction, high performance
• Disaster Recovery
• Ability to work concurrently on multiple projects
• Ability and willingness to support a 24/7 Production Environment.

Education and experience/certificates, licenses, registrations required:
• Demonstrated experience with relational database design, performance tuning and capacity planning
• Expert with high-traffic, large (100M+ rows) databases in production environments using MySQL replication
• Expert with InnoDB storage engine, tools, mixed InnoDB/MyISAM
• Experience with open source/Linux/UNIX development and production
environments is key
• Troubleshooting and problem resolution skills with MySQL
• Experience in DB backup, recovery, and optimization techniques
• Min. 5 years experience as a DBA or equivalent