SQL DBA

Early Applicant

Exp: 4-6 Years

Job Description

Role : SQL DBA

Experience: 4+Years

Location : Bangalore(WFO)

Notice Period: Immediate joiner

Skill Required:

Installation and configuration of MySQL instances on single or multiple ports.
Hands-on experience of working with MysQL 8 and MySQL 5.7 .
Clear understanding of MysQL Replication process flows , threads , setting up multi node clusters and basic troubleshooting.
Understanding of at least one of the backup and recovery methods for MySQL .
Strong fundamentals of SQL and able to understand and tune complex SQL queries when needed.
Strong fundamentals on the linux system side and monitoring tools like top , iostats , sar etc.
At Least couple of years of production hands on experience on medium to big sized MySQL databases.
Setting up and maintaining users and privileges management system and troubleshooting relevant access issues.
Some exposure to external tools like Percona , ProxySQL , HAP etc.
Understand the transaction flowsand ACID compliance.
Basic understanding of networking concepts .
Performing on-call support and should be able to provide the first level support .
Excellent verbal and written communication skills.
Shell scripting to automate basic housekeeping tasks .
Knowledge of Anisble a plus .