SQL DBA

Remuneration:Basic salary 
Location:Cape Town
Type: Permanent
Reference:#1704222
Company:Datafin Recruitment


Our client, an international company with offices in Cape Town specialising in providing digital marketing and reporting tools to their clients, is looking for a SQL DBA to join their team.

Duties:
  • Management and inventory of software licensing for the platform and corporate desktop for databases.
  • Management and operation of Change Control System for software deployments and engineering directed server changes.
  • Business Continuity Plan (includes backup, disaster recovery corporate, and production).
  • Production and Corporate Database Security.
  • Setup, manage, and monitor production and corporate database replication (including Always On and DR Synchronisation), maintenance, and backups.
  • Deployment of change scripts.
  • Management of Jira issues related to database administration.
  • Management of Desk.com cases related to the deployment of change scripts and database performance issues.
  • Analysis of performance of databases.
  • Manage security settings and developer interaction.
  • Manage Encryption of Data.
  • Out of hours’ response on database issues.
  • Preparing systems for SQL Server Installation.
  • Backing up and restoring SQL Server databases.
  • SQL Server Recovery Models.
  • Working with Database Files and File groups.
  • Performance Optimisation and Tuning.
  • DMV Authenticating and Authorising Users.
  • Assigning User/Group Permissions in Active Directory.
  • TDE Transparent Data Encryption.
  • UDM (Unified data model) Production Platforms.
  • Setup and manage always on replication and DR synchronisation.
  • Produce and manage a maintenance plan.
  • Setup, monitor and test a backup plan.
  • Mercury Domain and Other Encore Platforms.
  • Manage security settings and developer interaction.
  • Apply a standard maintenance plan.
  • Setup, monitor and test various customer backup plans.
  • Work on client migration and upgrade plans.
  • Perform customer reviews and performance upgrade tasks.

Maintenance
  • Create and manage a server patching and update programme.
  • Monitoring disk space, memory and other server utilisation.
  • Design and execution of database backup plans.

Documentation
  • Maintain diagrams and other logical and physical database setup details.
  • Record and backup other setup and config.

Support
  • Internal monitoring setup for database operations.
  • Duty rota for management of desk.com ticketing.
  • Out of hours’ backup on database response.

Requirements:

Equipment and software
  • The database administrators need to be conversant and familiar with the following products and software:
  • Windows 2012 and 2008 operating systems.
  • SQLServer 2012. Currently, we have several SQL Server Versions in Use: SQL SERVER 2000, 2005, 2008, 2008 R2, 2012 Standard and Enterprise SQL Server.
  • SQL Server Management Studio.
  • SQL Server Profiler.
  • Windows Performance/Resource Monitor.
  • SQL Server Agent.
  • Windows Power Shell.
  • Cloud Berry
  • SQL Server Data Collector.
  • Windows Active Directory
  • In addition to the SQL Server related products, we have some MySQL and MemSQL databases that also require administration and knowledge of these databases and related tools is important.

Role requirements
  • College degree in computer science with an emphasis on data management.
  • Five years’ experience in large-scale database estates involving several offices and data centres in different countries.
  • Two years’ experience in Cloud Database Administration, specifically OpenStack and AWS.

Databases administered
  • SQL Server 2012 down to 2005.
  • MEMSQL 3.1.
  • MySQL.

While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.

When applying for jobs, ensure that you have the minimum job requirements. Only SA citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence. Please email a Word copy of your CV to and mention the reference numbers of the jobs. We have a list of jobs on http://www.datafin.com.

Posted on 19 Jun 12:06

Apply by email
Taryn Roman

Or apply with your Biz CV
Create your CV once, and thereafter you can apply to this ad and future job ads easily.


More...
For any job-related queries please contact our partner site Bizcommunity.com
on 021 404 1460 or email