Yury Davydov
*** ****** **., *************, ** **923
203-***-**** (cell)
EDUCATION:
MS in Engineering. Moscow Aero Space University (MAI)
Classes on SQL Server Administration, Performance and tuning; Sybase ASE, Sybase Replication Server administration; Oracle Database Administration workshops I & II
SUMMARY:
Expert at managing large numbers of database systems on various platforms: Solaris, Linux, Windows.
20+ years’ experience (design, development, administration, architecture) with core, high visibility and high volume corporate database infrastructures at major financial firms.
Developed multiple tools for effective management of database systems.
Expert at monitoring, alarming and security compliance as well as DR configuration and set up.
Database Administration:
Hands-on responsible for multiple database servers (SQL server, PostgreSQL, Sybase, Sybase Replication Server, MySQL, Mongo DB) at high volume Hedge Funds:
Extensive experience supporting multi-Terabyte SQL Servers 2008 – 2016
Extensive experience in Data Modelling and Data Architecture
Server configuration and tuning expert
Expert level T-SQL. Expert in writing complex queries, view, stored procedures, etc.
Expert on Security implementation reconciliation and monitoring
Expert on Query tuning and optimization
Extensive experience with PostgreSQL 9.x, 10.x, 11.x. PostgreSQL replication
Expert level on multi -Terabyte Sybase ASE versions 11.9.2, 12.x, 15.x and 16
Expert level on Sybase Replication versions 11, 12.x, 15.x and 16
Expert level on SQL, Shell, Python and Perl coding in Linux, SUN Solaris and AIX environment
Data Modeler Data Architect
Designed and implemented comprehensive reference database as well as numerous other data models. Solid understanding of process and workflow
Solid technical analysis skills. Skilled at requirement gathering & definition, designing a 'best' architecture to solve the business problem, and in creating a comprehensive design plan.
Senior Developer:
Redesigned, implemented and tuned multiple functions and procedures for SQL Server, PostgreSQL and Sybase
Designed and implemented multiple comprehensive database server maintenance and monitoring scripts in Shell, Perl and C on Solaris, Linux and AIX
Software/Hardware Skills:
Hardware Windows servers, Linux Servers, AIX, IBM Mainframe
Operating systems Windows, Linux, Solaris, IBM AIX, MVS/ESA, TSO/ISPF, CICS
Data Base Management systems SQL Server 2008 – 2016; PostgreSQL 9x, 10x, 11x; Sybase ASE Server 11.x, 12.x, 15.x, 16; Sybase Replication Server 11.x, 12.x, 15.x, 16
Languages Python, SQL, Shell Scripting, Perl, C
Software Docker, DBever, MySQL Workbench, DB2 Workbench, QMF
EXPERIENCE:
10/20 – 10/22 Bank of America, New York NY
Sybase Database Administrator
Worked as a consultant supporting Sybase environment
Responsibilities:
Worked on new initiatives on hardening database security:
oStreamlined database access and security
oMigrated privileged accounts into Secure Vault
oMigrated Sybase sa account into Secure Vault
oMigrated MySQL root accounts into Secure Vault
01/20 – 03/20 Alliance Laundry Systems LLC, Ripon WI
Postgres Database Administrator / Developer
Worked as a consultant supporting Postgres DBMS in AWS RDS environment
Responsibilities:
Tuning of Postgres Servers
Streamlined user access and security
Fixed Postgres replication (master – slave configuration)
Performance tuned functions and queries with 3x performance improvement
Analyzed and corrected multiple functions
Wrote and optimized queries, functions, etc.
Deployed DDL and DML into Development with subsequent promotion to QA and Production
04/19 – 11/19 Exodus Point Capital Management LLC, New York, NY
Database Administrator,
Work as a consultant supporting SQL Server and Postgres DBMS on Dedicated Hardware and in AWS RDS
Responsibilities:
On SQL Server performed essential DBAs duties (backup, restore, partitioning, maintenance, etc.) as requested
Implemented custom SQL Server monitoring scripts
SQL Server security remediation project
Shrank SQL Server 8 TB database to 1.3 TB without loss of performance
Supported user activities (DDL changes, backups, restores, performance tuning, query optimization, etc.)
Performed data modelling with the goal of streamlining and simplifying and streamlining data model
Performed SQL Server security administration activities, such as enrolling users, granting privileges, etc.
Configured PostgreSQL DBMS to improve performance and stability
Migrated AWS Postgres database to “bare metal” SQL server
Installed numerous Postgres extensions (cross database access, file access, etc.)
Configured HADR in Linux Docker container for SQL Server 2017
Build Docker images for PostgreSQL 11 with high availability and essential extensions
03/10 - 02/19 Millennium Partners LLC. New York, NY
Database Administrator,
Work as a SQL Server and Sybase DBA for various trading and Risk Management groups. Involved in capacity planning, developing and implementing DR and archiving planning implementation and testing, assist members of application teams with query optimization, performance tuning and scripting, where:
Responsibilities:
Managing 10TB SQL Server for the Risk group
Managing 4TB SQL Server for Data Warehouse that is being populated from MUREX application
Designed and implemented custom SQL Server monitoring and maintenance scripts
Managing significant number on SQL servers for other Fixed income and trading groups
Designed, modified and implemented data models for multiple applications
Provide production support for mission critical Sybase ASE and Replication servers
Scoped, evaluated and performed migration of MUREX databases from AIX to x86 platform
Replaced Log Shipping with Sybase Replication as a DR solution which significantly decreased DR latency and improved overall system stability
Designed and implemented Generic Sybase maintenance scripts deployed through the company
Provide 24x7 support for SQL Server, Sybase ASE and Replication Server as well as other DBMS (PostgreSQL, MySQL, MongoDB) online and batch production
Assisted as a DBA in implementing ORACLE – based third party vendor application
Provided guidance and tuned queries for numerous application teams across the firm
Develop, document and present internal standards and procedures
09/07 - 03/10 Goldman, Sachs & Co. New York, NY.
Senior Analyst Developer / Database Architect / Sybase Database Administrator
Work as a Development DBA in Global Investment Research division, where:
Responsibilities:
Perform query optimization and tuning with the objective of improving performance and query simplification
Wrote and optimized numerous stored procedures, triggers and views
Troubleshoot performance problems and made necessary corrections to resolve the issues
Perform logical and physical database design
Design global reference database with the objective of consolidating and cleansing reference data across multiple applications. The design did not require any changes for underlined applications
Came up with the proposal on distributed application and database implementation with the objective of improving application availability throughout multiple regions (America, Europe, Asia)
Make analysis and recommendations on Sybase ASE and Replication server configuration
Provide technical assistance and support to members of the team
Worked on making Sybase database servers compliant with the company – wide requirements
02/04 - 08/07 Bank of America Securities., New York, NY.
Sybase Database Administrator / VP / Consultant II Database Analyst,
Provide primary DBA support for Equity Financial Products trading suite of applications, where:
Responsibilities:
Support other mission-critical applications such as Credit Trading, Risk, etc.
Troubleshoot, tune up and monitor production, contingency, QA, and development environments
Installed and upgraded Sybase products including ASE and Replication
Designed and implemented DR solutions utilizing Replication server and other means
Designed and implemented replication strategies (multi-site availability, warm standby, multi-directional, function strings, etc.) resulting in reduction of replication latency and improvement of replication stability and accuracy
Originated and followed through with Sybase ASE server consolidation project: 21 different (UNIX, NT) Sybase ASE and Replication servers consolidated on 4 UNIX boxes
Was a lead DBA for the project of implementing Sarbanes Oxley compliance
Wrote numerous Perl – based Sybase ASE and Replication Server monitoring scripts
Provide 24x7 support for Sybase ASE and Replication Server online and batch production
Provide technical assistance and support to applications programming groups
One of the authors of division – wide Sybase ASE and Replication Server build standards
10/00 - 02/04 Citicorp Global Asset Management, Stamford, CT
Assistant VP / Sybase Database Administrator,
As a DBA provided support for various mission-critical applications including trading and back office, where:
Responsibilities:
Troubleshoot, tune up and monitor production, QA, system integration and development environments
Designed and implemented replication strategies (warm standby, bi-directional, function strings, login synchronization, etc.)
Process redesign with the objective of process automation, streamlining and enhancement
Provide 24x7 support for Sybase ASE and Replication Server online and batch production
07/99 - 10/00 eSpeed Inc./Cantor Fitzgerald Securities, World Trade Center, NY
Sybase Database Administrator,
Responsibilities:
Support various mission-critical applications including electronic fixed instruments trading system
Provide 24-hour support for Sybase online and batch production
Evaluate performance and tune up Sybase databases and servers
07/90 - 07/99 General RE Services Corporation, Stamford, CT
Assistant secretary / Sybase and DB2 Database Administrator
Responsibilities:
Support various mission-critical applications including Sybase / UNIX and DB2 / mainframe based data warehouse
10/97 - 04/98 Bankers Trust Financial Services Information Systems Corp., NY
Assistant Vice President / Sybase Database Administrator,
Responsibilities:
Sybase DBA involved in all areas of database administration