MySQL / Oracle / SQL Server DBA

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 5.6.X and above , MySQL Enterprise Backup (MEB) 3.8.X and above , MySQL Enterprise Monitor 4.0.X and above , Infobright 4.9.2 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 w.r.t 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] 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 w.r.t 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 3.8.X and above , MySQL Enterprise Monitor 2.3.X and above , or similar technology on MySQL 5.6.X 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.,

Keyskills :
mysql linux erwin basic sql bash perl uat oot os disk qa