PowerReviews is the leading provider of social commerce software-as-a-service solutions to global retailers and brands.
We are an innovative social media company committed to making software
for consumers to rate products purchased on E-commerce websites.
The company's unique structured data approach to collecting,
organizing, and analyzing user-generated content significantly boosts
product sales and customer engagement.
We’ve got the Power:
- PowerReviews is live on over 4,700 websites - across 13
languages in 21 countries - including Staples, Drugstore.com, Room
& Board, ESPN, Neutrogena, Quicksilver, and Jockey.
- Recognized as the customer reviews Solution Leader in the Internet Retailer Top 500
survey, PowerReviews has received venture capital backing from
Four Rivers Group, Woodside Fund, Menlo Ventures and Tenaya
Capital.
- PowerReviews has received two patents since 2009 from the U.S.
Patent and Trademark Office (U.S. Patent No. 7,930,363) relating to
the method in which it delivers user-generated product reviews to
websites globally.
Database Administrator
We are looking for a
Database Administrator to manage multiple development and production
databases. This position requires regular on-site interaction with the
engineering and operations teams in our San Francisco office. The DBA
reports to the Database Architect and supports our Postgresql
environment. However, don’t worry if you don’t have much experience
with Postgresql. If other requirements are met, this position will be a
great opportunity to acquire solid Postgresql experience.
Responsibilities
- Release process - schema change management, prepare release-specific checklists and scripts
- Availability - maximize uptime, implement and maintain proper safeguards for backup, replication, and recovery
- Security - define and implement user privileges and access controls to data
- Automation - develop scripts to automate routine database
related operations, maintain systems configuration for DB systems
using Puppet
- Development Support - help engineers and business analysts
adopt database best practices, review database change requests and
provide optimization advice
- Emergency response - Participate in oncall rotation
Requirements
- 1 to 3 years experience managing production relational databases in 24x7 environment
- Experience with writing SQL queries and performance optimization
- Familiarity with database best practices, principles of
database replication, backup, scalability and high availability
- Understanding of basic database fundamentals: multi-version
control, concurrency, transactions, indexing, locking, caching
- Understanding of Unix environment, and shell scripting experience
- Must be authorized to work in the U.S.
Nice to Have
- Experience with Postgresql is desired, but Oracle or MySQL experience will work, too
- Experience in using one or more monitoring solutions (Zenoss, Nagios, Cacti, etc)
- Experience in Ruby or other scripting language like Perl or Python.
|
