Senior PostgreSQL Developer

Location: Birmingham, United Kingdom
Salary: £45K – £55K
Experience: 5 – 6 years
Sector: Insurance, Fintech
Duration: Permanent


We require an experienced PostgreSQL Specialist to join a leading company on a permanent basis. As the PostgreSQL Engineer, you will be responsible for developing reviewing, tuning, testing, and reporting across a new reporting suite based on the organisation PostgreSQL data warehouse/database. As the PostgreSQL Specialist, you will also establish telemetry dashboards whilst also creating and implementing any recommendations.

Who are we looking for:

  • Extensive experience with PostgreSQL
  • Experience of data warehousing
  • Experience of performing load testing
  • Experience of working in past paced high availability environments
  • Experience of deploying large PostgreSQL implementations and apply data security
  • Experience of cloud platforms – AWS, Azure 
  • Recovery and Replication
  • Overall system health
  • Developing Triggers/Stored Procedures
  • Query optimization
  • Developing SQL reports and business logic of UNIFY
  • Staging, testing and development of database
  • Documentation of schema
  • Schema Management, updates, and rollbacks


  • Responsible for the monitoring and uptime of all production databases.
  • Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
  • Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
  • Develop Stored Procedures and Database Triggers in support of application development.
  • Participate in application development projects and be responsible for the database architecture and design.
  • Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
  • Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
  • Responsible for regular backups and recovery of databases.
  • Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
  • Responsible for pro-active remediation of database operational problems.
  • Responsible for Query tuning and preventative maintenance.
  • Participate in a 24×7 support rotation.
  • Perform other duties as assigned.


  • BSc in Computer Science, Engineering, or relevant field
  • 5-8 Years of relevant experience 
  • It would be grateful if PostgreSQL certification database certification