Tony Wong

**-** *** ******, *******, NY *****

Home: 718-***-**** Cell: 718-***-****

tp0s4a@r.postjobfree.com

Experience

Debevoise & Plimpton LLP - Manhattan, NY

Senior Database Architect 01/07–05/12

• Design and implement High Availability solutions for critical business applications, components include SQL 2008/2005 database servers , web servers, and application servers (such as biztalk, sql reporting services… etc) by using Netscaler Web Farm, DNS alias, application clusters and Microsoft Windows 64bits 4-nodes physical Cluster and 2-nodes virtual Cluster environments with SAN storage solution.

• Design, install and configure Microsoft Sharepoint 2010 infrastructure for firm-wide critical web applications with VMWare 4.0 virtual servers running in Microsoft Windows 2008 and SQL 2008R2 virtual Windows servers cluster with HP EVA/MSA SAN storage.

• Engineering Microsoft Windows 2008/SQL 2008R2 SOE, routine maintenance processes and automation of failover/reboot procedures.

• Recommend and design VMWare virtual architecture, system standard, research on best-practice, setup backup/recovery strategy for virtual system, design maintenance processes, monitor system performance, install appliances, clone/migrate VMs and document implementation procedures for other administrators to follow.

• Acting as a tech lead to design and coordinate database end-to-end processing for major system outsource project of PeopleSoft benefit database.

• Provide end-to-end solutions to protect critical yet obsolete (hardware or software) servers by migrating to supportable hardware/software environments through virtualization or system/database replication.

• Consolidate server/database systems to reduce hardware/license/administration cost, resource consumption, and ensure at least better-then-current system performance with no production disruption.

• Design Windows Operating System/IIS/database servers Standard Operating Environment build standard, architecture and naming convention for firm-wide servers.

• Design and implement Business Continuality Recovery and Disaster Recovery solutions for critical servers. Solutions include database synchronization, server synchronization, virtualization and consolidation.

• Diagnosis current database environment, provide best practice recommendation to senior management, and develop project action plan to remedy current system and solution for long term object.

• Assist developers, support engineers and DBAs for their daily work needs, questions and unsolved mysteries. Tasks such as staging system deployment to ensure production deployment success, new SQL server features and best practice, Windows security settings guideline.

• Setup monitoring procedures, system maintenance/reboot with automation, alerting notification and server information collection processes for firm-wide servers with SQLH2 on Microsoft Reporting servers and SQL 2005 servers to gather valuable information for management and administrator usage.

• Provide database replication solution in global environments for applications such as WSUS, Appv virtual center, Appsense, VMWare update manager to achieve high availability, easy portability and full automation goals.

• Initiate project deployment on technical contact with vendor and implement architecture design solutions, major projects involve are Carpe Diem, Interaction, Autonomy iManage, etc.

• Perform database performance tuning for developers (ex. remote procedure call in global SQL environments, XML loading slowness, harddisk cache issue with G6, DT impact). Trouble shoot critical operation issues, such as database corruption on carpe diem sql servers, Interaction process manager server crash, web server/farm security/space issue, MSA/EVA storage VM migration. Assist in Day Light Saving patch deployment and action plan, create system utility using VBScript with HTML to setup password synchronization and reset service processes,

Alliance Bernstein - Manhattan, NY

Lead Database Engineer/Senior System Database Architect 02/97 – 01/07

• Engineering and administrating over 200 MS-SQL servers; tasks include evaluate and design database standards and operating environments; installation and configuration of MSSQL2005/2K/7.0/6.5 servers; create system/database maintenance jobs/schedule; setup disaster/recovery and backup/restore process through replication and dump/load of database; enable trace/auditing with lumigent/profiling of critical database system; implement remote administration, alert, notification and monitoring and design/document SOE of database system.

• Engineering and evaluate MSSQL 2005 64bit database software, present performance benchmark and analyze result to senior management/development community and setup company direction and strategy of 64bit deployment.

• Deploy first Windows 2003 OS and MSSQL 2005 64bit platform for critical Alliance WEB applications.

• Design in-place Windows OS upgrade from Windows 2000 to Windows 2003 for MSSQL servers to save hardware and administrative cost with minimum business impact.

• Setup data warehouse environments to supply information from heterogeneous DBMS sources though Microsoft SQL server Link Server, Oracle Gateway and various database replication processes.

• Support critical 24x7 database applications in MS-SQL 2005/2K/7.0 databases/EMC/Windows 2003/2K/NT cluster environments.

• Design MSSQL server auditing setup process with vendor (Entegra Lumigent) and implement to all MSSQL production and disaster recovery servers.

• Engineering and administrating over 30 Oracle instances; tasks include installation and configuration of Oracle 10g/9i/8i/8 servers under Unix/Linux/Windows environments; implement/enforce/document system standard; setup oracle networking environment with name server, management server, intelligence agent and UNIX/Windows client; create system maintenance utility such as hot/cold/export backup, log file archive/cleanup, and database health checking ; automation of database startup and shutdown; assist in preparing schema objects and performing data manipulation; implement dba lockup security and audit policy and maintain user/role security.

