Cutshort logo
For Employers
xyz logo
MySQL Database Administrator
xyz
MySQL Database Administrator

MySQL Database Administrator at xyz · Indore · 5 - 6 years · ₹12L - ₹15L / yr · Posted 16 Dec 2023

HR BIZ HUB's logo

MySQL Database Administrator

at xyz

Agency job
5 - 6 yrs
₹12L - ₹15L / yr
Indore
Skills
MySQL DBA
MySQL
DBA
ERD

• Job Description:


MySQL Database Administrator (DBA) who will be responsible for ensuring the

Performance, Database Tuning, Database Cleanup, Database Migration, Database Availability, and Security of Clusters of MySQL

Instances. The candidate will also be responsible for Orchestrating Upgrades,

Backups, and Provisioning of Database Instances. The candidate will also work in

tandem with the other teams, documentation, and specifications as required.

.

• Key Responsibilities:

✓ Provision MySQL instances, both in Clustered and Non-Clustered Configurations

✓ Ensuring the Performance, Database Tuning, Database Availability, and Security

of Clusters of MySQL Instances

✓ Development of Database Schema

✓ Development of ERD

✓ Find the Root Cause of Database related issues & Database Clean-up

✓ Migrating Data from Customer Database to Serosoft Product Database

✓ Prepare Documentation and Specifications

✓ Handle common database procedures, such as upgrade, backup, recovery,

migration, etc.

✓ Profile server resource usage, optimize and tweak as necessary

✓ Collaborate with other team members and stakeholders

• Skills and Qualifications:

✓ Strong proficiency in MySQL database management

✓ Decent experience with recent versions of MySQL

✓ Understanding of MySQL’s underlying storage engines, such as InnoDB and

MyISAM

✓ Experience with replication configuration in MySQL

✓ Proficient in Database Clean-up and Migrations

✓ Knowledge of De-Facto Standards and Best Practices in MySQL

✓ Proficient in Writing and Optimizing SQL statements

✓ Proficient in Table Scan, Row Scan, Query Execution Plan, SQL Profiler, etc.

✓ Should be able to decide when to create Views (Standard Views, Indexed views,

and Partitioned views)

✓ Knowledge of MySQL features, such as its Event Scheduler

✓ Ability to plan Resource requirements from High-Level Specifications

✓ Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc.

✓ Knowledge of limitations in MySQL and their workarounds in contrast to other

popular relational databases

✓ Proficient understanding of code versioning tools such as SVN / Git

✓ DBA Certification would be added advantage

Read more
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos

Similar jobs (1)

Risosu Consulting LLP
at Risosu Consulting LLP
1 candid answer
Vandana Saxena
Posted by Vandana Saxena
Mumbai, Navi Mumbai
4 - 8 yrs
₹6L - ₹8L / yr
MySQL DBA
NOSQL Databases
skill iconPostgreSQL
skill iconMongoDB


Job Description (JD) for the MySQL Database Administrator role

Experience: 4-8 Years 

Location : Mumbai 

Job Title: MySQL Database Administrator 

Responsibilities 

  • Provision and configure MySQL database instances in clustered and non-clustered environments. 
  • Ensure database performance, security, availability, and reliability. 
  • Prepare and maintain database documentation, technical specifications, and operational procedures. 
  • Perform database upgrades, backups, restoration, recovery, and migrations. 
  • Monitor database and server resource utilization and perform performance tuning and optimization. 
  • Manage database users, access privileges, periodic access reviews, audits, and documentation. 
  • Configure, monitor, and troubleshoot MySQL replication. 
  • Collaborate with application, infrastructure, development, and other stakeholder teams to resolve database-related issues. 
  • Provide database and application deployment support, as required. 
  • Perform database backup and restoration validation, data integrity checks, and post-migration validations. 
  • Follow database change management, security, and operational best practices. 


Skills and Qualifications 

  • Strong hands-on experience in MySQL database administration. 
  • Good working knowledge of recent MySQL versions, preferably MySQL 8.x. 
  • Understanding of MySQL storage engines, including InnoDB and MyISAM. 
  • Practical experience in configuring, monitoring, and troubleshooting MySQL replication. 
  • Knowledge of MySQL administration best practices, security, and high availability. 
  • Proficiency in writing, analyzing, and optimising SQL queries. 
  • Experience with MySQL features such as the Event Scheduler, audit logging, and performance monitoring. 
  • Ability to assess database resource requirements based on application workloads and technical specifications. 
  • Familiarity with other SQL and NoSQL databases, such as PostgreSQL and MongoDB. 
  • Understanding of MySQL limitations compared with other relational database platforms and the ability to identify suitable workarounds. 
  • Working knowledge of version control tools such as Git, SVN, or CVS. 
  • Graduate degree in a relevant discipline and good verbal and written communication skills. 


Good to Have 

  • Basic Linux administration, command-line troubleshooting, and Bash scripting skills. 
  • Familiarity with application server frameworks such as JBoss, GlassFish, and WildFly. 


Read more
Why apply to jobs via Cutshort
people_solving_puzzle
Personalized job matches
Stop wasting time. Get matched with jobs that meet your skills, aspirations and preferences.
people_verifying_people
Verified hiring teams
See actual hiring teams, find common social connections or connect with them directly.
ai_chip
Move faster with AI
We use AI to get you faster responses, recommendations and unmatched user experience.
Did not find a job you were looking for?
icon
Search for relevant jobs from 10000+ companies such as Google, Amazon & Uber actively hiring on Cutshort.
companies logo
companies logo
companies logo
companies logo
companies logo
Get to hear about interesting companies hiring right now
Company logo
Company logo
Company logo
Company logo
Company logo
Linkedin iconFollow Cutshort
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos