Database Administrator

2 weeks ago


Johannesburg, South Africa LENOHLAHLA CONSULTING Full time

JOB DETAILS
Job Title Database Administrator
Job Type Permanent
Division Business Change and Technology
Department Infrastructure

**EE Occupational Levels Level 4 & 5**: Skilled, Technical and Academically Qualified
Location - Town / City Sandton
Location - Province Gauteng
Location - Country South Africa
Job Advert Summary
Job summary statement/purpose

The primary role of the database administrator's (DBA) is to ensure that data is available, structured, protected from loss and corruption, and easily accessible. The DBA will be expected to manage, maintains, and secure data in one or more data systems to ensure that users can perform business-related analyses. This role will be responsible for data storage, display, utilisation, and analysis.

Minimum Requirements

**Qualifications**:
Degree in Computer Science, Information Systems, or IT relevant Degree

Microsoft certified Database Administrator (Added Advantage)

Cloud Certification (Added Advantage)

Experience

Relevant database certificates

Insurance background (Added advantage)

Minimum of 5 years proven MS SQL Database Administration

MySQL experience (added advantage)

Knowledge and experience with database Performance Tuning and Optimization (PTO).

Business Intelligence experience - Power BI (added advantage)

Knowledge and experience with backups, restores and recovery models (Preferable)

Knowledge and experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

