Dba Administrator

A 1L Realization (Pty) Ltd; Gauteng; On-site; ZAR 500 000 - 750 000; Full time

Job summary

A technology solutions company in South Africa is seeking a Database Administrator with 8 to 10 years of experience. The candidate will be responsible for installing and configuring Oracle servers, managing databases, and ensuring optimal performance. Skills in database troubleshooting and shell scripting are essential. This position offers an opportunity to implement upgrades and maintain Oracle standards in a dynamic environment.

Qualifications

• 8 to 10 years of experience in database management and Oracle solutions.
• Proven ability to maintain and optimize database performance.
• Experience with database recovery methods and security policies.

Responsibilities

• Install and configure Oracle server and clients.
• Manage and troubleshoot databases, ensuring their performance.
• Implement upgrades and maintain Oracle standards.

Skills

Database troubleshooting

Shell scripting

DB Performance Management

Tools

Oracle

RMAN

Job description

Total of 8 to 10 years experience.

Putting Customers First

Delivering Results

Managing a Changing Environment

Communicating for Impact

Install Oracle server, client with respect to appropriate version, release and patch level.

Install patches, Upgrades minor release, Install and configure new features upon agreement with OpCo.

Creation of Database (builds and manage database including Tablespace and system / infrastructure users.

Recommendation on what patches to install.

Upgrades databases according to the Component Catalogue if approved by the appropriate OpCo Application Teams and compliant with the OpCos applications hosted.

Responsible for recovery of the database using RMAN, BCV backups.

Maintaining Oracle Standards for set up of Production Oracle DBs

Maintaining Oracle Standards for set up of Test / Acceptance Oracle DBs

Responsible for improvement and maintenance of the databases to include rollout and upgrades

Test database failover test

DB Performance Management - Pro-active and Tuning Sql and database.

Responsible for ensuring availability and performance of the databases.

OEM or grid control

Predicting future Oracle trends for linear tablespace (per instance) growth and space management.

Perform data refresh from production systems, wherever the infrastructure is available

Implement workarounds and solutions to solve incidents and problems, in close collaboration and according to OpCos needs.

Database troubleshooting and problem root cause analysis.

Secure DB according to security policies

Auditing / Intruder detection on DBMS level.

Problem management

Shell scripting