Summary

Frederick Ong (MCSE, MCDBA, MCP+I,CSA)
A team player with broad technical knowledge and creative problem solving. Having 6 to 8 years of experience in configuration, impelementation, and security of MSSQL 7.0 MSSQL 2000,SQL 2005,2008, Sybase 11.x, ASE 12, and Oracle with Windows 9.x, Windows 2000,Windows XP,and Windows 2003. Experience in Database scriptings,Data migration, phyical design, database integrity, data warehousing, normalization, maintenance, performance and tuning, ODBC, DTS, SSIS ,MDAC,DBCC, JDBC, JISQL, XML, Phase Forward INFORM, RAVE Medidata, CTMS, Fisher Medrio, and OCRDC ETL, and disaster recovery, LPM,security, bcp, isql, showplan and reindexing.

Skills

• MSSQL Server(6.5,7.0 , 2000, 2005, 2008) Oracle, Sybase, Crystal Reports, Windows NT, Windows 2000, Windows XP, Windows 2003, Linux, HPUX, Citrix, IIS, Office (98,2000,XP), Transact SQL, PL/SQL, DBArtisan, ODBC, OLEDB, MSDE, MAS 500, Sales logix, Vineyard Knowledge Sync, Kronos, Improptu,MP2, Maximo, BCP, FTP, Humming Bird,,EDI, Peregrine(TLW), TrueCommerce, VB.NET, C#, Lotus notes, DTS, SSIS, Outlook, Exchange, POS Vital, PDF, ADP, HTML,XML, INFORM, SAS, DBMSCOPY,, ERP, CMMS, CRM, CAT 5, Fiber Optics, Switches, Hubs, Gateway.

Experience

Confidential, Texas Nov 2006 - Present
(8000 - 10,000 employees)
Database Administration, Management , Planning, Development , and Integration

• Plan and implement Disaster recovery for SQL servers including Database Mirroring and Log shipping.
• Implement SQL security NT and SQL mixed mode for internal users and plan and test updrade forMSSQL 2000, 2005, and 2008 Servers.
• Reviewing time of the projects and identified risks related to the project
• Create and applied training programs for internal employees.
• Process, review, and query clinical trial data integrate into Oracle Clinical database or an Electronic Data Capture (EDC) System
• Planning, construction, testing and maintenance of databases with GCP and GDP.
• Developed SDLC for Clinical Data.
• Configure ETL Clinical Data for Phase Forward INFORM, RAVE Medidata, CTMS, Fisher Medrio, and OCRDC system.
• Transform Clinical Data using ANSI-SQL, XML, Active X and VB Script,C#, SAS.
• DBCC, Performance and Tuning MSSQL 2000 and 2005, and 2008 servers using SQL profiler, showplan, and index wizard.
• Use DTS and SSIS Local packages for exporting and importing data to EDC.
• Create store procedures, views, and triggers for Data migrations and reportings.
• Plan and create batch scripts to automate jobs.
• Working on testing of Clinical database, queries optimization and performance.

Confidential,Missouri April 2006 - Oct 2006
(8000 - 10,000 employees)
Database Administration and Report Development

• Created Store procedures, views, triggers for replication.
• Created Financial & Inventory & EMR Reporting using Crystal Report and Reporting services
• Performed and tuned Sybase SQL Anywhere servers.
• Troubleshot errors,deadlocks,and queries.

Confidential,Houston, Texas July 2005 - April 2006
(13,000 + employees)
DBA /Data Center

• Performed upgrade SQL 2000 to SQL 2005.
• Installed SQL 2005 on Win2003.
• Managed Data flow from remote sites and used Management Studio for Admin.
• Performed and Tuned MSSQL servers.
• Create Integration Services and Local packages for exporting and importing data
• Used SQL Profiler for tuning store procedures,views.

Confidential, South Carolina Nov 2001- July 2005
(100 + employees)
DBA /Network Administrator

• Performed migration on SQL 2000 from Win 2000 to Win2003 server.
• Installed and Configure Mssql 7.0, SQL 2000 on Win 2000 & Win2003.
• .Created Financial & Inventory Reporting using Crystal Report.
• Created Store procedures, views, and triggers to customize report and MAS 500 application.
• Configured Memory, locks,cache Management, and Parallel Processing,
• Performaned and Tuned by binding the large tables, indexes and tempdb to the memory.
• Scheduled daily database amd transaction log backup using Maintenance plan.
• Used SQL Profiler to troubleshoot Batch processing and store procedures.
• Executed showplan and Explain Plan to optimize indexes and store procedures.
• Imported and Exported Data using DTS and Local Packages.
• Created Emergency repair Disk for PC Disaster and Recovery and configure paging files to optimize PC performance.

