Evandro Simorangkir Email & Phone Number

Jakarta Metropolitan Area

Jakarta, Jakarta, Indonesia

o Manage Greenplum database (cluster) consists of 1 master node, 1 standby-master node, and 6 segment nodes.o Daily maintenance Greenplum database : check segment down, locked queries, long duration queries, number of active connections ; bring-up and recover segment down; analyze logs ; routine vacuum bloated table or database; database parameter tuning; indexing table; optimize SQL queries.o Manage Microsoft SQL server and Postgresql databaseso Daily maintenance of SQL server databases : check blocking spid, long-running queries, failed sqlagent jobs, alert logs; backup restore databases; shrink database files and database log files; create/modify user login; indexing table.o Daily maintenance of Postgresql databases : check locked queries, long duration queries; analyzed error logs ; create/grant access roles; vacuum table; indexing table; optimize SQL queries; explain analyzed queries; backup restore databases;o Manage cloud instances (GCP) : Microsoft SQL server and Postgresqlo Daily linux server monitoring : checking CPU, memory, disk utilization, running process, and cronjob ; RHEL package/software installation.

Jakarta Metropolitan Area

Project : Online Game Developmento Developing online game platform (Web and Mobile) databases : in charge in developing RDBMS databases system in cloud platform (AWS)o Developing datawarehouse for online game statistics and back office dashboard.o Using AWS services : Amazon Relational Database Service (RDS) and Amazon Elastic Computing Cloud (EC2)o Maintaining and troubleshooting MSSQLSERVER in AWS RDS : backup/restore databases, indexing table, parameter tuning, slow query tuning, partition table, optimize store-procedure syntax, restart services, etco Monitoring and optimize MSSQLSERVER in AWS RDS : monitor database resources, monitor active connections, create faster query or faster store-procedure,etco Migrating database from MSSQLSERVER to POSTGESQL in AWS RDS.o Develop python scripts for ETL (Extract Transform Load) used in migrating data from MSSSQLSERVER into POSTGRESQLo Developing POSTGRESQL databases in Amazon RDS and Amazon EC2 : Setup postgresql db engine; Create schemas/tables/PK/FK/views/materialized views/ procedures/functions/sequences/ index; Create jobs/schedulers using pgagent.o Developing and setup POSTGRESQL extension in Amazon EC2 : timescaledb, pgagent, pgbouncer, etc.o Scripting POSTGRESQL procedures and functions (PLPGSQL) used for grabbing data from database into dashboard (frontend)o Setup apache Kafka for real time data streaming from online game : setup kafka brokers (docker), create kafta topics, create partitions, create kafka producers (using python), create kafka consumers (using python), streaming kafka message (using python),etc.

Jakarta, Indonesia

Project : Manage Service DataWarehouseClient : PT.Bank BRI (Indonesian Banking Company)o Manage and monitoring data warehouse of core banking data (MSSQLSERVER platform) : 80 total MSSQLSERVER databaseso Manage and monitoring ETL server running SSIS Packages every day : 50 total ETL serverso Troubleshoot MSSQLSERVER issues : full tempdb, slow queries, blocking SPID, mssqlserver not running, table with no index, restarting MSSQLSERVER, backup-restore DB issueso Optimize MSSQLSERVER : create index table, partition table, optimize store-procedure syntaxs, create job to shrink log fileo Troubleshoot SSIS package issues : ODBC/Native connector issues, data-source & data-destination issues, errors related to data typeso Optimize SSIS packages : create ODBC/Native connector, create new/alternative pipelines, create new/alternative transformation step/containero Develop dashboard using Grafana for : database monitoring, table data presentation, server monitoring (cpu utilization, memory utilization, hard disk utilization, disk write/read throughput, etc)

Jakarta, Indonesia

Project : Automation DatawarehouseClient : Telkomsel (Indonesian Telecommunication Operator) ● Build and manage databases for storing, processing, analyzing data using PostgreSQL & SQL Server● Collect raw data from various formats (csv, excel, database table & JSON) and from various sources (ftp, sftp, oracle db, hadoop db, sybase db, mysql db, mssql server db, & mariadb) ● Perform data cleansing: formatting data_type, removing duplicate data, removing trailing/leading characters, etc.● Combined raw data from various sources into desirable data.● Perform data aggregation in SQL : grouping, sum, max, min, join, union, etc. ● Build automation using scheduler agent for : collecting data from various sources, cleansing data, combining data, and aggregating data. So all processes done by scheduler agent● Build ETL (Extract, Transform, Load) processes using python script.● Automate ETL Processes using scheduler agent and python script.● Build REST API : data transfer interface from databases to visualization tools (Power BI, Tableau, Grafana)● Perform data verification and data validation.

Jakarta, Indonesia

Project : Manage ServiceClient : Telkomsel (Indonesian Telecommunication Operator) ● Make report of Telkomsel network capacity utilization & network revenue (GSM, WCDMA, LTE).● Make matrix-9 report, red site capacity report, 3G/4G utilization report. ● Summary network capacity data (national data) to be processed into readable report. ● Analyze & give recommendation of high utilization network capacity.

Jakarta, Indonesia

Project : Manage ServiceClient : H3I Tri (Indonesian Telecommunication Operator) ● Monitor Hutchison 3 Indonesia (H3I) cellular network capacity.● Analyze cellular network capacity problems such as high utilization, low utilization, traffic blocking and congestion.● Plan for network capacity expansion, rebalancing, and dismantle.

Jakarta, Indonesia

Project : Manage ServiceClient : Telkomsel (Indonesian Telecommunication Operator) ● Analyze Telkomsel cellular network performance in north & west Sumatra.● Optimize poor cellular network performance to achieve target KPI.● Radio network parameter tuning to improve network performance.

Jakarta, Indonesia

Project : Network DeploymentClient : Bakrie Telecom (Indonesian Telecommunication Operator)● Analyze EVDO cellular network performance in Sumatra.● Optimize poor cellular network performance to achieve target KPI.● Radio network parameter tuning to improve network performance.

Jakarta, Indonesia

Project : Manage ServiceClient : Telkom Flexi (Indonesian Telecommunication Operator)● Collect signal data (drive test) of TELKOM FLEXI cellular network in Jakarta.● Analyze cellular data performance such as poor coverage, interference, low receive signal.● Optimize poor cellular network performance to achieve target KPI.