Database Administrator (Percona MySQL)

Database Administrator

Position Overview: We are seeking a highly skilled and motivated Database Administrator (DBA) to join our team. The ideal candidate will collaborate with our partner, a company that focuses on molecular biology, medicinal chemistry, and biotechnology, to improve patient outcomes. Our partner operates a certified clinical laboratory specializing in automated DNA-based molecular analysis of chronic and infectious diseases. The company is also involved in research, drug screening, clinical trials, and academic collaborations to develop complex genetic tests and pre-clinical treatments. The role involves managing and maintaining the database systems that store and process data from various laboratory tests.

Responsibilities

• Database Management: Design, implement, and maintain robust database systems using Percona MySQL PXC cluster solutions with HAproxy and PMM monitoring to ensure efficient storage, retrieval, and management of data related to laboratory tests.
• Performance Monitoring: Utilize PMM monitoring tools to monitor database performance, identify bottlenecks, and take proactive measures to optimize and improve database performance.
• High Availability: Configure and manage HAproxy for high availability and load balancing of the Percona MySQL PXC cluster.
• Data Security: Implement and enforce data security measures to protect sensitive patient information and ensure compliance with relevant regulations (e.g., HIPAA).
• Backup and Recovery: Develop and implement database backup and recovery strategies to ensure data integrity and availability.
• Collaboration: Work closely with the IT team, laboratory staff, and researchers to understand data needs and provide database solutions that support their work.
• Automation: Implement and manage database automation processes to enhance efficiency and reduce manual workload.
• Troubleshooting: Diagnose and resolve database-related issues promptly to minimize downtime and data loss.
• Documentation: Maintain comprehensive documentation of database configurations, processes, and procedures.
• Database Migration: Lead and manage database migration projects, specifically from MySQL version 5.7 to MySQL 8 cluster.

Requirements

• Education: Bachelor’s degree in Computer Science, Information Technology, or a related field. Advanced degree or certifications are a plus.
• Experience: Proven experience as a Database Administrator, preferably in a clinical laboratory, healthcare, or biotechnology setting.
• Technical Skills: Proficiency in Percona MySQL PXC cluster solutions, including configuration and management. Experience with HAproxy for high availability and load balancing. Proficiency in using PMM (Percona Monitoring and Management) for database monitoring and performance tuning. Experience in database migration from MySQL version 5.7 to MySQL 8 cluster. Strong understanding of database architecture, design, and performance tuning. Experience with database security practices and regulatory compliance (e.g., HIPAA). Knowledge of automated database management tools and scripting languages (e.g., SQL, Python, Bash). Familiarity with cloud-based database services and infrastructure (e.g., AWS, Azure).
• Analytical Skills: Strong problem-solving abilities and attention to detail.
• Communication Skills: Excellent verbal and written communication skills, with the ability to explain technical concepts to non-technical stakeholders.
• Team Player: Ability to work collaboratively in a multidisciplinary team environment.
• Adaptability: Flexibility to adapt to evolving project requirements and technologies.

Will Be a Plus

• Experience in managing databases for genetic research, drug screening, or clinical trials.
• Familiarity with laboratory information management systems (LIMS).
• Understanding of molecular biology and medicinal chemistry data requirements.

Mandatory Skills

• Database architecture
• Database security
• Percona MySQL PXC
• HAproxy
• AWS
• Azure

Mandatory Languages

• English

Working Day

• Full Time Job

Working Conditions

• Monthly payments on Payoneer/PayPal/crypto;
• Working schedule: Monday to Friday.
• The position is offered as a freelance contract.
• Days off and vacations are granted upon prior approval from the employer.
  
  
  Contact me on Telegram - @valeria_axiom