We are looking for an experienced Database Administrator to join our team in St. Augustine, Florida. This long-term contract role focuses on managing and optimizing MySQL databases while ensuring security, scalability, and performance across infrastructure and database layers. The ideal candidate will have a strong understanding of architecture, security engineering, and Linux-based systems, combined with a proactive approach to problem-solving.<br><br>Responsibilities:<br>• Monitor system resources, including memory and disk I/O, to identify potential bottlenecks and recommend hardware upgrades or resizing as needed.<br>• Configure and optimize Linux kernel settings and storage parameters to improve MySQL database performance.<br>• Design and implement high availability and disaster recovery solutions, such as Group Replication or InnoDB Cluster, to meet recovery objectives.<br>• Perform database tuning by adjusting variables like buffer pool size, max connections, and thread caches to minimize latency.<br>• Enforce role-based access control and connection security measures to ensure compliance with cybersecurity frameworks.<br>• Configure audit logs to monitor database activity and identify security anomalies.<br>• Develop automated maintenance processes for backups, log rotations, and statistics gathering.<br>• Provide expert guidance on schema design, including normalization and denormalization strategies for optimal data structure efficiency.<br>• Analyze slow query logs to identify indexing opportunities and optimize query performance.<br>• Advise on implementing data integrity measures like foreign keys, triggers, and constraints to ensure consistent data validation.
