IT Full-Time Job ID: DGC00693
Chennai, Tamil Nadu 5-6 Yrs ₹5.25 - ₹07 Yearly
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%