Database Administrator at Datonomy Solutions

Database administrator (OS)Job objective

  • This position is to provide database administration support of the data infrastructure and databases for a new project.
  • The person will work closely with the software vendor to be able to support the solution.
  • The technology stack includes Linux servers, Hadoop servers, Postgres, proprietary NoSQL database.
  • The person will have to do daily operational support of these databases as well as engage with developers to gain an understanding of the solution in order to provide quality support.

Job objectives

  • Work with software vendor for knowledge transfer
  • Engage with the software vendor to get a detailed understanding of how the data/database should be managed.
  • Produce documentation so that other database administrators can support the system. Understand how data access/auditing is done.
  • Understand how data backup/recovery is implemented.
  • Perform database administration tasks ensuring data is available, protected and recoverable
  • Perform daily database health checks and resolve identified issues
  • Ensure that database backups are scheduled and complete successfully
  • Verify that backups are valid by regularly testing the restore process.
  • Monitor databases so that capacity constraints can be mitigated by timely provisioning of resources.
  • Close incidents within the SLA
  • Execute database changes according to change management process
  • Assist developers with any database issues
  • Ensure information security and regulatory compliance
  • Ensure that system security complies with regulations
  • Manage server security remediation activities, including performing vulnerability scans and patching
  • Perform database administration tasks ensuring data is available, protected and recoverable.
  • Perform daily database health checks and resolve identified issues
  • Ensure that database backups are scheduled and complete successfully
  • Verify that backups are valid by regularly testing the restore process.
  • Monitor databases so that capacity constraints can be mitigated by timely provisioning of resources.
  • Close incidents within the SLA
  • Execute database changes according to change management process
  • Assist developers with any database issues

Qualifications

  • Grade 12 Essential
  • Desirable Industry Certification: AWS / Azure Certification
  • MongoDB or Cassandra or Hadoop certification

Experience

  • Essential 3+ years Manage all aspects of at least one database management system from installation, configuration, backup management and security. For example MongodDB, Cassandra, other.
  • 3+ years of experience administering one or more relational database management systems such as MySQL or Postgres
  • Desirable 3+ years of experience working with services in Azure and/or AWS 3+ years of exposure to one or more Apache Software Foundation Big Data & Database projects such as Hadoop, HBase

Knowledge and skills

  • Essential 4+ years General understanding of database management concepts
  • Essential 3+ years Proficiency in installing, configuring, administering, using, and benchmarking NoSQL solutions.
  • 3+ years Basic familiarity with the Linux operating system
  • 3+ years Mastery of one or more Apache Software Foundation Big Data & Database projects such as Cassandra, Hadoop, Hbase, MongoDB
  • Desirable 3+ years Proficiency in some of the common development toolsets such as Java, XML, JSON, REST, Shell, Perl, etc.

Availability is mandatory and will be on a rotational basis. Overtime as needed. The company is working on a hybrid system, not completely remote and you must be based in the Western Cape.

Desired skills:

  • Database
  • Administrator
  • AWS

Find out more/Apply to this position

Maria H. Underwood