DVV130 | MySQL / Oracle / SQL Server DBA

DVV130 | MySQL / Oracle / SQL Server DBA

15 Sep
|
TERRA TECHNOLOGY
|
Bangalore Urban

15 Sep

TERRA TECHNOLOGY

Bangalore Urban

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



Should be able to do POC's 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.

,

The original job offer can be found in Kit Job:
https://www.kitjob.in/job/18952552/dvv130-mysql-oracle-sql-server-dba-bangalore-urban/?utm_source=html

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:
Enter Your E-mail address to receive the latest job offers for: dvv130 | mysql / oracle / sql server dba
Publish a new Free Offer
Need to publish an offer? With more than 1 million unique users per month, you will find the ideal candidate for your company instantly, what are you waiting for!
Publish Now

Subscribe to this job alert