Position: MySQL Database Administrator

Job Role:

Being part of a Database Administration team, it needs to administer design database schemas, all types of

database objects like tables, views, stored procedures, functions etc for IT projects, including maintaining

databases while ensuring high levels of data availability. The Database Administrator will evaluate and

advise on all technology components for database management systems and applications. They may handle

databases for entire systems as well as for individual applications. Using their analytical and problem-solving

skills, database administrators help companies structure their data in a way where it's an easily accessible,

valid and secure environment. work on continued upgradation of technical artefacts.

Job Description:

●

Core MySQL and MySQL Enterprise monitoring.

●

Installation and configuration and upgradation of MySQL database.

●

User access management for MySQL.

●

Hands-on experience on Linux OS and familiar with basic Linux commands and shell scripts.

●

Data migration, backup, restore & recovery, Resolving performance issues, blocking and deadlocks.

●

Implement and Monitor MySQL Cluster to provide High Availability for mission critical events,

database mirroring, replication and log shipping.

●

Implement and maintain security and integrity controls including backup and disaster recovery

strategies for MySQL databases.

●

Design and create database objects such as data table structures, stored procedures, views,

Triggers, reports, Database Administration, Configuration, Maintenance and Support.

●

Experience in DR Drill activities like switchover and failover.

●

Knowledge of ETL tools like Pentaho Data Integration, Tableau etc

●

Extensive work experience on query optimization, script optimization, other related optimization toolsand techniques including Performance monitoring.

●

Develop, implement, and maintain change control of databases. Ensure all database systems meet

business and performance requirements, including patch management.

Experience.: 2 - 5 yrs of relevant experience

Education : B.Tech/B.E. in Computers, MCA, MS/M.Sc in Computers, M.Tech in Computer Science or IT