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
– Part 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.