**Responsibilities**:
**KEY PERFORMANCE AREAS (DUTIES & RESPONSIBILITIES**:
1. Database Software Installation

Collaboration on the initial installation and configuration of a new database either SQL/ MYSQL.

Setting up the hardware and deploying the operating system for the database server, and installation and configuration of database software.

Handling of data transfer from the existing system to the new platform.

2. Database Maintenance

Maintenance of database servers and updating of processes/SOPs.

Ensure high levels of performance, 97% availability and sustainability.

Ensure that databases logs are tracked, issues are resolved on time.

Works closely with IT Project Managers, Business Analysts, Enterprise Architects, Suppliers, Infrastructure team and development teams.

Provide support to Application Productions team, Application Developers and Infrastructure team.

Participates in the configuration, tuning and troubleshooting of the databases in use in Development, QA and Production.

Performs backup recovery through testing and ensure database are backed up accordingly.

Provide support for business-critical systems; and perform scheduled maintenance and support release deployment activities.

3. Database Security

Know the potential weaknesses of the database software and the companys overall system and minimise risks.

Implementing best practices to minimize risks.

Ensuring that there are audit logs should there be any security breach.

Recommend best security practices for Databases to achieve business objectives, advise on risk assumptions for any variances granted, and provides alternatives to achieve desired end results.

4. Monitoring and Reporting

Database Performance monitoring and resolution Implement and maintain storage, archiving, backup, and recovery procedures function correctly.

Monitor database health and its performance on a regular basis.

Produce reports on various database e.g., capacity, availability, job run etc.

Provide Business Intelligence (BI) Dashboard support.

Provide necessary support for business Intelligence function through access management.

5. Policy Holder Data Acquisition

Support business with Policy Holder Data acquisition programme by ensuring data is collected and availed for reporting purposes.

Provide support for Policy Holder Data to enable business for data management.

6. Research and continuous improvement

Research identify and recommend database improvements.

APPLICATION QUESTIONS

**Which of the following IT related qualification do you have**: Are you a Microsoft certified Database Administrator?

Do you have Cloud Certification?

Do you have any relevant database certificates?

How many years of experience do you have in MS SQL Database Administration?

Do you have short-term insurance background?



  • Johannesburg, South Africa Telebest Full time

    Our client has an opportunity available for a Database Administrator in the ICT and Projects department based in Gauteng.Requirements:3 years’ experience working with SQL databases and the management thereof.2+ years working experience on DB2 databases.Travel and work overtime when required.Relevant IT diploma or degree.Certified in SQL, DB2 and...


  • Johannesburg, South Africa Datonomy Solutions Full time

    Are you ready to take your database skills to the next level? We're on the lookout for a passionate and dynamic Database Administrator!Job Description: To manage, monitor and support mainframe IDMS and DB2 database objects and ensure their availability, performance, security and consistency in order to support mission critical business applications.Create...


  • Johannesburg, South Africa Planet10 Full time

    GoldenRule is currently engaged in an exciting project and hiring for a major in the mining sector. We require the skills of a Database Administrator to be based in Johannesburg '† Must have 4 to 7 years experience in the Operation Technology Application domain. Adv. Database Exp ( MS SQL 2005 2008 2012) Adv. Reporting Exp( MS SSRS 2005 2008 2012) Adv....


  • Johannesburg, South Africa Positive Switch Full time

    **Description** - The senior SQL Database Administrator will support the business in achieving its strategic objectives within the Data Services Business Unit. - As senior SQL Database Administrator in the business unit team, you will be responsible for consulting with clients on complex information technology challenges - Microsoft SQL database...


  • Johannesburg, South Africa SavageOne Pty Ltd Full time

    This position will entail fully remote work, collaborating with international clients on a contract staffing basis (month-to-month), for 8 hours a day, Monday to Friday. Timezone flexibility may be required to accommodate different countries.Position Summary:As a Junior Database Administrator, you will collaborate closely with our team of senior database...


  • Johannesburg, South Africa Tipp Focus Full time

    **Job Purpose** The purpose of this role is to support the delivery of the Database & ERP Application Administrator function in line with the organisational mandate, strategies and business operations. This position reports to the Database & BI Reporting Specialist **General Requirements** **Minimum requirement** Formal Education This position requires a...


  • Johannesburg, South Africa Pollock and Associates Full time

    Senior Database Administrator ICT Johannesburg North, Johannesburg - Gauteng - South Africa Reporting to the Senior IT Manager you will be responsible for providing operational database services. You will have strong technical aptitude/rapport and the ability to convey technical content in a clear, concise manner, using appropriate language appropriate...


  • Johannesburg, South Africa People Source Full time

    Opportunity to join innovative software company and work with a wide range of clients on projects with real world purpose and impact. Build, configure, monitor and maintain active databases and systems. Be involved in the provision of high-quality database solutions to support evolving IT requirements. Jhb based.


  • Johannesburg, South Africa PPS Recruitment Full time

    **Job Advert Summary**: **Purpose of the Job**: The role is responsible for maintaining the integrity and performance of the company databases and guaranteeing that the data is stored securely and efficiently. **Minimum Requirements**: **Education**: - Matric (Grade 12) - BSc/BTech in IT, Computer Science degree OR Diploma in IT - ITIL Foundation -...


  • Johannesburg, South Africa OutsideCapital Full time

    Our Client is designed to be different and embraces bold ideas, with a focus on providing holistic business solutions in new and innovative ways. Reporting into the Global Director, Integration Services and working within the Global Data and Integration team, the Global Database Administrator will assume a technical leadership role across numerous...


  • Johannesburg, South Africa BET Software Full time

    **We Want You**: A role exists for a Senior Database Administrator at South Africa’s leading betting brand. We are looking for a well-motivated, energetic, inquisitive, highly proficient individual, who has a solid technical base. A technical expert to lead a team of Database Administrators whose primary focus is maintaining and enhancing BET Software’s...


  • Johannesburg, South Africa The Joblink Full time

    Contact person for this position: Amori Prinsloo Our client is looking to employ a Database Administrator (DB2/IDMS) for a 1 year contract that might be extended for 2 years. **Key Duties and Responsibilities**: - Create and maintain business database objects within an IDMS and DB2 subsystem. - Perform database tuning to ensure the DBMS functions at...


  • Johannesburg, South Africa Psybergate Full time

    What you will be doing:  Create and maintain business database objects within an IDMS and DB2 subsystem. Perform database tuning to ensure the DBMS functions at optimal levels. Schedule database maintenance tasks. Troubleshoot database and DBMS errors and provide solutions to support business when required. Provide input and implement operational and...


  • Johannesburg, South Africa Adzuna ZA B C2 Full time

    What you will be doing:Â Create and maintain business database objects within an IDMS and DB2 subsystem.Perform database tuning to ensure the DBMS functions at optimal levels.Schedule database maintenance tasks.Troubleshoot database and DBMS errors and provide solutions to support business when required.Provide input and implement operational and business...


  • Johannesburg, South Africa Psybergate Full time

    What you will be doing:  Create and maintain business database objects within an IDMS and DB2 subsystem.Perform database tuning to ensure the DBMS functions at optimal levels.Schedule database maintenance tasks.Troubleshoot database and DBMS errors and provide solutions to support business when required.Provide input and implement operational and business...


  • Johannesburg, South Africa Blue Pearl PTY LTD Full time

    Job DescriptionYour Role and Responsibilities Conduct day to day continuous administration of DB2 on Linux-Unix-Windows (not just MainFrame), Administer DB2 utility and application framework and building solution for DB2.Install, upgrade and patch production DB2 databases. Install, upgrade, patch DB2 utility application framework products.Conduct performance...


  • Johannesburg, South Africa Blue Pearl PTY LTD Full time

    Your Role and Responsibilities Conduct day to day continuous administration of DB2 on Linux-Unix-Windows (not just MainFrame), Administer DB2 utility and application framework and building solution for DB2.Install, upgrade and patch production DB2 databases. Install, upgrade, patch DB2 utility application framework products.Conduct performance tuning of high...


  • Johannesburg, South Africa Unique Personnel Full time

    **Job Number** - 70911 **Job Type** - Permanent **Job Title** - Telesales Sales/Database Administrator **Computer Skills** - MS Excel,MS Office **Industry** - Retail - Wholesale **City** - Johannesburg **Province** - Gauteng - JOB PURPOSE: To assist in driving sales and administration within the department responsible for the business point of sales...


  • Johannesburg, South Africa Progressive International Full time

    Gauteng, JHB - Northern Suburbs - NEG - neg Monthly Cost To Company (Market related) **JOB PURPOSE** **QUALIFICATIONS AND REQUIREMENTS**: - Bachelor’s degree in Computer Science or Computer Information Systems NQF 7 - 3 years’ of relevant experience in an IT environment actively administering databases, Essbase experience will be an advantage. -...


  • Johannesburg, South Africa FirstRand Full time

    Job Description To be responsible for installing, configuring, maintaining and monitoring an environment consisting of Windows and Linux servers, connected to a SAN environment; This environment will consist of both physical and virtual servers on both platforms. - Drive business profitability in the context of cost management through Information technology...