Database Administrator
Location - Devon (hybrid role - 1/2 days in the office
We are seeking a highly skilled Database Administrator to join our highly skilled infrastructure team working alongside Cloud and DevOps engineers. The candidate will have expertise in managing and optimizing MySQL databases. The ideal candidate will have experience with multiple database engines, such as MySQL, PostgreSQL, MongoDB, Oracle, SQL Server, or MariaDB, and will be responsible for ensuring high n performance, availability, and security of our production database environments.
Key Responsibilities:
* Database Administration: Manage, maintain, and optimize MySQL databases for high availability and performance.
* Multi-Database Support: As we our cloud posture matures our tech stack is likely to expand to other database engines (e.g., PostgreSQL, Oracle, SQL Server, MongoDB, MariaDB, Redshift, Azure Data Lake) based on business needs.
* Performance Tuning: Monitor database performance, troubleshoot slow queries, and optimize indexes, partitions, and configurations.
* Backup & Recovery: Develop and maintain backup and recovery strategies to ensure data integrity and business continuity.
* Security & Compliance: Implement database security policies, manage user access, and ensure compliance with industry standards (e.g., GDPR, HIPAA).
* High Availability & Replication: Configure and maintain MySQL replication, clustering, and failover mechanisms for high availability.
* Automation & Scripting: Develop scripts using SQL, Python, Bash, or Ansible to automate routine DBA tasks.
* Database Design & Architecture: Collaborate with development teams to design scalable and efficient database schemas.
* Troubleshooting & Incident Response: Respond to database-related issues, perform root cause analysis, and implement corrective actions.
* Documentation & Best Practices: Maintain detailed documentation of database architectures, configurations, and operational procedures.
Required Skills & Qualifications:
* Experience: 5+ years of hands-on experience as a MySQL DBA in production environments.
* Multi-DBMS Expertise: Practical experience with at least one or more other database engines (MySQL, PostgreSQL, MongoDB, SQL Server, Oracle, MariaDB, etc.).
* SQL Proficiency: Strong SQL query optimization and troubleshooting skills.
* Performance Tuning: Experience with tools like EXPLAIN ANALYZE, slow query logs, and MySQL Performance Schema.
* High Availability: Knowledge of replication (Main-Replica, Master-Master), clustering (Aurora, Multi-AZ), and failover solutions.
* Scripting & Automation: Proficiency in Python, Bash, or Ansible for automation and database administration tasks.
* Cloud & DevOps: Experience with AWS RDS, Google Cloud SQL, Azure SQL, Kubernetes, or Docker is a plus.
* Security & Compliance: Understanding of database security principles, encryption, and access controls.
Preferred Qualifications:
* Certifications: MySQL, PostgreSQL, or other database-related certifications.
* Experience with NoSQL: Familiarity with MongoDB, Redis, or Elasticsearch.
* Experience with MapReduce, Hadoop and Big Data methodologies
* Monitoring Tools: Experience with Prometheus, Grafana, DataDog for database monitoring.