Database Administrator (MySQL / MariaDB)

Database Administrator (DBA)
The Database Administrator is responsible for designing, testing, planning, implementing, protecting,
operating, managing, and maintaining the company s databases.
Roles and Responsibilities
Administer, maintain, and optimize MariaDB servers to ensure high availability, scalability, and
performance.
Manage backups using tools like MariaBackup to ensure data integrity and availability.
Configure and manage database replication with MariaDB servers.
Perform query optimization and performance tuning to ensure efficient database operations.
Utilize monitoring tools such as Datadog and Percona Monitoring and Management (PMM) to
proactively identify and resolve database issues and for routine monitoring and alerting.
Develop and maintain stored procedures, functions, and triggers to support application
requirements.
Use utilities from the Percona Toolkit like pt-online-schema-changer and pt-archiver.
Manage MariaDB clusters running on both bare metal and cloud environments, particularly
Amazon AWS.
Work extensively with Redhat derived Linux operating systems for installation, configuration, and
management.
Document database configurations, processes, and best practices to ensure knowledge sharing
and continuity.
QUALIFICATIONS
Experience
o Minimum of 5 years of experience as a MariaDB or MySQL Database Administrator.
o Experience with Snowflake, MongoDB, DocumentDB, PostgreSQL, Redshift, ProxySQL,
and Elasticsearch is highly desirable.
o Knowledge of Mesos and Zookeeper is a plus.
Technical Skills:
o Proficiency in using Percona Toolkit tools.
o Experience with hotcopy backup tools like MariaBackup.
o Strong understanding of database replication and troubleshooting within MariaDB
clusters with Galera and traditional Primary and Replica schemes.
o Expertise in query optimization and performance tuning.
o Familiarity with monitoring tools such as Datadog and Percona Monitoring and
Management (PMM).
o Knowledge of stored procedures, functions, and triggers.
o Extensive experience working with Linux operating systems.
o Experience with managing AWS RDS and EC2 database instances.
o Strong analytical and problem-solving skills with the ability to troubleshoot complex
database issues.
o Excellent verbal and written communication skills, with the ability to document
processes and communicate effectively with technical and non-technical stakeholders.
Technologies
CentOS and other Redhat derived Linux distributions.
Amazon AWS and other cloud environments.
Terraform infrastructure management.
Ansible configuration management.
Atlassian collaboration software.
Experience and Education
4 year college degree or a minimum of 5 years of experience as a Database Administrator.
Prior experience in the financial industry is a plus.