Database Developer / DBA
£35-45k + £3k Bonus + Benefits Package
Are you a talented database developer with skills in PostgreSQL, PL/SQL, PL/pgSQL and the capability to maintain varied application databases written by in-house development teams?
In this role as database developer you will influence, innovate, and drive database design, enhance existing high standards whilst ensuring high levels of database performance, availability, and application quality. You will work alongside developers to aid complex bug detection and resolution and help drive continuous improvements of core technologies and processes.
As well as demonstrating a flair for database systems and SQL, you must be flexible, organised, collaborate effectively with other team members, possess excellent communication skills and enjoy working for a modern high tech and high-profile company.
Reporting to the Database Services Lead you will work on a variety of tasks including:
Key areas of technical expertise
You must be able to demonstrate a strong foundation in the following skills and technologies. These skills will be at the forefront of day-to-day work.
It should go without saying that you will have up-to-date experience of using a RDBMS. You will stand out if that RDMBS is PostgreSQL.
You will have a love and understanding of SQL and complex queries will be natural to you. You will be able to tune queries and be at home reading a query plan. You will be able to investigate SQL performance on operational databases.
You will be able to recognise a well-designed database. You should understand normalisation and the compromises that sometimes necessitate breaking it. You will understand indexing, constraints and so on.
Ideally, you will have experience of migrating data into production systems. At the least, you will be aware of the processes involved and will be familiar with some case studies.
Knowledge of the following areas would be advantageous:
The following will be encountered in our tech stack or operational deployments. While they might not be core, they will certainly be encountered and considered an advantage.
Core systems are built on RHEL. You don’t have to be expert, but you should be comfortable navigating a Linux file system.
Your core skills should include PostgreSQL but from time to time you will be asked to work on SQL Server deployments. This will primarily involve writing stored procedures in T-SQL and report writing in SSRS.
Physical and logical replication is key to some deployments and may play a key strategic role in the future.
Some in-house utilities use Python. Any experience would be advantageous.
Gitlab, with some subversion.
Core systems are written in Java; if you are comfortable reading Java code it would certainly help. Some C# might also make you stand out.
Perl and shell for scripting.
Although this role is development focussed, all-round DBA skills would be useful.
Other technologies of interest:
Our client never stop looking towards the future and would be interested in any experience of the following:
All existing staff in this department were cross trained to Postgres (PostgreSQL) from Oracle so those with skills in PostgreSQL, DB2 or Oracle skills with experience in complex SQL querys should apply!
If you wish to apply for this position, please email us at [email protected]
Mansfield, England, Nottinghamshire, NG18, United Kingdom