Database Administrator

HR Genie; Cape Town; On-site; ZAR 200 000 - 300 000; Full time

Job summary

A leading HR solutions provider in Cape Town is looking for a skilled Database Administrator. Responsibilities include maintaining databases, optimizing SQL, and ensuring data recovery. Candidates should have a minimum of 3 years of experience, with industry certifications being advantageous. Strong analytical and troubleshooting skills are essential in this challenging role.

Qualifications

• Minimum 3 years of experience as a Database Administrator.
• Proven track record of successful implementation.
• Industry-related certification preferred.

Responsibilities

• Maintain and monitor databases to ensure up-time.
• Perform SQL optimization and ensure best practices.
• Configure new servers and databases.
• Implement database recovery and disaster recovery plans.

Skills

SQL optimization

Database maintenance

Analytical skills

Troubleshooting

Communication skills

Education

IT Qualification

Tools

SQL

Postgres

Linux

Windows

NoSQL databases

Python

Job description

SUMMARY :

Maintain and Monitor Databases, SQL optimization and best coding practices, Database Health

POSITION INFO :

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.

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
• Basicawareness 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
• Proven track record of successful implementation