Deskripsi pekerjaan Database Administrator Prestisa
- Maintain and monitor the usage, performance, integrity, and security of database servers that included in DBA responsibility.
- Do a check response, root cause analyzing, tuning and troubleshooting when a problem occurs or a performance degradation on database servers.
- Do a routine assessment on database server performance and health check, and make a report based on the evaluation results.
- Do maintenance or migration in order to improve database performance.
- Support to provide data and/or access to database which is required for: audit, fraud investigation, bug fixing, reporting and other needs with approval from leaders of each related team. DBA lead/principal, and its security.
- Build an alerting system to monitor database server activity and failure, cooperate with dedicated team who handle alerting system.
- Build and setup various mechanism that support database needs and performance (e.g replication method, connection pulling, load balancer).
Requirements:
- Have excellent knowledge and experience in managing and monitoring database system PostgreSQL and/or MySQL (tuning, backup, recovery, scaling, design, troubleshoot, migration, alert system, etc).
- Experience in managing one of this database system is preferable: Cockroach DB, Cassandra, Scylla DB, Redis, elasticsearch.
- Familiar with cloud database such as RDS (AWS), CloudSQL (GCP), ApsaraDB (Aliyun).
- Able to operate advanced command on UNIX / LINUX operation system.
- Have great responsibility toward task and job given to the candidate.
- Able to deliver detailed information between team member and also to another team;
- able to take the knowledge (essence) from received information.
- Always have initiative to make better work system and environment.
