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
- Minimum of 5 years of experience as a MariaDB or MySQL Database Administrator.
- Experience with Snowflake, MongoDB, DocumentDB, PostgreSQL, Redshift, ProxySQL, and Elasticsearch is highly desirable.
- Knowledge of Mesos and Zookeeper is a plus.
- Technical Skills:
- Proficiency in using Percona Toolkit tools.
- Experience with hotcopy backup tools like MariaBackup.
- Strong understanding of database replication and troubleshooting within MariaDB clusters with Galera and traditional Primary and Replica schemes.
- Expertise in query optimization and performance tuning.
- Familiarity with monitoring tools such as Datadog and Percona Monitoring and Management (PMM).
- Knowledge of stored procedures, functions, and triggers.
- Extensive experience working with Linux operating systems.
- Experience with managing AWS RDS and EC2 database instances.
- Strong analytical and problem-solving skills with the ability to troubleshoot complex database issues.
- 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.