We are looking for passionate and talented Database Architect to join our growing team in downtown San Francisco and help take our applications to the next level. Joining the team you will have an immediate impact. You will be given a high level of responsibility and a high degree of freedom. Our team culture encourages you to come up with innovative solutions to problems as well as offering you the opportunity to work with best-of-breed open-source technologies created by the Java community. Youll be joining a highly-collaborative Engineering team that embraces best practices from the agile world and is focused on building a world-class team both in terms of practices and technology.
Who are we?
SunRun is the fastest growing residential solar company in the country and has a mission to bring clean, solar power to the masses. SunRun is unique in that we bring together two exciting areas: Cleantech and Consumer services. This means that not only does our Engineering team work on challenging software and usability issues; we get to take comfort in the fact that we're also changing the world - one solar system at a time. We are well funded, having raised ample corporate funds from Accel Partners and Foundation Capital as well as project financing from US Bancorp
At SunRun, we're all about bringing clean, solar power to the masses, and it is this singular mission that drives our Engineering team to focus on two simple, but very important things:
1) Reducing the upfront cost of solar. For the Engineering team, this means:
Building a consumer-facing website that allows prospective customers to determine exactly what solar energy would cost per kWh if installed on their home, to learn how systems in their neighborhood perform, and to determine what sort of technology is best in their geography.
Making it brutally easy for our growing network of top-tier installation partners to tap into our proprietary pricing and proposal engine and to offer the lowest priced solar systems on the planet.
2) Making it easy - maybe even fun - for our residential customers and SunRun's own operations team to oversee how our solar systems are performing. Why? Because increased monitoring == higher performing systems == more clean solar kilowatt-hours == better pricing on future systems. SunRun already owns and monitors at revenue grade more solar facilities than any other company in the country.
What you will do:
Help design and develop first-class components for a highly successful and growing multi-tier, distributed software platform.
Maintain production MySQL database environment:
o Monitor usage patterns to be able to troubleshoot real-time issues.
o Profile database usage to identify potential bottlenecks.
o Tune server settings to maximize efficiency.
o Setup and maintain MySQL replication.
Review and optimize existing database schema:
o Optimize table structure and indexing for maximum efficiency
Review and re-factor Java codebase related to database access:
o Identify and optimize inefficient database access code (inefficient queries, unnecessary updates, etc.).
o Review and re-factor in-house developed JDBC wrapper framework.
o Investigate opportunities for using second level caching solution to take load off the database.
Peer review of database access code in current and future development projects.
Contribute to key architectural decisions that directly impact the scalability of the SunRun applications.
Collaborate with other developers to design complete solutions for new features and application components.
Think innovatively to help shape our agile software development processes and practices.
Research and recommend new and emerging technologies that are not only exciting but will also enhance our customers user experience and improve the productivity of the team or scalability of the applications.
Qualifications:
Minimum 7 years of experience in database design/architecture, data modeling, security, performance, scalability, and tuning
Minimum 3 years of experience as a senior level database architect.
Minimum 3 years of experience with MySQL and MySQL replication.
Professional experience administrating and tuning MySQL 5 database servers.
Detailed knowledge of optimizing database schemas/indexing for the MySQL InnoDB storage engine.
Java development experience, specifically with JDBC.
Knowledge of distributed second-level caching solutions such as MemCached, EHCache.
Knowledge of Java database frameworks such as Hibernate.
Remote Linux administration experience.
Experience developing highly concurrent and scalable applications.
Experience with Agile development methodologies.
Proven ability to work in a highly collaborative environment.
Exceptional communication skills.
Exceptional analytic and problem solving skills.
BS in computer science or equivalent work experience.
Simply excited about technology.
Key technologies: Java, Spring, Hibernate, MySQL, Linux, Tomcat.
Why Join the SunRun Team?
Needless to say, there's never a dull moment here - we work genuinely hard but we love what we do and the culture we have built, where nobody takes themselves too seriously.
SunRun contributes to benefits for our employees
3 PPO Medical Insurance Options.
POS (PPO, EPO & HMO combined) dental.
We want our employees to have real lives, so we offer them time off:
Vacation time up to 10 days during your first year of employment.
15 business days during your second year of employment.
9 paid Holidays.
9 sick days.
We also want our employees to save for their future so we offer a:
401k & ROTH 401k.
We have other benefits that are beyond the basics:
Commuter checks.
We have some unique traditions that our employees participate in:
Free Lunch on Fridays / All Company meetings on Monday.
We want all our employees to feel ownership in the company, so we offer:
Stock options.
If you are interested in making a difference and joining our growing team please send your resume to us.
Additional Information
Local candidates only, no relocation (San Francisco Bay Area).
No third party applications.
- Principals only. Recruiters, please don't contact this job poster.
- Please, no phone calls about this job!
- Please do not contact job poster about other services, products or commercial interests.