menu
EST 1985
Serving classified ads since 1985.
Serving classified ads since 1985.
Sorry no location available with such name.

Database Developer

Description

Database Developer / DBA

Mansfield, Nottinghamshire

£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.

Database Developer

Reporting to the Database Services Lead you will work on a variety of tasks including:

  • Design and development of our product database components.
  • Database Optimisation.
  • Database Automation.
  • Develop and maintain ETL processes.
  • Develop and deliver data migration projects, from third party and in-house systems.

Core Responsibilities

  • Develop stored procedures using PL/pgSQL.
  • Tune SQL queries and be able to read and understand query plans.
  • Understand and develop performance parameter tuning.
  • Understand the ongoing challenges of using a RDBMS in an enterprise environment including managing performance and maintenance activities.
  • Provide technical support to internal staff and customers.
  • Deliver technical projects on time.
  • Produce technical documentation.
  • Develop own skills through self-learning.
  • Perform problem management and monitoring.

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.

  • Using a modern RDMBS, especially PostgreSQL

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.

  • Complex SQL

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.

  • Relational database design

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.

  • Data Migration

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.

  • Linux

Core systems are built on RHEL. You don’t have to be expert, but you should be comfortable navigating a Linux file system.

  • SQL Server, T-SQL, SSRS.

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.

  • PostgreSQL Logical and Physical Replication technologies

Physical and logical replication is key to some deployments and may play a key strategic role in the future.

  • Python, psycopg2

Some in-house utilities use Python. Any experience would be advantageous.

  • Version Control

Gitlab, with some subversion.

  • Java, JDBC

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 / shell

Perl and shell for scripting.

  • Systems automation (Ansible, Chef)
  • Docker
  • Backup, recovery, clustering, high availability with PostgreSQL

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:

  • Kafka
  • PostgreSQL Logical Decoding

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]

Get directions

Mansfield, England, Nottinghamshire, NG18, United Kingdom

  • Ad ID:  15007757
  • Ad Type:  Offered
  • Posted on:  18/07/2020, 02:47
loder image
loder image