Like data?
Like figuring out how to order it so you can search it efficiently?
Like mashing it in new and unexpected ways to reveal human behavioral truths?
Like to feel like you're doing something good for humanity?
We got yer' next gig.
Company Overview:
MyExpertSolution.com helps answer the pounding questions of the heart when the question is pounding.
MyExpertSolution.com is an internet start-up, based in Provo, that is culling experts from a variety of fields including mental-health and well-being, family and romantic relationships, addictions, education, and personal business and finance to answer questions for people with palpable immediate concerns that need to be answered now. There is currently a minimal online offering, but we are ramping up to build the architecture to handle 20+ million members.
Position Description:
MES needs a database architect familiar with MySQL web production environments to drive the database architecture that will allow users to interact quickly and efficiently with our experts in audio and text formats; allow insurance and health program providers to visualize subscriber usage patterns; allow experts to see and understand purchasing and affiliate model effectiveness; and allow for flexibility in the data model for doing on-the-fly measurement and analysis. (If you think Tufte is a demigod of the statistical realm, we want to talk to you.)
Responsibilities:
- Envision DB schema and architecture design to meet scalability, performance and high availability metrics.
- Design and construct advanced SQL queries and DB functions in collaboration with design and application teams. (You should read “stored procedures” here and think “one guy” when we say “team” because, hey, it's a start-up.)
- Advise on the model half of the MVC web application infrastructure.
- Work with the Technical Operations team (There's that “team” thing again.) to monitor and tune DB performance.
- Analyze and optimize SQL queries and DB functions.
- Perform production DB maintenance (out of hours) as required, if required.
- Respond to operational issues when appropriate.
(Some of the above responsibilities are database administration activities. This is necessary while in the start-up phase of this company.)
Required Experience:
- Minimum of 3-5 years experience in RDBMS (MySQL, Oracle, DB2, PostgreSQL, etc.) in a large production setting. (Be prepared to define the word “large.” )
- BA/BS CS/Math/Engineering or related field – or just be really smart with experience you can prove.
- Experience with MySQL InnoDB and stored procedures.
- Object-Oriented Programming using PHP/Python/Java, etc.
- Demonstrated knowledge of DB operations and maintenance in an enterprise setting, e.g. backup, replication, etc.
- Experience scaling database backend for web apps.
- Excellent written and verbal communications skills. (Do you really not have these?)
- Motivated self-starter. (If you spotted the redundancy, call us now!)
Yes, you have to work in Provo.
No, you can't live in New York/Chicago/Boston/Colorado/California and telecommute. Seriously, stop asking.
