Radek is available for hire

Radek Wiewior

Verified Expert in Engineering

Database Developer

Location

Jakarta, Indonesia

Toptal Member Since

July 6, 2022

Radek拥有25年的技术经验，寻找别人无法解决的挑战. Enterprise-class databases are his native environment. He has many years in Oracle Corporation using Oracle technologies. His favorites are performance tuning, system architecture, HA, and real-time replication, as well as the creation of Oracle experts in his free time. IT security is his second specialization.

Portfolio

Magnetar For Technology and Digital Solution Company PSC

Data Engineering, PostgreSQL, MongoDB, Oracle Cloud, MySQL, Performance Tuning...

Tokenomy Technologies

PostgreSQL, MySQL, Performance Tuning, Data Warehouse Design, SQL, JSON...

Goldenore

Oracle, SQL, Oracle Database Tuning, Data Reporting, Data Engineering, ETL...

Experience

Oracle - 20 years SQL - 20 years Java - 20 years Oracle Database Tuning - 20 years PL/SQL - 20 years Data Warehouse Design - 10 years

Availability

Part-time

Preferred Environment

Oracle, Data Engineering, Data Analysis, Data Analytics, Data Architecture, Databases, SQL DML, Performance Tuning, Data Queries, SQL Performance, Database Administration (DBA), Oracle PL/SQL, Stored Procedure, SQL Stored Procedures, Business Continuity & 灾备、Oracle SQL、Oracle DBA、数据库架构、数据库设计

The most amazing...

...我所做的分析是一个源代码(700万行)和中央数据库的国家社会保障的主要系统替换为现代技术.

Work Experience

Data Engineer

2022 - 2022

Magnetar For Technology and Digital Solution Company PSC

Designed and developed the engine of the data warehouse/ reporting subsystem.
Installed, configured, and deployed both UAT and PROD environments.
对从Oracle数据源提取的大约5000万行表进行了性能调优. Reduced time from around 10 hours to around 2 minutes.

Technologies: Data Engineering, PostgreSQL, MongoDB, Oracle Cloud, MySQL, Performance Tuning, Red Hat Linux, Linux, Bash, Reporting, Data Transformation, Oracle DBA, Database Architecture, Database Design

Data Management Consultant

2021 - 2022

Tokenomy Technologies

几乎实时地设计和创建来自八个系统的数据仓库报告.
创建了开发过程，使未来的数据仓库开发变得容易.
Tuned performance of ETL processes created by other developers and me. The time decreased was quite spectacular.

Technologies: PostgreSQL, MySQL, Performance Tuning, Data Warehouse Design, SQL, JSON, Data Reporting, Data Engineering, ETL, Data Warehousing, Data Analysis, Data Visualization, Data Analytics, Python, Data Architecture, API Integration, Microsoft Power BI, Databases, APIs, Integration, Microsoft Excel, SQL DML, Data Queries, SQL Performance, Database Administration (DBA), GitHub, Data Modeling, Data Pipelines, Business Intelligence (BI), Pipelines, Stored Procedure, SQL Stored Procedures, Data-level Security, Linux, Bash, Business Continuity & Disaster Recovery (BCDR), Finance, Reporting, Data Transformation, Database Architecture, Database Design, Web Scraping

Chief Technology Officer

2018 - 2020

Goldenore

Provided training to Oracle engineers to masterschip their skills.
Created architecture and supervised development projects, 比如为系统的数据库和应用服务器层创建性能调优和监控的自定义工具.
在项目中最复杂的部分出现问题时承担责任.

Technologies: Oracle, SQL, Oracle Database Tuning, Data Reporting, Data Engineering, ETL, Data Warehousing, Data Analysis, Data Visualization, Data Analytics, Python, Data Architecture, API Integration, Databases, APIs, Integration, Microsoft Excel, SQL DML, Performance Tuning, Data Queries, SQL Performance, Database Administration (DBA), GitHub, Oracle PL/SQL, Data Modeling, Data Pipelines, Migration, Oracle Cloud, Business Intelligence (BI), Pipelines, Stored Procedure, SQL Stored Procedures, Data-level Security, Linux, Bash, PL/SQL, Business Continuity & Disaster Recovery (BCDR), Oracle SQL, Data Migration, Finance, Reporting, Data Transformation, Oracle DBA, Database Architecture, Database Design

Database Architect

2016 - 2018

Proximus

Migrated data from the source system, Oracle JD Edwards, to SAP. Lots of work in tuning performance.
Designed the architecture of the Central Repository of Network Assets, GIS system.
管理数据从六个源系统迁移到网络资产中央存储库. Used six different GIS technologies.

