Database Administrator
Apsalar Inc - San Francisco, CA

This job posting is no longer available on Apsalar Inc. Find similar jobs:Database Administrator jobs - Apsalar jobs

Job Description

About Us:
Apsalar’s platform is the leading mobile DSP powered by 1st party behavioral data, providing an advertising and analytics platform for direct marketers and agencies looking to acquire and optimize high-ROI mobile audiences at scale.

Apsalar has won numerous awards, including eWeek’s Top Ten Promising Mobile IT Startups (2011) and OnMobile’s AlwaysOn Top 100 Private Companies (2012).

Based near South Park in the SoMa district of San Francisco, we’re helping mobile app marketers grow their businesses with our data-powered mobile advertising platform. We’re a diverse, fun-loving group whose culture centers on innovation, teamwork, and passion. We expect great things from our team, and because of that, our people come first.

Apsalar is looking for an experienced PostgreSQL DBA to manage its farm of PostgreSQL databases in a high performance environment. The job breakdown is 50% DBA, 50% systems engineering, i.e. while the emphasis is primarily on the database side of things, we are looking for someone who understands the entire systems stack, not just a narrow specialist.

We process billions of database transactions per day.

Responsibilities:
Manage and monitor production databases

Work with developers on tuning query performance

Automate operations

Establish and test backup and DR procedures

Requirements:
At least 2 years experience as principal DBA for production PostgreSQL databases

Experience with PL/pgsql

PostgreSQL performance tuning experience

Experience with londiste

Strong scripting, automation and and devops skills

Experience with PostgreSQL HA solutions

Experience with PostgreSQL replication

Bonus Points:
Experience with PL/Python

Experience with AWS

Experience with DTrace

Experience with PL/Proxy and Londiste

Experience with ZFS, NetApp filers or other copy on write platforms

Experience with Zabbix

Capacity planning skills

Disaster recovery planning skills

Experience with other DBs, e.g. Oracle or MySQL

Some proficiency with bash and Python. Other languages "doubleplusgood"

Perks:
Top of the line hardware for gear heads. Disk I/O subsystems clocked at > 100k write ops/sec. Full SSD storage and 10 gigabit network deployment for databases

Company paid lunches/socials on Fridays

Company paid breakfasts on Tuesdays

Kegerator on site

Responsible self starters enjoy who complete goals in a timely manner enjoy alot of autonomy

401k Plan

Company paid premiums for Healthcare (Kaiser or Anthem), Vision, & Dental. All free but you have to pay the co-pays.

Commuter/Parking plans

This role includes covering the first $100/mo of your cell phone bill

Walking distance to BART. Near I80 on ramp. City parking lot across the street.

Opportunity for the willing to learn about network engineering, system administration and more. If you want to learn, we probably have something to teach.