описание
We are looking for an experienced Senior Database Administrator (DBA) to optimize, maintain, and improve our MySQL 8.0 databases hosted on Oracle Cloud Infrastructure (OCI). The ideal candidate is proactive, highly skilled in database performance optimization, and capable of identifying weaknesses in existing database structures and processes.
задачи
- Identify and resolve slow queries and database performance bottlenecks.
- Analyze and optimize existing indexes, identify missing, redundant, or inefficient indexes.
- Review database schemas and recommend structural improvements.
- Monitor resource utilization, locking, concurrency, and overall database performance.
- Perform regular database health checks and performance audits.
- Evaluate large tables and recommend partitioning where appropriate.
- Design and implement archiving strategies to reduce production database size and improve performance.
- Develop data retention and cleanup procedures.
- Recommend scalable database architecture improvements.
- Design and automate reliable Production → Development/QA database synchronization processes.
- Establish consistent backup, recovery, and database refresh procedures.
- Minimize production impact during synchronization and maintenance.
- Implement proactive monitoring, performance tracking, and alerting.
- Manage MySQL updates, patches, upgrades, and compatibility.
- Investigate production database incidents and implement preventive measures.
- Maintain database security, reliability, and availability.
- Document database architecture, maintenance processes, and optimization improvements.
требования
- 5+ years of experience in database administration and optimization.
- Strong hands-on expertise with MySQL 8.0.
- Advanced knowledge of SQL query optimization, EXPLAIN, indexing strategies, and database performance analysis.
- Experience managing large production databases.
- Strong understanding of partitioning, archiving, replication, backup, and recovery.
- Experience implementing automated database synchronization processes.
- Ability to independently identify issues, propose solutions, and implement improvements.
- Strong troubleshooting and analytical skills.
- Будет плюсом: Experience with Oracle Cloud Infrastructure (OCI), especially OCI MySQL Database Service; Experience with cloud database monitoring and high-availability configurations; Linux administration and scripting skills; Knowledge of CI/CD pipelines and automated database deployments; Experience with AWS RDS or other cloud-managed database services
условия
- Условий в вакансии нет