codex Hiring for Telkom Indonesia

Database Administrator (DA)

• 18 Jun 2020

As a database administrator’s (DBA) primary job is to ensure that data is available, protected from loss and corruption, easily accessible as needed. DBA needs to know potential weaknesses of the database software and the company’s overall system and work to minimise risks. The DBA needs to know how large the database currently is and how fast it is growing in order to make predictions about future needs. Performance monitoring shows where the database should be tweaked to operate as efficiently as possible. The physical configuration, the way the database is indexed, and how queries are handled can all have a dramatic effect on database performance.

Description

1.Installing and upgrading the database server and application tool

2.Allocating system storage and planning storage requirements for the database system

3.Modifying the database structure, as necessary, from information given by application developers

4.Enrolling users and maintaining system security

5.Ensuring compliance with database license agreement

6.Controlling and monitoring user access to the database

7.Monitoring and optimizing the performance of the database

8.Planning for backup and recovery of database information

9.Maintaining archived data

10.Backing up and restoring databases

11.Generating various reports by querying from database as per need

12.Managing and monitoring data replication

13.Acting as liaison with users

Requirement

1. Understanding concept and architecture of Cluster Database at least one of 3 RDBMS below :

- Galera or Percona Xtradb Cluster

- MongoDB Cluster

- PostgreSQL Cluster or Replication

2. Understanding backup and recovery concept of Database (Full Backup, Incremental Backup, PITR).

3. Understanding concept of building effectiveness of SQL query. (Tuning and Security).

4. Ability to use multiple scripting.

5. Experienced on linux platform

Is a Plus :

1. Experienced on storage and OS layer administration

2. Experienced on Ansible

3. Experienced on OpenShift (Docker and Container)