Sybase DBA/Developer, Microsoft MSSQL DBA/Developer

JEFFREY THOMAS WONG

**** ********* **** ******: 832-***-****

Eastvale, California 92880 Email: *******@*****.***

CAREER SUMMARY

A proficient Technical Consultant with proven skills in the guidance of small teams specializing in the creative resolution of problems associated with complex, real-world software systems. Significant industry experience in the financial, automotive and telecommunication industry sectors. Proficient in the following software technologies (selected list):

Sybase Database

(15.7 to 2.1, 29 years)

Sybase Replication Server

(15.5 to 11.5, 4 years)

Sybase Open Client

(15.0 to 2.0, 10 years)

Perl

(5.10 to 4.0, 16 years)

C/C++

(ANSI / K&R, 16 years)

Unix

(Solaris / Linux / AIX, 16 years)

IBM UDB Database

(8.2 to 7.1, 3 years)

Sybase Open Server

(15.0 to 2.0, 8 years)

Sybase Open Switch

(15.0 to 12.0, 3 years)

PROFESSIONAL EXPERIENCE

DIGITAL VALUE CREATION LLC, Oak Park, California Mar 2017 – Jun 2017

Consultant (Microsoft SQL Server DBA/SQL Developer)

Provided onsite Microsoft SQL Server DBA and SQL Developer support services to a small non-profit organization that coordinates healthcare and social services for HIV and AIDS patients in Orange County, Southern California, with particular emphasis in migrating the customized in-house ClientTrack application system to ClientTrack 2015 (SQL Azure, cloud-based). Notable activities included:

Developed an SSRS implementation for the CMS Psychosocial Assessment report. This is a complex 12 page report containing 628 checkbox fields and 130 text fields. Implementation is currently awaiting customization, testing and deployment into the customer’s UAT and production computing environments.

ARTECH INFORMATION SYSTEMS LLC, Morristown, New Jersey Jan 2014 – Dec 2016

Consultant (Sybase DBA)

Provided remote Sybase production DBA support services as an IBM Contractor assigned to a large, multinational financial organization based in the northeast region of the United States. Product support specialties included the Sybase ASE, IQ, Replication Server and SQL Anywhere products:

Wrote 3 Perl programs to perform an index audit of 24876 index DDLs, 1 program to extract the index DDLs from 76 distinct target databases, 1 program to compute SHA-256 digital signatures of the “on” and “with” clauses of the index DDLs, and 1 program to compare these digital signatures and other distinctive characteristics against 319 index DDL templates, and to produce an auto-filtered Excel spreadsheet that documented the findings. This new auditing system takes approximately 30 minutes to complete. The previous semi-manual method was estimated to take at least 12 man weeks, and would not approach the accuracy of the new system in any significant fashion

Revamped weekly maintenance activities of a customer application system such that it used reorg rebuild SQL commands to reorganize the data and indexes of non-proxy tables, in lieu of the previous method of dropping and recreating the indexes of those tables. Additionally, added logic so that redundant update statistics were not applied to those tables that had been reorganized. Finally, added instrumentation to the weekly maintenance so that maintenance performance of all user tables could be tracked, as well as writing 4 Perl programs to transform and format this instrumentation data directly into specialized Excel spreadsheets. These spreadsheets were pre-configured with built-in auto-filtering and linear regression charting, consequently making the capacity planning of this application system by the application support personnel straight forward

Modified a production SQL query so that it now runs in 1 second. Prior to the modifications, this production query ran in 1269 seconds. Additionally, stability of this modified query was certified by subjecting the query to scalability and performance tests, whereby it was observed that the performance knee for this modified query occurred once the input load was scaled up by a thousand fold (NB: Query ran in 109 seconds with this load)

Wrote Korn Shell and cmd.exe scripts to integrate IBM Blue Care monitoring software into the customer's Replication Server, Sybase IQ and Adaptive Server Anywhere production server estates, so that ISM incident tickets are automatically generated upon detection of certain adverse conditions (e.g.: running out of database free space, database process blocking, etc.)

Recovered a corrupt 1.5 million row data row locked database table using BCP 10.0.4 and non-clustered index coverage. All but 42 rows of the corrupt table were successfully recovered, along with all primary keys for that table. Previous recovery efforts had only successfully recovered 472,000 rows (out of 1.5 million total rows)

Audited 40 user databases on a Sybase production instance. Three perl programs were written to identify stored procedures within those databases that did not have access permissions assigned to them. These 3 programs were able to accurately identify the 6 stored procedures that were incorrectly installed (out of the thousands of stored procedures that were installed on this particular Sybase production instance)

Constructed a SQL Anywhere database repository to track performance and configuration changes of a clustered and mirrored production SQL Anywhere 12.x application system

Tested Veritas Quick I/O for eventual deployment on selected production Solaris host machines, to resolve Sybase ASE tempdb kernel async I/O and direct I/O VxFS performance issues

Provided on-call production Sybase DBA support for the customer's world wide IT infrastructure base, as part of the DBA team assigned to that task

