SQL DBA

 

Recruiter:

Data Centrix

Job Ref:

JHB005619/Kono

Date posted:

Tuesday, October 26, 2021

Location:

Midrand, South Africa


SUMMARY:
We are currently looking for an certified Senior SQL DBA to be based at our Midrand office. The candidate will be responsible for the provision of day-to-day database administration and support in a large corporation with a multiple database environment, including resolution of database problems, data backup and restore, and the production of database performance statistics.

POSITION INFO:
Qualifications:
Matric and IT Diploma/Degree
MCSE - Certified Solutions Expert.
Certified Solutions Associate: SQL Server
Certified IT Professional: Database Administrator

Functional Support:

  • Oversee the maintenance, configuration, and implementation of everything that has to do with databases.
  • Respond to and resolve database access and performance issues.
  • Performance troubleshooting with recommended improvements.
  • Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
  • Monitor, optimize and allocate physical data storage for database systems.
  • Plan and coordinate data migrations between systems.
  • Perform database transaction and security audits.
  • Establish appropriate end-user database access control levels.
  • Develop routines for end-users to facilitate best practices database use.
  • Provide solution to any complex IT related challenges in the organization

Enterprise Tasks

  • Benchmark, analyse and test new technologies.
  • SQL flavour requirements, upgrades and downgrades (Enterprise through to Express).
  • Data and/or server migrations.
  • High Availability assessments and best-fit application (AOHA and Failover).
  • Disaster recover assessment and best-fit application (AOHA, log shipping, mirroring and replication)
  • SQL patching and Rollup installations and planning.
  • Facilitate enterprise integrations with SXi and other vendorsEvaluate new software releases and products.
  • Ensure regular updates, plan future rollouts.
Data Maintenance:
  • SQL server configuration for Data Warehousing and capacity planning.
  • Backup and recovery strategies (PIT and PID, Restore point objective and restore time objective).
  • Database hardware requirements (Capacity Planning).
Reporting and Continuous Improvement:
  • Develop, implement, and maintain change control and testing processes for modifications to databases.
  • Create, or support creation of, required reports in response to business user needs.
  • Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
  • Keep up with trends in the constantly evolving information technology industry.
  • Perform regular IT audit to discover areas of weaknesses and fortify them.
Administration and Knowledge:
  • High Availability health checks and regular failover tests.
  • DMV maintenance – Outdated index updates and tuning of existing.
  • SQL performance monitoring (General, Locks, Buffer) managers.
  • Troubleshoot integration packages execution failure.
  • Troubleshoot SSAS packages job failure executed the previous night.
  • Review error mails on replication errors and spot check a few instances.
  • Keep QA and DEV databases up-to-date with PROD for testing.
  • Deploy new/existing code and patches for SQL to running software (C++/C#).
  • Storage management (Log and log files that needs shrinking).
  • Verify SQL backups to disk.
  • Design, architect, and build SQL solutions from determining business requirements.
  • Write and troubleshoot complex stored procedures used to manage SQL environments.
  • Develop innovation, strategies, processes, and best practices.


 

NB! This job is now closed. You can apply for other jobs by uploading your CV.



 

 

 

Similar jobs you might be interested in:

SQL Server Database Administrator (DBA)
Location: Centurion
Salary: R600 000.00
Our client is looking for a detail-oriented and dedicated sql Server Database Administrator (dba).Purpose of the job:The sql Server Database Administrator (dba) will be responsible for planning, managing, administering and securing system databases as well as troubleshooting any database issues affecting system performance and ensuring data quality across the databases. Key Responsibilities i...
7 days ago


Senior Developer
Location: Johannesburg
Salary:
9 days ago


Systems Administrator (ERP & Microsoft)
Location: Johannesburg
Salary: 700 Annually
If servers, ERP, and Microsoft 365 are your playground, we want you on our team!
13 days ago


Intermediate SQL Administrator - East Rand
Location: East Rand
Salary: R45K - R60K
Intermediate sql Administrator - East Rand
50 days ago


Oracel DBA (Oracle Database Administrator)
Location: Johannesburg
Salary:
MTS's well established international client in the Warehousing and Logistics sector is looking for a skilled OCA certified Oracle dba with 5+ years experience in large enterprise environments. Candidates must have expertise in Oracle versions 12c, 19c, and 21c, and strong knowledge of Oracle RAC, Data Guard, RMAN, OEM, and PL/sql development.
6 days ago


SQL Server Database Administrator
Location: Pretoria
Salary: R75 000 per month
sql Server dba
2 days ago


Administrator (Technical Finance) SQL
Location: Johannesburg
Salary: R12000
Administrator (Technical Finance) sql
2 days ago


SQL Server Database Administrator (24 Months Fixed-Term Contract)
Location: Centurion
Salary: Annually
To plan, manage, administer and secure system databases as well as troubleshoot any database issues affecting system performance and ensure data quality across the databases.
6 days ago


SQL Server Database Administrator -24 Months Fixed -Term Contract
Location: Centurion
Salary: R50 000.00 per month
JOB PURPOSE:The purpose of the job is to plan, manage, administer and secure system databases as well as troubleshoot any database issues affecting system performance and ensure data quality across the databases. As an sql Server Database Administrator
8 days ago


SQL Developer talent ad
Location: Johannesburg
Salary:
Calling Experienced sql Developers Who Turn Data into PowerAre you passionate about writing complex sql queries that bring systems to life and power real-world decisions? Do you thrive on building scalable, high-performing database solutions that drive business intelligence and performance?
14 days ago


Create a free job alert for SQL DBA in Midrand

Enter your email address below and we will email you similar jobs when they become available:

You can cancel at any time. We will not spam you.
By giving us your email address your agree to our Terms and Conditions