MySQL Database Administrator - Chennai, India - Genxlead

Description

Job Responsibility:

Responsible for maintaining the company's database systems including back-up, performance tuning, capacity planning, monitoring critical events and documentation.

• Create and manage multiple databases and assist in capacity planning.
• Monitor, maintain database systems and troubleshoot problems that may arise.
• Maintain data integrity and security (manage roles and permissions of database users).
• Fimilar with Tools for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
• Develop strategies and implement solutions for managing backups, restoration and replication.
• Create and manage constraints and indexes.
• Should able to write and optimize exisiting quries.
• Should have good knowlege is quering json dataset (mysql)
• Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
• Proactive archiving and shrinking of databases.
• Manage production, QA and development database environments.
• Create detailed documentation including diagrams of database infrastructure.
• Learn relevant business processes and understand the data flow, criticality and dependencies.
• Effectively coordinate and communicate with all the stakeholders.
• Set up and maintain database infrastructure for the company's BI needs.
• Wellverse with one any RDMS and Big Data sysems.

Salary:
₹300, ₹800,000.00 per year


Benefits:

• Health insurance
• Provident Fund

Schedule:

• Day shift

Application Question(s):

• On a scale of 1 to 10, how would you assess your proficiency as a MySQL Database Administrator (DBA)?
• How many years of experience do you have in MySQL DBA?

Experience:

- total work: 3 years (preferred)


Ability to Commute:

• Chennai, Tamil Nadu (required)

Speak with the employer