Radek Wiewior
Verified Expert in Engineering
Database Developer
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
Experience
Availability
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
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.
Data Management Consultant
Tokenomy Technologies
- 几乎实时地设计和创建来自八个系统的数据仓库报告.
- 创建了开发过程,使未来的数据仓库开发变得容易.
- Tuned performance of ETL processes created by other developers and me. The time decreased was quite spectacular.
Chief Technology Officer
Goldenore
- Provided training to Oracle engineers to masterschip their skills.
- Created architecture and supervised development projects, 比如为系统的数据库和应用服务器层创建性能调优和监控的自定义工具.
- 在项目中最复杂的部分出现问题时承担责任.
Database Architect
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.
Databases Expert and Auditor
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. 证明迁移到新的现代技术栈是可能的,而且不那么昂贵.
Head Technical Consultant | Owner
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.
Senior Instructor
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数据库源代码的分析.
Software Engineer
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.
Microsoft Certified Trainer
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等开发工具进行培训.
Software Engineer
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.
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/从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/enPolish Gas Company (PS Gaz) | Migraton of Source Systems to SAP
http://www.psgaz.pl/enCompetences 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)
并基于Oracle数据库为ISOK系统创建了逻辑数据模型和物理数据模型.
系统审计|车辆和驾驶员中央登记系统和国家登记系统
• 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分析了超过700万行的源代码和ZUS主系统(KSI)的中央数据库,分析了用现代技术取代KSI的可能性并创建了一个场景.
Role
Deputy head of the architectural team
NC and Canal+ Poland
http://pl.canalplus.com/Trained new DBAs on specific, 为客户生产系统的数据库提供一套独一无二的维护程序.
我保证在准备和启动备份和恢复以及准备大约200个UAT环境方面提供体系结构支持. 为开发和测试环境准备并执行数据匿名化程序.
Delivered support in performance tuning of Oracle databases.
Polish Post
http://www.poczta-polska.pl/Role
Maintenance team manager
Competences used
Maintenance of Oracle databases and Oracle Exadata, Zabbix
KGHM Poland
http://kghm.com/分析了数千个源代码、Jakarta EE以及中央数据库的结构和内容. 我还创建了一个工具,用于导入和执行HTTP和HTTPS请求访问日志的简要分析,以允许IT部门验证用户发现的漏洞.
Ceramika Nowa Gala
http://nowa-gala.com.pl/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/Role
Software engineer - Oracle Consulting contractor
Competences Used
C, C++, Oracle Pro C, security.
A.PL (Action Group)
http://a.plSkills
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
Master's Degree in Computer Science Engineering
Warsaw University of Technology - Warsaw, Poland
Certifications
Oracle Certified Professional (OCP)
Oracle
Microsoft Certified Database Administrator
Microsoft
Microsoft Certified System Engineer
Microsoft
Microsoft Certified Trainer
Microsoft
How to Work with Toptal
在数小时内,而不是数周或数月,我们的网络将为您直接匹配全球行业专家.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring