Senior Database Administrator

Dexory

Job Summary

This role involves helping to scale a rapidly growing warehouse robotics platform by architecting and implementing scaling strategies for a terabyte-scale PostgreSQL database. The Senior Database Administrator will maintain performance, advise on data architecture, and implement solutions like partitioning and sharding. Key responsibilities include optimizing queries, managing indexes, designing data retention policies, and collaborating with development teams, all while supporting the company's mission to revolutionize the logistics industry with real-time data insights.

Must Have

  • Experienced PostgreSQL DBA
  • Ability to architect and implement scaling strategies for large databases
  • Proven track record of implementing scaling solutions on production systems
  • Strong opinions on scaling architectures (partitioning, sharding, data-warehousing)
  • Experience with query performance analysis and optimization
  • Skills in index strategy and maintenance
  • Ability to design and implement data archival/retention policies
  • Experience tuning tables with high write volume
  • Knowledge of connection pooling and configuration tuning
  • Proficiency in maintaining backup/recovery strategies and testing
  • Collaboration with development teams on schema design and migrations
  • Willingness to participate in on-call rotation for database incidents

Perks & Benefits

  • Private healthcare via Bupa with 24/7 medical helpline
  • Life insurance
  • Income protection
  • Pension: 4+% employee with option to opt into salary exchange, 5% employer
  • Employee Assistance Programme - mental wellbeing, financial and legal advice/support
  • 25 holidays per year
  • Full meals onsite in Wallingford
  • Fun team events on and offsite, snacks of all kinds in the office

Job Description

We believe that real time data will revolutionise the logistics industry. We are building the ultimate data insights platform that provides companies with unprecedented, real time access to their operations. Our autonomous data capture technology and insights generation capabilities help to measure, track and find goods across warehouses in real time, while building the ultimate digital twin of facilities.

Join us at a very exciting time of growth as we’re significantly ramping up all areas of the business to lead the way in logistics data globally, backed by some of Europe’s best VCs and driven by passion, curiosity and teamwork.

We value humility and we're as interested in your character as we are in your talent. Please apply, even if you feel you only meet part of our listed criteria. Diversity drives innovation and we offer an international and friendly work environment with an energetic company culture.

What does this role involve?

We're seeking an experienced PostgreSQL DBA to help us scale our rapidly growing warehouse robotics platform. We have a terabyte-scale database, and we're experiencing ongoing growth with associated scaling challenges.

We need someone who can help us architect and implement scaling strategies to support continued growth while maintaining performance, and take an advisory role on data architecture. We need you to have strong opinions one what type of scaling architectures (partitioning, sharding, data-warehousing / iceberg etc) are best in which situations, and have a proven track record of implementing these solutions at scale on already-deployed production systems.

This role will be mostly remote however will require 1 day per month minimum onsite at our Wallingford facilities. Unfortunately due to this, we cannot consider applicants outside of the UK and cannot provide sponsorship for this role.

Key Responsibilities

Immediate priorities (3-6 months)

  • Understand growth estimates and design scaling strategies for largest tables
  • Optimize existing indexes and query patterns
  • Establish monitoring and alerting for performance regressions
  • Develop capacity planning based on customer growth

Ongoing responsibilities

  • Query performance analysis and optimization for complex analytical workloads
  • Index strategy and maintenance
  • Design and implement data archival/retention policies
  • Tuning for tables with high write volume
  • Connection pooling and configuration tuning
  • Maintain backup/recovery strategy and testing
  • Working with development team on schema design and migrations
  • On-call rotation for database incidents

Benefits

Starting from the interview process and continuing into your career with us, you will be working by our four Operating Principles:

  • Performance: High standards, outstanding results,
  • Impact: Big challenges, bigger results
  • Commitment: All in, every time
  • One team: One mission, shared success

Joining our team and company isn't just about expertise; it's about embracing uncertainty with ambition. We're crafting world-changing solutions, fueled by a passion to redefine what's possible. We will look for you to help create and shape the future of logistics solutions through our products, our culture and our shared vision.

You will also receive:

  • Private healthcare via Bupa with 24/7 medical helpline
  • Life insurance
  • Income protection
  • Pension: 4+% employee with option to opt into salary exchange, 5% employer
  • Employee Assistance Programme - mental wellbeing, financial and legal advice/support
  • 25 holidays per year
  • Full meals onsite in Wallingford
  • Fun team events on and offsite, snacks of all kinds in the office

4 Skills Required For This Role

Team Management Performance Analysis Game Texts Postgresql

Similar Jobs