Looking for a job

william marcelinus

@williammarcelinus

Message

Database Administrator at PT. MNC Portal Indonesia managing PostgreSQL, Oracle, Elasticsearch, and AWS RDS clusters.

Indonesia

Message

At PT. MNC Portal Indonesia, I manage PostgreSQL clusters with master-slave replication, balancing, and database maintenance tools. I also manage Oracle 23c databases and AWS RDS and RDS Aurora clusters.

I maintain Elasticsearch clusters and MongoDB and Redis clusters, and configure Kibana and Logstash to monitor and process data. I also create scripts that connect APIs to Elasticsearch and update it from RDS.

Previously, at PT. Tribunnews Network, I managed MySQL RDS databases, created a custom PHP library for Elasticsearch, and developed APIs for mobile apps. I also developed advanced article search using geolocation.

My earlier work included developing flight APIs and booking systems at PT. XS Technologies, and creating internal systems at PT. Infrastruktur Bisnis Sejahtera. I have also developed web and application systems with PHP and Golang, and I'm currently developing a ransomware detector project using Golang.

Experience

Work history, roles, and key accomplishments

Current

Database Administrator

Current

PT. MNC Portal Indonesia

Jan 2023 - Present (3 years 9 months)

Managed PostgreSQL clusters with repmgr and pgpool, Oracle 23c databases, Elasticsearch clusters, AWS RDS and Aurora, MongoDB clusters, and Redis sentinel. Developed AI project for ransomware detection using Golang.

PostgreSQL Oracle Elasticsearch MongoDB Redis AWS RDS Aurora Go Kibana Logstash Filebeat Metricbeat

Fullstack Developer

PT. Tribunnews Network

Oct 2019 - Jan 2023 (3 years 3 months)

Created custom PHP libraries for Elasticsearch, upgraded news article features, fixed AMP errors, managed RDS MySQL databases, and developed APIs for mobile apps.

PHP Elasticsearch MySQL AWS RDS API Development AMP

Programmer Web

PT. XS Technologies

Oct 2016 - Oct 2019 (2 years 11 months)

Developed application platforms using Codeigniter, Phalcon, and Lumen, maintained Linux servers and MySQL databases, and developed flight and tour booking APIs.

CodeIgniter Phalcon Lumen MySQL Nginx FPM API Development

Programmer and IT Support

PT. Infrastruktur Bisnis Sejahtera

May 2015 - Sep 2016 (1 year 4 months)

Created application project management and trouble ticket systems using Codeigniter, installed and maintained Ubuntu servers, and assisted with networking using Mikrotik.

CodeIgniter Linux Ubuntu Mikrotik Networking

Internal Development Programmer

PT. Bhinneka Mentari Dimensi

Mar 2012 - May 2015 (3 years 2 months)

Customized and created systems with Microsoft Dynamics Nav 2009 R2, programmed with SQL Server 2012, and developed internal web-based modules using ASP Classic.

Microsoft Dynamics NAV SQL Server Classic ASP CSS JavaScript

IT Staff

PT. Pharos Indonesia

Mar 2011 - Mar 2012 (1 year)

Maintained hardware and software for servers and PCs, managed web-based applications for pharmaceutical marketing, and optimized networking performance.

PostgreSQL PHP Networking Hardware Maintenance Software Maintenance

Education

Degrees, certifications, and relevant coursework

Gadjah Mada University

Bachelor of Science, Computer Science

2006 - 2011

Pursued a degree at Gadjah Mada University from 2006 to 2011, with a paper on linear modelling and random number generation in production planning inventory control.