Investigated Sybase RDBMS migration feasibility for selected applications, in order to establish best practices for migration of approximately 2000 Sybase instances. Most of these database migrations are from ASE 15.0.3 to ASE 15.7, although some of these migrations are from ASE 12.5.4 to ASE 15.7

Facilitated Sybase technology transfer to company technical staffers via freely available Internet resources, such as white papers and TechWave 2011 conference presentations.

CITIGROUP, INCORPORATED, Dallas, Texas Sep 2011 – May 2013

Infrastructure Senior Tech Specialist

Provided Sybase production DBA support services as a member of the Global Markets DBA team. Responsibilities included:

Provided primary DBA support services to the Markets Derivatives group in Latin America, Asia, Australia, Canada and the United States

Provided on-call Sybase production DBA support services as part of the Global Markets DBA support team, in a “follow the sun” 24x365 support model

Designed and implemented a reporting mechanism whereby database instance vulnerability assessment data embedded in PDF files were extracted, parsed and converted into XML files. These XML files were then converted into specialized Excel drill-down spreadsheets, and subsequently used in audit verification of the (vulnerability) remediation activities performed on the audited database instances

Designed and implemented a reporting mechanism that analyzed BMC Patrol monitoring data to generate reports on database and filesystem growth

Designed and implemented a Perl script that read in an AutoSys 4.x JIL file, and then generated an AutoSys 5.3 JIL file, along with various command files that encapsulated Operating System command line sequences found in the original JIL file, and additionally renamed all command files found in the user script directory so that they corresponded in name to the AutoSys job names found in the generated JIL file

Designed and implemented various Korn, Awk and Perl filter scripts, that transformed various text data sources (such as crontab listings, isql query output, email in EML file format, and AutoSys job status output) into specialized Excel spreadsheets that could be used for analysis drill-down and charting by senior Global Markets DBA management.

Designed and implemented a mechanism that automatically identified and copied user database backups for the purpose of 7 year retention of monthly database backups. This mechanism was sensitive to what day of the week the end of month backup occurred, whether the end of month backup spilled over into the start of the following month, and whether any public holidays skewed what was perceived as the end of month backup for that month

Facilitated Sybase technology transfer to company technical staffers via freely available Internet resources, such as white papers and TechWave 2011 conference presentations.

ADVENT GLOBAL SOLUTIONS, INCORPORATED, Houston, Texas Jul 2010 – Jun 2011

Consultant (Sybase Performance and Tuning Specialist) Apr 2011 – Jun 2011

Provided Sybase performance and scalability services to a company providing regulatory compliance solutions to Wall Street financial organizations:

Diagnosed root cause of a slowly performing batch system to be excessive scanning of the database transaction log that were the outcome of deferred updates performed in that batch system. Recommended resolution of this performance issue by recoding the large transaction into a series of smaller transactions. Verified performance increase by comparing before and after batch run times (4x speedup).

Designed and implemented a stored procedure performance profiling system using Monitor Server and customized Historical Server views.

Designed and implemented various other performance and tuning monitoring tools using Sybase MDA tables, Perl and Transact-SQL database objects.

Facilitated Sybase technology transfer to company technical staffers via freely available Internet resources, such as white papers and TechWave 2010 conference presentations.

Consultant (Sybase Performance and Tuning Specialist) Jul 2010 – Dec 2010

Provided Sybase performance and scalability services to the North American energy trading subsidiary of a large, multinational energy company:

Customized an existing MDA tables based monitoring system (open source) to support heartbeat and time-weighted “waited-for-resources” monitoring, and interfaced this infrastructure to Netuitive Web-based visualization software, in support of monitoring and capacity planning management initiatives.

Designed and configured a portable Sybase Database, Replication Server and Sybase IQ reference implementation, that was used to both demonstrate Sybase Control Center 3.1 monitoring capabilities, and to highlight (Replication Server) rs_ticket latency monitoring implementation tradeoffs.

Facilitated Sybase technology transfer to company technical staffers via freely available Internet resources, such as white papers and TechWave 2010 conference presentations.

JP MORGAN CHASE & COMPANY, Houston, Texas May 2006 – Jul 2010

Vice President, Global Technology Infrastructure (Engineer Lead, Sybase)

Certified new Sybase product offerings on behalf of the corporation, with particular emphasis on the ASE database product and associated software upgrades/fixes. Additionally, developed and implemented ad hoc software sub-systems and third level support services to other corporate divisions/departments on a needs basis.

Developed and implemented a new Sybase database standard build infrastructure that was operating system agnostic, highly user configurable, completely automated, performant, and seamlessly compatible with the vendor's installation software. This infrastructure has been adopted as the corporate standard for the largest user of Sybase database technologies in the corporation.

Developed and implemented a Sybase database monitoring system that seamlessly combined the IBM Tivoli ITM 6.1 universal agent infrastructure with various Perl, awk and shell scripts. Current corporate-wide deployment two years after implementation is 453 Sybase instances out of a total population of approximately 2000 Sybase instances.

