• MySQL/Oracle/SQL Server DBA Jobs in Bangalore,India - 25309134

  • TERRA TECHNOLOGY
  • Save Job
  • 4 - 9 Years
  • Posted : above 1 month

Job Description:

Responsible for maintaining, installation, configuration and upgrading MySQL databases Good to have knowledge on Oracle, SQL Server Database

Database administration including security, backup, performance-tuning, Disaster recovery and resolve broad range of database related problems on a daily basis working along with team of DBAs

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 in on-call and be available as and when required along with a team of DBAs

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 Linux environment is mandatory

Should be able to do POCs on requirements and new releases independently

Required skills

Should have 4+ years working experience in both MySQL Databases Majority of the experience should be on MySQL 56X and above, MySQL Enterprise Backup (MEB) 38X and above, MySQL Enterprise Monitor 40X and above, Infobright 492 and above [ good to have]

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

Good to have basic understanding of Oracle Database 12c wrt administration and backup, SQL Server

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

Preferred knowledge of monitoring MySQL databases through Nagios/MEM/Zabbix

Good to have knowledge of Installation, configuration and upgrading of Oracle server software and working with Oracle Support

Should be capable to understand and Improve upon the existing and create/update new Documents, standards and best practices

Preferred knowledge of Data modelling tools like DBDesigner/ Erwin / Workbench wrt MySQL databases

Understand requirements and deploy specific configuration databases as and when required by development team

Strong communication skills are necessary for interaction with other teams Should have good presentation skills

Should have experience working with MySQL Enterprise Backup Version 38X and above, MySQL Enterprise Monitor 23X and above, or similar technology on MySQL 56X and above Databases

Should be ready to work on weekend and after-hours deployment tasks as and when required

Good to have knowledge/experience with Percona Toolkit, Ansible

Required experience

Total 4+ years Experience as MySQL DBA, strong shell scripting, Linux command line skills Strong communication and presentation skills Good to have knowledge on Oracle Database & Data modeling tools

Education

Regular Full Time Degree in Engineering, MCA or equivalent from a recognized College/university/institute

Qualifications Skills You are using an unsupported browser To use this site, please use a supported browser,

Profile Summary:

Employment Type : Full Time
Industry : IT - Software
Salary : Not Disclosed
Deadline : 03rd Jun 2020

Key Skills:

Would you like to try out these free online tutorials?

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status