Naukrijobs UK
Register
London Jobs
Manchester Jobs
Liverpool Jobs
Nottingham Jobs
Birmingham Jobs
Cambridge Jobs
Glasgow Jobs
Bristol Jobs
Wales Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

Database Developer

SOM-3 RECRUITMENT LIMITED
Job LocationMansfield
EducationNot Mentioned
Salary£35,000 - £45,000 per annum, negotiable, inc benef
IndustryNot Mentioned
Functional AreaNot Mentioned
Job TypePermanent, full-time

Job Description

Database Developer / DBAMansfield, Nottinghamshire£35-45k + £3k Bonus + Benefits PackageAre 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 teamsIn 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 DeveloperReporting 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 expertiseYou 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 dont 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!

    APPLY NOW

    Database Developer Related Jobs

    © 2019 Naukrijobs All Rights Reserved