Database Administrator

At Mercatus, we measure our success by the passionate loyalty that we help retailers build with their customers. Our leading-edge designs, technology, and underlying platform integrate into retail intelligence and other systems to help retailers build more profitable relationships with customers through innovative approaches to shopping.

Our continued growth has created exciting opportunities for entrepreneurial spirited talent. If you are a passionate and self-motivated individual with a track record of success then you may have what it takes to join the Mercatus team at this exciting time in our evolution.

The Role: Database Administrator

We are currently looking to add the first dedicated Database Administrator to our development team. This full-time position based in our downtown Toronto office will have primarily responsibility for designing, managing, and maintaining large-scale highly transactional databases in MySQL. Reporting to the Development Manager, this person will have the opportunity to be involved in all stages of product development. You will contribute ideas and take an active role in product planning, act as key database expert on application design and ensure optimal performance, stability and security of our database environment in both development and production environments.

Responsibilities:

• Work with software engineers to design, implement, extend and improve data schemas for large-scale multi-tier applications.
• Migrate existing MySQL database structure to new design to improve performance and maintainability
• Evangelize database access, maintenance, and development best practice to team members
• Work closely with QA to build and refresh test database and with operations to promote database changes from development to production.

Required Experience, Education and Skills:

• 5+ years experience in administration of enterprise databases in development and production environments
• Database & application design and development experience with high-volume transactional applications
• Expert level skills in MySQL on Unix (RedHat Linux is a plus)
• Expert knowledge of logical and physical data modeling
• Experience with ETL
• Proven ability to create, optimize and debug SQL statements/stored procedures
• Experience with performance tuning, load balancing, replication, backups and other database maintenance tasks
• Demonstrated knowledge of data security and governance practices
• Thorough understanding of Web 2.0 technologies
• Ability to work in a small team and build consensus with colleagues