Leave us your email address and we'll send you all the new jobs according to your preferences.
Senior PostgreSQL Data Engineer
Posted 11 days 20 hours ago by Mayfair IT Consultancy Ltd
Permanent
Full Time
Other
London, United Kingdom
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
- 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
Mayfair IT Consultancy Ltd
Related Jobs
Nursery Practitioner Level 2
- £15,999 Annual
- Leeds, City, United Kingdom, LS6 4EE
Multi Skilled Engineer
- £54,000 Annual
- Nottinghamshire, Forest Town, United Kingdom, NG19 0HA
Workplace Experience Ambassador
- London, United Kingdom
Automatic Door Engineer
- £50,000 Annual
- Kent, Swanley, United Kingdom, BR8
IT Support
- £24,800 Annual
- Essex, Buckhurst Hill, United Kingdom, IG9 6LN