Post Job Free

Resume

Sign in

Database Administrator Data Architect

Location:
Doylestown, PA
Posted:
January 31, 2023

Contact this candidate

Resume:

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



Contact this candidate