• Engineering new release/patch and utility tool for Oracle and MSSQL, evaluate new features, prepare rollout process with package and provide DBMS selection/recommendation for new application.

• Perform database/query performance optimization and resource tuning, automation of system tasks and trouble shooting.

• Design Windows NT 4.0 servers networking architecture and develop NT 4.0 workstation rollout process for global environment, including over 20 domestic and international branches.

• Setup Windows NT standards and provide technical support for 2nd/3rd level technicians and global offices rollout.

• Conduct SOX and Y2K compliance certification for MS-SQL, Oracle system and application databases.

• Install, configure and support Windows 2K Advanced servers, Windows XP/2K/ME workstation and laptops.

• Provide 24x7 production supports in Windows NT networking environment for the entire firm including trading floor, back office and global office.

• Support domestic and international offices trading floor and back office desktop and servers rollout project.

Merrill Lynch - Manhattan, NY Senior System/Database Support 11/93 – 02/97

• Design Windows NT architecture and integrate with network system. Evaluate various system components for Windows NT including server, workstation, network interface card, raid controller card, and remote system management interface card. Setup Windows NT Domain controller, servers and workstations. Buildup Windows NT environmental standards for Novell and OS/2 users. Convert Windows and OS/2 users to Windows NT platform. Develop system utilities under Windows NT using PowerBuilder. Setup Windows NT Remote Access Server and provide remote administration and support. Install and configure Windows NT SNA/SMS Server. Setup Windows NT technical forum and instruction. Certified application software under Windows NT platform. Evaluate Microsoft Windows 95.

• Setup and configure Sun Sparc servers and workstations, including Sparc-2000, Sparc-1000, Sparc-20 and Sparc-5. Provide system administrative functions on firewall machines, configure firewall/Unix security, implement and troubleshooting TCP/IP networking. Install/upgrade Sun/Solaris operating system and apply patches. Setup TFTP/Telnet server, DNS, NIS, NFS and automounter. Provide backup and recoverability for the systems. Setup disk array for Amdahl drive and disk mirroring with Solistic DiskSuite. Create system utilities in shell scripts.

• Install, configure and administrate MS-SQL server and provide application database design/support for developer.

• Install Oracle system 7 under AIX and setup database interface with CICS/6000.

• Install/configure Sybase system 10 under AIX, develop system procedures, setup security schema, assist developers, provide database support for vendor software such as Remedy Action Request System, Expert Advisor and IBM Netview/6000, and transport data between DB2/MVS and Sybase.

• Administer several RS/6000 machines of model 370, 250 and R30. Tasks include install software, configure hardware, setup IBM X stations, backup system, optimize performance, trouble shooting, daily maintenance, apply fixes, and security setup.

• Perform backup NetWare administration and cc:Mail administration functions, responsibilities include setup security for users and files, install Windows based applications on Novell server, and administer Novell through system utilities, i.e. Syscon, Pconsole, and Fconsole. Automate the cc:Mail post office check reclaim process. Maintain local post office and trouble shooting for cc:Mail problem.

• Provide system administrative functions to OS/2-Novell LAN users and technical support to OS/2-Novell LAN administrators. Install, configure, customize and tuning OS/2 Lan/Workstation operating system. Support various network protocols, such as IPX/SPX, TCP/IP, IEE802.2 ,APPC and NetBIOS. Evaluate OS/2 related software under both Dos/Windows and OS/2 platforms.

• Establish connections between DOS, Windows, and OS/2 clients to various database systems. I.e. DB2/2, DB2/6000, DB2/MVS, Sybase system 10 and Oracle through Q+E, Forest & Trees and Query Manager.

• Install/implement DB2/MVS V3.1, DB2/6000, DB2/2, BMC “Change Manager” and Platinum “Plan Analyzer”,“Data Transport” software related to DB2/MVS system, also provide technical support to database administrators.

SIAC-Brooklyn, NY Database Advisor/Software Engineer 08/93 - 11/93

• Setup Database client/server environment. E.g. install database related software (i.e. DDCS/2, Q+E, Dbartisan. etc.), tuning database performance, and implement communication protocol.

• Convert more than 100 DB2/MVS tables to Sybase; configure Sybase system, tuning performance, and mimic DB2 application design in Sybase system.

• Design client/server GUI applications in Vis/REXX. Setup service machine to schedule task to communicate with mainframe and perform database utilities on both DB2/2 and DB2/MVS database systems.

• Provide technical support to A/P programmers, DB Administrators and LAN administrators.

• Install Sybase system 10 under AIX.

• Setup AIX user environments and connection between AIX client and DB2/MVS through DDCS/6000.

• Assist in installation of CICS/6000 and DB2/6000 for Micro-Focus COBOL developers.

IBM Credit Corp.-Stanford, CT DB/DC Support/System Analyst 11/90 - 08/93

• Setup client/server environments, plan and research strategy and make recommendation to management.

