Jiravit Supavatanangura

206-***-**** Seattle, WA acxn28@r.postjobfree.com

Skilled and experienced IT professional with over 10 years of expertise in database administration, infrastructure, and operations. Subject matter expert in database design, configuration, and high availability implementation specializing in Oracle, SQL Server, and DB2. Recognized for ability to solve complex problems, improve processes, build partnerships to support organizational success, and develop high performing teams. Excellent verbal presentation and written communication skills.

TECHNICAL SKILLS

Database: DB2 Oracle MS SQL Server MySQL MS Access

Application: SAP ECC 6.0 IBM DataStage 8.0.1 Crystal Reports BusinessObjects XI

Operating System: MS Windows Server HP-UX Solaris AIX RHEL

Language: SQL Perl C/C++ HTML Shell Scripting

PROFESSIONAL EXPERIENCE

SOUTHEAST INSURANCE, PLC – Bangkok, Thailand

IT Consultant (February 2016 – July 2016)

Served as consultant to IT Senior Executives and member of Vendor Evaluation Committee. Responsible for conducting complete assessment of the company’s technology portfolio and operations; and identifying process and resource improvement. Provided expert knowledge and best practices in key technology areas, including database management, infrastructure, and system security to maximize efficiency and reduce cost.

Responsible for developing the company’s first 5-year database strategic plan to strengthen IT infrastructure and support key business initiatives.

Designed and implemented enterprise architecture standard that aligns with the overall company’s business strategies and serves as framework for evaluating and onboarding new technology and resources.

Improved database backup and recovery strategies for the company’s core system, resulting in significant reduction in execution time from 4 hours to 30 minutes.

Established policies, standard operating procedures, guidelines, and security baseline standard for team members to effectively maintain, secure, monitor and optimize databases.

CIMB THAI BANK, PLC – Bangkok, Thailand

Database Administration Manager (June 2008 – October 2015)

Responsible for managing a team of senior database administrators and overseeing strategy and implementations of all deploying, monitoring, and supporting of more than 50 systems running on various DBMS such as Oracle, DB2, and SQL Server. Managed $1M annual software maintenance budget and maintained a multi-year software asset forecast. Acted as the primary DBA and technical focal point for a large number of critical projects, including Enterprise Resource Planning, Data Consolidating Systems, and Internet Banking. Administered, maintained, and utilized policies and procedures for ensuring security and integrity of the databases.

Successfully designed and implemented database consolidation project that resulted in more effective management of database systems and generated cost saving of over $800K in software licenses.

Developed and maintained a data warehouse with over 5 terabytes and utilized Oracle Partitioning feature to gain faster performance by lowering query times and improving manageability.

Served as system administrator for a Data Consolidating Systems project that involves ETL processes using IBM DataStage, and business intelligence using BusinessObjects on HP-UX platform.

Responsible for the overall management of the company’s database software licenses and IBM software licenses, and for internal or third party software audits.

Successfully performed database migration from Oracle 9i to 10g within 1 hour for internet banking system, one of the company’s most critical applications.

Designed and implemented centralized backup and recovery strategies utilizing Veritas Netbackup to optimize reliability, availability, performance, manageability, and cost considerations.

Responsible for SAP BASIS administration, including monitoring and taking corrective actions on SAP systems, tracking key performance indicators, and trend reporting.

Implemented IBM License Metric Tool system to collect hardware and software information from over 70 servers to maintain compliance and eligibility for the sub-capacity licensing.

Administered HP Serviceguard and IBM PowerHA for high availability and disaster recovery solution for various critical systems to minimize downtime.

EXPEDITORS INTERNATIONAL OF WASHINGTON, INC. – Seattle, WA

Database Administrator (October 2005 – April 2008)

Responsible for managing reliability, integrity, availability and consistency of data by supporting over 1,000 databases globally. Engaged systems administrators, software developers and application support to deliver database environments that support business objectives. Provided 24x7 on-call production support. Monitored database resource usage and recommended hardware/software upgrades when needed.

Acted as the primary DBA responsible for successfully implementing High Availability and Disaster Recovery (HA/DR) solution, using DB2 HADR combined with Automatic Client Reroute (ACR) features for one of the company’s most critical applications to ensure business continuity with minimal to zero downtime.

Provided consistent data across the organization by designing and implementing data replication strategies.

Created documentations to be used among the team on standard procedures including database creation, DBMS installation and upgrade, and replication setup.

Successfully designed a database migration plan and migrated more than 15 databases from Sybase platform to DB2 within two weeks, improving reliability and availability.

Performed database recovery on more than 50 production databases to minimize data loss and ensure business continuity.

Developed Unix shell and Perl scripts to automate database operations and database monitoring.

J.V. CONTROL LIMITED – Bangkok, Thailand

Database Administrator / Report Writer (August 2004 – May 2005)

Developed and executed maintenance plans to maximize availability, performance, and reliability of SQL Server databases. Supported web-based applications which directly interface with corporate databases.

Installed and administered Crystal Enterprise as well as created, modified, designed, and implemented 20 reports using Crystal Reports for an integrated supply chain management system.

Utilized Data Transformation Services (DTS) for importing, exporting, and massaging data.

Advised executive management on technical application and database issues as related to corporate business rules, practices, and changes.

EDUCATION

M.S., Information Management – UNIVERSITY OF WASHINGTON (Expected Graduation: 2018)

B.S., Computer Science – SEATTLE UNIVERSITY (2003)

Contact this candidate