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)

CLOSED - MySQL Database Engineer (downtown Boulder)

This is an entry- to mid-level position.

This is a contract-to-hire position.

Role and Responsibilities:

The MySQL Database Engineer is primarily responsible for developing database applications on a Linux environment. This individual will participate in all activities related to database administration in a production, QA and development environments.

Work with technical and business staff for requirements

Conduct high level and detailed design based on requirements

Develop database code (SQL, MySQL stored routine and shell scripting)

Perform unit test and work with QA for integration test

Provide help and guidelines to application developers and business staff on database applications

Participate in database maintenance work (database health monitoring, backup and restore, table and index maintenance, trouble shooting and recovery)


Preferred Qualifications:

Highly self-motivated and responsible at work

A good understanding of SDLC

Previous experience in PHP, Java, C#, and C++ is a big plus

In depth understanding of relational databases and data warehousing, including logical and physical models, data integrity and referential integrity, database transaction, isolation levels and locking, database I/O, backup and restore, security

Expertise in database development, especially in MySQL stored routines (stored procedures, functions and triggers) and experience in other RDBMS (DB2, SQL Server, Oracle) development

Experience in performance tuning (SQL optimization, indexing optimization, storage engine optimization and schema optimization)

Competence in trouble shooting and debugging (database locking, unexpected result sets and mismatched data in tables, slow queries and so on)

Please send resume to jobs [at] createksolutions [dot] com