Database Administrator (DBA)
One Kings Lane - San Francisco, CA

This job posting is no longer available on One Kings Lane. Find similar jobs: Database Administrator jobs - One Kings Lane jobs

At One Kings Lane, we’re doing so much more than selling great home décor. We are pioneering a new generation in ecommerce while defining and curating a $158B national home market. We’re young, but we’ve grown our revenue 500% in the first year of business, and are on track to top that by over 200% this year. We have investors like Kleiner Perkins, Greylock Partners, and Tiger Global Management backing us up. And yet, don’t think of us as just an e-commerce company - at the core, we’re a product and technology company driven by our strong brand and products. We’re hard at work trying to solve problems around big data, recommendations, machine learning, supply chain management, site performance and scalability, fraud monitoring and detection, and mobile applications.

Our platform is actually barely a year old, but in the course of that time, the engineering minds at One Kings Lane are tackling technologies like Hadoop, NoSQL, Redis, Node.js, Ruby on Rails, PHP/Zend Framework, jQuery, and iOS/Objective-C. We believe in the Agile methodology, and can roll with continuous builds, working in the cloud, and behavior-driven development. Our stack has enough variety that you can start contributing immediately with what you do know, while continuing to expand your skills into areas you want to know.

The Opportunity:
The Site Reliability Team at One Kings Lane is looking for DBA's who want to build highly scalable and stable systems. Our team blends a variety of skill sets and works collaboratively to ensure not only that we deliver quality releases, but also take an active role in determining what architectures and technologies perform, scale and deliver services reliably. If you're looking for an opportunity to deepen your expertise and learn new things, this job is for you.

Responsibilities:
Designs, builds, and maintains database systems at all stages of development, from determining business requirements to planning and deploying test, staging, and production systems.

Performs operational DBA duties. These include: installation, upgrades, patching, environment cloning, implementing backup/recovery and monitoring procedures, capacity planning, site failover/switchover, clustering/HA, table maintenance, data recovery, ongoing systems performance tuning, schema and query optimizations, and user rights management.

Independently investigates, diagnoses, and resolves complex data anomalies. Writes software and uses automation to prevent problem recurrence.

Ensures data integrity and oversees ETL process flow between OLTP and OLAP/DSS systems.

Manages availability, latency, scalability and efficiency of OKL’s production services by engineering reliability into their backing storage systems.

Participates in service capacity planning and demand forecasting, software performance analysis, and system tuning.

Uses a variety of information gathering techniques to gather and document complex business data requirements and process flow models from internal and external business clients and development teams. Provides conceptual and technical modeling assistance to developers. Reviews and influences ongoing design, architecture, standards and methods for shared infrastructure and hardware platforms. Tests and validates data models with Operations staff prior to implementation into live production systems.

Identifies new internal and external data sources and assesses areas of overlap with existing data sources, and facilitates data sharing among all relevant stakeholders. Works with Operations staff to transform logical database models into physical database designs scaling across multiple data centers.

Administers and documents standard operating procedures and sets data standards and policies for development teams interacting with production data. Acts as custodian of sensitive customer personally identifiable information, and assists Security and Operations staff with audit processes and compliance.

Solves the challenges related to aggressive data warehouse growth.

Takes part in a 24x7 on-call rotation.

Qualifications:
Familiarity with Python, Ruby, Bash, and ability to write monitoring tests.

Experience with PerconaXtraDB and Percona Toolkit, as well as familiarity with Big Data concepts and operational procedures using a variety of tools.

Experience deploying and maintaining columnar data storage engine to support scalable data warehouse systems (InfiniDB, TokuDB, InfoBright, MonetDB).

Experience with Hadoop, Sqoop, Hive, Pig, or other projects based on distributed Map/Reduce principles.

5+ years work experience with MySQL and at least one other major RDBMS (SQL Server, Oracle, Sybase, DB2, Informix, Postgres).

6+ years relevant work experience, including large systems software design and development, with knowledge of UNIX/Linux and Windows.

Familiar with concepts, models, and processes of at least one major ERP system (Dynamics AX, SAP, Baan, Oracle E-Business Suite).

Detail oriented, passionate, even obsessive.

Highly intellectually curious, independent but still a team player.

Expertise in analyzing and troubleshooting large-scale distributed systems.

Experience in a high-volume or critical production service environment.

Experience working with a data access layer a plus.

Intrigued yet? Submit your resume now and tell us why you rock.

  • LI-OK

One Kings Lane - 22 months ago - save job - block
Recommended Jobs
Database Administrator - MySQL
Twilio - San Francisco, CA
Twilio - 23 days ago
Easily apply

MySQL Database Administrator
Five9, Inc. - San Ramon, CA
Five9, Inc. - 29 days ago

Database Administrator
Adobe - San Francisco, CA
Adobe - 21 days ago
About this company
5 reviews