Sr. Dba

2 weeks ago

Cape Town, Western Cape, 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 uptime
  • 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, openminded, team worker, with a friendly and pleasant personality
  • Selfdriven, 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 cloudbased 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
  • Indepth 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?

  • Sr. Dba

    1 week 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...