MySQL DBA

4 Months ago • 5-6 Years
Programming

Job Description

The MySQL DBA will be responsible for the performance, integrity, security, and availability of MySQL database systems. This involves installing, configuring, and maintaining multiple MySQL database environments, as well as optimizing query performance, implementing backup and recovery strategies, and managing security measures. The role also includes schema management, troubleshooting issues, managing replication and high availability, automating tasks, and collaborating with various teams. The ideal candidate should have experience in managing MySQL databases in both cloud and on-premise environments.
Good To Have:
  • Experience with cloud-based database services (AWS RDS & Aurora MYSQL).
  • Familiarity with database monitoring tools (Monyog, Prometheus, Grafana).
  • Experience with database migration tools and techniques.
  • Knowledge of DevOps practices and CI/CD pipelines.
  • Relevant MySQL certifications.
Must Have:
  • Experience as a MySQL Database Administrator (5-6 years).
  • Experience in managing MySQL databases in Cloud & on-premise environments.
  • Strong understanding of MySQL architecture and storage engines.
  • Proven experience in performance tuning and optimization.
  • Solid experience with database backup and recovery procedures.
  • In-depth knowledge of database security principles.
  • Proficiency in writing and debugging SQL queries.
  • Experience with MySQL replication technologies.
  • Familiarity with Linux/Unix operating systems.
  • Experience with scripting languages (Bash or Python).

Add these skills to join the top 1% applicants for this job

problem-solving
internal-audit
oracle
mysql
linux
aws
unix
azure
prometheus
grafana
nagios
ci-cd
python
sql
bash

Job Summary:

We are seeking a highly skilled and experienced MySQL Database Administrator to join our dynamic technology team. The ideal candidate will be responsible for the performance, integrity, security, and availability of our MySQL database systems. This role requires a proactive individual with a strong understanding of database administration principles, excellent problem-solving skills, and the ability to work independently and collaboratively. You will be involved in all aspects of database management, from design and implementation to maintenance and optimization.

Responsibilities:

  • Database Administration: Install, configure, administer, and maintain multiple MySQL database environments (production, staging, development).
  • Performance Tuning and Optimization: Monitor database performance, identify bottlenecks, and implement effective solutions to optimize query performance, storage, and overall system efficiency.
  • Backup and Recovery: Develop, implement, and test robust backup and recovery strategies to ensure data integrity and business continuity.
  • Security Management: Implement and maintain database security measures, including user access control, auditing, and vulnerability management, in compliance with security policies.
  • Schema Management: Design, implement, and manage database schema changes, including table creation, modification, and indexing, while ensuring data integrity and application compatibility.
  • Troubleshooting and Issue Resolution: Diagnose and resolve database-related issues in a timely and efficient manner, including performance degradation, connectivity problems, and data inconsistencies.
  • Replication and High Availability: Implement and manage MySQL replication topologies (e.g., master-slave, group replication) and other high availability solutions to ensure system uptime.
  • Automation: Develop and implement scripts and automation tools for routine database administration tasks, such as backups, monitoring, and deployments.
  • Collaboration: Work closely with development teams, system administrators, and other stakeholders to understand application requirements and provide database support.
  • Upgrades and Migrations: Plan and execute database upgrades and migrations with minimal downtime.
  • Staying Current: Keep abreast of the latest MySQL features, best practices, and security updates.

Required Skills and Experience:

  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • Minimum of 5-6 years of hands-on experience as a MySQL Database Administrator.
  • Should have a minimum of 2-3 years of experience in managing MySQL databases in Cloud (AWS - RDS/Aurora) & on-premise environments.
  • Strong understanding of MySQL architecture, internals, and storage engines (e.g., InnoDB, MyISAM).
  • Proven experience in performance tuning and optimization techniques, including query analysis, index optimization, Parameters and server configuration.
  • Solid experience with database backup and recovery procedures, including point-in-time recovery.
  • In-depth knowledge of database security principles and best practices.
  • Proficiency in writing and debugging SQL queries and stored procedures.
  • Experience with MySQL replication technologies and high availability solutions.
  • Familiarity with Linux/Unix operating systems.
  • Experience with scripting languages such as Bash or Python for automation tasks.
  • Excellent analytical and problem-solving skills with strong communication and collaboration skills.  
  • Ability to work independently and manage multiple tasks effectively.

Preferred Skills:

  • Experience with cloud-based database services (e.g., AWS RDS & Aurora MYSQL, Azure Database for MySQL, Google Cloud SQL).
  • Familiarity with database monitoring tools (e.g., Monyog, Prometheus, Grafana, Nagios etc.,).
  • Experience with database migration tools and techniques.
  • Knowledge of DevOps practices and CI/CD pipelines will be an added advantage.
  • Relevant MySQL certifications (e.g., Oracle Certified Professional, MySQL Database Administrator) will be an added advantage.

Set alerts for more jobs like MySQL DBA
Set alerts for new jobs by high radius
Set alerts for new Programming jobs in India
Set alerts for new jobs in India
Set alerts for Programming (Remote) jobs

Contact Us
hello@outscal.com
Made in INDIA 💛💙