Senior PostgreSQL Data Engineer
Mayfair IT Consultancy · London, United Kingdom
- Location
- London, United Kingdom
- Work mode
- Remote
- Type
- Contract
- Seniority
- Senior
- Salary
- Not stated
- Posted
- 27 Oct 2026
Verified open 19 Nov 2026 · Source: Company careers page
About the role
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 datasets
- 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
Similar jobs in London at other employers
Data Solution Architect
ExperisGrowth Analytics Partner, Media
DentsuaegisData Quality Consultant
LinklatersData Governance Consultant
Linklaters
More jobs at Mayfair IT Consultancy
Data Engineer
New on EvolcPerformance Analyst
New on EvolcEnterprise Architect
New on EvolcSolutions Architect
New on EvolcService Designer
New on EvolcData Architect
New on Evolc