Soni Maula Harriz
Verified Expert in Engineering
Software Developer
Bandung, Bandung City, West Java, Indonesia
Toptal member since August 31, 2017
With 10+ years in the computer industry, Soni's worked mainly as a PostgreSQL DBA and SQL developer—managing PostgreSQL servers, including Slony replication, streaming replication, Londiste 3, and Pacemaker-Corosync-DRBD stack. He's done performance tuning, data-center migrations, routine maintenance, troubleshooting, and daily DBA tasks. Soni's also experienced in Business Intelligence Analytics software using Looker and Amazon Redshift.
Portfolio
Experience
- SQL - 11 years
- Linux RHEL/CentOS - 11 years
- PostgreSQL - 11 years
- Backup & Recovery - 11 years
- Ubuntu - 9 years
- PL/pgSQL - 9 years
- Bash Script - 9 years
- Performance Optimization - 8 years
Preferred Environment
Ubuntu, RHEL, PostgreSQL
The most amazing...
...thing I've done was transforming a huge table into a partitioned table without downtime and troubleshot multiple performance problems in the PostgreSQL server.
Work Experience
PostgreSQL Database Administrator
USIC, LLC
- Migrated a master database that allows every table schema change to be tracked and monitored from the migration feature.
- Managed a complete data center migration. The data centers are designed and deployed to provide storage for critical data and some organizations' applications.
- Worked with a production database of 1.7 TB as part of my role.
- Split a huge table column of a big table structure change without downtime.
- Implemented performance tuning, query tuning, table size optimization, and review indexing.
PostgreSQL Developer
Cyber Radar
- Developed a trigger function for shadow and log tables to log write operations.
- Created scripts to automatically install and configure PostgreSQL on a new machine.
- Owned the data sync process between PostgreSQL and SQL Server.
Lead PostgreSQL DBA
Tokopedia
- Did complete database assessment on all Tokopedia Postgres database.
- Migrated Tokopedia database from self-hosting to AWS.
- Created maintenance script to manage Tokopedia database, so it can perform well.
- Upgraded Postgres version, so it stays up to date with the latest version.
Database Administrator
PT Data Aksara Sangkuriang
- Conducted statement-based replication using pgpool-II with our application written in Java. We found that pgpool-II had bugs with JDBC and attempted to contact Tatsuo Ishi, the creator, but the problem was not solved and we moved away from pgpool-II.
- Tried streaming replication which went well for our requirement, except for the automated failover.
- Implemented server clustering using Pacemaker, Corosync, and DRBD stack.
- Managed to keep the database slim by archiving obsolete data.
- Implemented performance tuning, views, triggers, stored procedure, and reporting.
Education
Diploma in Informatics Management
Politeknik Piksi Ganesha Bandung - Bandung, Indonesia
Certifications
EDB Certified Professional – PostgreSQL 9.6
EDB
EDB Certified Associate – PostgreSQL 9.6
EDB
Skills
Tools
Pacemaker, Corosync, Slony-I, Looker
Languages
SQL, Bash Script, PL/pgSQL, Python
Storage
PostgreSQL, DRBD, SQL Triggers, SQL Functions, Redshift, Google Cloud Storage, Google Cloud SQL
Platforms
Ubuntu, Linux, Linux RHEL/CentOS, Google Cloud Platform (GCP)
Other
Backup & Recovery, Performance Optimization, RHEL, Pgpool-II, Streaming, pg_repack, Ubuntu Server
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring