Publication
SQL Indexes Explained, Pt. 1
http://7zb.healthydairyland.com/database/sql-indexes-explained-pt-1
Mirko is available for hire
Hire MirkoMirko Marović
Verified Expert in Engineering
Performance Tuning Developer
Location
Prague, Czech Republic
Toptal Member Since
June 18, 2020
Mirko在数据库设计、开发和优化方面拥有20多年的经验. 他有机会使用最常用的数据库平台:MS SQL Server, Oracle, MySQL, and PostgreSQL. 他为具有极端工作负载的数据库优化了数据库查询、索引和设置. Mirko has also developed solutions for customers from the US, Russia, Czech Republic, Germany, Norway, Serbia, and Bosnia.
Portfolio
Cross Masters
数据库开发，数据库建模，ETL, Azure SQL, Azure数据工厂...
BetSys
数据库开发，数据库建模，索引，PostgreSQL, Git, Jira...
Self-employed
PostgreSQL, MySQL, Oracle, Microsoft SQL Server，数据库，SQL...
Experience
Availability
Part-time
Preferred Environment
PostgreSQL, MySQL, Oracle, Microsoft SQL Server，数据建模
The most amazing...
...我实现的性能改进是重新设计一个查询生成器，访问具有数十亿行的表, improving performance 12 to 80 times.
Work Experience
Senior Database Engineer
2022 - 2023
Cross Masters
- 重新设计了CIMEX金融数据集市，以实现可靠和同意的数据加载，每天多次.
- 通过引入带外伸和角色扮演维度的星型模式的数据模型设计，减少了各种财务报告的加载时间.
- Trained data engineers in SQL development best practices.
Technologies: 数据库开发，数据库建模，ETL, Azure SQL, Azure数据工厂, Databases, SQL, Database Design, Indexing, T-SQL (Transact-SQL), Data Modeling, Git
Senior Database Engineer
2019 - 2022
BetSys
- 欧洲杯前对PL/pgSQL、SQL函数和索引进行了优化, reducing overall CPU load by 60%.
- 重新设计了与支付相关的表的索引，减少了40%的数据读取.
- 将大型比赛(20万张以上门票)的门票评估时间从40分钟减少到不到2分钟.
Technologies: 数据库开发，数据库建模，索引，PostgreSQL, Git, Jira, Databases, SQL, Database Design, PL/pgSQL, Performance Tuning
Senior Database Specialist
2009 - 2019
Self-employed
- 为金融服务提供商开发和优化MySQL查询生成模式. 查询性能比以前的版本提高了12到80倍.
- 为Faraj Fund, UAE开发SQL Server存储过程和触发器.
- 为捷克Nova电视台构建PostgreSQL函数，优化查询和索引.
- 创建调度算法和数据库模型，并为3v3足球锦标赛门户开发MySQL查询, Phoniax, Norway.
- 为蓝兔设计开发了SQL Server报表数据库, DKNY's exclusive distributor in Prague, Czech Republic.
- 为捷克蓝兔设计POS应用程序.
- 为MTS系统开发了Oracle PL/SQL数据同步包, a telecom operator in Serbia.
Technologies: PostgreSQL, MySQL, Oracle, Microsoft SQL Server，数据库，SQL, Database Design, PL/pgSQL, Database Optimization, Performance Tuning, Indexing, T-SQL (Transact-SQL), Data Modeling, Jira, ETL
Quality Assurance Manager
2007 - 2009
SitronicsTS, Prague, Czech Republic
- Managed the quality assurance department, including test analysis, test execution, test automation, test data preparation, integration testing, and performance testing teams.
- 参与SDLC和QA流程的设计和建立.
- 管理俄罗斯各种电信OSS/BSS交付的产品测试, Czech Republic, Germany, Uganda, and Serbia.
Technologies: TFS
Consultant
2005 - 2006
Time Import, Prague, Czech Republic
- Gathered and manage requirements for KUSCK, Czech Republic.
- 部署、配置和管理subversion版本控制系统.
- 设计了KUSCK客户门户后端的高层架构.
Technologies: Subversion (SVN)
Database Engineer
2003 - 2005
Tmp Worldwide (Monster), Maynard (USA), Prague Czech Republic
- 为竞选管理数据集市开发存储过程.
- 审查代码并培训40多名开发人员学习T-SQL最佳实践.
- 为求职者设计索引和优化存储过程, employers, and mass sender subsystems.
Technologies: IBM Rational ClearQuest, Embarcadero RAD Studio, Microsoft SQL Server, Databases, SQL, Database Design, Database Optimization, Performance Tuning, Indexing, T-SQL (Transact-SQL), SQL Server 2000, Data Modeling
Oracle Consultant
2003 - 2003
Ad Astra, Prague, Czech Republic
- 为GTS(电信运营商)开发PL/SQL包，实现批发计费API, Czech Republic.
- 设计了GTS批发计费系统的逻辑模型和物理模型.
- 介绍了PL/SQL存储过程和PL/SQL包内函数的单元测试.
技术:数据库，SQL, Oracle PL/SQL, PL/SQL，索引，Oracle，数据建模
Database Team Leader
1999 - 2002
Strom Telecom, Doubravice, Czech Republic
- Designed, developed, optimized, 并为俄罗斯的客户管理庞大的电信数据库, Czech Republic, and Germany.
- 为Callax和Dusseldorf设计了批发计费和最低成本路由的数据库模型, Germany.
- Migrated the telecom billing system from SQL Server to Oracle.
- Implemented central ODS of telecom billing for MGTS, Moscow.
Technologies: Visual Basic 6 (VB6), SQL Server 2000, Databases, SQL, Database Design, Oracle PL/SQL, PL/SQL, Database Optimization, Performance Tuning, Indexing, T-SQL (Transact-SQL), Oracle, Data Modeling, ETL
Experience
Query Engine for Financial Market Data
我负责重新设计用于内置数据跟踪工具的MySQL查询模式. 查询引擎返回20年的细粒度数据. 对于各种查询模式，我将查询执行时间减少了12-80倍.
Portal for Job Seekers
http://www.monster.com/Job Seekers portal pages received on average 8,当我作为数据库工程师在Monster工作的时候，它的点击率是每秒000次. 我参与了定义和执行SQL Server标准和最佳实践. 我的任务包括代码审查、设计审查和性能优化. 我负责位于布拉格的40多名开发人员编写的T-SQL存储过程代码审查, Czech Republic, and Maynard, Massachusets, USA.
FORIS - OSS/BSS System for MTS, Moscow
http://moskva.mts.ru/personalFORIS is an OSS/BSS system consisting of billing, rating, provisioning, 资源库存模块使用每小时加载数亿行CDR的大型Oracle数据库. As a database team leader, I was responsible for designing the data model, PL/SQL development, database administration, and performance optimization. The system was successfully deployed, handling trillions of CDR data, inventory of hundreds of millions of cell phones, 和其他移动设备，每月为1亿用户生成发票.
PERSON Redesign for TV Nova, Czech Republic
http://tv.nova.cz/PERSON是TV Nova web和Voyo流媒体用户使用的用户管理系统. I was responsible for PL/pgSQL development, testing, reporting, and query performance optimization, including PostgreSQL indexes redesign.
Ticket Evaluation Optimization
http://www.sts.pl/Main Betsys's product is an online betting system. 目前，最大的部署是在波兰的博彩提供商STS. 评票速度慢是主要的竞争劣势. 评估200多张门票的大型比赛需要40多分钟. 经过性能优化后，最多只需要两分钟.
Skills
Languages
T-SQL (Transact-SQL)， PL/pgSQL, SQL, Visual Basic 6 (VB6)， Python 3
Paradigms
Database Development, Database Design, ETL
Storage
SQL Server 2000, PostgreSQL, Database Modeling, Microsoft SQL Server, Databases, MySQL, Oracle PL/SQL, PL/SQL, Azure SQL
Other
Database Optimization, Performance Tuning, Indexing, Data Modeling, Embarcadero RAD Studio, Azure Data Factory
Platforms
Oracle
Tools
TFS, Subversion (SVN), IBM Rational ClearQuest, Git, Jira
Education
1982 - 1989
数学学院计算机科学硕士学位
University of Belgrade - Belgrade, Serbia
Collaboration That Works
How to Work with Toptal
在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.
1
Share your needs
在与Toptal领域专家的电话中讨论您的需求并细化您的范围.
2
Choose your talent
在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.
3
Start your risk-free talent trial
与你选择的人才一起工作，试用最多两周. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring