Senior Database Administrator

Podfather
Glasgow, United Kingdom
13 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Glasgow, United Kingdom

Tech stack

PHP
Amazon Web Services (AWS)
Application Layers
Backup Devices
Cloud Computing
Computer Security
Databases
Data Warehousing
Shard (Database Architecture)
Software Debugging
DevOps
Disaster Recovery
PostgreSQL
MariaDB
MySQL
NoSQL
Query Optimization
Software Engineering
SQL Databases
Caching
Technical Debt
Data Layers
Database Monitoring
Pagination

Job description

As a Senior Database Administrator, you'll be the steward of the data layer that powers Podfather. Working closely with our Software Engineers, DevOps Engineers, and CTO, you will keep our databases reliable, performant, and well-designed as the business grows., * Database Operations: Take ownership of the day-to-day health of our MariaDB/MySQL estate, monitoring, backups, replication, capacity, upgrades, and patching, ensuring the platform stays reliable and recoverable.

  • Schema Design & Evolution: Design new schemas and evolve existing ones to support new product features, working with engineers to ensure changes are safe to deploy, performant at scale, and easy to maintain over time.
  • Performance & Scaling: Identify performance hotspots, tune queries/indexes, and help the team plan for growth as we scale to hundreds of thousands of users.
  • Driving Change & Problem Solving: Identify, understand, and resolve critical database and data-integrity issues. You'll articulate database trade-offs to technical and non-technical stakeholders alike to drive high-leverage improvements.
  • Information Security: Handle data securely throughout its lifecycle (encryption at rest/in transit), enforce the principle of least privilege, manage secure authentication, and handle patches/updates to protect the database estate., We are looking for a skilled practitioner who can lead database work to successful technical outcomes by factoring in technical debt, data modelling, stability, security, and business needs.
  • Query Optimisation: Comfortable reading and optimising SQL using execution plans, indexes, and configuration tuning.
  • Resilience & Observability: Responsible for backup strategies, replication, and disaster recovery procedures (including regular verification). You will fill database monitoring and alerting gaps to stop issues before they become incidents.
  • Application Layer Collaboration: Work closely with engineers writing application code (primarily PHP at Podfather) to review how the application talks to the database, ensuring migrations are a routine process rather than a risky event.
  • Incident Management: Take a leading role in debugging complex database issues, managing incidents, and collaborating with support teams to share known workarounds.

Requirements

If you love solving real-world problems, collaborating with a passionate team, and making a tangible impact every day, we want to hear from you., * MariaDB/MySQL experience.

  • Schema design experience.
  • Some experience of growing databases to scale, to hundreds of thousands of users and beyond.
  • Some application development experience; PHP would be preferred, but any experience working with a mature codebase would be fine.

Preferred Skills:

  • AWS experience preferred, but other cloud experience would be also be helpful.
  • PostgreSQL experience.
  • Data warehousing experience.
  • Experience of database scaling technologies such as sharding, pagination, replicas, caching, proxying
  • Experience of wider database technologies such as NoSQL, Graph, time-series DBs

Benefits & conditions

Flexible Working: We are a flexible working employer. Work where it is best for you, home, office, or a hybrid layout. In this role you will need to be within commuting distance of our office.

Continuous Growth: A commitment to your development through an individual training budget.

The Right Tools: High-spec workstation, multiple monitors, and your choice of operating system/kit.

Great Office Perks: A nice working environment with complimentary drinks and snacks in our Edinburgh office, strong transport links, and free parking.

Social Culture: Regular team events and social activities, including board games and online games nights.

Health & Wellbeing: Comprehensive Employee Assistance Programme which includes a 24/7 confidential helpline, remote GP and physiotherapy appointments, mental health support, lifestyle coaching, and nutritionist sessions.

Peace of Mind: Life Assurance and a company pension plan.

Extra Perks: Bike-to-work scheme and Enhanced Life Friendly Policies.

About the company

With our team of around 60 people working remotely or at our Edinburgh head office, we believe that we can offer you something special here at Podfather. Our whole ethos is about creating a unique and rewarding experience for both our customers and our employees. When you work here, you will get involved with challenging projects within a fun and friendly environment. We are a medium-sized company, which means you get to be part of multiple projects, wear different hats, and truly see the difference your work makes. We develop and deliver industry-leading route optimisation and electronic proof of delivery (ePOD) technology to the logistics, construction, and field service sectors. We have some huge clients, and some tiny ones, and because we are growing fast, now is a great time to join our team. At Podfather, we're guided by our core values: reliable, innovative, determined, collaborative, candid, and caring . You'll see these in action every day in how we work together, solve problems, and support our customers.

Apply for this position