Senior Database Administrator
Role details
Job location
Tech stack
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.