Database Administrator - Cape Town Verfied

Salary Negotiable Cape Town, Western Cape Cape Town, Western Cape more than 14 days ago 26-02-2017 9:04:42 PM
26-03-2017 9:04:42 PM
Database Administrator
Century City, Cape Town
 
Core Functions:
  • 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
 
Education & Qualification:
  • Bachelor’s degree in Computer Science, Mathematics or equivalent experience
 
Preferred Skills & 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
 
Competencies:
  • Extremely analytical oriented and paranoid about attention to detail.
  • Conceptual thinker, problem-solving and solution driven.
  • Ability to find gaps in data collection.
  • Good communication skills with data team required.
  • Team player.
  • Can take instructions well and manage timelines according to business needs.
  • Excellent communication skills (verbal and written).
  • 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.

Recruiter: CompuJobs