What are the responsibilities and job description for the Senior MySQL Database Administrator position at e.biT Consulting?
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
● 5 years of experience as a Database Administrator.
● Prior experience in the financial industry is a plus.
