Senior PostgreSQL Data Engineer - Flexible & SC-Cleared

Mayfair IT Consultancy Ltd; Greater London; On-site; GBP 70,000 - 100,000; Full time

Benefits offered by this job

Competitive salary

25 days annual leave

Flexible working

Professional development budget

Company pension

Job summary

Mayfair IT Consultancy Ltd is seeking an experienced PostgreSQL Engineer to join our enterprise data team in the UK. You will design, optimise and support PostgreSQL databases in production, implement PL/pgSQL procedures, and ensure performance, security and reliability across large datasets.

The role requires active SC clearance, Linux experience and strong SQL skills, plus scripting in Python or Bash and familiarity with Agile delivery teams. Flexible working options available.

Qualifications

• Active SC Clearance in security-sensitive environments.
• 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.

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.

Skills

PostgreSQL

PL/pgSQL

Advanced SQL

Stored procedures

Data transformations

Linux

Python/Bash scripting

Agile

SC Clearance

Job description

Mayfair IT Consultancy Ltd is seeking an experienced PostgreSQL Engineer to join our enterprise data team in the UK. You will design, optimise and support PostgreSQL databases in production, implement PL/pgSQL procedures, and ensure performance, security and reliability across large datasets.

The role requires active SC clearance, Linux experience and strong SQL skills, plus scripting in Python or Bash and familiarity with Agile delivery teams. Flexible working options available.