22 Oct '21
PostgresSQL DBA

Information Technology, Western Cape CPT - Northern Suburbs

-

This position involves providing database admininstration support of the infrastructure for the data and databases for a new project. The person will work very closely with the software vendor in order to be able to support solution.  The technology stack includes Linux servers, Hadoop servers , Postgres, a propriety 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.

KEY PERFORMANCE AREAS / OUTPUTS

?     To work with software vendor for knowledge transfer

?     To carry out database administration tasks ensuring data is available, protected and recoverable.



 

KEY PERFORMANCE AREAS AND INDICATORS

1. To work with software vendor for knowledge transfer

?     Engage with software vendor to get a detailed understanding of how the data

/ database needs to be managed.

?     Produce documentation so that other DBAs are able to provide support of the system.

?     Understand how data access/auditing is done.

?     Undestand how data backup / recovery is implemented.

2. To carry out database administration tasks ensuring data is available, protected and recoverable

?     Perform daily health checks for databases and resolve any issues identified

?     Ensure database backups are scheduled and completing successfully

?     Verify backups are valid by testing restore process regularly.

?     Monitor databases so that capacity constraints can be mitigated by timeous provisioning of resources.

?     Close incidents within SLA

?     Execute database changes according to change management process

?     Assist developers with any database issues


3. To ensure information security and regulatory compliance

?     Ensuring system security meets regulatory compliance

?     Manage server security remediation activities which will include conducting vulnerability scans and patching

4. To carry out database administration tasks ensuring data is available, protected and recoverable.

?        Perform daily health checks for databases and resolve any issues identified

?     Ensure database backups are scheduled and completing successfully

?     Verify backups are valid by testing restore process regularly.

?     Monitor databases so that capacity constraints can be mitigated by timeous provisioning of resources.

?        Close incidents within SLA

?        Execute database changes according to change management process

?        Assist developers with any database issues



 

FORMAL QUALIFICATION

 

Time

Essential

Desirable

Grade 12

 

X

 

Industry Certification: AWS / Azure

certification

 

 

X

MongoDB or Cassandra or Hadoop certification

 

 

X

 

 

 

 

 

JOB RELATED EXPERIENCE

 

Time

Essential

Desirable

Managing all aspects of at least one NoSQL database management systems from installation , configuration , backup management and security. For example MongodDB , Cassandra, other.

Years (3+)

X

 

Experience in administering one or more of the Relational Database Management Systems such as

MySQL or Postgres

Years (3+)

X

 

Experience working with services in Azure and / or AWS

Years (3+)

 

X

Exposure to one or more Apache Software Foundation Big Data & Database projects such as Hadoop, Hbase

Years(3+)

 

X

 

 

 

 


 

JOB RELATED KNOWLEDGE

 

Time

Essential

Desirable

General understanding of database

management concepts

Years (4+)

X

 



 

JOB RELATED SKILLS

 

Time

Essential

Desirable

Proficient with installing, configuring, administering, using and benchmarking NoSQL solutions.

Years (3+)

X

 

Basic familiarity with Linux

operating system

Years (3+)

X

 

Some experience engineering and/or administering NoSQL

infrastructure

Years (3+)

X

 

Proficient with one or more Apache Software Foundation Big Data & Database projects such as Cassandra, Hadoop, Hbase, MongoDB

Years(3+)

X

 

Proficient with some of the common developer tool sets such as Java, XML, JSON, REST, Shell, Perl and etc.

Years(3+)

 

X

Ad Visible Until: 30 November 2021
Ref: CPT000852/DM

Vacancy Type: Permanent