Developed various ad hoc virtualization reference infrastructures/systems to satisfy Sybase architectural needs within the corporation. Examples include an Open Switch Warm Standby Replication Server VM, VIX automation mechanisms for ESX 3.5 ASE 15.0.3 database VMs, and ASE 15.5 database developer training VMs.

DPM INCORPORATED, Troy, Michigan Aug 2005 – Apr 2006

Consultant (Sybase DBA)

Provided production Sybase database administration services for 6 Replication Server instances and 2 ASE database instances of a HMO that was using the TriZetto Facets 4.11 managed healthcare application system.

Developed a monitoring system for Replication Server (12.6) instances and ASE Database (12.5.0.3) instances.

Coordinated with database migration services with upgrades of the Facets application system from 3.5 to 4.11.

RESOURCE TECHNOLOGIES CORPORATION, Troy, Michigan May 2003 – Aug 2005

Consultant (Sybase/UDB/Microsoft DBA)

Provided 7x24 production database administration services for 29 Sybase instances, 30 IBM UDB instances, and 12 Microsoft SQL Server instances, on behalf of a major car manufacturer.

Consolidated 7 separate Sybase ASE 12.5.0.3 instances on 7 separate Solaris 8 machines, to a single 4 node Solaris 9 cluster configuration that contained 6 Sybase ASE 12.5.2 HA failover/failback instances.

Migrated the PeopleSoft 8.1.7 HRMS application system database from Sybase ASE 12.5.0.3 on AIX 5.1, to IBM UDB 8.2 on AIX 5.1.

7x24 performance monitoring of the UDB 8.2 PeopleSoft 8.1.7 HRMS application system database using standard IBM UDB monitoring tools.

7x24 performance monitoring of Sybase ASE 12.5.0.3 instances using Sybase MDA tables functionality.

EXCELL DATA CORPORATION, Bellevue, Washington Jan 2003 – May 2003

Consultant (Technical Lead)

Provided technical leadership for a small team of 5 developers tasked with performance re-engineering of a production batch system that provided carrier revenue/customer rebate reporting for large corporate customers of a major telecommunications vendor. Performance was improved dramatically such that batch processing that used to take 1 day to successfully process, now took less than 30 minutes to accomplish the same workload.

CTI, Fort Lauderdale, Florida May 2002 – Aug 2002

Consultant (Sybase/Microsoft DBA)

Provided Sybase and Microsoft database administration services for an e-commerce (Internet) solutions provider.

Established stabilization and performance enhancements to a Solaris 8 Sybase ASE 12.0 instance, and development and deployment of Microsoft databases used to track revenue generation of a 7x24 video-and-chat Java Internet application.

SYBASE INCORPORATED, Dublin, California Oct 1994 – Feb 2002

Principal Consultant Jan 1998 – Feb 2002

Provided timely resolution of customer technical issues that negatively affected the delivery of quality Sybase product and service offerings. Major customers supported in this role included Bear Stearns, TD Securities, Key Bank, Northwestern Mutual Life, NBC, AT&T Wireless, Verizon Online, and Florida Power and Light.

Developed and implemented an IIOP Proof of Concept system for a major financial institution. Components used in the POC included IBM WebSphere 4.0, Sybase EA Server 4.0 and hosted EJBs.

Adapted the OpenSwitch 12.0 coordination module to handle bi-directional Replication Server 11.5 traffic, for a major trading house/hedge fund.

Developed and implemented a statistical analysis and exception reporting system for network performance issues of a Frame Relay WAN of a major utilities company.

Resolved major concurrency, deadlock and connection scalability issues for a major telecommunications vendor using the Kenan Arbor customer billing application system.

Developed and implemented a custom Open Server application on behalf of a well-known, profitable dotcom. This Open Server application enabled this customer's application programs to utilize persistent connections to the Sybase database instance supporting the customer's business operations.

Senior Consultant Oct 1994 – Dec 1997

Provided pre-sales, post-sales, and consulting services to various Sybase customers. Major customers supported in this role included Meijer, Daimler Chrysler, Federal Express, Bank One, and Reynolds and Reynolds.

Resolved critical performance issues with a supply chain application used by a major supermarket chain. A 6x speedup was attained for the material disposition subsystem, and a 15x speedup was attained for the shipping manifest subsystem.

Developed and implemented an Open Server application that provided data bridging services between a Sybase database instance and a heritage Uni*Verse automotive distributor retail application system.

Ported the OpenClient/C 10.0.3 Sybase connectivity product to the real-time process monitoring system used in the production lines of a major car manufacturer, despite very limited technical support provided by the vendor of this process monitoring system.

EDUCATION & CREDENTIALS

Bachelor of Science, Computer Science

Australian National University, Canberra, ACT, Australia

Professional Qualifications

Sybase Replication Server Administrator Professional, V15.0.1

Sybase IQ Administrator Professional, V15.2

Adaptive Server Enterprise 15.0 Administrator Associate

Replication Server 12.5 Administrator Professional

Adaptive Server Enterprise Administrator Associate (V12.5)

DB2 UDB V7.1 Database Administrator for Unix, Windows and OS/2

DB2 UDB V7.1 Family Fundamentals

Contact this candidate