Connecting...

W1siziisinrozw1lx2fzc2v0cy9wzw9wbgvzb2x2zwqvanbnl2jhbm5lci1kzwzhdwx0lmpwzyjdxq

Database Administrator

Database Administrator

Job Title: Database Administrator
Location: Western Cape
Industry:
Salary: 65000.00
Reference: JN -032017-8029
Job Published: June 08, 2017 08:10

Job Description

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 the team and assist the company in maintaining our data.
 
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.