Company Logo

Oracle Application Support

Lowongan ini telah ditutup

Loker ini dikelola oleh

PP
PT Pro Sigmaka MANDIRI

Persyaratan

Kerja di lokasi
3 - 5 tahun pengalaman
Minimal Sarjana (S1)

Skills

SQL

Oracle Database

Linux

Deskripsi pekerjaan Oracle Application Support PT Pro Sigmaka Mandiri

Job Description

  • Checking db instance / listener, freespace of tablespace, running AWR report, checking session diagnostic, checking alert log for error, checking locking object, checking SGA usage, monitoring DB statistic, open cursor limit, check invalid db object, check user quota limit,
  • Check object fragmentation, analyze the needs of table partition, check for block corruption, check IO
  • Check DB growth, Find Tablespace Status, segment management, initial & Max Extents and Extent Management, Check if tablespace need coalescing.
  • Trend Analysis of objects with tablespace, last analyzed, no. of Rows, Growth in days & growth in KB
  • Check performance of complex PLSQL / SQL query and give recommendation for SQL tune-in
  • -Analyze the needs for index / PK / FK
  • Consultation from end user and colleagues on experience and best practice on Oracle Database, storage capacity planning and system environment (OS etc.)

Minimum Qualifications

  • Bachelor Degree in IT
  • At least 4 Years of working experience in the related field is required for this position.
  • Have Database Administration skills, especially Oracle.
  • Shell scripting OS (Windows / Linux) capabilities for monitoring, cronjob/job scheduler & Email notification purposes.
  • Basic PL / SQL & SQL Programming.
  • Having basic knowledge & experience of Windows & Linux system administration.
Tentang Perusahaan
PT Pro Sigmaka Mandiri
51 - 200 karyawan

PT Pro Sigmaka Mandiri experienced in several industry sectors, a broad portfolio and technology platform as well as bringing a dedicated and highly qualified team.

Alamat kantor

Trio Building, Jl. Mampang Prpt. Raya No.17 Lt.3, Mampang Prpt., Kec. Mampang Prpt., Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12790

Tips Aman Cari Kerja

Pemberi kerja yang benar tidak akan meminta akun Telegram, top-ups atau pembayaran dalam bentuk apapun. Jangan berikan kontak pribadi, informasi bank, maupun kartu kredit kamu.

Pelajari Selengkapnya

Lowongan Lainnya Untukmu

.Net Developer

Rp 6,8-10jt
Kontrak
1–3 tahun
Minimal Sarjana (S1)
PT Pro Sigmaka Mandiri

Backend Developer (JavaScript)

Gaji Tidak Ditampilkan
Kontrak
3–5 tahun
Minimal Sarjana (S1)
PT Digital Data Integrasi
Kontrak
1–3 tahun
Minimal Sarjana (S1)
PT Pro Sigmaka Mandiri

Oracle Application Support