Sql Server Oracle

H. James Chang

*** ******** *****, *******, ** 75019 817-***-****

*****.********@*****.***

PROFESSIONAL SUMMARY

15+ years of experience as an Oracle DBA in areas of analysis, design,

performance tuning, upgrading, and backup and disaster recovery. Extensive

experience on Oracle on Red Hat and OEL 5.X.

Database administrator with comprehensive knowledge in database physical

and logical design, data collection and extraction, disaster recovery,

performance tuning, systems optimization, and networking in a web-based

environment.

Extensive experience in data warehousing projects to extract, transform,

and load into Oracle databases for engineering analysis, production

control, and inventory purposes.

EXPERIENCE

Applied Mind Inc. Dallas, TX

DBA (Part-time) 04/2010 - To Date

Installed and configured a 2 nodes HA Oracle 11gR2 RAC database on OEL 5.5,

designed the schema, and on-going production support. Implemented a

disaster recovery plan.

ST MICROELECTRONICS Carrollton, TX

DBA/Project Leader 11/1994 - 08/2009

Oracle Database administrator for the world's 5th largest semiconductor

manufacturer with over $12 billion in annual revenue. Responsible for

leading a group of four software engineers and designing databases and

system infrastructure to support its 24/7/365 production operations.

. Supported Oracle 7, 8, 8i, 9i, 10g, 11g on a mixed operating system

environment, platforms included: Windows 2003, 2008 and Unix, primarily

Solaris, HP-UX, Red Hat Linux.

. Proficient in large RDBMS Administration, Installation & Performance

Tuning, & Security Management, Strong Backup & Recovery, DataGuard /

Standby. Proficient in UNIX shell scripts

. Designed and built a data warehouse for semiconductor testing data

acquisition, to collect parametric and functional test data, extract-

transformation-load into Oracle database for engineering analysis, coded

in C, and script language using C, Korn, and Bourne Shell.

. The logical design covered start schema with dimension, facts tables and

partition tables.

. Maintained a critical production system with 15 Oracle and MySQL database

instances with application and proxy servers, hosted on 150+ servers, and

5TB disk storage in a high availability environment. Developed a system

and Oracle database disaster recovery plan use RMAN and user-managed

database recovery.

. Migrated applications from Microsoft spread sheet workgroup environment

to a three-tier application environment using Oracle and Weblogic, IBM

Websphere.

. Designed and built a system and database monitoring system to proactively

detect potential problem and provide early warning.

. Designed a secure data transfer system between Windows and UNIX to

replace legacy scheme.

. Worked as project leader with ST teams from other countries in a multi-

cultural environment.

. Designed a real-time data flow systems with error-correction and data

quality scoreboard within multi-national sites.

. Performed data warehousing projects to extract, transform, and load into

Oracle databases for engineering analysis, production control, and

inventory purposes.

. Accomplished Phoenix Information Technology infrastructure startup.

Worked with internal customers to define the requirements and

specifications to acquire hardware and software - key contributor in an

integration of computer systems/database/network and configuration to

support production.

. Performed system and applications migration from DEC/VMS to UNIX

environment.

. Experienced working with Data Warehouse and OLTP Multi-Terabyte databases

in production environments.

. Tuning critical production databases using Explain Plan, Oracle

Enterprise Manager.(OEM)

. Set up 11g Database Testing on Dev platform to evaluate & test new

features

NATIONAL SEMICONDUCTOR Arlington, TX

System Admin/Database Administrator 05/1988 - 11/1994

Programming/Analyst, interfaced with users and participated in various

corporate database development projects in a cross functional team.

Assumed responsibilities of head DBA in Sybase, DEC/RDB and systems

administrator in Sun UNIX and VAX/VIMS.

. As a key application developer, designed logical and physical databases

for cycle time, inventory, finance and engineering analysis.

. Developed administrative reports for cycle time, WIP, inventory,

planning, forecasting, and projecting for executives.

. Migrated databases from Network model to table based relational model.

. Performed database and system backup/restore and performance tuning.

EDUCATION

BA - Business Management, National Chengchi University, Taiwan

MS - Computer Science, University of Texas at Arlington, Arlington, Texas

MBA - Concentrating on I.T. Project Management, University of Dallas,

Irving, Texas

PROFESSIONAL DEVELOPMENT COURSES

Credit and non-credit Microsoft, Cisco, and Oracle courses from college.

Oracle 10g RAC, Data Warehouse, Tuning, and 11g Admin. Training from Oracle

University.

Company sponsored quality, ethics, and project management seminars and

workshops.

HR peer assessment and performance evaluation training.

Microsoft Windows Server, Active Directory, and SQL Server

TECHNICAL SKILLS

Oracle SQL Tuning/RAC/ASM/Data Warehouse, ETL, Data Guard, RMAN, Grid

Control, Streams

Oracle database server 7, 8, 9i, 10g, 11g administration, performance

tuning, standby DB

Shell scripting in C, Bourne, Korn, bash, Perl; Web Design, MySQL,

Microsoft SQL Server

Cisco routers, switches, routers, topology, subnetting, disk storages,

iSCSI

Java, Servlet, C, COBOL, PL/SQL, Informix, Ingres, Rdb,

Apache/WebLogic/Websphere Admin

DHCP, DNS, TCP/IP, FTP, networked backups, VERITAS Netbackup, tape library

Windows Server 2003/2008 Operating System Infrastructures, Active

Directory, Microsoft SQL Server

Sun Solaris 9, 10; HP-UX, Linux, DEC VMS, Oracle Enterprise Linux, Red Hat

Linux

VM Virtualizations; EagleSoft Dental Software

PROFESSIONAL MEMBERSHIPS, COMMUNITY AFFILIATIONS

Dallas Oracle Users Group

Recognitions from North Lake College

CERTIFICATIONS

Cisco Certified Network Associate (CCNA) - Apr 2008

Oracle Certified Professional (OCP) 10g - Oct 2009

Oracle Certified Associate (OCA) 10g - Oct 2009

Microsoft Certified Technology Specialist (MCTS) SQL Server 2008 - July

2010

Microsoft Certified I. T. Professional (MCITP) SQL Server 2008 - July 2010

Contact this candidate