DwiAmri Yanto

Senior Oracle Database & Unix Infrastructure Engineer with 19+ years of experience managing large-scale enterprise database environments including Oracle RAC clusters & SAP load balancer, SAN, Exadata, and migration from Sparc to X86 machines, ODG, database performance analysis using ASH, AWR, ADDM. Extensive experience designing high-availability architectures, and capacity planning based on workloads also certified in Oracle Database Administration and Oracle sun clustering

Aug 2022 – Present – Sr. System & DB Engineer, PT Data Network Solutions

• Projects like Unix, Linux, Oracle mostly for HA solutions like clustering, replication & migration, Oracle RAC, ODG, and xtts cross platform migration Big Endian proc to Little Endian Intel based, from Sparc zones to Oracle Linux based VMs and from legacy machines to VM ecosystem
• Support migration Oracle DB on prem to Oracle on OCI & to Amazon Aurora Postgre via AWS SCT and AWS DMS
• Do maintenance contract checking and troubleshoting performance issues on Oracle DB, make reports about DB health status
• Fine tuning using tools like statsapck for legacy client, AWR and ADDM, tuning on block data health level like reorg, shrink, partition, attribute clustering, instance like pga, sga, process, session, transaction, red log, undo tbs space, undo retention, temporary tbs, and sql queries tuning recommendation mostly on top system events like buffer busy wait, db sequential read, latch free, row lock contention, and top sql queries on where and join clauses

Aug 2012 – July 2022 – System & DB Administrator Lead, PT Mitra Adiperkasa

Lead administrator responsible for enterprise SAP ECC6 EHP8 and Oracle 12c database environments supporting multiple business units across the MAP companies Group.

Key Achievements

• Managed large SAP environments running Oracle databases on SPARC M, T, V Series, and x86 SUN X series Exadata X7, and HP ProLiant servers with focus on high availability and disaster recovery architecture to get minimum downtime and minimum data loss
• Lead major SAP platform migration from SAP R/3 4.7 to ECC6 EHP8 including Oracle upgrade from 8i/9i → 12c / 19c with SNP NZDT with CDC method tool from old to new devices
• Managed large-scale storage migrations and massive SAP retail tables archiving with opentext and multi tier storages management for SAP HANA migrate preparation, move old archived data & not accessed partitioned tables to SAS disks, new data and most accessed data put on expensive disks
• Do routine online reorg for aggressive growth and fragmented tables and move to new tablespace to reclaim space and optimize storage index Exadata with reorg, attribute clustering, table partioning, and HCC activation for specific tables like the most highest scan IO reads, the fastest growth, the most consumed interconnect bandwith
• Administer and maintain Oracle RAC clusters supporting critical SAP workloads load balancer with role based services for SAP ASCS and ERS, Active Passive Sun cluster, SLES Pacemaker & Corosync cluster, Veritas VCS for Oracle DB, Listener, and SAP ASCS CI servers
• Designed and implemented Active Data Guard disaster recovery environments with annual DR drills and monitoring of redo transport / apply lag, activate snapshot ODG and convert back as for small testing team / SIT
• Performed database performance tuning using: ASH AWR ADDM reports, SQL trace & TKPROF, OS tools like Dtrace & SAR, optimizer execution plan checking using DBMS_XPLAN, SQL Plan Management baselines, tuning various levels from data health level like reorg & update statistic, instance level like sga, pga, undo size & retention, redo log resize, temp size, session & process tunings, sql level like query checking where & join clauses, rewrite SQL to vaoid too many hard parsing and index checking
• Worked closely with SAP ABAP teams to resolve high-cost SQL queries and optimize workload performance
• Implemented shell scripts for automated day to day monitoring for monitoring team, cluster health & status, database status, Data Guard synchronization & gap, disk I/O and system resources, threshold process & sessions alerts, sessions locking on db, housekeeping logs, and backup results, also combined my scripts to Grafana monitoring & OEM
• Pool all server secure logs and Oracle audit trail log *.aud logs to rsyslog with imfile module
• Manage servers, OS, users access and rbac for separate teams IT Monitoring, IT Middleware Programmers, SAP & Orace dba, and IT auditors, with automation tools like Ansible for monitoring, pakcages & patches OS & DB updating according to CIS benchmark and collection data for auditors

July 2009 – June 2012 – System Engineer – Pacific Interlink Sdn Bhd

Responsible for infrastructure supporting enterprise SAP implementations across multiple regional sites.

Key Responsibilities

• Managed SAP infrastructure running Oracle10g and DB2 LUW databases on IBM Power systems P8 AIX
• Designed and implemented multi-site disaster recovery environments with Oracle ODG

Primary DC → Jakarta

DR sites → Medan and Johor Bahru

• Tuning SAP & Oracle parameters like Saptune, Work process, dialog, btc, upd, print, additional dia servers, ASMM, process, sessions, transactions, redo size to get 1 per 30 minute, undo size, temp size, and paralel process on standby DR to make apply log faster
• Performed DR failover / switchover yearly testing and backup recovery procedures
• Managed storage architecture including RAID configurations optimized for database workloads

2008 – March 2009, Sun Presales Solution Architect – PT SCS Astragraphia Technical presentations to assist sales persons, solution architect for design & BoQ for Sun servers, storage, SAN switches with SUNPWD tool & SAP quick sizing numbers

2007 – March, 2009 – SUN Engineer & Oracle DBA – PT SCS Astragraphia

Provided infrastructure and database administration for government mission-critical systems.

Key Contributions

• Managed high-end SPARC & X86 enterprise servers including Sun Fire E25K/E15K, Exadata V2, for big government projects like Pertamina and Jamsostek, its DC and DR
• Administered Solaris 8/9 Oracle 9i RAC clusters and Weblogic application
• Implemented Oracle Data Guard disaster recovery and yearly drill switchover
• Add and extend datafile and undo tablespace, apply manually archived logs in DR to fill the ODG gap
• Performed storage migrations SUN StoreEdge & STK and yearly capacity planning using Solaris SAR and Oracle Statspack workload analysis

Awarded Best Performance Team for successful delivery of the Jamsostek DC/DR project

Jan 2005 – April 2007 – Data Center Team Lead - PT SCS Astragraphia

Managed Unix SUN and Fujitsu & Windows servers, HP OpenView monitoring, NetBackup, AD & Exchange migration.

April 2002 – May 2004 – IT Staff – PT Interkemas Flexipack

IT Support, Troubleshooting, ERP BAAN support.

Bachelor Degree of Physics, Electronics, GPA 3.1, ITB Indonesia