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 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