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 here http://www.brandwatch.com/careers/#collapse53419
Many thanks
--
Federico Campoli
Brandwatch | Senior Database Administrator
federico@xxxxxxxxxxxxxx |
New York | San Francisco | *Brighton* | Berlin | Stuttgart
--
Sent via pgsql-jobs mailing list (pgsql-jobs@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jobs
