Roman Titov
Verified Expert in Engineering
Database Developer
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
Experience
Availability
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
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.
Development Manager
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.
Chief Technical Officer
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.
Software Testing Engineer
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.
Software Engineer
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.
Software Engineer
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).
Software Engineer
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.
Experience
Legal Info Full-text Search Solution
https://drive.google.com/file/d/17jiRIcQgPT39aZa8kiDJKvdPSDHwISJ6/view?usp=sharingIn 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=sharingThe 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
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
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
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring