Database Administrator

Job Placements; Cape Town; On-site; ZAR 200 000 - 300 000; Full time

Job summary

A leading recruitment agency is seeking a Database Administrator in Cape Town to manage and optimize databases. The ideal candidate will have at least 3 years of experience in database management, proficiency in SQL and RDBMS like Postgres, and a strong capacity for problem-solving and teamwork. Key responsibilities include maintaining database performance and implementing disaster recovery plans. This position offers an exciting opportunity to work in a dynamic environment.

Qualifications

• A minimum of 3 years experience as a Database Administrator.
• Retail experience is advantageous.
• Stable work history.

Responsibilities

• Maintain and monitor databases to ensure DB health.
• Configure new servers and databases.
• Ensure data integrity and implement disaster recovery plans.

Skills

Teamwork

Communication skills

Problem-solving

Database management

Analytical skills

Education

Matric

IT Qualification

Industry-related certification

Tools

SQL

Postgres

Linux

Windows

Perl

Python

Bash

Big Data

Job description

THE PURPOSE OF THE ROLE

The key function of a Database Administrator (DBA) includes installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.

KEY RESPONSIBILITIES :

• Maintain and Monitor Databases
  • Database up-time
  • Visibility of DB health
  • SQL optimization and best coding practices
  • SQL runs without impacting the software negatively
  • SQL procedures and functions run efficiently
  • Ensure developers are following best practices
• New Server and Database Setups
  • Configure new server and databases a functioning database
• Database Recovery
  • Ensure all data is intact
• Disaster Recovery
  • Ensure documented disaster recovery plan

CORE SKILLS / COMPETENCIES :

• Flexible, open-minded, team worker, with a friendly and pleasant personality
• Self-driven, able to work under pressure (deadlines)
• Strong interpersonal and communication skills
• Ability to manage, prioritize and solve problems
• Basic awareness of other infrastructure technologies
• Good Analytical and troubleshooting experience
• Experience in large enterprise supporting numerous servers and databases
• Willing to work occasionally in nonstandard working hours (on call and planned work)
• Experience in mission critical, high availability, high reliability environments
• Provide real time support to maintain the necessary functionality and respond to issues as they arise
• Support technical users by identifying and resolving user problems
• In-depth understanding of database maintenance and performance tuning including the following : installation, configuration, upgrade, monitor, manage, performance tuning

Mandatory technical skills required to do the Job :

• Microsoft Office
• Experience with various RDBMS. e.g., SQL, Postgres
• Experience with Linux, Windows
• Knowledge of NoSQL databases
• Experience with Data Modeling and Database design
• Experience with SQL coding and optimization
• Experience with fundamentals such as : Backup as well as recovery of databases, Tuning database, performance management, monitoring and DB Security
• Experience with Script, Perl, Python, bash
• Experience with cloud base solutions
• Experience with Big Data

MINIMUM REQUIREMENTS :

• Matric
• IT Qualification would be advantageous
• Industry related certification
• A minimum of 3 years experience as a Database Administrator
• Retail experience is advantageous
• Stable work history