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
- 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
- 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
- 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
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
Need an ATS-Ready Cyber CV?
Create an industry-standard cybersecurity CV with technical templates.
Build Free CV Now