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:
* 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