Technical Consulting Manager Outsourcing at Honda Automobile (Thailand) Company Limited.
- Daily healthcheck SAP Oracle database v.11gR2 (Dealer management system) and non-SAP Oracle 11gR2 and 12c database.
- Weekly healthcheck and incident report
- Monthly server performance analysis, database performance analysis and monthly preventive maintenance.
- Manage backup using RMAN, Tivoli and Commvault.
- Database assessment, tuning and housekeeping.
กันยายน 2557 ถึง เมษายน 2561
Deputy department manager
Thai Union Group
72/1 หมู่ 7 สมุทรสาคร 74000
สำหรับสมาชิกเท่านั้น
Asia IT - Infrastructure Management Department
- Subsidiaries : 2 ppls
- Manage vendor for data preparation, ETL and BI (Tableau, Power BI)
- Manage database performance using AWR, ADDM reporting for systems using Oracle.
- Manage MSSQL performance using UCP, MDW, SQL Profiler
- Consolidate databases from various sources (Warehouse, Financial Consolidate, ERP, DW, Business Process Improvement, others) into single Data warehouse. Propose solution related to system technical area such as network NAT, routing, etc.
- Manage all client by Windows AD, deploy an automation script, GPO to maintain client and support project.
- Manage backup, retention and test restore policy to well apply align auditors recommendation.
- Proposal for new software backup
- Lead project BI on cloud (Tableau Server, MSSQL Datawarehouse Server on Azure) and consolidate, ETL automation jobs load into single Datawarehouse.
- Learn Sales data structure, create SSIS ETL job for Sales data, Sales Dashboard
- Learn P&L data structure, create SSIS ETL job for P&L consolidate data, P&L Dashboard
มิถุนายน 2556 ถึง กันยายน 2557
Senior service engineer
Yip In Tsoi
523 มหาพฤฒทาราม บางรัก กทม 10500
สำหรับสมาชิกเท่านั้น
Outsource: government housing bank: Project Core Bank MA (On Site 8*5) On call 24*7
- Daily monitoring OS and Oracle database for Financial Core Banking system both DC and DR.
- Propose change request for tuning SQL, patching and any useful fix.
- Support YIT application team for the database related requests such as cloning database, extract data, migrate data, etc.
- Monthly preventive maintenance and create reports.
First Logic Co.,Ltd. (G-ABLE group) (Nov 2012 - Jun 2013)
Oracle Presale
- Pre-sale Oracle Database & Middleware product (Oracle Database, RAC, Exadata, EM, Goldengate, ODI, WebLogic Server)
- Implement & Consult Oracle Database, RAC, Exadata, Goldengate, Active Data guard
- Provide knowledge sharing for the internal business unit (G-ABLE & CDG)
- Help & support for other business unit in part of performance tuning, test, export, backup, error fixes.
- Help & support marketing team for all booth event as the value-added distributor & Core Technology Partner
ASAP solutions Co.,Ltd. (Apr 2012 Nov 2012)
Oracle DBA
- Implement and outsourcing
CUEL Limited (Oct 2009 - Mar 2011)
System/Database Administrator
Maintain apps/system/database 1 production (ERP Single node), 1 UAT, 2 DEV systems.
- Daily Operation - OS (Solaris Sparc 10)
- Daily Operation - Application (Oracle E-Biz 11.5.10)
- Daily Operation - Database (10.2.0.2)
- Daily Operation - Storage NetBackup
Mektec Manufacturing Corp. (Thailand) Ltd. (Oct 2008 - Sep 2009)
System/Database Administrator
Maintain apps/system/database Administration 1 production (ERP Multi nodes), 2 Test instances
- Daily Operation - OS (AIX)
- Daily Operation - Application (Oracle E-Biz 11.5.10)
- Daily Operation - Database (9.2.0.4)
- Daily Operation - Storage NetBackup