• Install OS/2 Release 1.3 and 2.0 with related workstation applications, such as CSP/2AD, CSP/2RS ,DDCS/2, and CICS/OS/2.

• Involved in LAN Administration for workstation’s hardware setup, configuration and implementation, LAN communication design and implementation and server software installation.

• Install Lotus Notes on OS/2 Server and setup databases for forum users.

• Setup cc:Mail users, Postoffice, Bulletin Board and Public Mailing List.

• Install/Customize DB2 Release 2.3, QMF Release 3.1.1 and DB2PM Release 2.1.1.

• Provide dba/system support, naming convention, standard and control security of DB2 related subjects

• Implement DRDA(Distribute Relational Database Architecture) and enable DDF (Distribute Data Facility) with GUI front end using Vis/REXX.

• Setup CICS regions, provide system support, problem determination and trouble shooting for developers

• Install/customize Cross System Product Release 3.3 and 4,1, Install/customize Runtime Service Release 1.1 and 2.1 and technical supports for more than 100 CSP developers.

• Install and implement DBCS for national-language applications

P.T.R.(Consultant Firm)

Westvaco-Manhattan, NY SQLDS DBA/CSP Administrator 04/88 - 11/90

• Maintain/improve SQL/DS database system efficiency, security, performance tuning and trouble shooting under VM/HPO system.

• Define/coordinate SQL database/CSP application system layout and connection.

• Design physical data model/logical data structure and monitor DASD utilization on SQL database system.

• Develop startup/stopping process for SQL system and backup, recovery, reorg. procedure for SQL table.

• Convert CSP application systems from VM/SQL/DS to MVS/DB2 environment.

• Setup CSP environment for development, test and production systems.

• Maintain/implement CSP efficiency/archive/security on VM/HPO & MVS/XA systems.

• Provide technical support and assist application analyst for CSP developers/users.

• Perform migration tasks from CSP version 3.1 to 3.2 and 3.3 release under VM/HPO.

• Develop CSP utility, establish CSP/SQL naming conventions and coding standards (i.e. Error exit routine, call function routine syntax checker and panel layout).

• Develop CSP and COBOL programs for purchase order ,inventory & invoice systems.

• Develop REXX programs for panel-driven facility/operating procedure/startup profile and setup service machine.

P.T.R. (Consultant Firm)

C.D.C., BIS-Greenwich, CT Database Analyst & Project Leader 11/86 - 04/88

• Implement/develop sales management and marketing software package on X/L (DBMS) proprietary relational database under TSO and CALL/370 mainframe system.

• Improve system efficiency, acceptance test and ensure functional correctness.

• Monitor/implement data integrity on database system and develop system common routines.

• Responsible for project life cycle of Sales Management project development.

• Design, analyze and optimize efficiency of database system.

• Set up development id, assign tasks & resolve technical problems for programmers.

• Establish production environment/data & resolve problems for customer's system.

Department of Computer Science, Stevens Institute of Technology - Hoboken, NJ

Teaching Assistant of Theory of Digital Machine and Operating System 01/86 - 12/86

Japanese corp. Mitsubishi/Idec/Matsushita Electronic Agent - Taipei, Taiwan Technical Engineer/Programmer 08/83 - 07/85

• Maintain/repair industrial computer.

• Design programs of industrial computer according to customer's requirements.

• Responsible for seasonal sales/payroll report using COBOL under DOS/VS.

• Maintain database system of inventory under MS-DOS.

Operating & Network System

Vmware ESXi 3.5/4, Microsoft Windows 2008/2003/2K/NT Server and Windows 7/Vista/XP/2K/NT Workstation, Sun Solaris, Red-Hat Linux, Citrix Winframe, IBM AIX, SCO Unix, Microsoft Windows 95/98/ME, IBM OS/2, OS/2 Lan Server, DOS, MS-Windows, MS-Windows for Workgroup, Novell NetWare, CICS/6000, CICS/MVS, TSO, VM/CMS

Database Management System

Microsoft SQL Server 2008/2005/2K/7.0/6.5, Oracle10g/9i/8i/8/7 on UNIX/Linux/NT, Sybase 10/4.9, DB2/6000, DB2/MVS, DB2/2, SQL/DS, DDCS/2, DDCS/6000

Hardware

Compaq Proliant Server (DL585, DL380, ML760, ML740, ML570, ML530, 7000, 6500, 5000, 3000, 2500, 850), Sun/Sparc System (2000, 1000, 20, 5), IBM RS/6000, IBM X station, DMX/EMC, BoxHill, Intel Workstation/laptop/Server (Compaq, Gateway, Dell, IBM, Micron), APC UPS, IBM ES/9000, IBM3090, IBM 4381, IBM 4341, IBM S/370, VAX-11/780, DEC-10

Education

Stevens Institute of Technology - Hoboken, NJ

MS Computer Science. G.P.A. 3.9 - Aug.85..Dec.86

Kaohsiung Institute of Technology - Kaohsiung, Taiwan

BS Electrical Engineering - Aug.76..Aug.81

Contact this candidate