Roman is available for hire
Hire RomanRoman Titov
Verified Expert in Engineering
Database Developer
Location
Penza, Russia
Toptal Member Since
July 12, 2022
Roman is passionate about SQL IT pro with over 20 years of experience in all aspects of the software development process, including customer support, development and testing, analytics, DevOps, architecture, data engineering, and data science. He scaled from a project manager to a chief technical officer in a small startup that a Fortune 500 company later acquired.
Portfolio
OOO Moe Delo
Microsoft SQL Server, PostgreSQL, Elasticsearch, Python, Microsoft Power BI...
OOO Moe Delo
Microsoft SQL Server, C#, ASP.NET MVC, Microsoft Team Foundation Server...
ApexSQL
Microsoft SQL Server, C#, Windows Forms (WinForms), Obfuscation...
Experience
Availability
Part-time
Preferred Environment
Windows, Microsoft SQL Server, SQL Server Management Studio (SSMS), PostgreSQL, Microsoft Power BI, ELK (Elastic Stack)
The most amazing...
...thing about my work is the necessity to constantly learn and implement new things no one around you did before.
Work Experience
Database Architect
2015 - PRESENT
OOO Moe Delo
- Migrated custom full-text search engine to MSSQL FTS in a proprietary accounting legislation SaaS solution with some improvements in performance and relevance.
- Developed and implemented MSSQL FTS-based full-text search for a new proprietary contractor ranking SaaS solution.
- Built and implemented multiple Elasticsearch-based full-text search solutions.
- Led planning, set up, and maintained corporate SQL Servers with up to 12 MSSQL instances and up to 6 PostgreSQL instances.
- Participated in monitoring and alerting system development and implementation.
- Defined SQL development standards, including interviewing new candidates for SQL skills, conducting educational meetings, and assessing SQL skills for company developers.
- Developed and implemented various ETL processes for reporting, machine learning, and product content delivery.
- Adopted and managed a company-wide Microsoft Power BI business intelligence solution and developed reports.
- Developed, implemented, and maintained several machine learning models.
Technologies: Microsoft SQL Server, PostgreSQL, Elasticsearch, Python, Microsoft Power BI, MySQL, SQL, T-SQL (Transact-SQL), SQL Server Management Studio (SSMS), Spyder, GitHub, YouTrack, Confluence, ELK (Elastic Stack), ETL, JSON, SQL Stored Procedures, Stored Procedure
Development Manager
2012 - 2015
OOO Moe Delo
- Built and managed a development team of up to seven employees.
- Established development principles and processes and defined development and testing standards.
- Participated in defining and detailing new features and communicating with stakeholders and subcontractors.
- Led developing and optimizing system storage, MSSQL databases, and related ETL processes.
Technologies: Microsoft SQL Server, C#, ASP.NET MVC, Microsoft Team Foundation Server, YouTrack, GitHub, Confluence, SQL Server Management Studio (SSMS), Agile Software Development, IT Project Management, SQL Server Integration Services (SSIS), SQL Stored Procedures, Stored Procedure
Chief Technical Officer
2005 - 2012
ApexSQL
- Built and managed an IT department of up to 30 employees.
- Established development principles and processes, defined development and testing standards, and performed code reviews.
- Participated in search and design of new features and improvements to existing ones.
- Developed and implemented new features for proprietary software products.
- Built and managed IT infrastructure, including source control, deployment, obfuscation and licensing, and automated and manual testing.
- Participated in communication with customers and subcontractors.
Technologies: Microsoft SQL Server, C#, Windows Forms (WinForms), Obfuscation, Microsoft Team Foundation Server, Apex, Software, SQL, SQL Server Management Studio (SSMS), IT Project Management, Agile Software Development, DevOps, SQL Stored Procedures, Stored Procedure
Software Testing Engineer
2004 - 2005
ApexSQL
- Tested new releases of proprietary software products, reported bugs, and assisted developers with reproduction.
- Developed and executed test plans in collaboration with developers.
- Automated testing procedures with the use of command-line interfaces (CLI).
- Assisted customers with issues and answered questions.
- Prepared and updated technical support documentation.
Technologies: Microsoft SQL Server, Apex, Software, SQL, Software Testing, Customer Support, SQL Stored Procedures, Stored Procedure
Software Engineer
2003 - 2005
RNT
- Participated in the development of a proprietary access control software product.
- Built event storage for the access control product, MSSQL database.
- Developed database maintenance scripts for clients.
Technologies: Delphi, Microsoft SQL Server, Microsoft Visual C++, SQL Stored Procedures, Stored Procedure
Software Engineer
2003 - 2003
Megapolis
- Developed an application for loading production reports from sub-branches.
- Participated in customization of the adopted ERP software (UI, tables, queries, and reports).
- Maintained ERP software system storage (Oracle database).
Technologies: Delphi, Oracle, Microsoft Visual C++, Crystal Reports, ETL
Software Engineer
2001 - 2003
Sberbank
- Developed an application for aggregating and reporting on loan data from sub-branches.
- Assisted with adopting various banking software in sub-branches.
- Fixed and optimized SQL queries issued by the adopted banking software.
Technologies: Delphi, Microsoft Visual C++, Microsoft SQL Server, C++Builder, ETL
Experience
Legal Info Full-text Search Solution
https://drive.google.com/file/d/17jiRIcQgPT39aZa8kiDJKvdPSDHwISJ6/view?usp=sharingAn MSSQL FTS-based full-text search solution used in a proprietary SaaS solution for accountants and entrepreneurs. I was the SQL developer who developed the solution and all related ETL processes.
In addition to searching a few types of content, including legal and court acts, frequent questions, use cases, change reviews, and print forms, the solution also enables searching for a specific legal act part, article, paragraph and items within.
It provides match highlighting, autocomplete based on most popular queries and documents, spelling correction, searching related documents, and question and results in cache.
The solution has been in production since 2015.
In addition to searching a few types of content, including legal and court acts, frequent questions, use cases, change reviews, and print forms, the solution also enables searching for a specific legal act part, article, paragraph and items within.
It provides match highlighting, autocomplete based on most popular queries and documents, spelling correction, searching related documents, and question and results in cache.
The solution has been in production since 2015.
Contractor Info Full-text Search Solution
https://drive.google.com/file/d/1ufI4TAp-S77pnnYMSjOUzPOV0EfI6xg6/view?usp=sharingAn MSSQL FTS-based full-text search solution used in a proprietary SaaS solution for accountants and entrepreneurs. I was the SQL developer who developed the solution and all related ETL processes.
The key feature of the solution is to extract known filters from natural language queries and adequately process and apply them. Those filters include person names, registration numbers, and classification codes.
It gets processed considering arbitrary word order, abbreviations, omissions, and contractions.
The solution has been in production since 2016.
The key feature of the solution is to extract known filters from natural language queries and adequately process and apply them. Those filters include person names, registration numbers, and classification codes.
It gets processed considering arbitrary word order, abbreviations, omissions, and contractions.
The solution has been in production since 2016.
Request Log Database
An MSSQL database to store all requests issued in all proprietary SaaS solutions along with parameters and response times. Starting from a user action in UI and ending with database queries it produced. I was the SQL developer who developed the database.
The critical requirement for the database was sustaining high insert rates and reasonable query response time while keeping large volumes of data. This required leveraging several more advanced MSSQL features like memory-optimized tables and table data types, natively compiled stored procedures, partitioning, column store indexes, and resource governor.
In 2022, the database was moved to a cheaper engine after two years in production because of extreme disk space requirements.
The critical requirement for the database was sustaining high insert rates and reasonable query response time while keeping large volumes of data. This required leveraging several more advanced MSSQL features like memory-optimized tables and table data types, natively compiled stored procedures, partitioning, column store indexes, and resource governor.
In 2022, the database was moved to a cheaper engine after two years in production because of extreme disk space requirements.
Financial Transaction Classification
A Python web service for auto classifying financial transactions as clients requests them from banks. I was the data engineer who developed both the model and the service, as well as all related ETL processes.
This is a standard ML task for the financial industry where among the features, you can find transaction date, sum, descriptions, and bank and client details. The accuracy of the final version was about 97%.
The service has been in production since 2022.
This is a standard ML task for the financial industry where among the features, you can find transaction date, sum, descriptions, and bank and client details. The accuracy of the final version was about 97%.
The service has been in production since 2022.
Education
1997 - 2002
Engineer's Degree in Software Engineering
Penza State University - Penza, Russia
Skills
Libraries/APIs
Windows Forms (WinForms)
Tools
Microsoft Power BI, ELK (Elastic Stack), Confluence, Microsoft Visual C++, C++Builder, Crystal Reports, Microsoft Team Foundation Server, Spyder, YouTrack, Git, GitHub
Storage
Microsoft SQL Server, SQL Server Management Studio (SSMS), SQL Stored Procedures, PostgreSQL, Elasticsearch, MySQL, JSON, SQL Server Integration Services (SSIS)
Languages
SQL, T-SQL (Transact-SQL), Stored Procedure, SQL DML, SQL DDL, Apex, Delphi, C#, Python
Platforms
Windows, Oracle, Linux, Docker
Paradigms
Agile Software Development, DevOps, Software Testing, ETL
Frameworks
ASP.NET MVC
Other
Software Development, Performance Tuning, Query Composition, Query Optimization, Software, IT Project Management, Data Engineering, Obfuscation, Customer Support
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring