Senior Database Administrator - Northern Suburbs, South Africa - Pepkor Payments & Lending

Pepkor Payments & Lending

Verified Company

Northern Suburbs, South Africa

1 week ago

Posted by:

Thabo Mthembu

beBee Recruiter

Description

About Pepkor Payments and Lending (Pty) Ltd

Pepkor Payments and Lending is a new division of Pepkor Trading (Pty) Ltd, that incorporates personal loans and store credit operations of Pepkor through two registered credit providers namely, Capfin and Tenacity Financial Services, who are also divisions of Pepkor Trading (Pty) Ltd.

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, Preprod, staging etc.)
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.
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 Optimization.
Suggest code improvements on an adhoc basis, problematic code will be investigated and improved.

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.

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: