Senior database administrator

Recruiter:

Curiska

Job Ref:

1228045422

Date posted:

Saturday, September 3, 2022

Location:

Johannesburg, South Africa

JOB SUMMARY:
-

JOB DESCRIPTION:

Roles and Responsibilities:
o Database Administration
? Oversee all data generated, monitor server transaction speeds, and look for any service degradation in speeds due to SQL fragmentation or lack on maintenance
? Oversee all SQL instances and databases
? Ensure all databases of the same platform is up to data and the same
? Ensure data is accurate and integrity is maintained with SQL backups and logs shipping
? Ensure the companies records are archived and secure and keep the companies database maintenance plan intact with the company records
? Ensure the Databases security is correct and accurate and only allow who is required to the required databases

o High Availability
? Implement and maintain a working high availability environment with SQL replication for failover on all SQL instances

o Database Reporting and dashboards
? Ensure all company reports are accurate and running
? Build and maintain the company dashboards
? Ensure all Business intelligence is reachable at all time
? Ensure all reconciliation take place and investigate any discrepancies found

o Database Solution Design
? Design databases for custom build solutions and be able to understand hight transaction flows and be able to build the databases, store procedure and functions as required to met demands

• Knowledge:
o Power BI or any third-party BI software
o SQL and SQL replication in advanced stage
o Data warehousing and transactional flows of data in systems
o Active Directory, DNS with working with SQL
o Virtual Server Experience, Azure or AWS experience a bonus with SQL
o Knowledge on all forms of internet connectivity
o SQL security Implementations and management
o Knowledge of SQL best practices for change control, implementations etc.

Similar jobs you might be interested in:

Senior IBM DB2 Database Specialist (DB2 + HA/DR + Linux EC2)
Location: Johannesburg
Salary: 450 -500 ph
senior IBM DB2 database Specialist (DB2 + HA/DR + Linux EC2)
42 days ago

Junior Database Administrator (SQL & Open Source)
Location: Midrand
Salary: 25000 Monthly
Job Title:Junior database administrator (SQL & Open Source databases)Work Model:Hybrid Contract Term:3 Years Main Purpose of the Job:The Junior database administrator is responsible for supporting and maintaining Massmart’s enterprise database environment across retail and data centre platforms. The role ensures the availability, performance, and stability of critical database ...
6 days ago

Cloud Engineer
Location: Johannesburg
Salary:
We are seeking a specialised Cloud Engineer to design, build, secure, and maintain the infrastructure powering our modern data platforms. Unlike a traditional Cloud Engineer focused on general application hosting, this role is dedicated to the unique demands of large-scale data workload, spanning high-volume storage, high-throughput networking, and compute-optimised environments for Spark and SQL-...
7 days ago

Salesforce Administrator / Developer
Location: Johannesburg
Salary: 30000.00 Monthly
Our client is looking for a Salesforce administrator / Developer to join their team, based fully in-office in Bedfordview. This is an exciting opportunity for a professional with at least 2 years of experience who enjoys both the technical development and functional administration side of Salesforce.
13 days ago

Administration Assistant (Junior)
Location: Johannesburg
Salary: 200 000 Annually
We are seeking a highly motivated Junior Administration Assistant to join a Private Clients team in Johannesburg North.
15 days ago

Senior Accountant
Location: Johannesburg
Salary:
A well-established organization in Alberton is seeking a driven and detail-oriented senior Accountant to join their high-performing finance team in a fast-paced manufacturing/retail environment.
15 days ago

Specialist Support Engineer
Location: Johannesburg
Salary:
Lead and support enterpriseâlevel virtualisation, storage, and backup environments in a highly technical, missionâcritical IT infrastructure role.
15 days ago

Accounts Assistant
Location: Johannesburg
Salary:
An exciting opportunity for a detailâdriven finance professional to join a reputable hospitality group supporting multiple hotel operations across the Cape. If you enjoy regional reporting, handsâon finance, and exposure to senior stakeholders, this role is for you.
21 days ago

Technical Development Lead
Location: Johannesburg
Salary:
Role Purpose:The purpose of this role is to lead a development team within the Technology Services space, providing technical guidance, hands-on development, and direct management of both permanent employees and contractors. This role is pivotal in driving the technical excellence and delivery of a cloud-based product, contributing to the overall strategic roadmap, and fostering a high-performance...
Today

Group Financial Controller
Location: Johannesburg
Salary:
Opportunity for a Group Financial Controller
Today

Senior database administrator

Similar jobs you might be interested in:

Create a free job alert for Senior database administrator in Johannesburg