Resume

Sign in

Engineer Software

Location:
Salem, New Hampshire, 03079, United States
Posted:
November 30, 2017

Contact this candidate

Richard Gostanian

Salem, NH *****

603-***-**** ac3jtj@r.postjobfree.com

General Background

More than 25 years of designing, consulting, and programming experience, with emphasis on the measurement, analysis and evaluation of computer system performance, primarily in Unix/Linux environments. Most work has revolved around, but not limited to, relational database technology. The primary focus has been on the Oracle and Sybase systems, with particular emphasis on database internals, SQL optimization, storage subsystems, application troubleshooting and the design of highly available, high performance and highly scalable systems. Also have experience with distributed systems, columnar databases and, more recently, OLAP systems.

Technical Skills

C, PERL, bash programming, Solaris and Linux programming environments

SQL, PL/SQL, Transact SQL, Oracle, Sybase, Sybase IQ, Berkeley DB

Oracle performance monitoring tools including Oracle wait events, and SQL trace, execution plan analysis

Programming language profilers, hardware performance counters, memory bandwidth monitoring tools

Design, tuning and evaluation of database systems mostly Oracle and Sybase

I/O subsystems, queueing theory, distributed systems theory

Deep understanding of database architecture and internals

Industry Experience

2010 - 2017 Principal Software Engineer Oracle Corporation

Originally worked at Sun Microsystems, but became an Oracle employee when Sun was acquired by Oracle in 2010.

Remained in the same Sun Microsystems performance group after the acquisition, although the work focus shifted from running industry standard benchmarks to studying how Oracle products could run more optimally on both SPARC/Solaris and Intel/Linux environments.

Several projects revolved around Oracle scalability using a variety of Oracle features including materialized views, the Oracle parallel query feature, Oracle OLAP cubes and the new in-memory processing capability introduced in Oracle 12c.

Other activities included collaborating with database developers to identify areas for functional and performance improvements.

In addition, designed and implemented two new OLTP benchmarks for internal consumption, one of which was used to demonstrate superior scalability of the Berkeley DB system on SPARC hardware vs. comparable Intel-based hardware. The latter effort resulted in a large hardware order from a major financial institution.

Also served as a mentor to several new hires, working collaboratively on different projects and teaching many relevant tricks and techniques learned over the years.

2002 – 2010 Senior Software Engineer Sun Microsystems

Most efforts spent running and optimizing both industry-standard, and homegrown benchmarks, with the goal of demonstrating superior performance of Sun hardware vs. hardware from IBM, Dell, and HP. for sales and marketing purposes. In addition to utilizing prior extensive knowledge of OLTP environments, began working with data-warehousing environments. A small sample of accomplishments in this area included:

Publishing more than a dozen TPC-H world record performance, and price-performance, benchmarks on several

generations of Sun hardware with Sybase IQ as the database manager

Became an enthusiastic adaptor of the shared-nothing columnar approach to data warehousing. In this regard, worked

with the developers of the ParAccel Analytic Database (an enhanced version now available as Redshift on Amazon Web Services) to achieve the first ever 30TB TPC-H published result, in addition to several smaller scale world record results

Performed numerous I/O studies through many generations of disk arrays, culminating with a published comparison of flash vs. spinning disk performance at the time when all-flash storage arrays were first introduced into the enterprise market

Also was occasionally asked to resolve difficult performance problems for important customers.

In addition to benchmarking and consulting activities, made numerous presentations to members of my group on both performance-oriented and related technology subjects. These included short courses on data compression techniques, random number generation and queuing models.

1996 - 2001 Senior Technical Consultant Stratus Computer

After finishing work on the ISIS for Database product, returned to the Stratus parent company to focus on resolving critical customer situations, generally requiring either significant increases in performance, or the solution of difficult technical problems. Typical of the many accomplishments of this kind were the following:

Led an effort at Bancomer, a large Mexican bank, to measure and understand the performance of an Oracle-based internet banking application running on a Stratus HP-UX fault-tolerant system. Based on results of a performance study, made recommendations for re-architecting and re-coding parts of the application. Whereas the original system provided unacceptable response times for 4,000 users, the redesigned system was able to handle more than 30,000 users with adequate response times.

Tripled throughput and reduced response times by more than 50% for a Sybase marshaling yard application at the Swiss Federal Railways, by completely rewriting a number of stored procedures and making extensive changes to the physical structure of the database.

Demonstrated to SWIFT, the feasibility of using Oracle, on a Stratus VOS machine, to build a confirmation matching and reporting system for inter-bank foreign exchange deals. First showed that the system had to be capable of performing more than 500 disk I/O’s per second, in order to meet the required throughput demands. Then by writing an application simulator and experimenting with various physical database designs, showed the steps necessary to achieve the requirements. At the time (the early 90’s), 500 I/O’s per second was a significant accomplishment using the CPU and disk technology of that era.

By the early 2000’s, Stratus began development of a fault-tolerant Windows server using a triple modular redundancy approach, replacing its old pair and spare design. During this period, devoted a good deal time becoming proficient with both Windows NT and SQL Server.

1993 - 1995 Member of the Technical Staff Isis Distributed Systems

Isis Distributed Systems was a subsidiary of Stratus Computer. Its purpose was to commercialize the ISIS Toolkit, a messaging technology, developed at Cornell University, used for building highly available distributed applications, by coordinating the replication of processes across multiple commodity UNIX or NT servers. As a database specialist, I was asked to help design and develop a fault-tolerant database replication product using the Isis technology in conjunction with off-the-shelf commercial database systems. The work, which led to a commercial product, was based on a novel atomic commit protocol algorithm described in US Patent 57819190. Also learned much about distributed systems theory as part of understanding the ISIS technology.

1984 - 1993 Software and Systems Engineer Stratus Computer

Divided time between the software engineering organization and the sales support organization focusing on database related activities for each group. Activities for the sales organization included

Designing and tuning proof-of-concept benchmarks for important sales situations

Resolving critical performance problems at customer sites

Conducting database training seminars for Stratus support personnel

Activities for the engineering organization included

Porting portions of Oracle (versions 3 and 4) to VOS (Stratus’ proprietary operating system)

Assisting Sybase engineers with their port of Sybase to VOS

Investigating and fixing port-related bugs in both Oracle and Sybase

Evaluating third party database related products for resale by Stratus

Patents

R. Gostanian and J. Ahern, Performing concurrent transactions in a replicated database environment

5781910 A, United States

Education

Ph.D. Mathematics New York University

B.S. Mathematics Rensselaer Polytechnic Institute



Contact this candidate