Developing shell script for Store File Transfer System.
- Merge many text files from store to head office system.
- Split file from head office system to each store.
Modify store application client (7-11) for send and receive files from head office with RSYNC Utility.
Creat and modify several shell Scripts according to the changing needs of the project and client requirements.
Setup and manage cron jobs, batch processing and job scheduling using shell scripts.
Perform proof of concept for migrate data from DB2 to Oracle with SQLDeveloper.
Migrate MySQL data to new sever.
กรกฎาคม 2562 ถึง กรกฎาคม 2563
Senior Officer (Technical Service)
GoSoft (Thailand)
313 Si Lom, Silom, Bang Rak, Bangkok 10500
สำหรับสมาชิกเท่านั้น
Installed, configured, administered and supported WebSphere Application Server ND v8.5/9.0 and IBM HTTP Server.
Installed, configured, administered and supported JBoss EAP Server and Apache Webserver.
Installed and configured Tomcat sever.
Created Clusters and instances in WebSphere Network Deployment to support HA.
Involved in creating and configuring profiles, clusters, nodes, node agents
for WebSphere Application Server.
Performed WebSphere Configuration backup and restoration using scripts.
Configured JDBC Providers, Data Sources, JDBC connection pools, Virtual Hostings, Global Security through admin console.
Created new virtual test environments for developers.
Developed housekeeping script for Application Server.
Installed MS SQL Server.
Installed and configured Oracle 10g , Oracle 11g, Oracle 12c.
Installed and configured Dataguard service in Oracle 11g for Diaster Recovery (DR).
Configured and switchover Dataguard service from Physical Standby to Primary.
Participated in writing Database Procedures, Functions, Packages and Trigger.
Maintained, configured, diagnosed and troubleshooting Oracle 10g RAC and Dataguard service.
Utilized SQL Developer, TOAD and SQLPlus for development and problem research.
Performed configured and setup schedule backup with RMAN Backup using shell script.
Monitored the Transaction activities.
Migrated database across different servers and platforms using data pump export/import and perform database refresh.
Management of schema objects, indexes and performing SQL Loader jobs for loading data from flat files.
Database tuning by generated explain plans for long-running queries, created indexes on columns to improve performance.
Developed script for monitor capacity of tablespace size and applied archive log status in standby database.
Created store procedure to extract the data from the operational database into simple flat text files and excel files using UTL_FILE package.
Analysed and designed table structure in many projects.