codex Hiring for Telkom Indonesia
Database Administrator (DA)
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.
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
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)
Deadline kirim lamaran : 14 Jul 2020