Database Administrator (Snowflake and PostgreSQL)

PT. Nityo Infotech
Staff
Full Time
IDR 20.000.000 - 25.000.000
Menara Batavia, Level 14, JI.K.H. Mas Mansyur No. Kav. 126, Karet Tengsin, Tanah Abang, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta 10250

Deskripsi Pekerjaan

● Database Administration & Operations ○ Administer and support Snowflake and PostgreSQL databases (core requirement). ○ Manage users, security policies, roles, and connectivity. ○ Perform proactive monitoring, capacity planning, and health checks. ● Backup, Recovery & Disaster Preparedness ○ Design and implement backup/restore strategies. ○ Define and meet RTO (Recovery Time Objective) and RPO (Recovery Point Objective). ○ Conduct periodic disaster recovery testing. ● Performance Tuning & Optimization ○ Optimize queries, indexes, and schema design. ○ Troubleshoot bottlenecks and improve workload performance. ○ Implement cost and storage optimization strategies. ● Best Practices & Data Management ○ Enforce database security, auditing, and compliance standards. ○ Apply data compression and storage optimization techniques. ○ Automate recurring DBA tasks for efficiency and consistency.

Kualifikasi Pekerjaan

● Mandatory: ○ Proven expertise in Snowflake and PostgreSQL administration. ○ Strong knowledge of backup/recovery, RTO/RPO, and disaster recovery. ○ Hands-on experience with performance tuning, indexing, and query optimization. ○ Solid understanding of data compression and storage optimization. ● Added Advantage: ○ Experience with Amazon Aurora (PostgreSQL/MySQL). ○ Experience with Azure Database (SQL, PostgreSQL, or MySQL). ● Good to Have: ○ Familiarity with Infrastructure as Code (Terraform/CloudFormation/ARM) for DB provisioning. ○ Python or Shell scripting for automation, backups, and monitoring.

Gambaran Perusahaan

Waktu Proses Lamaran

Industry

Konsultan

Situs

https://www.nityo.com/

Nomor Telepon

628551602050

Ukuran Perusahaan

250-500

Waktu Bekerja

monday - friday

Gaya Berpakaian

Formal

Tunjangan

Medical

Bahasa yang Digunakan

English

Lokasi Perusahaan

Menara Batavia, Level 14, JI.K.H. Mas Mansyur No. Kav. 126, Karet Tengsin, Tanah Abang, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta 10250