MySQL DBA

2 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

Marvell - Package Development, Signal Integrity and Power Integrity Engineer, Senior Staff

Marvell

Austin, Texas, United States (On-Site)
1 Month ago
Nordson Corporation - Area Sales Manager

Nordson Corporation

Reims, Grand Est, France (On-Site)
2 Months ago
Any Desk - Software Developer C++

Any Desk

Stuttgart, Baden-Württemberg, Germany (On-Site)
1 Month ago
Next Level Business Services - Mule Admin

Next Level Business Services

Thousand Oaks, California, United States (On-Site)
8 Months ago
Rockstar Games - Procedural Motion Animation Programmer (Mid / Senior Level)

Rockstar Games

Oakville, Ontario, Canada (On-Site)
2 Months ago
Synechron - Senior Core Java Developer

Synechron

New York, United States (On-Site)
1 Week ago
NXP - Embedded Software Developer - Student

NXP

Brno, South Moravian Region, Czechia (On-Site)
9 Months ago
Next Level Business Services - .NET Developer

Next Level Business Services

New York, New York, United States (On-Site)
8 Months ago
Single Store - Software Engineer, Query Processing (C/C++)

Single Store

Hyderabad, Telangana, India (Hybrid)
1 Week ago
Nice - Senior Specialist Software Engineer (C++, Domain)

Nice

Pune, Maharashtra, India (Hybrid)
1 Week ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

The Embassy VFX - Pipeline Developer

The Embassy VFX

Vancouver, British Columbia, Canada (Hybrid)
4 Months ago
bounteous - Murex Integration Developer

bounteous

New York, United States (On-Site)
2 Weeks ago
version 1 - Senior Azure Administrator

version 1

Birmingham, England, United Kingdom (On-Site)
3 Weeks ago
Google - Software Engineer III, Mobile, Android

Google

Bengaluru, Karnataka, India (On-Site)
8 Months ago
Ion - Senior Software Engineer, Italy

Ion

Pisa, Tuscany, Italy (On-Site)
9 Months ago
NVIDIA - System Design Power Validation Engineer

NVIDIA

Taipei City, Taiwan (On-Site)
2 Months ago
Amber - Customer Support Agent with English and Chinese

Amber

Montreal, Quebec, Canada (Remote)
1 Month ago
Like Card - Customer Service Senior Supervisor – Chat, Social Media & Call Center

Like Card

Istanbul, İstanbul, Türkiye (On-Site)
1 Month ago
Nintendo - Intern - Retail Marketing & Strategy

Nintendo

Redmond, Washington, United States (On-Site)
8 Months ago
Redhorse Corp - Secure Communications SME III

Redhorse Corp

Arlington, Virginia, United States (On-Site)
1 Week ago

Get notifed when new similar jobs are uploaded

Jobs in Hyderabad, Telangana, India

level ai - Senior FullStack Engineer - Virtual Agent

level ai

Noida, Uttar Pradesh, India (Hybrid)
2 Months ago
Optiv - Senior Analyst- Soc

Optiv

Bengaluru, Karnataka, India (On-Site)
1 Month ago
Capgemini - SAP Global Trade Services (GTS) Consultant

Capgemini

India (On-Site)
1 Month ago
Testee investment Pvt Ltd. - Head of Quantitative Research & Analysis

Testee investment Pvt Ltd.

Kolkata, West Bengal, India (On-Site)
10 Months ago
zeta - Director Marketing, Consumer Fintech

zeta

Bengaluru, Karnataka, India (On-Site)
2 Months ago
Tide - Lead Data Scientist

Tide

Hyderabad, Telangana, India (Hybrid)
1 Month ago
DNEG - Animator (DNEG Animation)

DNEG

Bengaluru, Karnataka, India (On-Site)
8 Months ago
Capgemini - Mechanical & Physical Engineer

Capgemini

Hyderabad, Telangana, India (On-Site)
1 Month ago
Loyalty Juggernaut - Quality Assurance Specialist (Manual Testing)

Loyalty Juggernaut

Hyderabad, Telangana, India (On-Site)
7 Months ago
SparkCognition - Software Engineer (Scala_Backend)

SparkCognition

Bengaluru, Karnataka, India (On-Site)
9 Months ago

Get notifed when new similar jobs are uploaded

Programming Jobs

Nagarro - Senior Engineer, Java

Nagarro

India (Remote)
8 Months ago
5minlab - Client Programmer

5minlab

Seoul, South Korea (On-Site)
6 Months ago
CGS Carrers - Senior Java Software Engineer

CGS Carrers

Indonesia (Remote)
2 Months ago
Ion - Software Developer Cobol/Cics/DB2, Italy

Ion

Italy (Hybrid)
9 Months ago
PwC - Manager - Insurance Consulting (P&C Retail & Commercial)

PwC

Zürich, Zurich, Switzerland (On-Site)
9 Months ago
GoDaddy - Senior Software Developer

GoDaddy

Iași, Iași County, Romania (Remote)
1 Month ago
Sailpoint - Senior Java Software Engineer

Sailpoint

Mexico City, Mexico (Remote)
1 Month ago
Ninja theory - Programming

Ninja theory

Cambridge, England, United Kingdom (On-Site)
2 Weeks ago
luxsoft - Senior Software Developer - Hogan ODS

luxsoft

(Remote)
3 Weeks ago
Capgemini - Golang Dev

Capgemini

Bengaluru, Karnataka, India (On-Site)
1 Month 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.

Hyderabad, Telangana, India (On-Site)

Hyderabad, Telangana, India (On-Site)

Houston, Texas, United States (On-Site)

United States (Remote)

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)

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