MySQL DBA

3 Months ago • 5-6 Years • Programming

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

Pay2 - Engineering Manager (Web Frontend)

Pay2

Gurugram, India (On-Site)
2 Months ago
Escape Velocity Entertainment - IT Systems Engineer

Escape Velocity Entertainment

Czechia (Remote)
2 Months ago
Welltech - CRM Analyst

Welltech

Poland (Remote)
3 Weeks ago
bytedance - Cloud Solutions Technical Account Manager

bytedance

Singapore (On-Site)
4 Months ago
Comscore - Data Scientist

Comscore

Pune, Maharashtra, India (On-Site)
1 Month ago
binance - Senior Java Developer - Exchange Service

binance

Taipei City, Taiwan (Hybrid)
4 Years ago
Autodesk - Manager, Software Development - Global Developer Relations

Autodesk

Vancouver, British Columbia, Canada (On-Site)
2 Months ago
Veeam Software - Junior C# Developer

Veeam Software

Prague, Czechia (On-Site)
2 Months ago
Apollo - Senior Software Engineer, Rust

Apollo

United States (Remote)
1 Month ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

FICO - Senior Manager - AI Engineering - Applied AI

FICO

United States (Remote)
1 Month ago
Sonar Source - Research Engineer

Sonar Source

Singapore (On-Site)
6 Months ago
Visa - Sr. Site Reliability Engineer - ServiceNow

Visa

Ashburn, Virginia, United States (Hybrid)
2 Months ago
PwC - Senior Associate IT Assurance Services

PwC

Makati City, Metro Manila, Philippines (On-Site)
10 Months ago
Syniverse - Senior IT Internal Auditor

Syniverse

San José Province, Costa Rica (On-Site)
1 Year ago
InnoPhase IoT - Staff/Sr. Staff PHY Design Engineer

InnoPhase IoT

San Jose, California, United States (On-Site)
3 Months ago
Shield AI - Staff Electrical Engineer

Shield AI

Dallas, Texas, United States (On-Site)
2 Weeks ago
NinjaVan - Executive, Fulfilment (Customer Success)

NinjaVan

Subang Jaya, Selangor, Malaysia (On-Site)
2 Months ago
Apple - Program Manager, Trust & Safety (Data)

Apple

Cupertino, California, United States (On-Site)
1 Month ago
Synechron - Generative AI Testing & Prompt Engineer

Synechron

Bengaluru, Karnataka, India (On-Site)
1 Month ago

Get notifed when new similar jobs are uploaded

Jobs in Hyderabad, Telangana, India

Bazaar Voice - Senior Product Designer

Bazaar Voice

Bengaluru, Karnataka, India (Hybrid)
3 Months ago
PwC - Senior Associate – Business Analyst

PwC

Mumbai, Maharashtra, India (On-Site)
3 Weeks ago
Qube Cinema - Engineer - Technical Operations (QCN)

Qube Cinema

Chennai, Tamil Nadu, India (On-Site)
3 Months ago
Capgemini - Engagement Executive-Marketing Operations

Capgemini

Kolkata, West Bengal, India (On-Site)
3 Months ago
Qualcomm - Customer Engineer

Qualcomm

Chennai, Tamil Nadu, India (On-Site)
3 Months ago
Capgemini - M&C Subject Matter Experts

Capgemini

Mumbai, Maharashtra, India (On-Site)
2 Months ago
PhonePe - Senior Business Operations Analyst, Payments

PhonePe

Bengaluru, Karnataka, India (On-Site)
2 Months ago
Ceragon Networks - Verification and Validation Engineer

Ceragon Networks

Bengaluru, Karnataka, India (On-Site)
1 Month ago
Brillio - .NET Azure Architect - R01525011

Brillio

Pune, Maharashtra, India (Hybrid)
9 Months ago
Interactive Brokers - Software Engineer

Interactive Brokers

Mumbai, Maharashtra, India (Hybrid)
3 Months ago

Get notifed when new similar jobs are uploaded

Programming Jobs

perfect garbage studios - Senior Programmer

perfect garbage studios

(Remote)
8 Months ago
Capgemini - API Integrations - REST, SOAP, Powershell, Java, Selenium

Capgemini

Pune, Maharashtra, India (On-Site)
3 Months ago
luxsoft - Senior C++ Developer

luxsoft

Toronto, Ontario, Canada (On-Site)
2 Months ago
Roof Stacks - Software Developer

Roof Stacks

Istanbul, İstanbul, Türkiye (On-Site)
4 Months ago
Roblox - Engineering Manager, Programming Languages & Compilers

Roblox

San Mateo, California, United States (On-Site)
1 Month ago
albi online  - Software Developer

albi online

Berlin, Berlin, Germany (Hybrid)
1 Month ago
Integrant - Senior Software Engineer - Java

Integrant

Cairo, Cairo Governorate, Egypt (Hybrid)
3 Weeks ago
bohemia interactive - C++ Programmer

bohemia interactive

Prague, Prague, Czechia (On-Site)
2 Weeks ago
Nice - Specialist Software Engineer (.Net)

Nice

Pune, Maharashtra, India (Hybrid)
1 Month ago
Canonical - Senior Software Engineer - Python/MongoDB

Canonical

(Remote)
2 Months ago

Get notifed when new similar jobs are uploaded

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.

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