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.
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
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
Megan Förg Consulting is a Permanent and Contract Recruitment Consultancy providing recruitment solutions to clients and candidates both locally and internationally.
Our primary business objective is to know our clients and candidates. Networking and growing our candidate database enables us to provide top talent to the marketplace. With a solid recruitment background in various disciplines, we’re able to provide you with candidates from the IT, Finance, HR, Office Support, Digital, and Engineering/Technical industries.
Being a privately owned company, we provide a solution which is tailor-made to suit each individual client’s needs. Professionalism, honesty and efficiency are of utmost importance to us, and our goal is to build longstanding business relationships with both our clients and candidates. Our candidates are sourced, screened and referenced, and additional verification checks can be done as per client requests.