MySQL DBA

1 Month ago • 5-6 Years

Job Summary

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.
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).
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.

Job Details

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.

Similar Jobs

Scanline VFX - Modeler

Scanline VFX

Seoul, South Korea (Hybrid)
7 Months ago
CME Group - Data Center - Infrastructure Engineer III

CME Group

Aurora, Illinois, United States (On-Site)
2 Weeks ago
bytedance - Seller/Account Management Intern, FMCG Beauty (Philippines)

bytedance

Taguig, Metro Manila, Philippines (On-Site)
1 Month ago
Coherent corp. - IT Site Administrator/ISSO

Coherent corp.

Philadelphia, Pennsylvania, United States (On-Site)
1 Month ago
bytedance - Data Engineer - Global Payment - Singapore

bytedance

Singapore (On-Site)
7 Months ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

HoYoverse - Product Manager, AI-Powered Services

HoYoverse

Singapore, Singapore (On-Site)
1 Month ago
N-ix - Solutions Architect

N-ix

Ukraine (Hybrid)
1 Day ago
GoTo Group - Software Engineer - Data Science Platform

GoTo Group

Jakarta, Jakarta, Indonesia (On-Site)
7 Months ago
HP - Data Analyst Internship

HP

Sant Cugat Del Vallès, Catalonia, Spain (On-Site)
2 Weeks ago
Google - Customer Solutions Engineer

Google

New York, New York, United States (On-Site)
1 Month ago
Nintendo - Software Engineer - Console and PC Games, C++

Nintendo

Miami, Florida, United States (On-Site)
2 Months ago
Qualcomm - Technical Account Manager (m/f/d)

Qualcomm

Munich, Bavaria, Germany (On-Site)
3 Weeks ago
Saviynt - Technical Lead, Professional Services

Saviynt

Atlanta, Georgia, United States (Remote)
7 Months ago
Varonis  - MDDR Team Lead

Varonis

Raleigh, North Carolina, United States (On-Site)
2 Weeks ago
Sailpoint - Manager, Engineering

Sailpoint

Pune, Maharashtra, India (On-Site)
1 Month ago

Get notifed when new similar jobs are uploaded

Jobs in Hyderabad, Telangana, India

Zones - Senior Application Support Engineer

Zones

Hyderabad, Telangana, India (On-Site)
3 Months ago
Ruselle Investments - Analyst, Active Ownership

Ruselle Investments

Mumbai, Maharashtra, India (On-Site)
1 Month ago
Interactive Brokers - Operation Analysts

Interactive Brokers

Mumbai, Maharashtra, India (Hybrid)
4 Weeks ago
Autodesk - Senior Software Engineer, Salesforce

Autodesk

Bengaluru, Karnataka, India (On-Site)
2 Weeks ago
Capgemini - Project Manager

Capgemini

Mumbai, Maharashtra, India (On-Site)
1 Month ago
GHX - Content Specialist

GHX

Hyderabad, Telangana, India (On-Site)
1 Month ago
warner bros games - Staff Software Engineer - Golang - QoE Platform

warner bros games

Bengaluru, Karnataka, India (Hybrid)
3 Months ago
Capgemini - Lead Front End Engineer - React.Js

Capgemini

Bengaluru, Karnataka, India (On-Site)
1 Week ago
Digicore studios - Lead Generation Specialist

Digicore studios

Pune, Maharashtra, India (On-Site)
2 Months ago
Reltio - Senior Staff Engineer

Reltio

Bengaluru, Karnataka, India (Hybrid)
1 Week ago

Get notifed when new similar jobs are uploaded

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

We are Pragmatists. Today, there are 3 distinct types of companies: the Pretenders, the Fairytale Startups, and the Pragmatists. At our core, we embody the latter. We prefer to keep it real. Unlike the Pretenders, we want our core values to guide decisioning and show up in the way people think, feel and act on a daily basis. Instead of being a Fairytale Startup, we want our people to think of us as their work home away from home (not a theme park) and to feel that they are making a huge impact. Our employees use their creativity and talent to invent new solutions, meet demands, and offer the most effective services/products.

Houston, Texas, United States (On-Site)

Hyderabad, Telangana, India (On-Site)

Houston, Texas, United States (On-Site)

Houston, Texas, United States (On-Site)

Hyderabad, Telangana, India (On-Site)

Hyderabad, Telangana, India (On-Site)

Hyderabad, Telangana, India (On-Site)

Hyderabad, Telangana, India (On-Site)

Hyderabad, Telangana, India (On-Site)

Amsterdam, North Holland, Netherlands (On-Site)

View All Jobs

Get notified when new jobs are added by high radius

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug