Location: Cape Town, CBD
Salary: R35k per month

Our client seeks a DBA for a permanent role based in Cape Town, CBD.

Purpose of Role:
The high volume of transactional / operational data together with very detailed analytical marketing effectiveness statistics provide the ideal opportunity for an experienced Database Administrator to join our client and assist them in maintaining their data.

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

Requirements:
Bachelor’s degree in Computer Science, Mathematics or equivalent experience
Minimum 3 years’ experience as Production Database Administrator
3+ years of experience on writing Linux shell scripts, perl scripts etc. Languages and Software Packages:
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, MSSqlServer
Tools: Percona toolkit, MySQL Utilities
Development Methodologies: Agile development
Extremely analytical oriented and paranoid about attention to detail
Strong computer literacy on MS Office suite and an advanced/expert Excel user
Highly self-motivated and able to work under pressure and to tight deadlines