Engineer Software

Matthew Pham

***** ****** **, ********, ** ***** 951-***-**** abnu6c@r.postjobfree.com

OBJECTIVE

Seeking a database position in an organization to provide expert knowledge of TERADATA and others DB best practices

enabling the team to leverage the platform as effectively as possible, and to advance and promote the effective use of

business information to support the business strategic project execution, and information delivery through analytical tools

and reports.

SUMMARY OF QUALIFICATIONS

Over 28 years of experience in technology field, with 15 years as system engineer/DBA emphasis in large DBMS

TERADATA, ORACLE, SQL, LINUX, UNIX and Windows systems. Experience specialized with TERADATA

development, pre-production, and production environments. Possess strong knowledge of methodology, tools,

standards and procedures, and subject matter expertise with strong business knowledge.

Demonstrate an excellent technical and analytical skills (e.g., systems design), and strong programming and

design skills with working knowledge of project management concepts and in depth knowledge of information

systems concepts and the ability to proactively manage problems. Attain very strong infrastructure experience,

application development, customer skills and support experience.

Possess excellent interpersonal skills, communication, analytical, detail-oriented and organizational skills with the

ability to handle multiple tasks concurrently, problem-solving skills, decision-making and leadership abilities.

Work well with and respect for all levels of business, all departments and levels within the organization data

modelers, ETL staff, BI developers, and business system analysts by contribute to strong customer dedication,

achieve highest standards of integrity, make strong commitment to excellence, and attain accountability for

success.

Fluent in English, Vietnamese, Laotian, and Thais.

TECHNICAL SKILLS

Databases: TERADATA RDBMS V2R2,3,4,5,6 TD12,TD12.5TD13, Oracle, SQL Server7

Hardware: EMC, SAN, SYMBIOS Array storage, PC hardware, IDE/SATA hard drives, Intel node/Dell node

Operating Systems: UNIX, MPRAS, LINUX, Solaris, AIX, Windows 2000/2003/NT/XP/Vista

Utilities/Tools: FASTLOAD, FASTEXPORT, MULTILOAD, TPUMP, TESTBYTES, DGEN, INFORMATICA,

IRWIN, COGNOS, VERITAS Backup, SYMATEC Antivirus, Trend Micro-Office Scan, TERADATA Manager/Tools

Box, QUERYMAN

Languages: Perl, SQL, UNIX Shell Scripting, Java, JSP, JDBC, XML, HTML, C, C++, VB

Networking: LAN/WAN, Ethernet 802.3, TCP/IP, DHCP, DNS, WINS, ARP, FTP, Telnet, DSL/Cable, hubs,

routers, Ethernet 802.11

Tools and Applications: Source Control System Clear Case, Clear Quest, MS Office, MS Office Tools, MS Visio

CERTIFICATIONS

TERADATA Professional Certified, Oracle trained, Database Administration for UNIX, LINUX, Windows,

Microsoft Certification System Engineer (MCSE) NT4.0

Logical Data Model (DCI) - (1998)

TERADATA DBS and Call Level Interface - (1997)

TERADATA RDBMS Support V2R2 and V2R3 - (1996)

TERADATA DBS System Administration - (1996)

TERADATA DBS Performance and Tuning - (1996)

TERADATA RDBMS Support V2R2 and V2R3 - (1996)

EMC SYM3 and SYM4 products - (1996)

MP-RAS UNIX Dump Analysis - (1996)

AT&T System Architecture Course - (1995)

MP-RAS UNIX Tuning - (1994)

MP-RAS UNIX System Administration - (1994)

SYMBIOS 6257, 6256, 6299, 6298, 6250, Series 3 and Series 4 Controllers

PROFESSIONAL EXPERIENCE

NCR/AT&T/NCR/TERADATA Corp. Dayton/Miamisburg, OH (May 1980-April/2008)

Consultant Software Engineer/Senior Performance Engineer (1996-2008)

Senior System/Software Engineer (1993-1996)

Senior Solution Engineer/Principal Hardware Engineer (1990-1993)

Circuit and Memory/Component Engineer (1985-1990)

System Technician/Senior System Technician (1980-1985)

Matthew Pham

32302 Alpine Ct. Temecula, CA 92592, 951-***-****, abnu6c@r.postjobfree.com

