Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in bengaluru
>
Teamware Solutions
>
MySql Dba With Automation

MySql Dba With Automation

Name: Jobpe
Address: T-Hub, Plot No 1/C, Sy No 83/1, Raidurgam panmaktha, Knowledge City Rd, Hyderabad, Telangana, 500081, IN
Telephone: +91-83339-09630
Price range: Free

Teamware Solutions

3 - 5 years

3 - 12 Lacs

bengaluru karnataka india

Posted:22 hours ago| Platform: Foundit logo

Apply

Skills Required

galera cluster

Work Mode

On-site

Job Type

Full Time

Job Description

Key Responsibilities:
MySQL Database Management:
Install, configure, and maintain MySQL databases in a production environment.
Monitor database health, availability, and performance using tools like
MySQL Enterprise Monitor
,
Percona Monitoring and Management (PMM)
, or similar.
Manage database instances and environments, including
MySQL Cluster
,
Replication
, and
Master-Slave configurations
.
Implement and support
MySQL replication
, including
master-master
and
master-slave
setups.
Ensure proper
database backups
,
restore procedures
, and
disaster recovery plans
are in place and tested regularly.
Troubleshoot and resolve database-related issues, including
performance bottlenecks
,
deadlocks
, and
query optimization
.
Perform regular
health checks
and
security audits
on MySQL systems to identify vulnerabilities and take corrective actions.
Database Performance Tuning:
Identify and resolve performance issues by analyzing and optimizing
queries
,
indexes
, and
schemas
.
Utilize
query optimization techniques
,
EXPLAIN plans
, and
database profiling
to improve performance.
Implement
database partitioning
and
indexing strategies
to enhance performance for large datasets.
Perform
server tuning
to optimize MySQL configurations for various workloads (OLTP, OLAP, etc.).
Automation of Database Tasks:
Develop and implement
automated scripts
for
database backups
,
restores
,
data migrations
, and other routine administrative tasks using tools like
Ansible
,
Puppet
,
Chef
, or
Shell Scripting
.
Automate
database provisioning
,
configuration management
, and
patching
using CI/CD pipelines or orchestration tools.
Set up
monitoring dashboards
and automated alerts for database health, performance, and capacity planning.
Implement
self-healing scripts
and
automated failover mechanisms
for high availability and disaster recovery.
Security & Compliance:
Implement and enforce
database security policies
to ensure data privacy and compliance with relevant regulations (e.g.,
GDPR
,
HIPAA
).
Configure and maintain
user roles
,
permissions
, and
encryption
for data at rest and in transit.
Monitor and audit database activities for unauthorized access, breaches, or other security incidents.
Capacity Planning & Scaling:
Perform
capacity planning
and
database sizing
for both short-term and long-term growth.
Scale MySQL databases as needed, ensuring efficient scaling for increased load or data size.
Implement
horizontal scaling
and
vertical scaling
strategies based on business needs.
Design and implement
sharding
strategies for large datasets, ensuring optimal performance across multiple nodes.
Collaboration & Support:
Work closely with
DevOps
,
Application Development
, and
Infrastructure teams
to design, deploy, and manage MySQL databases in a cloud or hybrid environment (AWS, Azure, GCP, etc.).
Provide
on-call support
for MySQL databases in case of emergencies or incidents.
Assist developers with
SQL optimization
,
database schema design
, and
data-related troubleshooting
.
Support database migrations, version upgrades, and patch management.
Documentation:
Maintain up-to-date documentation for all
database configurations
,
procedures
, and
automation scripts
.
Document best practices, troubleshooting steps, and disaster recovery procedures.
Prepare and present
reports
for database performance, availability, and resource utilization.
Continuous Improvement:
Continuously evaluate new technologies, tools, and best practices in MySQL database administration.
Suggest and implement improvements for
automation
,
efficiency
, and
scalability
of MySQL environments.
Keep up-to-date with the latest MySQL releases, security patches, and industry trends.
Required Qualifications:
Bachelor's degree
in
Computer Science
,
Information Technology
, or a related field.
3-5 years
of experience in
MySQL database administration
.
Strong experience with
MySQL performance tuning
,
query optimization
, and
indexing
strategies.
Proficiency in
database automation
using scripting languages such as
Shell
,
Python
, or
Bash
.
Hands-on experience with
database replication
(Master-Slave, Master-Master) and
high availability
setups (e.g.,
Galera Cluster
,
MySQL Group Replication
).
Experience with
backup and recovery
strategies, including
point-in-time recovery
and
full database restores
.
Familiarity with
cloud platforms
like
AWS
,
Azure
, or
Google Cloud Platform
and managing MySQL databases in these environments.
Experience with
configuration management tools
like
Ansible
,
Puppet
, or
Chef
.
Familiarity with
CI/CD
pipelines and
DevOps practices
.
Strong understanding of
database security
and best practices for securing MySQL environments.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Teamware Solutions

IT Services and IT Consulting

Chennai Tamilnadu

Before You Leave... Find Your Perfect Job!

Login to

Please Verify Your Phone or Email

Confirm Action

Contact Us

MySql Dba With Automation

Experience & Salary

Skills Required

Work Mode

Job Type

Job Description

Key Responsibilities:

MySQL Database Management:

MySQL Enterprise Monitor

Percona Monitoring and Management (PMM)

MySQL Cluster

Replication

Master-Slave configurations

MySQL replication

master-master

master-slave

database backups

restore procedures

disaster recovery plans

performance bottlenecks

deadlocks

query optimization

health checks

security audits

Database Performance Tuning:

queries

indexes

schemas

query optimization techniques

EXPLAIN plans

database profiling

database partitioning

indexing strategies

server tuning

Automation of Database Tasks:

automated scripts

database backups

restores

data migrations

Ansible

Puppet

Chef

Shell Scripting

database provisioning

configuration management

patching

monitoring dashboards

self-healing scripts

automated failover mechanisms

Security & Compliance:

database security policies

GDPR

HIPAA

user roles

permissions

encryption

Capacity Planning & Scaling:

capacity planning

database sizing

horizontal scaling

vertical scaling

sharding

Collaboration & Support:

DevOps

Application Development

Infrastructure teams

on-call support

SQL optimization

database schema design

data-related troubleshooting

Documentation:

database configurations

procedures

automation scripts

reports