Roman Khaykin, Database Architect and Developer in Acton, MA, United States
Roman Khaykin

Database Architect and 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


  • Valmarc Corporation
    Cloud, ShellScript, Linux, Data Modeling, Toad, Python 2, Database Design...
  • MicroBilt
    Data Modeling, Toad, SQL Server 2016, T-SQL, Database Design, PL/SQL...
  • MathWorks
    ShellScript, Linux, T-SQL, Relational Databases, SQL, Microsoft SQL Server...



Acton, MA, United States



Preferred Environment

Cloud, Toad, Oracle, Linux

The most amazing...

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


  • 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 and functions. Worked constantly in SQL optimization.
    • 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.
    • Designed and developed a document store within MySQL database.
    • Implemented backup and recovery strategy using RMAN (Oracle) and MySQL Enterprise backup (MySQL).
    Technologies: Cloud, ShellScript, Linux, Data Modeling, Toad, Python 2, Database Design, PL/SQL, Relational Databases, SQL, Oracle, MySQL
  • Database Architect

    2010 - 2013
    • 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: Data Modeling, Toad, SQL Server 2016, T-SQL, Database Design, PL/SQL, Relational Databases, SQL, Microsoft SQL Server, MySQL, Oracle
  • Database Administrator

    2008 - 2010
    • 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: ShellScript, Linux, T-SQL, Relational Databases, SQL, Microsoft SQL Server, MySQL, Oracle
  • 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: ShellScript, Linux, Toad, PL/SQL, Relational Databases, SQL, IBM DB2, Oracle
  • 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: ShellScript, Linux, PL/SQL, Relational Databases, SQL, Microsoft SQL Server, IBM DB2, Oracle
  • 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: ShellScript, Linux, Relational Databases, SQL, Oracle


  • 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 asynchronous processing to allow 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 Oracle and PostgreSQL relational databases and NoSQL databases (HBase, Hive, and Impala).

    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 developed SQL queries which were used for report running against the Impala database on top of the HBase data. I also developed Postgres stored procedures for data load.


  • Languages

    SQL, T-SQL, Python 2
  • Platforms

    Oracle, Linux
  • Storage

    Relational Databases, PL/SQL, MySQL, PostgreSQL, Microsoft SQL Server, IBM DB2, SQL Server 2016
  • Paradigms

    Database Design
  • Other

    Data Modeling, Cloud, ShellScript
  • Tools



  • 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


  • MySQL 5.6 Certified DBA
  • Oracle 11g Certified DBA

To view more profiles

Join Toptal
Share it with others