Database Administrator (DBA)

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

Salary

• $25 - $30 per hour 
  

Working Day

• Part Time Job (up to 70 hours per month)

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.