Leonid Draginsky, Software Developer in Westerville, OH, United States
Leonid Draginsky

Software Developer in Westerville, OH, United States

Member since May 15, 2019
Having spent over two decades working on increasingly complex projects—often as a tech lead for large (100+) teams—in healthcare, government, finance, hospitality, and manufacturing, Leonid is a software developer who can build products. Drawing upon his expertise in database development and optimization, he can handle critical tasks such as data processing performance bottlenecks, cross-platform processes/data migrations, and process design.
Leonid is now available for hire

Portfolio

Experience

  • Object-oriented Design (OOD), 20 years
  • ANSI SQL, 19 years
  • Oracle SQL, 17 years
  • Oracle DBA, 17 years
  • T-SQL, 17 years
  • Oracle PL/SQL, 17 years
  • Agile, 10 years
  • SQL Server DBA, 8 years

Location

Westerville, OH, United States

Availability

Part-time

Preferred Environment

Oracle RDBMS, Microsoft SQL Server, Windows, Linux

The most amazing...

...thing moving a large operational datastore from Microsoft SQL Server 2008 to Oracle 11; migrating from Oracle 10 on Windows to Oracle 12 on Linux.

Employment

  • Senior Software Development Specialist

    2016 - PRESENT
    Sedgwick CMS
    • Developed and configured software tasks based on operational requirements in an Agile project/development environment using a legacy system.
    • Optimized the database process.
    • Shared my database expertise with the development team.
    • Moved the legacy reports/code from SQL Server 2008 to Oracle 18c.
    • Composed system documentation.
    • Mentored the junior staff.
    Technologies: Oracle 18c, Microsoft SQL Server 2008 and 2014, SQL, Transact-SOL, PL/SQL, Stored Procedures and Triggers, Cross-platform Code Migration, Database Code Optimization, C#.NET, Visual Studio
  • Database Administrator — Consultant

    2015 - 2016
    Office of Ohio Secretary of State
    • Migrated the core system from Oracle 11gR1 on Windows to 12cR1 on Linux.
    • Administered to the Oracle APEX development environment.
    • Established the Oracle system migration process and schedule with virtually no downtime.
    • Optimized Oracle SQL and PL/SQL code.
    • Implemented a payment card validation process using PayPal web services.
    • Mentored in-house development and DBA teams.
    • Implemented a secure code deployment process.
    Technologies: Oracle 11g & 12c, Oracle SQL & PL/SQL, Oracle Packages and Stored Rrocedures, Oracle RAC, Oracle APEX, Microsoft SQL Server 2008, Toad, Oracle SQL Developer, Oracle SQL*Loader, Oracle Export and Import Utilities, Cygwin, Oracle Enterprise Linux
  • Development Database Administrator (DBA)

    2012 - 2015
    JPMorgan Chase
    • Designed and configured an Oracle 11g development database.
    • Supported a geographically distributed team (100+ on/offshore developers).
    • Migrated the core database system from Microsoft SQL Server 2008 into Oracle 11g.
    • Built complex views, triggers, and stored procedures in Oracle SQL, PL/SQL in support of the development team.
    • Developed an upstream automated database code deployment scripting system.
    Technologies: Oracle 11g, Microsoft SQL Server 2008, Oracle SQL, Oracle PL/SQL Packages and Stored Procedures, Transact-SOL Stored Procedures, Oracle RAC
  • Software Developer

    2010 - 2012
    Exceptional Innovation, LLC
    • Found the solutions to performance bottlenecks in the front-end (C#.NET) and back-end (Microsoft SQL Server 2008/2014) layers.
    • Rectified SQL Server concurrency issues enabling simultaneous read and writes (by redefining process architecture emulating PostgreSQL transaction insulation).
    • Resolved external vendor errors in contractually supplied data (in Oracle - remotely).
    • Implemented Transact-SQL scripts enabling incremental deployment of functionality with transparent handling of partial/aborted runs.
    • Performed Microsoft SQL Server 2008/2014 installation, configuration, and patching.
    Technologies: C#.NET 3.5 and 4.0, Microsoft Visual Studio 2008 and 2010, LINQ and LINQ to SQL, ADO.NET, ASP.NET, WPF, Web Services, SQL, Transact-SOL Stored Procedures and Triggers, Microsoft SQL Server 2008 and 2012
  • Application Development Lead

    2004 - 2010
    JPMorgan Chase
    • Ported a legacy Microsoft Access business process to Oracle 10.2.
    • Developed a C#.NET data transfer utility with automatic process control and notification.
    • Wrote scripts for common Oracle administration tasks and data migration.
    • Implemented HTML and XML report generators.
    • Contacted the administration and provisioning of department-based oversight for remote Oracle environments.
    Technologies: Oracle 9.2 & 10.2 SQL & PL/SQL, SQL*Plus, Toad, C# .NET, ASP.NET, MS Visual Studio, IBM RAD 6 & 7, Eclipse, Oracle SQL, HTML, XML, Java
  • Programmer/Analyst 4

    2002 - 2004
    State of Ohio, Department of Health
    • Developed a multi-format data loader (C# & Oracle 8i).
    • Implemented ETL process on Oracle 8i.
    Technologies: Oracle 8i SQL and PL/SQL, Toad, C#.NET, Microsoft Visual Studio .NET, HTML, XML, ASP.NET, ASP, Java, JavaScript, COM+, ActiveX, Delphi
  • Delphi Programmer

    2001 - 2002
    American Electric Power
    • Developed and automated a station design system on Oracle7/8i in Delphi.
    Technologies: Delphi 4, 5, and 6, Custom Libraries and ActiveX Controls, Oracle 7/8i SQL and PL/SQL
  • Software Engineer

    2000 - 2001
    Managed Care Software
    • Developed an EDI module in Delphi to support HIPAA format (ASCII X12).
    Technologies: Delphi 4 (Client/Server Edition), Delphi 5 (Enterprise Edition), EDI (ASCII X12 and HIPAA)
  • Software Engineer

    1998 - 2000
    EDICT Systems
    • Developed eCommerce (ASCII X12 standard) apps in Delphi 1/4/5.
    Technologies: Delphi 4/Delphi 5, EDI (ASCII X12 and HIPAA)

Experience

  • Database Deployment Scripts (Other amazing things)

    When functioning as a database administrator—whenever it's my sole responsibility or in addition to my core development functions—I'm always implementing scripting containers that allow database code upstream deployment to be "non-event."

    The problem at hand is that when app deployment (be it in .NET, Java, or anything else) requires overwriting/replacing an executable file, deploying the database changes becomes an incremental process that that can't be done by "replacing" the old with new.

    This is often a risky part of any production deployment process as losing production data can be irreversible (or—at the very least—requires a complicated recovery process). I'm able to mitigate this issue by implementing progressive incremental testable deployment scripts. In every place, where I've established such a process, it is still in use long after my departure.

  • Oracle to SQL Server and SQL Server to Oracle Migration Guide - Pt. 2 (Publication)
    Migrating in either direction between Microsoft SQL Server and Oracle Database? This round of pitfalls to avoid includes coverage of sequences, identity columns, and filtered indexes.
  • Oracle to SQL Server and SQL Server to Oracle Migration Guide (Publication)
    Migrating in either direction between Microsoft SQL Server and Oracle Database? There are some significant pitfalls to be aware of...

Skills

  • Languages

    SQL, T-SQL, Transact-SQL, C#.NET, Java, Delphi
  • Tools

    Toad, Visual Studio 2019, Oracle Application Express (APEX), Cygwin, LINQ to SQL
  • Paradigms

    Agile, Object-oriented Design (OOD), Object-relational Mapping (ORM)
  • Storage

    Oracle DBMS, SQL Server DBA, Oracle DBA, Microsoft SQL Server, Oracle SQL Developer, SQL Server Management Studio, Oracle SQL, Oracle PL/SQL, Oracle 11g, Oracle 12c, Relational Databases, ANSI SQL, SQLite
  • Other

    Oracle OEM 12c, Scripting, Web Services
  • Frameworks

    .NET, ASP.NET, ADO.NET
  • Libraries/APIs

    LINQ
  • Platforms

    Windows, Linux, Unix, Visual Studio Code

Education

  • Master's degree in Chemical Engineering
    1979 - 1984
    Petroleum Academy - Moscow, Russia
Certifications
  • Certified Delphi 6 Developer
    FEBRUARY 2002 - JANUARY 2004
    Brainbench

To view more profiles

Join Toptal
I really like this profile
Share it with others