Consultant Software Engineer/Senior Performance Engineer (1996 - April 2008)

Possessed an in-depth understanding of database internals and infrastructure, Performed designing, modeling,

installing, implementing, maintaining, managing, perform tuning and configuration, coordinating systems support,

performing system administration, system security, software update management, and data dictionary

maintenance.

Expert level related to TERADATA physical database implementations (e.g., in-depth understanding of skew, PPI,

joins methods, data access paths, and workload management). Understood and performed using architectural

diagrams, logic flowcharts, data maps, operating procedures, maintenance and support procedures, and tools.

Possessed strong knowledge of database architecture concepts, specific implementations. Involved in significant

a high-volume production environment. Experienced with open source ETL packages and methods for large

scale data migration. Diversified technical background with awareness of concepts in networking, LINUX, and

storage.

Responsible included analyze and determine the problems on pre-release software (V2R60, V2R6.1, V2R62,

TD12 and TD13) in compliance to meet or perform better than previous released on various OS like

Windows/UNIX/LINUX and HW platforms. Ensured that no regression impact by release feature added to the

minor or major release. If regression found identify the root cause of problems and analyzing collected raw data

from system internal log tables such SVPR and SPMA and trace affected code and recommend code changes by

of RFC (request for change) or DR (defect report).

Knowledge and experienced with database storage management, data acquisition and transformation, data

generation techniques, and data load utilities and tools by using TESTBYTES, DGEN, FASTLOAD,

FASTEXPORT, MULTILOAD, TPUMP, SQL Server DTS, INFORMATICA, TERADATA Manager, WINCLI

Runtime, BTEQ, BTEQ Win, Index wizard, and Statistics wizard. Understood the concepts and very familiar with

BI tools such as COGNOS, Business Objects and Micro-strategy.

Created SQL test scripts, designed test data, characterized database Performance Feature released and

performed regression capacity planning test release for various MP-RAS, Windows and LINUX platforms.

Performed and analyzed RSS Res-usage data from SPMA and SVPR tables.

Specialized with emphasis in design for backend batch systems which included: SQL Scripts, Shell Scripts.

Experience with ERWIN tool for LDM, PDM, DDL Scripts.

As OS system administrator, DBA supporting Customer Relationship Management for RO and VA development

projects. Responsible for the implementation and maintenance of database backup and recovery processes.

Responsible for administering and auditing database security. Performs installation, upgrades, and patching of

database software

Handled replication: managing replication delay, scaling replication throughput, and designing resilient systems.

Configuration: tuning DB, managing memory usage, and tuning file systems for maximum throughput.

Reliability: backups under load, failover strategies, and recovery from replication issues.

Monitored and maintained production test and development environments.

Planned, created, designed and exported scripts, data manipulation and definition scripts, load scripts, using

procedures in TERADATA SQL, UNIX scripts for file manipulation, and execute test plans for Unit, Integration,

and System test phases. Set up and performed runtime database optimization and performance tuning.

Performed deployment, operation, and design to ensure high reliability and performance

Performed daily database maintenance activities and supports the environment. Enhanced and maintained

database security and integrity. Database scheduled back-ups and recovery. Designed and implemented

disaster recovery plans.

Actively managed quality control and audited of databases to ensure accurate and appropriate use of data.

Worked with users to resolve data conflicts and inappropriate data usage. Reviewed and resolved solution

design.

Collaborated with developers and architects to create high-performance, cost-effective designs.

Participated in an on-call rotation as part of a 24x7 operations team to resolve urgent production issues

Ensured data integrity with good process and a keen eye for detecting errors and misused of data.

Performed backup and restore (BAR) design and implementation. Created database objects for tables, user ID,

roles, profiles, grant users. Designed and monitored alerts, database parameters, and performance metrics.

Added columns, built indexes, and analyzed indexes. Performed and managed patches and releases for

departmental systems.

Performed administrative functions related to database support and project activities. Very proficient with

TERADATA tools including TERADATA Manager, TERADATA's Priority Scheduler, and BTEQ

Created UNIX Scripting for backend application as well as support tools for the group.

Coordinated evaluation of new software release for meeting user needs, and ensured that system requirements

are identified, prioritized and incorporated in an effective, efficient manner.

Extract data from various databases for report generation. Execute tests, extract data and analyzes test results,

and report identified defects using in house. MS-Excel Macros for data analysis ensure no regression in new

Software releases. Followed up on problem issues identified to ensure resolution is satisfactory prior to release.

Define and capture metadata and rules associated with ETL processes using Erwin. Design Extract, Load and

Transform (ETL) process for data warehouse and data marts.

Member of technical assessment team which performed on all departmental projects and developments.

Matthew Pham

32302 Alpine Ct. Temecula, CA 92592, 951-***-****, abnu6c@r.postjobfree.com

Recognized with many Technical Excellence and performance awards.

Senior System Engineer (1993-1996)

Responsible as support team lead readiness to deploy new Enterprise Systems to the field. Headed and

coordinated all the activities with multiple internal and external interfacing systems and third party vendors for

Enterprise’s requirements.

Troubleshoot complex development and production application problems, provided technical and production

support to support group and responsible as team member of the 24x7 on-call group.

Worked as a team member on large, highly complex technical and programming planning projects for cross

organization planning. Performed analysis, wrote support planning for medium to large size projects performs

analysis, resolved problems and monitored to proactively prevent problems from occurring.

Adhered to project management standard practices and departmental guidelines included coping and

prioritization controls for projects and change control management.

Experienced with large enterprise systems support and third party products such NSC, SYMBIOS and EMC disk

arrays along with the TERADATA V2 support at the system level. Responsible as team lead for the roll out support

plan and readiness of the 5100 World-Mart products for the LSGSC.

Supported legacy products such as 5100, 4800, 4900, 3600 platform, 3550, 3455, SHAREBASE 8000, BL700

and BL300, and assisted with the define plan for backup and disaster recovery project for the US Bureau of Labor

and Statistic.

Performed large system recovery by identifying the root caused of the failure, responsible to provide hardware

and software support, and recovery of the system back online. Collaborated with developer and management to

ensure errors fixed and provided to customers.

Deployed departmental new application and maintain/enhancement of the application. Investigated technical

issues and collaborated the technical solution to resolve the errors identified by end users.

Utilized Project Management Tools: Create/ Maintain charter and planning docs, dependency based

schedules, status reports, tracking logs, scope and risk management docs using MS Office, and MS Office

Tools (Word, MS Project, Excel, and PowerPoint), VISIO, and online collaboration tools.

Senior Hardware Engineer (1990-1993)

Successfully designed and implemented the 900W DC/DC converters for NCR System 5100 (World-Mart

System).

Accomplished and successfully delivered the design and build of the backplane for NCR System 3600 YNET.

Designed and created P-spice model and performance simulation analysis for the layer stack-up of the backplane

design.

Planned, created, and designed the active SCSI terminators for System 3600 product line as the result of a NCR

patent filling disclosure with NCR Corp.

Circuit and Memory/Component Engineer (1985-1990)

Created support logic design for in house to screen memory module for soft error failure.

Performed schematic capture and created specification for discrete, transformers, and hybrid components

Created automated logic functional test software to screen and characterized for 10K, 100K ECL and TTL fast

logic for QA department. To prevent components failure out in the field and provide better yield and improvement

from wafer check before committed for final production.

System Technician/Senior System Technician (1980-1985)

Troubleshoot and repaired PCB/Processors, IF, memory and IO logic boards using scopes and logic analyzers.

Debugged and troubleshoot the system, identified failure components, repaired and re-run diagnostic test.

Created and established procedures for troubleshoot system manual and assisted in the preparing troubleshoot

techniques and provided on the job training for new hires.

EDUCATION

Chapman University, Orange, CA (1983-1985)

Bachelor of Science, Electronics Engineering

University of California San Diego, CA (1985-1987)

Certification in Micro Computer Design

Certification in Software Design

San Diego Mesa Community College, San Diego, CA (1980-1983)

Associated of Science, Electronics Technology

Professional/Community Associations

Vice President (Co-Founder) of Asian/Pacific American Association for Advancement, Inc. NCR Chapter, San Diego, CA

Member of Professional Association – NCR/TERADATA Chapter, San Diego, CA

Matthew Pham

32302 Alpine Ct. Temecula, CA 92592, 951-***-****, abnu6c@r.postjobfree.com

Contact this candidate