Senior PostgreSQL Data Engineer

Mayfair IT Consultancy Ltd

Greater London

On-site

GBP 70,000 - 100,000

Full time

10 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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

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