Hi,
I'm Somyos. Nickname is Lek.
I working various area of Infrastructure ,Implementer ,Consultant,Administrator.
E-Mail:lek_cpe@yahoo.com,lekcpe@gmail.com
Technical Skills
I'm Somyos. Nickname is Lek.
I working various area of Infrastructure ,Implementer ,Consultant,Administrator.
E-Mail:lek_cpe@yahoo.com,lekcpe@gmail.com
| Work Area -SAP Basis Consult,Administrator -System Engineer,System Integration,Administrator -Oracle DBA Consult,Administrator | Education -Master of Science IT of KMUTT -Bachelor of Computer Engineering of KMUTT |
Technical Skills
Type
|
Detail
|
SAP
|
- Installed Sap R/3 ,J2EE,Dialog for Sap ECC 6 /4.7/ NETWEAVER BI 7/ BW 3.0 on Unix and Windows
- Installed Secude for Integrate Sap 4.7 Server Sent to Certify client from Smart Card to LDAP server ( CA Authentication)
- Installed Sap Download Manager
- Installed to Import Thai language with supplement
- Perform SAP homogeneous system copy ABAP+JAVA Oracle Database by SAPINST& DBTOOL
- Perform SAP homogeneous system copy ABAP+JAVA MS SQL Database by DBTOOL
- Perform SAP heterogeneous system copy ABAP ECC6
- Perform SAP heterogeneous system copy JAVA Enterprise Portal EP6
- Perform SAP heterogeneous system copy ABAP CRM 4.0 and JAVA IPC/ICSS CRM
- Perform SAP heterogeneous system copy ABAP BW
- Perform SAP heterogeneous system copy to MCOD ABAP Environment Oracle Database
- Integrated LDAP(critical path) synchronize DN name with Sap username
- Post installed process sick,se06,sgen,saplicense,stms
- Client Copy ( remote and local )
- Design and sizing ERP server/backup/network for SAP with Vendor and Customer and Create backup/restoration for Disaster Recovery Plan and Strategies for SAP System Landscape
- Designed and setup SAP Printing with SAP Sprint
- Designed Blueprint Phase for Technical Infrastructure
- Designed and Setup File system for reduce I/O workload with for SAP and Oracle Database
- Designed and Setup SAP Authorization composite with single roles and derive roles
- Designed ,and Planning for recommend and Setup SAP Printer ,PC ,Backup ,Report & Form for As-is and To-be
- Setup Solution manager for Maintain optimizer and Early Watch ,and Going Live Check in Analysis ,Verification Phases with Solution manager
- Setup Central User Admin (CUA) for Manage user account on SAP DEV,QAS
- Setup ALE for Message types ,and IDOC
- Setup Scot to send sap mails to internet mails
- Setup Transaction and Screen variant for Hide values ,buttons
- Setup Logical Spool Server for Production printers Landscape
- Setup Log on Load balance (SMLG) and Operation mode
- Configured Backup/Restore by sapdba ,brtools,brrestore,brbackup/OS command/Sap agent with Omniback, Sap agent with Netbackup point in time(full,partial,individual,Apply archive )
- Configured Sap Gateway on DB different machine with CI for completely brtools and db13
- Configured Sap and design lay-out with cluster software Central system(DB/CI) and DB/CI on different machine
- Configured Script automatic start Disaster Recovery Sap by XP Storage
- Configured Transport Management System for Sap
- Configured Sap-router and VPN Connection and Certificate Client for Linux ,Windows
- Configured Smartcard and Secude and SSL and ICM (WEB) Certify Authentication for Sap R/3 ,BW
- Configured System profile parameter
- Configured Sap and Omniback/Dataprotector Utility Tools for Periodic Schedule Online, Offline ,and Archive Backup
- Configured Openview for Integrate Sap 4.7
- Monitoring Sap process ,cpu ,memory ,utilization
- Monitoring Database ,Operating system Alert Monitor
- Monitoring Backup/Archivelogs
- Monitoring Overview ,Schedule background Jobs ,Dialog process ,Database locks ,Update terminates
- Monitoring ITS (wgate,agate) for Sap gui HTML
- Monitoring ICF/ICM/J2EE and Sap web dispatcher
- Maintain Kernel patch,Support Package ,Spam/Saint Add On—Plugin /snote, Supplement Thai language Sap ECC6/4.7/4.6/ IDES/ BI/BW
- Maintain authorizations / user maintenance
- Maintain Profile and Operation mode
- Maintain file system allocate free spaces for database
- Maintain system structure OS for sap (/oracle/
- Maintain Cloning Sap system by OS different hostname)
- Maintain Storage allocate free spaces file system for OS
- Maintain System profile parameter for backup/restore ,Third party
- Maintain File sharing System (NFS) for Sap ( /sapmnt/
- Maintain Integrated Third party software (performance ,authentication ,utility for backup/restore)
- Maintain Disaster Recovery Sap other machine
- Maintain Backup/Restore by OS command for Sap
- Maintain Configured Clustering machine for Sap
- Maintain Split Storage backup for Sap
- Applied OSS Notes for fixing any SAP standard issue for BASIS ,and Functional teams.
- Performed adjust SAP from Earlywatch ,Analysis Report
- Performance Tuning SAP and Oracle Database buffer
- Conducted training and performed knowledge transfer for Basis team of customer
- Helped and supported both consultant and customer teams
- Problem Solving Sap ECC6/ECC5/4.7/4.6C
- Collective exiting system information for client pc, server ,backup ,exiting software ,and interface for new SAP environment
- Post Go-live sap support
|
Oracle Database
|
- Installed Oracle 8i,9i,10g on Unix and Windows
- Installed Standby or DATAGUARD database 8i,9i,10g on Unix and Windows
- Installed Oracle RAC 10gR2 on Unix and 10gR1 on Windows
- Installed RMAN Backup oracle 9i,10g Unix and Windows
- Apply Patch Oracle 8.1.7,9.2.0.4,9.2.0.5,10.2.0.3,10.2.0.4
- Upgrade from DBUA Oracle 8i to oracle 9i, Oracle 9i to oracle 10g, Oracle 8i to oracle 10g
- Upgrade from Export/Import Oracle 7i to oracle 10g , Oracle 8i to oracle 9i, Oracle 8i to oracle 10g, Oracle 9i to oracle 10g
- Export/Import (full database ,tables ,user schema)
- Configured ASM on Oracle RAC one/two node
- Configured Data loading using Script SQL *Loader
- Configured Oracle 9i Repository for Management Server (OMS) with agent for Windows ,Unix
- Configured Oracle Multiple DB Difference SID on one machine for Hp-UX, Linux, Windows
- Configured Oracle ,Omniback/Dataprotector and VERITAS Netbackup Utility Tools for Periodic Schedule Online, Offline, and Archive Backup
- Configured to Connecting (PHP ,ASP ,ODBC ,Oracle client) Application to access Oracle Server
- Configured undo segment instead of rollback segments after upgrade new version Oracle database
- Backup/Restore by OS/Rman/Oracle and Omniback/Dataprotector point in time (full ,Apply archive Production System)
- Monitoring Oracle process ,cpu ,memory ,utilization , Tuning Memory SGA,PGA
- Monitoring Oracle RAC
- Monitoring resource and group Oracle Fail safe on Windows server
- Maintain Tablespaces and planning the location of data ,index ,constrains redo log file ,control file ,rollback segments ,undo segments
- Maintain Checking for errors in alert logs
- Maintain files system allocate free spaces for database
- Migrate oracle database on file system to ASM database Instance
- Disaster Recovery Oracle by Standby Database
- Problem Solving Oracle 7,8i,9i,10g
|
MS SQL Server Database
|
- Installed MS SQL Server 2000,2005 Windows
- Backup/Restore master/msdb,SAP by SQL Studio
- Apply Service Pack for MS SQL Server 2000,2005
- Maintain Users
- Maintain File location,and Transaction log
- Maintain move SQL Server databases to a New location
|
DB2 Database
|
- Installed db2 udb version8 Windows
- Create test database
|
MC/SERVICEGUARD Cluster ware
| - Installed and Configured MC/SERVICEGUARD Cluster HP-UX with ORACLE,SAP - Installed and Configured MC/SERVICEGUARD Cluster LINUX REDHAT with ORACLE - Monitor/fail-over/fail-back Cluster Node and Package Status MC/SERVICEGUARD cluster (HP-UX) - Configured Script Start/Stop and Monitoring Package on MC/SERVICEGUARD cluster (HP-UX) - Rolling upgrade MC/SERVICEGUARD cluster to new version (HP-UX) |
VERITAS Cluster ware
| - Installed and Configured VERITAS Cluster on Linux REDHAT and SUSE with ORACLE - Configured Oracle /SAP Agent Resource AIX - Monitor/fail-over/fail-back Cluster Node and Resource group Status on VERITAS cluster |
OpenAIS Cluster ware [SuSe]
| - Installed and Configured OpenAIS Cluster on Linux SUSE 11 with Oracle 11g - Configured Oracle Agent Resource AIX - Monitor/fail-over/fail-back Cluster Node and Resource group Status on OpenAIS cluster |
RAC Oracle Cluster ware
| - Installed and Configured Oracle Clusterware (CRS) on HP-UX ,Linux REDHAT ,Windows - Monitor Cluster Node and Package Status MC/SERVICEGUARD cluster (HP-UX) |
HACMP Cluster ware
| - Monitor Cluster Node and Resource group Status on HACMP cluster (AIX) - Configured Script Start/Stop and Monitoring Resource group for HACMP cluster (AIX) |
MS Cluster ware
| - Monitor/fail-over/fail-back Cluster Node and Resource group Status on MS cluster (Windows) |
Sun Cluster ware
| - Monitor Cluster Node and Resource group Status on Sun cluster |
HP-UX Operating System
|
- Installed Hp-UX 11i(v1,v2,v3) Operating System on PA-RISC and Itanium (IA)
- Installed HP Integrity Virtual Management (HP IVM)
- Installed DEPOT Software for Hp-UX Goldbase ,Bundle ,HW Enable Patch, sudo ,SSH, Apache,PGP ,Jdk Java ,Oracle 8i, Oracle 9i,Oracle 10g,SAP ,SAP R/3 4.6C,SAP R/3 4.7,IDES R/3,BW 3.0,BW 3.2
- Managed LVM,VXVM(VERITAS volumn manager)
- Managed Filesystem/Disk Path with storage(11i v1,v2 and 11i v3 DSF)
- Managed LVM Mirror UX ,Mirror vg00 boot disk
- Managed Npar, Vpar ,HPVM
- Managed GSP,MP Console
- Managed Extend size Volume and Logical Volume group for vxvm ,vxfs
- Backup/Restore ignite server /ignite tape ,cpio ,tar,gzip, fbackup files system and OS
- Backup/Restore Oracle and SAP by OS
- Configured GSP Console Modify Partition
- Configured Apache Web server ,FTP,SFTP Server ,SSH Certify Server, PGP Certify Client
|
AIX Operating System
|
- Installed AIX 5.3 Operating System on P-Series
- Installed Software for AIX Patch,Jdk Java,Oracle 9i,Oracle 10g
- Installed VERITAS file system
- Managed LVM,VXVM (VERITAS volumn manager)
- Managed HMC Console LPAR
- Managed Filesystem/Disk
- Managed LVM Mirror Disk ,Mirror rootvg boot disk
- Managed Extend size Volume and Logical Volume group for jfs, jfs2,log jfs
- Backup/Restore makesysb ,cpio ,tar ,gzip system and OS
- Backup/Restore Oracle and SAP by OS
|
Linux Redhat/Suse(Sles) Operating System
|
- Installed Linux Redhat 7,8 ,TLE , fedora 1,2,ES and AS 1,2,3,4,5
- Installed RPM Software for Linux Proxy ,Tripwire ,Apache ,iptables, ipchains, Sudo ,Ssh ,PGP,Jdk Java, Oracle 8i, Oracle 9i,Oracle 10g
- Configured Hardening operating system
- Configured iptables ,ipchain, DHCP, GATEWAY, DNS
|
Sun Operating System
|
- Installed Sun solaris 10 Operating System on x86
- Installed PKG Software for Solaris
- Managed Filesystem/Disk slice
- Backup/Restore ufsdump ,cpio ,tar ,gzip
|
Windows Operating System
|
- Installed Window NT 4 server ,2000 server, 2003 server Operating System ,Promote Domain Controller
- Install Software for Windows Patch ,Service Pack , SSH, Apache, X-Windows, PGP ,JDK Java ,Oracle 8i, Oracle 9i,Oracle 10g,SAP R/3 4.6C,SAP R/3 4.7,IDES R/3,BW 3.0,BW 3.2
- Configured Array Disk Raid Manager for HP Compaq Intel Server(ML ,Net server)
- Configured Dynamic Disk Windows 2000 server,2003 server
- Configured DHCP, GATEWAY, DNS
- Configured Boot loader ,IIS Web server, Apache Web server, FTP,SFTP Server ,SSH Certify Client ,PGP Certify Client
|
HP Hardware Platforms
|
- L-class ,RP-class ,RX-class ,and RX Unix Blade (HP-UX)
- Prolian ,DL-class ,ML-class ,Intel Blade (X86 intel base)
- DAT Drive DDS1,2,3,4 Ultrium 2,3,4, AutoLoader ,MSL Tape Library
|
IBM Hardware Platforms
|
- P-series (AIX)
- X-series (X86 Intel base)
- DAT Drive DDS1,2,3,4 Ultrium 2,3,4, AutoLoader, Tape Library
|
EVA Hp Storage System
|
- Design layout and Configured Vraid and LUN from App client browser and basic script BC
- Implement Shell Scripts BC on split oracle database with HP-UX
|
MSA Hp Storage System
|
- Design layout and Configured Raid and LUN from Comman Line /ACU client browser
|
VA Hp Storage System
|
- Design layout and Configured Raid and LUN from App client browser
|
XP HP Storage System
|
- Monitor XP-Storage Pair status and HORCM manager for HP-UX
|
FastT,DS Ibm Storage System
|
- Design layout and Configured Raid and LUN and Flash copy and Logical copy from SMclient
- Implement Shell Scripts Flash copy on split oracle database with AIX
|
NetApp Storage System
|
- Design layout and Configured Raid and LUN from client browser
|
HP Openview Dataprotector /Omniback Backup
|
- Installed DataProtector,Omniback Cell Manager for Hp-UX 11i Server/Windows clients
- Integrated Rman Backup Oracle 8i,9i,10g/SAP agent backint
- Deployment DataProtector,Omniback for Hp-UX 11i,and Windows Client
- Configured Specification and Schedule Backup Oracle 9i/SAP
- Configured Full backup/ archive Oracle
- Restore Full backup file System Oracle/SAP with archive log for recovery
|
VERITAS Netbackup Backup
|
- Integrated Rman Backup Oracle 8i,9i,10g /SAP agent with backint interface
- Configured Full backup/ archive Oracle
- Configured Specification and Schedule Backup Oracle 9i/SAP
- Configured Full backup/ archive Oracle
- Restore Full backup file System Oracle/SAP with archive log for recovery
|
Sanswitch brocade
|
- Configured zoning ,alias,port
- Configured LUN masking to host windows,aix,hp-ux,linux
|
Network and Security
|
- Add Rule and Routing table Check Point Firewall for Windows ,Stonegate for Linux ,iptables for Linux
- Scan port and Service ISS Scan ,Retina Scan,Nessus Check Harderning Operating System, Ethereal Scan package
- Monitor Load balancer hardware (F5 BIG-IP)
- Monitor IDS (intrusion detection Host base),Office scan(server virus scan), LDAP, Web server
|
HP Openview operation(OVO),reporter ,internet service(OVIS)
|
- Monitoring system by OVO
- Configured Opc template to check System overview
- Configured Opc Template to integrate SAP 4.7 and smart plug-in
|
Shell Script Language
|
- Menu SAP auto Startup/Shutdown Disaster Recovery Site (Read Data from Cluster file)
- Menu Oracle Backup/Restore by OS Backup
- Menu Management Oracle for Administrator and Operator
- Menu Oracle Startup/Shutdown
- Menu Websphere Startup/Shutdown
- Menu Peoplesoft(JDE) Startup/Shutdown
- Menu SAP Startup/Shutdown
- SAP start/stop Script for MC/ServiceGuard Cluster
- Split Mirror Backups Oracle with SAP (EVA,XP storage)
- Business Copy Oracle [SAP] EVA HP storage)
- Flash Copy Oracle [SAP] DS IBM storage)
- Oracle hot/cold Backup Database file system Script
- Oracle start/stop Script for HACMP cluster and MC/ServiceGuard Cluster
- Oracle Rman Backup Script
- Oracle Analyze Optimizer script (COB)
- Oracle Standby Database (Standard Edition) manual ftp Archive Log to Disaster Recovery Site
- Oracle Export(logical Backup)
- Oracle Loader Data
|
Bat Script Language
|
- Menu Management Oracle for Administrator and Operator
- Oracle Export(logical Backup)
- Oracle Loader Data
|