Technologies: Oracle, SAP, Data Migration, GIS, IT Systems Architecture, SQL, Oracle Database Tuning, Data Reporting, Data Engineering, Data Analysis, Data Visualization, Data Analytics, Python, Data Architecture, API Integration, Databases, APIs, Integration, Microsoft Excel, SQL DML, Performance Tuning, Data Queries, SQL Performance, Database Administration (DBA), GitHub, Oracle PL/SQL, Data Modeling, Data Pipelines, Migration, Oracle Cloud, Pipelines, Stored Procedure, SQL Stored Procedures, Linux, Bash, PL/SQL, Business Continuity & Disaster Recovery (BCDR), Oracle SQL, Reporting, Data Transformation, Oracle DBA, Database Architecture, Database Design

Databases Expert and Auditor

2016 - 2016

Trusted Information Consulting Sp. z o.o

Audited central government systems, including the database layer area. Managed the design, high availability (HA), and security verification.
管理国家社会保障(ZUS)制度现代化可能性分析. ZUS KSI is the largest IT system in this part of Europe. At that time, maintenance was possessed by a single specific IT company. The target was to demonopolize.
Led a POC and analysis of over seven million lines of source code, port DB2 database of tousands of tables to new enviroment. 证明迁移到新的现代技术栈是可能的，而且不那么昂贵.

Technologies: IT Systems Architecture, IT Security, SQL, Data Engineering, Data Analysis, Data Analytics, Python, Data Architecture, Databases, Integration, Microsoft Excel, SQL DML, Data Queries, T-SQL (Transact-SQL), Database Administration (DBA), Oracle ERP, Oracle PL/SQL, Data Modeling, Data Pipelines, Pipelines, Stored Procedure, SQL Stored Procedures, Data-level Security, Linux, Bash, PL/SQL, Business Continuity & 灾备、Oracle SQL、报表、Oracle DBA、数据库架构、数据库设计

Head Technical Consultant | Owner

2006 - 2016

Royal Software

Created a team of Oracle Experts from scratch. Some of them are now Oracle Certified Masters and Oracle ACE recipients.
Provided reasonable-priced Oracle-based solutions to customers.
从头开始构建自定义Oracle EBS模块，以管理投资并将其与现有的EBS安装集成.
Developed a Gis-class system. A central bank of geodetic networks for a government customer.
Managed the development of A.PL internet supermarket in Oracle iStore.
Maintained GEOPORTAL.GOV.PL, including a high service-level agreement (SLA).
Provided subcontractor services to Oracle Consulting for many customers.

Technologies: Oracle, SQL, Oracle Database Tuning, Data Reporting, Data Engineering, ETL, Data Warehousing, Data Analysis, Data Visualization, Data Analytics, Data Architecture, API Integration, Databases, APIs, Integration, Microsoft Excel, SQL DML, Performance Tuning, Data Queries, SQL Performance, T-SQL (Transact-SQL), Database Administration (DBA), GitHub, Oracle Application Express (APEX), Apex, Oracle ERP, Oracle PL/SQL, Batch Apex, SugarCRM, Data Modeling, Data Pipelines, Migration, Business Intelligence (BI), Pipelines, Stored Procedure, SQL Stored Procedures, XML for Analysis (XMLA), Data-level Security, Linux, Bash, PL/SQL, Business Continuity & Disaster Recovery (BCDR), Oracle SQL, Data Migration, Finance, Reporting, Data Transformation, CRM APIs, Oracle DBA, Crystal Reports, Database Architecture, Database Design

Senior Instructor

2002 - 2006

Oracle

Provided Oracle-certified training to Oracle professionals.
修改了编程路径，包括SQL、PL/SQL、Java、Jakarta EE、Oracle Forms和报表.
回顾了管理路径，包括管理、备份和恢复以及网络.
Checked the HA path, including data guard and RAC; the. options path, partitioning and spatial; and the performance tuning path, including SQL, PL/SQL, and database.
Led internal training for Oracle's employee support. 执行了详细的灾难分析，包括对Oracle数据库源代码的分析.

Technologies: Oracle, SQL, Oracle Database Tuning, Data Reporting, Data Engineering, ETL, Data Warehousing, Data Analysis, Data Visualization, Data Analytics, Data Architecture, Databases, APIs, Integration, Microsoft Excel, SQL DML, Performance Tuning, Data Queries, SQL Performance, Database Administration (DBA), Oracle Application Express (APEX), Apex, Oracle ERP, Oracle PL/SQL, Batch Apex, Data Modeling, Data Pipelines, Migration, Business Intelligence (BI), Pipelines, Stored Procedure, SQL Stored Procedures, Data-level Security, Linux, Bash, PL/SQL, Business Continuity & Disaster Recovery (BCDR), Oracle SQL, Data Migration, Finance, Reporting, Data Transformation, Oracle DBA, Database Architecture, Database Design

