Profile

I am very passionate about different applications of BIGDATA such as spark, python, R and  enjoy developing applications using Oracle Forms and Oracle APEX.  I also have been working as Oracle Database Administrator and System Administrator.

Skill

Oracle DBA – Advanced
Oracle SQL/PLSQL - Advanced
Oracle Form Developer – Advanced
Postgres - Intermediate
Bigdata - Intermediate
Python – Intermediate
Web Developer- Intermediate
AIX, Linux - Intermediate

Trainning

  • Developer Training for Spark and Hadoop ( Cloudera Inc. - 2018)
  • Android Fundamental Training ( PT. GITS Indonesia – 2018)
  • Installing and Configuring Windows Server 2012 ( be:logic – 2017)
  • AIX Basic Administration ( IBM – 2016)

Work Experience

BIGDATA ENGINEER
PT. Akurpratama
2017 - DATE
  • Maintain Oracle Bigdata Cloud Services (BDCS) using Ambari.
  • Maintain Oracle Analytic Cloud (OAC).
  • Gather and process raw data at scale ( including writing scripts, web scraping, write SQL Queries) using Bash Scripting, Python and Hive.
  • Process unstructured data into a form suitable for analysis using Hadoop, Spark, Hive.
  • Extract data from a variety of relational database into Hadoop and Hive.
  • Design database, data models, ETL Processes, data warehouse and business intelligence (BI) using Sqoop, Hive, OBIEE and Oracle DataVisualization.
  • Real-time streaming ETL using Spark Streaming, Kafka and Flume.
DATABASE ADMINISTRATOR
PT. Akurpratama

2009 - 2016

  • Provided architecture design and implemented the all production database replication, backup and contingency recovery strategies for all OLTP Data Warehouse databases in the company.
  • Designed and implemented disaster recovery plan using standby databases with dataguard. Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site.
  • Created scripts and scheduled backups in cron for RMAN database backups and recoveries.
  • Worked with the internal development team to provide the necessary SQL, PL/SQL packages / procedures and other database management scripts to enhance, tune, optimize and implement database related development activities.
SYSTEM ADMINISTRATOR
PT. Akurpratama

2009 - 2016

  • Experience in administration of AIX 5.3, 6.1, 7.1, RHEL 5/6.
  • Installation and configuration of AIX on Various hardware including Power 7,power 7+ & Power8 servers and RHEL.
  • Installing and configuring Oracle Database on AIX and Redhat.
DEVELOPER
PT. Akurpratama

2004 – 2009

  • Develop Retail Applications System with Oracle Form and Report.