Our client based in the Cape Town area are looking for a dedicated Database Administrator to add to their team on a permanent basis

Candidate Responsibilities:
• 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

Technological Capabilities and Experience Required:
• 4+ experience as Production Database Administrator
• 3+ years of experience on writing Linux shell scripts, Perl scripts etc. Languages and Software Packages:
• Bachelor’s degree in Computer Science, Mathematics or equivalent experience
• 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
• The DBA role requires hands-on production database administration skills, deep technical expertise with MySQL and Percona Server
• Sound understanding on installation, configuration, patching, supporting and upgrading MySQL and Percona servers
• Strong understanding on MySQL backup and recovery strategies
• Strong understanding on MySQL replication
• 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, MS SQLServer
• Tools: Percona toolkit, MySQL Utilities
• Development Methodologies: Agile development