SQL Database
Reading, Berkshire, United Kingdom
£ Up to 70,000 per annum + benefits
SQL (Advanced Skills) Developer
Background:
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:
Strong Postgres/Postgres SQL database experience
Open source tools for unit testing e.g. dbunit
Advanced SQL development skills, including writing complex SQL queries
Analyse existing SQL queries for performance improvements. Construct and optimise SQL
queries using explain analyse and slow query logging
Suggest new queries. Groupings, Rolling up Data and Filtering in Groups
Data transfer mechanisms
Define database schema and develop best practice approaches
Repository knowledge (Git check in/ checkout / merge / creating tags)
Adherence to industry best practices, standards and adoption of Open Source technologies
Good communication skills
Agile development environments: Scrum, TDD, BDD, Kanban
Well versed with agile ceremonies (stand-up, sprint planning, sprint review, sprint
retrospective etc.)
Experience of working on large programmes having number of cross-functional teams
Additional skillset:
Python,
AWS,
Java, Microservices
Experience in large scale integration projects involving messaging, web-services and
distributed systems.
Awareness of Docker based release management process
Public Sector domain experience preferred