Database Administrator

  • Megan Forg Consulting
  • Cape Town, Western Cape, South Africa
  • Mar 15, 2017
Permanent Information Technology

Job Description

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

Job Level

Skilled

Salary Range

R30 000 - R40 000 per month