Sql Server Engineer

ALEX ZORYA

PHONE 201-***-****

E-MAIL ******@**.**.***

SKILLS:

Program languages: Expert level: C, C++. Some experience assembler x86, T-SQL.

OPERATING SYSTEMS: “Unix -like” (Solaris, HP-UX, BSD 4.3, SCO, Linux), Windows (NT,

2000, XP) (WIN32). OS “internals” like scheduling (different models), memory

management (both “API level” and internal), multithreading (NT and different UNIX

models), synchronizations, etc. some experience in kernel mode programming and

writing drivers (for Linux).

RDBMS: MS SQL Server (6.5, 7.0, 2000), Btrieve, Sybase, InterSystems Cache. ODBC,

OLEDB, DBLIB APIs.

NETWORKING: TCP/IP, Sockets API.

DEVELOPMENT: All lifecycle stages of large enterprise-level server software development.

Performance-critical, secure server side code.

EXPERIENCE:

REBAR SYSTEMS 10/10-3/11

Equity trading (Contractor)

Worked on enhancing the core of EMS multiplatform (Windows, Linux) trading system

(client-server, C++, sockets, ACE), all the business logic is implemented as loadable

modules (shared libraries). Developed a few built-in modules (system health monitoring)

as well as a few standalone server side components that worked as “client” processes

(OrderLimitChecker, FixMessagesSender, etc)

CREDIT SUISSE 8/08-8/10

Equity trading (Contractor)

Worked on AGORA Gen 3 project – the third generation of AGORA (order management

and routing) system. Developed a part of Hermes API (new API for Agora Gen3) that

encapsulates Cache database access. Was one of the main architects for the Agora Light

project – a light weight version of Agora with performance as a key requirement. It is a

server side multiplatform multithreaded application. (C++, STL, Boost, Intersystem

Cache “post relational” database, TIBCO EMS and 29West LBM as a message bus,

multithreaded.)

CITIGROUP (EQUITY TRADING) 9/06 – 3/08

Supported and enhanced an automated option trading system. It is a big set of standalone

processes (mostly C++ STL, some Boost) components, multithreaded applications

(mostly Windows - based, but some components are Linux based). Several different

private communication protocols like simple last reliable cache, reliable publisher-

subscriber API are used as IPC. Led a small team that worked on improving performance.

We built non-intrusive internal profiling system to find bottlenecks, changed the internal

memory management, improved our processes IPC communication, used locking free

algorithms, changed the way our components used threads, etc. The biggest performance

gain was achieved for our Logger (one of the main components which track all the trades

and orders in the system) and AutoQuote (C++, multithreaded, internal pup-sub API). It

generates quotes in real time for different exchanges. Key requirements were

performance and reliability (this application generates up to 80% of the total revenue)

Bloomberg (R&D mortgages team) 9/04 –

8/06

Worked on Bloomberg core product “Bloomberg Professional service”. It is a UNIX

(Solaris and AIX) server side product. (C, C++, FORTRAN). Led the project of

switching from Bloomberg proprietary ISAM database to one of the standard SQL

Servers.

Microsoft Corporation 1998 - 2004

Independent Contractor 2002 - 2004

Software Design Engineer 1998 - 2002

VisualStudio team (contractor)

Worked on the new profiler (probe based) for Visual Studio 2005. I worked with internal

Microsoft research built library to change compiled executables.

BizTalk Server group (contractor)

Worked with BizTalk Explorer Object model (C#, XML, EOM objects) and BTF (a

business messaging protocol, C++, multithreaded).

SQL Server division (Reliability team) (FTE)

Took part in development internal MS framework and applications for “Five ninth”

initiative.

This framework had been installed on our Early Adaptors real business environments

with “big enough” number (hundreds) of MS SQL Server working under heavy OLTP

load. The collected data then had been transferred to Microsoft, loaded into the databases

and analyzed.

Developed monitoring tools (C++, mostly multithreaded, ODBC and OLEDB as DB

interface) that were installed on our client business servers (where MS SQL Servers were

running) and client computers (where customer applications were running) to monitor

SQL Server responsiveness, availability and some internal parameters. The key

requirement was to be as less intrusive as possible since we had dealt with real business

environment of our customers.

Helped in development analyzing framework (C,C++, T-SQL, some COM and extended

stored procedures) that was installed locally in Microsoft and was used to process and

analyze data.

As a result of this initiative some key components of MS SQL Server (like logging

system, internal profiling and memory management model for Job Object API) were

changed.

Bank of Savings of Russia 1993 – 1998

Chief engineer-programmer

Led a team of system developers of the banking software system “ESCORD”(C, C++,

HP-UX, Sybase, DBLIB, ODBC, MS SQL Server.) This system was installed in 60

clearing centers and had been used in more than 30000 regional divisions of SBRF all

over Russia.

EDUCATION: St.-Petersburg University, Russia.

Master of Science, Physics 1992.

Contact this candidate