MA

Senior PostgreSQL Data Engineer

Mayfair IT Consultancy Ltd London Posted 22 Nov 2026 Closing: 22 Dec 2026
Permanent Hybrid SC Cleared I.T. & Communications
Competitive

Role Description & Technical Scope

Job Ref: #3206062193
Requirements
  • Active SC Clearance
  • Strong PostgreSQL engineering experience within enterprise environments
  • Extensive PL/pgSQL development experience
  • Experience developing stored procedures, functions, triggers and database objects
  • Advanced SQL skills including CTEs, window functions and query optimisation
  • Database performance tuning, indexing and partitioning experience
  • Experience implementing data transformations within PostgreSQL
  • Production database support and troubleshooting experience
  • Linux environment experience
  • Python, Bash or Shell scripting skills
  • Experience working within Agile delivery teams
Key Responsibilities
  • Develop, optimise and support PostgreSQL database solutions within a large-scale production environment
  • Design and build PL/pgSQL stored procedures, functions, triggers and views
  • Implement data transformation and validation logic within PostgreSQL
  • Write and optimise complex SQL queries for large datasetst>
  • Troubleshoot performance issues and perform query optimisation
  • Review schemas and recommend improvements to indexing, partitioning and data models
  • Support database migrations and integration activities
  • Work closely with application, infrastructure and engineering teams
  • Develop automated testing approaches for database functionality
  • Ensure database reliability, scalability, integrity and security
Highly Desirable
  • HMCTS, HMRC, Home Office or wider Government experience
  • Current SC Clearance gained on a Government programme
  • Data Engineering background
  • ETL / ELT pipeline development experience
  • AWS, Azure or Databricks experience
  • Database migration experience from Oracle or SQL Server to PostgreSQL
  • Data modelling and data warehouse experience
Benefits
  • Competitive salary
  • 25 days annual leave
  • Flexible working
  • Professional development budget
  • Company pension

Ready to apply for this vacancy?

You are viewing Senior PostgreSQL Data Engineer at Mayfair IT Consultancy Ltd. Click below to proceed directly to the official employer or verified application portal.

Direct official application • No candidate registration required

Similar Cyber Security Vacancies

Explore related InfoSec, SOC, Engineering, and Security Operations roles

Lead Cyber Security Architect

Eden James Consulting Limited • London
Competitive View Role

Cyber Security Consultant

Eden James Consulting Limited • London
Competitive View Role

Principal Cyber Security Consultant

Electus Recruitment Solutions • Somerset
Competitive View Role

Junior Vulnerability Researcher

Hackajob Ltd • Gloucestershire
not provided View Role

Ethical Hacker / Penetration Tester - no experience needed

NEWTO TRAINING LIMITED • Birmingham
£65000.00 - £65000.00 per annual View Role

Senior Software Engineer (Embedded Security Engineer)

Northern Recruitment Group Limited • Tyne And Wear
£60000.00 - £60000.00 per annual View Role

Vacancy Summary

  • Date Posted: 22 Nov 2026
  • Location: London
  • Job Type: Permanent
  • Workplace: Hybrid
  • Security Clearance: SC Cleared
  • Industry: I.T. & Communications
100% FREE CV BUILDER
Need an ATS-Ready Cyber CV?

Create an industry-standard cybersecurity CV with technical templates.

Build Free CV Now