Senior Database Administrator for Schema Modernization

Vertex Analytics

Freelance · Remote · Flexible hours

About the role

Vertex Analytics is expanding its B2B SaaS platform with a multi‑tenant feature set. We need a Database Administrator to design, implement, and fine‑tune the underlying data layer, ensuring isolation, performance, and reliability across tenants.

Key responsibilities

• Architect and configure multi‑tenant schemas in PostgreSQL, MongoDB, and MySQL
• Implement automated provisioning and de‑provisioning of tenant databases
• Monitor performance, conduct capacity planning, and optimise queries per tenant workload
• Develop backup, recovery, and disaster‑recovery procedures tailored for multi‑tenant environments
• Collaborate with dev and product teams to translate feature requirements into scalable data models

Must-have skills

• 5+ years managing PostgreSQL, MongoDB, and MySQL in production
• Deep understanding of multi‑tenant architecture patterns
• Proficiency with database security, role‑based access, and encryption
• Experience with automation tools (e.g., Ansible, Terraform) for DB provisioning

Nice to have

• Familiarity with containerised databases (Docker, Kubernetes)
• Knowledge of cloud‑native database services (AWS RDS, Azure Cosmos DB)