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.
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.
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