MySQL DBA - Cape Town
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.)