Jobs

Job title: Database Administrator
Employment type: Full Time
Experience: 5 to 7 years
Salary: Negotiable
Job published: 13 August 2021
Job reference no: 968194934

Job Description

Database Administrator

Highly attractive market related salary

Cape Town

Excellent career opportunity with a leader in the Financial Services industry. This role will be responsible for the implementation, maintenance and repair of the company's databases, monitoring and improving database performance and capacity, assist in planning for future expansion requirements, coordinate and implement security measures to safeguard the database.

The focus of the role will primarily be on OLTP, including performance management and secondly assisting with design and development as well as the coordinating and communicating of deployments to production.

Key Performance Areas:

  1. Database Administration
  • Co-ordinates the effective management of the database environment
  • Facilitates best possible system performance from the perspective of the applications and reports using the databases
  • Ensures the Security of data is maintained at all times
  • Provides an effective database security management support
  • Sets up and maintain SQL mirroring, replication and log shipping

       2.  Data Storage Optimization

  • Ensures effective database management of files and file groups
  • Identifies large tables and archive and/or partition them if beneficial to system
  • Assists with the placement of files on correct storage types, as required

       3.  SQL Monitoring and Performance Optimization

  • Monitors SQL Server instance
  • Identity’s poorly performing SQL code (stored procedures, function etc.)
  • Follows deployment life cycle as per Jira

       4.  Deployment Access

  • Grant deployment access timeously and correctly
  • Coordinates with developers
  • Communicates deploy status via email (success, roll back, not deployed etc.)

       5.  Business Continuity Planning

  • Assists with Disaster Recovery planning and deployments
  • Assists with configuration of DR environment (database restores, mirroring, application configuration, testing)

Functional Competencies:

Advanced knowledge of MS SQL Server 2008 R2, including:

  • SSIS; SQL Mirroring, replication and log shipping; SQL security administration
  • Identify poorly performing SQL code; SQL DR technologies and SQL Backup and restore
  • Strong in MySQL; Strong in System Administration (Windows & Linux), Systems Design
  • Proficient technical and SQL troubleshooting skills
  • Good understanding of enterprise architecture
  • Good knowledge of servers, networks, desktop technologies and server virtualisation.

Desirable knowledge of/experience:

  • JIRA, Agile Scrum, XP and Kanban methodologies
  • Project management principles
  • MS SQL Reporting Services and Analysis Services
  • SQL 2012, Red Gate products, SQL Sentry and SQL High availability

Qualifications:

  • Relevant Degree/Diploma in IT or related discipline
  • Strongly recommended: MCDBA, MCSA: SQL Server and or MCSE: Data Platform

Experience:

  • Minimum 5 years MS SQL DBA experience

Please apply online. 

Skills:

Industries: