MySQL DBA - Cape Town Verfied

R 240000-480000 per annum Cape Town, Western Cape Cape Town, Western Cape more than 14 days ago 28-04-2016 8:27:16 AM
26-05-2016 8:27:16 AM
Our client is focused on bringing innovative payment solutions to merchants and end consumers. Their aim is facilitating E-commerce in Southern Africa and Africa by providing the most effective online and mobile payment solutions to their consumers and target markets.


Qualification:

BSc Computer Science or equivalent


Skills & Experience:

5 years’ experience as a DBA or equivalent

Demonstrated experience with relational database physical design

Demonstrated experience with relational database performance tuning and capacity planning especially on MySQL based environments

Experience with Open Source/Linux development and production environment is CRITICAL

MS SQL experience advantageous



Job Description:

Develop and support MySQL database replication, optimize MySQL database performance

Estimate MySQL database capacities; develop methods for monitoring database capacity and usage

Establish mechanisms for data backup/restore of relational databases; give restoration services as needed

Develop and optimize physical design of MySQL database systems

Develop application-specific fault-tolerant distributed database mechanisms

Work with Developers to apprve schema changes

Write ad-hoc BI reports

Implement the database design

Create database objects (tables, indexes, etc.)

Write database procedures, functions and triggers

Assist Developers with database activities

Documentation of existing schemas

Consolidation of existing schemas (Patches etc.)

Tools/Plan for data generation (Functional/Integration and Load testing

Experience with code and database migration/management through various stages of the development life cycle

Ability to understand business domain/process working with cross functional teams (Application, DBA, Release etc.)