Database Administrator (Oracle & PostgreeSQL) Asst. Manager

PT Enseval Putera Megatrading (Jakarta, Jakarta, Indonesia)

DKI Jakarta, Indonesia

Enseval as Indonesia's largest Healthcare Product Distribution Company has been reached all areas in Indonesia through its 48 branches. Furthermore, Enseval also expanded its contribution of Indonesia’s better health service through selling raw materials for pharmaceuticals and cosmetics purpose, as well as medical and health diagnostic tools. Enseval has the vision to be a leading and integrated distribution and logistics company through service excellence, competent people and advanced technology. This vision is followed by the company’s mission to contribute in improving the quality of health and delivering the best health care products for Indonesia.

About this position

The position of Database Administrator (Oracle & PostgreSQL) Asst. Manager involves managing and maintaining database systems, ensuring security, performance, and reliability.

Responsibilities

• Installation & Configuration.
• Schema handling.
• Database user roles and Security related permission.
• User creation, object Backup & Restore.
• Architect level Server security.
• Creating and Managing PostgreSQL Databases.
• Index Management PostgreSQL.
• Partitioning and System Catalogs Backup.
• Recovery and PITR Monitoring disk usage PGAdmin.
• Transferring Data Moving.
• Transaction Logs Reliability and WAL High Availability Failover Replication.
• DR Replication monitoring and configuration.
• Implementing Postgresql related tools.
• Writing shell script for Postgresql Database Performance tuning.
• Checking alert logs.

Requirements

• Experienced with PostgreSQL & PostgreSQL Architecture minimum 2 or 3 years.
• Familiar with AWS RDS or other cloud platform.
• Advanced: Manage database inside container like Docker and inside Kubernetes cluster.
• Excellent communication skill and leadership.