Lead Database Administrator
New
P
PartnerizePartnership automation
This role is fully remote and open to candidates based anywhere in the UK or the US.Full-TimeLead
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Required Skills
- PythonBashKubernetesMySQLAnsibleNetworking
Requirements
- Advanced administration of MySQL in production environments, on-premise or in the cloud.
- Strong Linux system administration and networking awareness to support, secure, and maintain servers.
- Experience as the sole or lead owner of large production database infrastructure in a SaaS environment, with accountability for availability and performance.
- Experience coordinating with external technical stakeholders and working with light change management processes.
- Advanced experience configuring and troubleshooting MySQL replication, including primary-replica, multi-master, and GTID setups.
- Ability to resolve replication lag, manage failovers, and execute disaster recovery plans.
- Working understanding of database monitoring tools, measures, thresholds, and response mechanics.
- Deep expertise in query tuning, slow query analysis, and schema optimization, including normalization, partitioning, query rewrites, and indexing.
- Experience executing minimal-downtime upgrades and complex migrations.
- Strong Python and/or Bash scripting skills for building robust, version-controlled automation.
- Experience securing database infrastructure with SSL/TLS encryption, user access control, audit logging, and automated backup encryption.
- Desirable experience with Ansible, Kubernetes or containerized databases, GitLab, monitoring stacks such as Prometheus and Grafana, PostgreSQL, AWS, Apache Druid, Snowflake, Jira, and Confluence.
Responsibilities
- Own daily database operations, including backup management, resolving slow-running queries, and performance tuning.
- Design, secure, and maintain Linux servers supporting distributed databases.
- Plan and deliver database upgrades and migrations, including step-by-step execution plans and stakeholder communication about business impacts.
- Scope incoming work, delegate where appropriate, and act as the database escalation point for support teams.
- Measure and optimize system performance and lead automation of database management and monitoring.
- Work with development teams, product owners, and stakeholders to meet database needs and improve database testability in software deployments.
- Document procedures, best practices, and troubleshooting steps.
- Plan, prioritize, and estimate tasks using Jira, and support critical database issues during and outside normal business hours.
- Coach and mentor engineers on database design, optimization, and migration strategies.
View Full Description & ApplyYou'll be redirected to the employer's site