DBA MySQL Professional

Job Description

Requierements: must be proficient in SQL, the language used to interact with databases. MySQL Knowledge: The DBA must have a thorough understanding of MySQL, including its architecture, configuration options, and administration processes. Operating System Knowledge: The DBA must have a basic understanding of the operating systems on which MySQL runs. Troubleshooting Skills: The DBA must be able to efficiently identify and resolve problems. Communication Skills: The DBA must be able to communicate effectively with other team members. Tools Used by a MySQL DBA Responsabilities: Review PHPMySQL connector compatibility (e.g., mysqli, PDO). Identify queries or schema features affected by upgraded MySQL or PHP drivers. Verify character sets, collations, and default behaviors (e.g., strict mode). Capture current query performance (slow query logs, index usage). Establish a baseline for performance before the upgrade. Set up monitoring (e.g., with Percona, PMM, or MySQL Enterprise Monitor). Assist devs in optimizing queries affected by refactoring (e.g., ORM usage). Create or update indexes to improve performance post-upgrade. Help design schema updates if required during modernization. Ensure backup mechanisms are in place and tested (logical + physical). Validate rollback procedures for staging and production environments. Coordinate DB snapshotting before critical deployments. Review MySQL version and patch level for compatibility and vulnerabilities. Audit user permissions and tighten access controls if needed. Required Languages: English Fluent Advanced 96-100%. Job location(s): Hybrid, Mexico.