Software Engineer

1999 - 2002

Oracle

Performed as a contractor in Oracle Consulting, delivering technical solutions.
开发了一种解决方案，允许通过Radius服务器对国家警察信息系统进行认证.
Provided financial reports, Oracle reports, and PL/SQL for Hortex.
Solved bugs in Oracle EBS inter-module data transformation.
Managed dozens of other projects based on Oracle technologies.

Technologies: Oracle, SQL, Oracle Database Tuning, Data Reporting, Data Engineering, Data Analysis, Data Visualization, Data Analytics, Data Architecture, API Integration, Databases, APIs, Integration, Microsoft Excel, SQL DML, Performance Tuning, Data Queries, SQL Performance, Oracle Application Express (APEX), Apex, Oracle ERP, Oracle PL/SQL, Batch Apex, Data Modeling, Data Pipelines, Migration, Business Intelligence (BI), Pipelines, Stored Procedure, SQL Stored Procedures, Data-level Security, Linux, Bash, PL/SQL, Business Continuity & Disaster Recovery (BCDR), Oracle SQL, Finance, Reporting, Data Transformation, Oracle DBA, Database Architecture, Database Design, Excel VBA

Microsoft Certified Trainer

1995 - 1999

C.S. Edusoft

Trained on Windows NT Server advanced administration, including security.
Taught SQL Server administration and Transact-SQL development.
对Visual Basic、Visual c++、Visual Fox Pro等开发工具进行培训.

Technologies: Windows NT Server, Microsoft SQL Server, Microsoft Visual Studio, SQL, Data Engineering, ETL, Data Warehousing, Data Analysis, Data Visualization, Data Analytics, Data Architecture, Databases, Microsoft Excel, SQL DML, Performance Tuning, Data Queries, SQL Performance, T-SQL (Transact-SQL), Database Administration (DBA), .NET, Data Modeling, Stored Procedure, SQL Stored Procedures, Data-level Security, Business Continuity & Disaster Recovery (BCDR), Finance, Reporting, Microsoft DBA, Crystal Reports, Database Architecture, Database Design, Excel VBA

Software Engineer

1994 - 1995

Quality Business Software (QBS)

Created reports for existing systems in customers environment.
Designed and implemented a system to manage doctors' offices.
Created and customized the end user interface in existing systems.

Technologies: Object Pascal, Microsoft Access, dBASE, Visual FoxPro, SQL, Data Reporting, Data Engineering, Data Analysis, Data Analytics, Databases, Microsoft Excel, SQL DML, Data Queries, .NET, Data Modeling, Reporting, Database Architecture, Database Design

Experience

Tokenomy Singapore

我设计了一个技术项目，实现了一个基于八个事务性生产系统的新数据仓库.

The project is now fully operational and used by customers in production. Because of high time requirements, I did lots of performance tuning work.

生产仓库从Oracle Exadata 4实时迁移到Oracle Exadata 6

http://www.pocztowy.pl/

我设计并执行了Pocztowy Bank生产仓库的迁移过程.

从Oracle Exadata 4迁移到Oracle Exadata 6，并致力于优化性能. The requirement from the customer was a service window of about 10 minutes.

Polish Gas Company (PS Gaz)

http://www.psgaz.pl/en

我设计了体系结构并监督了ETL系统的实现，以从五个源系统提供中央网络资产存储库, including GIS type with different formats for storing spatial data.

Polish Gas Company (PS Gaz) | Migraton of Source Systems to SAP

http://www.psgaz.pl/en

从许多源系统迁移数百万条记录集，并用SAP系统为它们提供.

Competences used
Oracle, SQL, PL / SQL, BI, ETL, performance tuning, pre-tuning forecast of around 50,000 years, a post-tuning execution time of fewer than 0.1 seconds, 以及其他具有大约100万条记录的表的多个聚合.

Polskie Wody (KZGW) | IT System of The Country Shield (ISOK)

管理体系结构的审核和重新设计，监督ISOK体系的实施.

并基于Oracle数据库为ISOK系统创建了逻辑数据模型和物理数据模型.

系统审计|车辆和驾驶员中央登记系统和国家登记系统

I performed audits of systems in the areas of Oracle and DB2 database design. Managed high availability and security issues on the databases layer.

• www.cepik.gov.pl
• www.gov.pl/web/cyfryzacja/system-rejestrow-panstwowych

State Social Security (ZUS)

http://www.zus.pl/slownik/-/letter/K/kompleksowy-system-informatyczny-ksi-zus-/21738

我领导了创建基线和文档以实现Corporate Service总线的体系结构团队.

分析了超过700万行的源代码和ZUS主系统(KSI)的中央数据库，分析了用现代技术取代KSI的可能性并创建了一个场景.

