M. FEBRI
YUGISTIAN
Oracle Database Administrator
SYSTEM ARCHITECT
Entering the world of enterprise data requires precision, foresight, and a touch of madness. As a DBA, I don't just manage data; I orchestrate the heartbeat of the business.
From optimizing SQL queries that run in milliseconds to architecting RAC clusters spanning continents, my workspace is the unseen infrastructure that powers the digital world.
SKILL NODES
/home/usr/skills_matrix.json
🔴 DATABASE ADMINISTRATOR
Database Core
- > Oracle 19c
- > PDB / CDB
- > Installation
Performance
- > Tuning
- > Query Optimization
- > AWR / ASH
Operations
- > RMAN Backup
- > Patching
- > Monitoring
Enterprise
- > High Availability
- > Migration
- > Team Collab
🧠 FULLSTACK DEVELOPER
Frontend
- > HTML5 & CSS3
- > Responsive (Flexbox)
- > Tailwind CSS
- > JavaScript & DOM
Framework
- > React.js (Basic)
- > Components & Props
- > useState Hook
- > Next.js (Routing)
Backend
- > PHP & Laravel
- > CRUD & MVC
- > REST API
- > Auth (ratudegan.id)
ACTIVE OPERATIONS
SELECT operation_name, status FROM v$active_sessions;
Active Sessions
Pemantauan sesi database aktif untuk menjaga performa dan kestabilan sistem.
Backup & Recovery
Backup rutin dilakukan untuk memastikan keamanan dan ketersediaan data.
Performance
Monitoring performa sistem untuk mencegah bottleneck di lingkungan produksi.
Query Optimization
Optimalisasi query untuk meningkatkan efisiensi dan responsivitas sistem.
Maintenance
Pemeliharaan sistem rutin untuk menjaga stabilitas jangka panjang.
App Development
Pengembangan aplikasi dasar dengan fokus integrasi backend dan database.
Monitoring
Monitoring sistem database secara real-time untuk deteksi dini masalah.
Installation
Instalasi dan konfigurasi Oracle Database di environment produksi.
SYSTEM LOGS
/var/log/dba_history.log
Oracle Database Administrator
Mensa Bina Sukses (Mensa Group)
• Managed databases for ERP System (SAP) and other applications.
• Managed Database for warehouse and inventory management system.
• Managed Asm Disk Group and Database File.
• Performance Query .
• Backup and Recovery.
• Installed Asm and Database.
• installed and Configured Oracle Grid Infrastructure.
• installed and Configured Oracle Data Guard.
• installed and Configured Oracle RAC (Junior).
• Performed maintenance on Redo logs, SPfiles, and Datafiles.
• Installed and upgraded Oracle databases (19c).
• Optimized query performance and database capacity.
Oracle Database Administrator
Pelindo Solusi Digital
• Managed databases for Regional 2.
• Performed maintenance on Redo logs, SPfiles, and Datafiles.
• Installed and upgraded Oracle databases (19c).
• Optimized query performance and database capacity.
Entry Database Support
Permata Sentul Golf
• Handled DDL and DML for "Absen Caddy" system.
• Created Packages and Stored Procedures.
• Maintained golf databases and developed "e-customer" database.
ACTIVE OPERATIONS
SELECT * FROM v$session WHERE status = 'ACTIVE';
status: COMPLETED ✓
period: 2022
> WIMDB: Setup Oracle 19c on OL 7, added redo groups, backup dmp.
> LIBdb/vmsoradb: Created new DB, migrated VMS1 to vmsoradb, implemented PDB.
status: LIVE PRODUCTION
role: Full Stack Developer
> Launched ratudegan.id main portal.
> Built dashboard.ratudegan.id for analytics & admin.
Integrated complex backend logic with modern frontend dashboards.
ESTABLISH CONNECTION
Target: M. Febri Yugistian (DBA)
Remote_Connect: +62 878-6016-1011 (WhatsApp)
Remote_Connect: +62 819-1009-1718 (WhatsApp)
Encryption: TLS 1.3 | Latency: 4ms | Status: LISTENING