Scroll To View More
Roman Khaykin, SQL Developer in Acton, MA, United States
Roman Khaykin

SQL Developer in Acton, MA, United States

Member since February 26, 2018
Roman is an experienced database architect and developer who has worked with multiple relational databases (Oracle, MySQL, SQL Server) and NoSQL databases (HBase, MongoDB). In his career, he's developed stored procedures with PL/SQL, T-SQL and MySQL procedural language. Roman has also done a fair amount of scripting using Shell and Python.
Roman is now available for hire

Portfolio

Experience

  • Oracle, 20 years
  • Relational Databases, 20 years
  • SQL, 20 years
  • ShellScript, 15 years
  • MySQL, 10 years
  • Linux, 10 years
  • Data Modeling, 8 years
Acton, MA, United States

Availability

Part-time

Preferred Environment

Linux, Oracle, OEM Cloud/Database Control, Toad

The most amazing...

...thing I've designed and implemented was a parallelization of massive data load into an Oracle RAC database.

Employment

  • Database Architect

    2013 - PRESENT
    Valmarc Corporation
    • Designed a database for a Brand Protect system including a logical data model and physical data model.
    • Developed MySQL and Oracle stored procedures.
    • Migrated a database from MySQL to Oracle including the stored procedures code.
    • Developed data load scripts using Shell and Python.
    • Implemented high-availability solutions for both Oracle (Active DataGuard) and MySQL (replication).
    • Designed and developed a geolocation clustering solution based on DBSCAN algorithm using Python and PL/SQL.
    Technologies: Oracle, MySQL
  • Database Architect

    2010 - 2013
    MicroBilt
    • Designed databases for a credit scoring and payment processing application including the logical data model and physical data model.
    • Developed PL/SQL stored procedures and packages; also included T-SQL stored procedures.
    • Implemented a high-availability solution using Stream replication (Oracle) and Master-Master MySQL replication.
    • Developed client reports using XML queries.
    • Implemented an archiving process utilizing Oracle partitioning.
    Technologies: Oracle, MySQL, SQL Server
  • Database Administrator

    2008 - 2010
    MathWorks
    • Designed and implemented database physical and logical structure for Oracle, SQL Server and MySQL databases.
    • Developed SSIS packages and SQL Server/MySQL stored procedure and triggers.
    • Designed and implemented an Oracle RAC database.
    • Developed and designed MySQL and SQL Server replications.
    • Built backup and recovery strategy and procedures for a MySQL databases.
    Technologies: Oracle, MySQL, SQL Server
  • Senior Database Administrator

    2003 - 2008
    Manhattan Associates
    • Designed and implemented database physical structures.
    • Designed logical data structures and provided support for back-end development.
    • Developed back-end application components for a web-based information system using PL/SQL and Perl.
    • Implemented database performance tuning and SQL optimization.
    • Installed a database monitoring system using Oracle Enterprise Manager Grid Control.
    Technologies: Oracle, DB2
  • Database Consultant

    2000 - 2003
    GRT Corporation
    • Installed, configured, and supported databases under Oracle, DB2, and SQL server.
    • Performed database tuning and SQL tuning.
    • Configured cluster databases under DB2 EEE, Oracle RAC, and SQL Server cluster.
    • Developed and implemented backup and recovery strategies.
    • Built stored procedures.
    Technologies: Oracle, DB2, SQL Server
  • Database Administrator

    1996 - 2000
    Central Bank of Russia
    • Installed and upgraded Oracle RDBMS.
    • Developed backup and recovery strategies and procedures.
    • Configured and maintained an Oracle Parallel server cluster.
    • Performed database and SQL tuning.
    • Implemented proactive database monitoring based on the HP OpenView EMP framework.
    Technologies: Oracle

Experience

  • Valmarc Brand Protect (Development)

    Valmarc Brand Protect is an application that can differentiate an authentic brand product from a counterfeit product. It comes to a verdict based on a large volume of data received from the manufacturer of the brand product.

    As it is a data-centered application, it requires complicated database operations. Keeping this in mind, I designed the initial data model for the Brand Protect application and implemented it on two different platforms: MySQL and Oracle.

    I designed the data load processes and implemented them using SQL*Loader, Shell scripts, and Python scripts. That included such amazing technics as parallelization and an asynchronous processing to allow a timely processing of complicated aggregations. I developed stored procedures and packages; some of the procedures, despite containing complicated logic, required a short response time—under 50 milliseconds. I also did a lot of SQL and database tuning to satisfy the requirements.

  • R4 Technology AI System (Development)

    R4 Technology utilized a complicated mathematical algorithm to perform data analysis. A huge volume of data was processed using both the Oracle database and NoSQL databases.

    I developed Oracle stored procedures and packages which were used by data analysis software to store and retrieve data from the database as well as implemented parts of the analytical algorithms. I used PL/SQL HTTP and XML support to communicate with other parts of the system from within the Oracle stored procedures. I also developed SQL queries which were used for report running against the Impala database on top of the HBase data.

Skills

  • Languages

    SQL, T-SQL, Python 2
  • Platforms

    Oracle, Linux
  • Storage

    Relational Databases, PL/SQL, MySQL, SQL Server 2016
  • Other

    Data Modeling, ShellScript

Education

  • Certification in MySQL Performance Tuning
    2008 - 2008
    MySQL AB Training Services - Online
  • Certification in Oracle 10g: RAC for Administrators
    2007 - 2007
    Oracle University - Online
  • Master's degree in Applied Mathematics
    1989 - 1994
    Tula Technical University - Tula, Russia
Certifications
  • MySQL 5.6 Certified DBA
    DECEMBER 2017 - PRESENT
    Oracle
  • Oracle 11g Certified DBA
    SEPTEMBER 2009 - PRESENT
    Oracle
I really like this profile
Share it with others