Role
Deputy head of the architectural team

NC and Canal+ Poland

http://pl.canalplus.com/

I delivered maintenance support in over 200 instances in Oracle databases.

Trained new DBAs on specific, 为客户生产系统的数据库提供一套独一无二的维护程序.

我保证在准备和启动备份和恢复以及准备大约200个UAT环境方面提供体系结构支持. 为开发和测试环境准备并执行数据匿名化程序.

Delivered support in performance tuning of Oracle databases.

Polish Post

http://www.poczta-polska.pl/

我创建了一个管理员团队来维护客户的具有高SLA要求的Oracle数据库.

Role
Maintenance team manager

Competences used
Maintenance of Oracle databases and Oracle Exadata, Zabbix

KGHM Poland

http://kghm.com/

我负责中央采购系统(SWZ)在安全领域的审计工作.

分析了数千个源代码、Jakarta EE以及中央数据库的结构和内容. 我还创建了一个工具，用于导入和执行HTTP和HTTPS请求访问日志的简要分析，以允许IT部门验证用户发现的漏洞.

Ceramika Nowa Gala

http://nowa-gala.com.pl/

I created a new custom module from scratch for Oracle EBS, handling investments, integration, implementation, and production launch.

Managed the architectural design of a new module, provided training on Oracle EBE internal specifics for the developers' team, and supervised the module's implementation.

Role
Chief of the developers' team and architect.

Police Headquarters | National Police Information System (KSiP)

http://policja.pl/

管理一个解决方案的开发，允许通过Radius服务器对国家警察信息系统进行认证.

Role
Software engineer - Oracle Consulting contractor

Competences Used
C, C++, Oracle Pro C, security.

A.PL (Action Group)

http://a.pl

Worked on the development, production run, and maintenance of one of the first internet galleries in Poland. 我培训和监督了一个由开发人员、系统/数据库管理员和项目组成的团队. 这是Oracle store在欧洲的第一个实现(2007-2008)。.

Skills

Languages

SQL, SQL DML, Stored Procedure, Java, Python, T-SQL (Transact-SQL), Bash, Excel VBA, C++, C, Object Pascal, dBASE, Visual FoxPro, Apex

Paradigms

Database Design, ETL, Business Intelligence (BI), OLAP

Platforms

Oracle, Oracle Database, Linux, Microsoft, Jakarta EE, Red Hat Linux

Storage

PostgreSQL, PL/SQL, Oracle Database Tuning, Databases, SQL Performance, Database Administration (DBA), Oracle PL/SQL, SQL Stored Procedures, Oracle SQL, Oracle DBA, Microsoft DBA, Database Architecture, Microsoft SQL Server, Data Pipelines, Oracle Cloud, MySQL, MariaDB, JSON, IBM Db2, MongoDB

Other

Performance Tuning, Data Migration, Data Engineering, Data Analysis, Data Analytics, Data Architecture, API Integration, APIs, Integration, Data Queries, Data Modeling, Migration, Data-level Security, Business Continuity & Disaster Recovery (BCDR), Reporting, Data Transformation, Data Warehouse Design, IT Security, Data Reporting, Data Warehousing, Data Visualization, Pipelines, XML for Analysis (XMLA), Finance, CRM APIs, Web Scraping, Oracle Performance Tuning, System Architecture Design, Oracle Spatial, PL/SQL Tuning, SAP, IT Systems Architecture, Business Analysis, System Design, Sparx Enterprise Architecture, Reverse Engineering, Risk Analysis, Digital Forensics, Oracle EBS, Windows NT Server, System Administration, Administration

Frameworks

.NET

Tools

Microsoft Access, Microsoft Excel, GitHub, Oracle ERP, Microsoft Power BI, Oracle Exadata, GIS, Oracle Tuxedo, Zabbix, Oracle Forms, Oracle Reports, Microsoft Visual Studio, Oracle Application Express (APEX), Batch Apex, SugarCRM, Crystal Reports

Libraries/APIs

Zendesk API

Education

1991 - 1997

Master's Degree in Computer Science Engineering

Warsaw University of Technology - Warsaw, Poland

Certifications

AUGUST 2002 - PRESENT

Oracle Certified Professional (OCP)

Oracle

MAY 1998 - PRESENT

Microsoft Certified Database Administrator

Microsoft

MAY 1998 - PRESENT

Microsoft Certified System Engineer

Microsoft

OCTOBER 1997 - PRESENT

Microsoft Certified Trainer

Microsoft

Collaboration That Works

How to Work with Toptal

在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.

Share your needs

在与Toptal领域专家的电话中讨论您的需求并细化您的范围.

Choose your talent

在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.

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