Database Administrator @ Factentry Data

Job Description

Role Title : Database administrator (MySQL) Experience : 4 - 5 Years Location : Chennai ( Vanagaram) Work Mode : Work from office Job Responsibility: (What you do) Responsible for maintaining the companys database systems including back-up, performance tuning, capacity planning, monitoring critical events and documentation.(MySQL Database administration) 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). Familiar with Tools for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them. Develop strategies and implement solutions for managing back-ups, restoration and replication. Create and manage constraints and indexes. Should able to write and optimize existing queries. Should have good knowledge is querying 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 companys BI needs. Well-versed with one any RDBMS and Big Data systems. Must Have skills : (What we need) User Creation ; Mysql Installation and upgrade Mysql Constraints; Replication Concepts and troubleshooting ; Complex Queries; Query Optimization; Indexing ;BACKUP AND RESTORE ; Slow query concepts MYSQL Configuration Setup ;Reading Binlog and relay log ; Performance tuning

Employement Category:

Employement Type: Full time
Industry: Others
Role Category: Others
Functional Area: Not Applicable
Role/Responsibilies: Database Administrator

+ View Contact

Keyskills:   MySQL Database administration Capacity planning Performance tuning Data integrity Security management Database tuning Query optimization SQL development Stored procedures Archiving RDBMS JSON dataset querying Shrinking databases BI infrastructure setup Big Data systems