DO NOT RESPOND TO THIS POSTING; TO APPLY PLEASE VISIT: https://home.eease.com/recruit/?id=381805”
The Company
Jigsaw (www.jigsaw.com) is quite simply unlike any other organization. We firmly established ourselves as one of the unique success stories of the Web 2.0 revolution. For the past several years Jigsaw has been leveraging user generated content to map the global business community. By doing so, we have created an online, collaborative business-contact marketplace where marketers, recruiters, and sales people can buy and trade third-party business contact information. Even the most world-weary VCs applaud the paradigm shifting vision at the heart of the Jigsaw story:
Its always a mind blower when some startup fundamentally changes the rules in any category that is assumed to be mature.
Jeff Nolan, SAP Ventures
This is a rare opportunity to join one of the most unique companies in Silicon Valley, where a healthy contempt for the status quo is essential, and to play a central role in accelerating the growth of this successful business to a position of global market leadership. Jigsaw is a venture-funded startup with offices in San Mateo, CA, and Post Falls, ID.
Find out what the Wall Street Journal, San Francisco Chronicle, Business 2.0, Smart Company and Information Week are saying about Jigsaw by going to our Press Room at www.jigsaw.com. We look forward to hearing from you!
Role
The successful candidate for this position will be responsible for the production MySQL database administration, support, development and data warehouse design.
Responsibilities
Analyze system and database performance, health checks and implement tuning improvements.
Contribute to architectural directions and new features evaluation/ implementation.
Provide off-hours maintenance and project support.
Guide development teams on appropriate use of database features and structures.
Help identify inefficient queries and suggest alternatives.
Logical design of warehouse: schema design, ETL processes, data archival, etc.
Work with the development team to design and build data warehouse including data mart, ETL processes and metadata repositories.
Assist report writers in query performance tuning as requested.
Assist with daily operations and support.
Skills Required
5 years MySQL database architect and administration on Linux
2 years supporting data warehouse environment Substantial operational experience in a 24X7 environment.
Solid knowledge of MySQL RDBMS internals.
Expert level knowledge in MySQL database physical model, backup and
recovery, performance tuning, security, and replication.
Working knowledge of Business Intelligence tools Knowledge of star and snowflake schemas and data warehouse methodology Experience with dimensional modeling, data quality and SCD Experience with third-party database monitoring tools.
Experience with MySQL development skills in scripting languages Experience with MySQL clusters, Master-Master, load-balancing reads is preferred Experience with Linux administration is preferred Experience with Java architectures/issues is preferred
Benefits:
Competitive salary based on experience
Medical, Dental, Vision, AD&D, Life and Long-term Disability Insurance
Medical and Dependent Flexible Spending Account Plans
401K and stock options