Apply now »
Country/Region:  GB

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

Apply now »