Senior Database Administrator - Northern Suburbs at Pepkor Payments & Lending

The purpose of the Database Administrator (DBA) is to be responsible for the implementation, maintenance, and repair of 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:

Database Administration

• Coordinates the effective management of all Southern View Finance database environments (Production, Dev, UAT, Pre-prod, staging etc.)
• Facilitates best possible system performance from the perspective of the applications and reports using the databases.
• Ensures the Security of data is always maintained.
• Services any data movement requests securely, accurately, and timeously
• Provides support and advice to development team for new and existing SQL code.
• Conducts daily routine tasks including Health Checks.
• Provides an effective database security management support.
• Ensures that backups are done and restored daily.
• Sets up new database environments, configure in adherence with applications.
• Database partitioning and archiving implementation.
• Sets up and maintain SQL mirroring, replication, and log shipping.

Capacity Planning & Availability Measures

• Produce monthly reports.
• Make recommendations to align hardware with reporting stats.

SQL Monitoring and Performance Optimisation

• Monitors SQL Server and ensures monitoring tools are in alignment with business KPA’s.
• Identifies poorly performing SQL code (stored procedures, function etc).
• Suggest code improvements on an adhoc basis, problematic code will be investigated and improved.

Deployment planning, execution and roll back plan

• Accurate and timeous implementation and communication of deployment schedule
• Implements deploys and rollbacks, impact and interdependencies considered.
• Maintain change control methodology, amend operating procedures as deployment life cycle changes.
• Enforce and verify SQL code policy is implemented on production.

Business Continuity Planning

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

Operational Incidents

• Takes care of existing operational incidents timeously and correctly.
• Provides an efficient 3rd line support and assists with database related queries.
• Documents and accurately updates SOP and escalating processes.
• Adheres to company policies and operating procedures.
• Adheres to Response SLAs.
• Ensures that Incident management is adhered to in accordance with (ITIL).

Mentoring

• Positive engagement in team activities and actively contribute ideas to improve team dynamics performance.
• Stakeholder management (internal and external).
• Assist in development of others, e.g. mentoring and knowledge share
• Quality control of other’s work.

Functional Competencies:

• MS SQL development
• Administration
• Knowledge of SDLC
• Knowledge of the Change Control Processes

Behavioural Competencies:

• Teamwork
• Adhering to Principles and Values
• Applying Professional / Specialist / Technical Expertise
• Information Gathering and Problem Analysis
• Quality and Detail Orientation
• Coping with Pressures and Setback

Qualifications:

• Grade 12 (Senior Certificate)
• Relevant IT Diploma or Degree
• MCDBA/MCSA or Equivalent

Experience

• At least 8 years advanced MS SQL development and administration experience in an IT operational environment