SQL Developer - Reading, Berkshire, United Kingdom - Mastek

    Mastek
    Mastek Reading, Berkshire, United Kingdom

    4 weeks ago

    Default job background
    Description

    Background:

    Is your CV ready If so, and you are confident this is the role for you, make sure to apply asap.

    Mastek is a delivery partner with Migration and Borders Technology Portfolio (MBTP) in the Home Office's Digital, Data and Technology (DDaT) directorate.

    MBTP are the consolidated technology delivery partner for UK Visas and Immigration (UKVI), Immigration Enforcement, Border Force and Border, Immigration & Citizenship System (BICS) Policy & International. There are several Mastek teams working across different areas, one of the key teams is Framework Engineering team.

    This team provides business analysis, delivery and enhanced engineering support for the MBTP portfolio in particular for their new case working platform and HO in general.

    Job Description:

    Mastek is looking for SQL (Advanced Skills) Developer who can work in agile team and help Mastek to develop new features or modify existing features for systems required by Caseworking teams.

    Experience: 6+ years

    SC Eligible: Required

    Location: Onsite

    Grade: G6/G7

    Key Skills:

    • Postgres/PostgreSQL database experience
    • source tools for unit testing e.g. dbunit
    • SQL development skills, including writing complex SQL queries
    • existing SQL queries for performance improvements. Construct and optimise SQL queries using explain analyse and slow query logging
    • new queries. Groupings, Rolling up Data and Filtering in Groups
    • transfer mechanisms
    • database schema and develop best practice approaches
    • knowledge (Git check in/ checkout / merge / creating tags)
    Adherence to industry best practices, standards and adoption of Open Source technologies
    • communication skills
    • development environments: Scrum, TDD, BDD, Kanban
    • versed with agile ceremonies (stand-up, sprint planning, sprint review, sprint retrospective etc.)
    • of working on large programmes having number of cross-functional teams
    Additional skillset:
    • Microservices
    • in large scale integration projects involving messaging, web-services and distributed systems.
    • of Docker based release management process
    • Sector domain experience preferred