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%