Database Administrator - Cape Town Verfied

Salary Negotiable Cape Town, Western Cape Cape Town, Western Cape more than 14 days ago 22-07-2016 9:33:54 AM
19-08-2016 9:33:54 AM
Database Administrator

Location: Cape Town CBD
Salary: Up to R35k per month

Requirements:
Bachelor’s degree in Computer Science, Mathematics or equivalent experience
Minimum 3+ years’ experience as Production Database Administrator
MySQL backup and recovery strategies
Strong understanding on MySQL replication.
Deep technical expertise with MySQL and Percona Server
3+ years of experience on writing Linux shell scripts, perl scripts etc.
Experience with High Availability MySQL/Percona environments
Experience with workflow engines and creating traceability of data through multiple systems.
Experience with database reporting systems, especially Jaspersoft
Experience working in a software development environment with software configuration management and agile development practices
Sound understanding on installation, configuration, patching, supporting and upgrading MySQL and Percona servers
Should be good with query tuning and performance optimization
Should be good with MySQL stored procedures and functions
Good exposure to Linux operating system
Languages: Linux shell scripting, Perl, Python
Database: MySQL, Percona, MSSqlServer
Tools: Percona toolkit, MySQL Utilities
Development Methodologies: Agile development

Duties:
Estimate database capacities, develop methods for monitoring and maintenance of database instances for data miming and reporting
Review and make recommendations for tuning existing environments
Design and tune new tables and databases create, update maintenance scripts and data import/export processes
Maintain reports in Jaspersoft Deliver ad hoc SQL-based reports combining data from multiple data sources