Confidential, South Carolina Aug 2000 - Oct 2001
(21,000 + employees )
DBA/Network Administrator

• Configuratrion and implementation of Mssql 6.5, Mssql 7.0, Mssql 2000, Sybase and Oracle on both LAN and WAN.
• Administered Cognos application and extracted employee payroll and timesheet data for reporting purposes.
• Performed database disaster recovery on MSSQL 6.5 & 7.0, 2000 by restoring the master and msdbdatabase backups and reconfigure the server for the appropriate network libraries and security mode.
• Troubleshot SQL client connectivty, TCP/IP packet transfer, communication failure,and slow queries over WAN by using NETIQ, HP OPENVIEW, and WINDOWS NETWORK MONITOR.
• Database migration from Mainfram database & Text file to MSSQL 7.0 on Windows NT & 2000 platform including using TS\\SQL, DTS,local packages, FTP, bcp , and DBartisan.
• Implement security SQLDMOSecurity_Mixed mode to authenticate Windows NT, Windows 2000, and Mssql users and groups.
• Completed MSSQL 6.5 & MSSQL 7.0 Administration, Performance and Tuning courses
• Perfomance and Tuning including filegroups, cache management, DBCC, reindexing, APF, parallel processing.
• Implemented physical design by Creating, Normalizing the tables by enforcing rules, defaults, indexes, and locking scheme.
• Using showplan to optimize store procedures and triggers for performance purpose.
• Scheduled DBCC, reinidexing, and Backup Maintenance plan to monitor daily database backup and database performance.
• Upgraded Mssql 6.5 & Mssql 7.0 to SQL 2000 by using upgrade wizard.
• Resource allocation planning, DSS and implement OLAP, logical process manager, Database Change Control and create security.
• Troubleshot long queries, deadlocks, rollback transactions, and connectivity problems using SQL Profiler.

Confidential, South Carolina April 1998 - Aug 2000
(1000 + employees)
Senior Research Analysts (DBA)

• Integrated Windows2000, NT, Win98, Win95, and with MSSQL (6.5 & 7.0) and Access.
• Wrote TS\\SQL scripts for MSSQL 6.5 and 7.0 servers.
• Troubleshot and MSSQL7.0 server performances and scheduled Maintenance backup.
• Data Conversion and import queries in Paradox, Microsoft Access, MSSQL.
• Trained and consulted CMMS and EAM (MP2) software for customers in an Enterprise environment.
• Implemented Web link, Data procedures that integrates with IIS 4.0.
• Troubleshot installation failures and repair ODBC in Windows 2000, Windows

NT, Windows98, MSSQL, Oracle and IIS.
Confidential, Hawaii 1997-1998
Hardware, software and networking engineer

• Redesigning and upgrading cabling termination using fiber optics (clipping and hot melt) CAT 5 and CAT3 (with RJ45), and coaxial (BNC).
• Maintaining and setting up LAN and BN using Fast Ethernet NIC, 3Com Ethernet Link Hubs and Cisco Router.
• Worked in Windows NT 4.0 server and Novell NetWare environment with TCP/IP, IPX/SPX, NetBeui, and APPLETALK protocols.
• Upgraded and setup IBM PC and Macintosh Computers and HP printers (5si MX Plus, 4si MX) for LAN and BN.
• Supported troubleshooting for 120 IBM PC300XL, 300PL and 350 and Macintosh computers 7100, 6100/60, 6115 Qudra610, users with OS/2 and OS.
• Supported the users for MS-DOS, Windows98, Windows NT workstation, Windows95, Office97, Frontpage98, Internet Explorer 3.0 or later, Netscape and other GroupWare, such as Microsoft Outlook and GroupWise.
• Applied PC software migration, cloning, and upgrading using Ghost application.

Teaching Assistant

• Setup for LAN and maintaining the system software using Novell Netware and Windows NT.
• Applied Microsoft Access in normalization , database integrity , rules, defaults and creating relationalship in Database.
• Created charts and company statement of reports using Excel and Crystal reports.
• Applied Visual Basic 5.0 (RDO) with Active X and Microsoft FrontPage, SQL, Microsoft Access on 3-tier business logic.
• Applied Author ware software with multimedia presentation.

Education

• Master in Business Administration for Information System and Data Management).
• Bachelor of Science in Information System and a minor in Business Management).
• Completed senior projects using the following software: Visual Basic Client Server, Visual J++, Windows NT, Novell NetWare, Author ware, Microsoft FrontPage, and System Design Methodologies.

Interests

Computer Networking, Vice-President of Badminton Club, meeting people, jogging, and fishing.

Fluent in English, Mandarin,Taiwanese, Cantonese, Hokkien, Teochew, and Hainanese.