CLOSED - MySQL Database Architect - Boulder, CO

This is a Senior-level contract-to-hire position in Boulder, CO (direct hire is also a possibility)

Must be able to perform the following responsibilities:

1) Database development (70%)

• new development in stored procedure and possibly shell scripting (requirements, design, implementation)
• bug fix of stored procedures
• Performance enhancement (indexing, query tuning)
• support the development team for all kinds of database related issues
• Ongoing work to identify legacy embedded SQL calls in application code and convert them to stored procedures.
• Write stored procedures to support all required internal data analysis needs.
• Openx database development
• Participate in implementation of schema re-designs as necessary.
• Maintenance and possibly re-design of ETL process
• other database development responsibilities


2) Database administration (20%)
• health monitoring of production databases
• database server tuning
• database maintenance (i.e. security, table/index maintenance, diagnostics of database issues)
• database backup and restore
• Database Upgrade
• release support and other DBA responsibilities


3) Assist in evaluation of new database technologies (10%)
• Use of schema-less “databases” (e.g. MongoDB or CouchDB) for highly scalable, fast access to certain aggregated profile type data.
• Open source data warehouse solutions (e.g. InfoBright and Jaspersoft, Calpont)
• \MySQL Cluster
• Sharding using dbShards
• Other MySQL storage engines (TokuDB from Tokutek, Falcon storage engine in MySQL 6.0)