Sr. Dba

5 months ago


Cape Town, South Africa redPanda Software Full time

**Title: Senior Database Administrator**

**Location: Cape Town (Mowbray)**

**KEY RESPONSIBILITIES**:

- **Key Roles and 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**:

- Strong communicator, fluent in English
- 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 quickly and completely
- Recent experience with Sybase, SQL Server, Windows Server, and Linux
- Basic scripting knowledge: Bash/Perl/Python scripting
- Exposure to cloud-based database platforms (Azure, AWS, GCP)
- Basic awareness of other infrastructure technologies - for example, Linux, Windows administration, storage, or data networking
- Good Analytical and troubleshooting experience on above
- Experience in large enterprise supporting numerous servers and databases preferred
- 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 of Sybase, SQL Server, and Postgres
- **Mandatory technical skills required to do the Job**:_
- Microsoft Office
- Experience with various RDBMS. e.g., SQL, Postgres, Sybase
- Knowledge of NoSQL databases
- Experience with Data Modelling 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 required. Bachelors’ Degree or diploma in IT related field an advantage.
- Matric
- +5 years’ experience in a similar role

**RECRUITMENT PROCESS**
- Competency based interview to assess above requirements
- Applicable assessment
- Background checks

Application Question(s):

- How long have you worked as a DBA
- How many years of retail experience do you have in?