Database Administrator

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.