DataBase Architect Job at Itransition

Job Description

We are looking for an experienced DataBase Architect to join our team.

Proactively identify database performance problems and resolve them by proposing and delivering changes to the codebase
Providing database expertise to our architects, engineering and data science teams through code reviews, pairing and training to help deliver secure and performant database designs and queries
Review, optimize and refactor the existing database schema
Create and improve documentation
Database security best practices
Database best practices
Workflows and team processes
Long term scalability and architecture planning
Improve tooling to detect performance bottlenecks and security issues, early in the development cycle
Participate in the incident management processes to ensure reliability goals (SLOs) are met by working with the Platform Reliability Team

5+ years of working experience as DataBase Engineer
Significant experience in using MySQL for mission-critical applications
In-depth knowledge of MySQL backup/recovery and replication
SQL and query optimising techniques with a demonstrable ability to both diagnose and prevent performance problems
Assist the development teams with database design and schema modifications
Expert understanding of high-performance MySQL (>50k QPS)
Working knowledge of PostgreSQL, Redis, MongoDB, Snowflake and Clickhouse
Customer focussed
Thrive in a highly collaborative and fast-paced organisation that has office-based, distributed teams and individuals
Proficiency in the English language, both written and verbal, sufficient for success in a remote workplace
You are a good Linux admin

It would be desirable to have a knowledge of MySQL clustering technologies like Galera Cluster
Bonus points if you have knowledge of GCP (We are GCP focussed) or AWS data products and services
Bonus points if you have knowledge of Ansible
Bonus points if you have knowledge of Helm