MySQL DBA
Location: Noida, Uttar Pradesh, India
Experience Required: 4+ Years
Job description :
- Database administration including security, backup, performance-tuning, Disaster recovery and resolve a broad range of database related problems on a daily basis working along with a team of DBA's.
- Work with developers in defining optimal database architecture, optimizing SQL queries and overall performance tuning.
- Building strategy for maintenance and migration/upgrade from DEV to UAT and PROD.
- Thorough understanding of disaster recovery, planning and implementation.
- Have knowledge of monitoring MySQL instances, Innodb engine, capacity planning of databases and forecast required H/W, software licenses.
- Work with QA, deployment team and Product Management to understand requirements and work on database patch on UAT and production.
- Work on-call and be available as and when required along with a team of DBA's.
- Monitor and optimize MySQL database performance and capacity planning.
- Establishing and testing disaster recovery policies and procedures.
- Root cause analysis of database related issues.
- Ability to detect and troubleshoot DB Server related CPU, memory, I/O, disk space and other resource contention.
- Understanding of OS, network, Storage, memory, OS variables primarily on Linux Platform primarily. Thorough working experience in the Linux environment is mandatory.
- Should be able to do POC's on requirements and new releases independently.
Skill Sets Requirement :
- Should have 4+ years working experience in both MySQL Databases. Majority of the experience should be on MySQL 5.6.X and above.
- Experience working in large [50+] database instance environments with size ranging up-to 1TB having Master-Slave replications, group replication, InnoDB Cluster and DB Upgrades.
- Should have thorough knowledge of MySQL replication topologies.
- Familiar with InnoDB engine and performance tuning related to InnoDB engine.
- Understand existing Backup and Design and Implement various MYSQL backup/recovery strategies
- Should have thorough knowledge of shell scripting. Should have worked on complex shell scripts [any of bash/Perl/python/C]
- Should have working knowledge on one of Ansible/Chef/Puppet for automating DB related tasks.
- Should be capable to understand and Improve upon the existing and create/update new Documents, standards and best practices.
- Understand requirements and deploy specific configuration databases as and when required by the development team.
- Strong communication skills are necessary for interaction with other teams. Should have good presentation skills.
- Should be ready to work on weekend and after-hours deployment tasks as and when required