Database Administrator (MS SQL)

Permanent
Cape Town
Posted 3 weeks ago

Job Level: Intermediate

This position will report to the Network Operations Centre Manager and will work closely with all senior team members of the IT Department.

The focus of the Database Administrator (DBA) is to see to the regular maintenance, health and integrity of all centralised database systems. In addition, we expect you to contribute ideas, identify opportunities, suggest solutions and share expert knowledge within our team.

 

Database Administration

  • Ensure day-to-day availability of all SQL databases;
  • Ensure daily backups of all databases are done properly;
  • Conduct frequent DR failover and testing exercises across all DBs;
  • Apply patches and upgrades as/when required;
  • Ensure the security of data is maintained at all times;
  • Regularly audit user access to all DBs;
  • Conduct daily routine tasks including health/sanity checks;
  • See to the regular and complete execution of all DB schedules, tasks and jobs;

 

Database Optimization

  • Conduct regular database performance tuning;
  • Manage large tables and archive and/or partition and/or truncate as required;
  • See to the placement of files on correct/most appropriate storage types;
  • Provide support and advice to development team for new and existing SQL code and/or queries;
  • Identify poorly performing procedures and/or functions;
  • Proactively make suggestions and implement actions/projects to ensure the appropriate environment for all DBs to perform optimally;
  • Automate repetitive tasks;

 

Database Requests

  • Service any data movement/supply requests securely, accurately, and timeously;
  • Maintain and manage all reporting requests;
  • Provide 3rd line support for DB-related issues/queries where needed;

 

Skills Required

  • Minimum 3 years MS-SQL DBA experience;
  • Strong working knowledge of SQL Server and T-SQL;
  • Knowledge of SSRS / SSIS / SSAS / Replication;
  • Firebird knowledge advantageous but not a necessity;
  • Strong scripting experience;
  • Solid working experience of Windows Server operating system;
  • Solid understanding of database design and architecture;
  • Excellent verbal and written skills;

 

Deadline for applications is 28/02/2019

For more information, call Nova Buchan on 073 393 9731 or send your CV to  Nova@capitaledgerecruitment.co.za

 

Job Features

Job CategoryInformation Technology

Apply Online

A valid email address is required.
A valid phone number is required.