Power by


About Me

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
 
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


Accreditation







Certification

  • DB2 10.1 IBM Certified Database Administrator Feb 2017
  • Oracle 12c Database Administrator Certified Professional (OCP) June 2016
  • DB2 10.1 IBM Certified Database Associate March 2015
  • SAP Certified Technology Associate - OS/DB Migration for SAP NetWeaver 7.3 July 2014
  • SAP CERTIFIED TECHNOLOGY ASSOCIATE SYSTEM ADMINISTRATION (ORACLE DB) WITH SAP NETWEAVER 7.0 Aug 2011
  • Oracle Database 10g R2 Real Application Clusters Administrator Certified Expert (OCE) Apr 2008
  • Oracle 10g Database Administrator Certified Professional (OCP) May 2007
  • Oracle 9i Database Administrator Certified Professional (OCP) Jun 2005
  • Oracle 9i Database Administrator Certified Associate (OCA) Apr 2005
  • HPUX Certified Systems Engineer (CSE) July 2007
  • HPUX Certified Systems Administrator (CSA) Feb 2006
  • IBM Certified Specialist pSeries Admin and Support for AIX V5.3 (IBM Certified Specialist) May 2006
  • HP StorageWorks Accredited Systems Engineer (ASE) May 2008
  • HP StorageWorks Accredited Integration Specialist (AIS) 2008
  • HP Enterprise Storage Solutions Accredited Presales Consultant (APC) 2008
  • HP Data Protector Software (AIS Specialty in HP Data Protector) Nov 2007 
  • VERITAS Storage Foundation 4.0 (VERITAS Certified Specialist ) Nov 2006





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//sap ,/sapmnt//profile,.. )
- 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/ , /usr/sap/trans)
- 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
Loading