PostgreSQL/SQL Database Developer – Brighton UK

Brandwatch is building something special. We have already created the
best Social Media Monitoring platform in the world, but that’s just the
start. We are looking for great people to help us write the next chapter
in Social.

We are now hiring a PostgresSQL/SQL Database Developer to join our
Systems team and help us scale our infrastructure as we collect and
analyse more and more data from the Web.

You will be responsible for the way the Brandwatch Applications store
their metadata in Postgres (currently over 50TB across 30 shards),
identifying any performance or scalability issues with the current
designs and working closely with the developer teams to spread best
practice and, where necessary, implement new functionality.

The successful candidate will be responsible for:

     Managing and cultivating the Database schema, taking ownership of
it's overall development and establishing best practice for its
implementation
     Design and Development of SQL and PL/pgsql code with the developer
teams
     Improvement of the existing database structure, whether for
performance or manageability
     Peer review of the SQL code across the development team with a
major focus on performance and scalability
     Working closely with the database administrator to proactively
monitor the databases
     Actively identifying and predicting scalability and performance
issues, and addressing them with the Systems and Development teams.

What you need:

     At least 3 years experience as a SQL Developer, ideally with
PostgreSQL. Experience with Oracle or MS SQL Server will also be considered.
     Very strong knowledge of SQL and the procedural languages
(especially PL/pgSQL or PL/SQL)
     Strong knowledge of query tuning, both as a general methodology and
ideally with regards to PostgreSQL running on modern Linux systems
     Strong knowledge of the RDBMS architecture
     Attention to detail and an analytic approach to your work

The following would be advantageous:

     Professional Java developer experience
     Professional experience as database administrator, ideally with
multi-terabyte data sets
     Knowledge of the PostgreSQL ACID implementation
     Capability to build ad hoc data models
     Interest in the wider developments in large-scale data storage and
processing (NoSQL or otherwise)

Our Culture:

     Small teams of skilled people, in a friendly and relaxed environment
     Quiet hours for developers so you can work uninterrupted throughout
the morning
     Work with people all over the world…and use telepresence robots for
meeting remote colleagues… provided you don’t mind seeing a Berliner
colleague’s face rolling past on a robot!
     “Funky Friday” takes place every other week giving you 10% of your
time to work on something new, reading groups, tech talks, generous
training and conference budgets, and any technical books you need

Perks

     All the usual start-up temptations…cupboards bursting with snacks
(a range to satisfy all taste buds), fruit boxes, drinks fridges… and of
course coffee
     A company that values creativity and cares about its staff
     An environment where constant innovation and having fun are required
     An open company culture where everyone’s voice can be heard
     Opportunities to develop your career
     Macbook Pro
     Based in our Brighton HQ in spacious new offices
     25 days paid holiday
     Bike to work scheme & childcare vouchers
     Sushi days
     Foosball table

Apply http://jobs.jobvite.com/careers/brandwatch/job/o55u0fwo

Many thanks


--
Federico Campoli
Brandwatch | Senior Database Administrator
federico@brandwatch.com |

New York  | San Francisco |  *Brighton*  |  Berlin  |  Stuttgart