Jozef Kapicak
Application and Database Designer; AI Solutions Architect
Experience
Application and Database Designer; AI Solutions Architect
Infineon Technologies AG
Management role for the new developed applications
Data retrieval and recovery from worldwide central Infineon database clusters
Definition, setup and usage of one of the main Infineon databases (MsSQL, MySQL, GraphQL, Cassandra DB)
Wrote a proof of concept solution for retrieving data from main secured remote databases while managing data (Python, PHP, JavaScript, HTML, CSS)
Integration of LLMs and using N8n platform (Gemini, Claude, DeepSeek, GPT-4) with pipelines
Automatic filling standardized Excel templates with filtered data
Creation of websites for user interaction targeting control over functionality
Implementation of smart CI/CD ETL/ELT pipelines with integrated AI support (GitLab, OpenShift, Docker, Kubernetes)
MCP & A2A protocols implementation
Reading manually filled Excel sheets and saving data in a database
Identification and reporting of data inconsistencies in Python and fixing them
Provision of a website to fix inconsistencies in the database
Retrieval of data from Process Block Catalog and Process Flow Excel sheets from Team Center DMS (Python)
Accumulation and writing of retrieved data into Excel templates
Parsed and processed large JSON trees up to 100,000 rows (Python, PHP, PowerShell, shell scripts)
Wrote a tree traversal engine for large JSON data structures (Python)
Security management and change management
Used tools: Unix, Ubuntu, Debian, Windows, macOS; Bash, PHP, Python, JavaScript, HTML, CSS, PowerShell, Nginx, Apache; PostgreSQL, MsSQL, MySQL, MariaDB, GraphQL; Docker, Ganeti, WSL, Proxmox; Puppet, Git; Data formats JSON, XML, CSV, TXT, SQL; SSMS, VS Code
Main Database Consultant
sprd.net AG
Main administrator of ~500 databases and ~150 DB clusters across Europe & North America
Maintenance of database instances and infrastructure (MySQL Galera Cluster, PostgreSQL, MongoDB)
Setup and tuning of new and existing DB clusters
Monitoring and problem analysis for server downtimes and DB issues
Analysis and optimization of stored procedures, triggers, SQL and slow queries
Use of Percona toolkit and solution management for crashes and overloads
DB updates, upgrades, user and backup management, data recovery, security management
Participation in Scrum meetings
Used tools: Unix, Ubuntu, Debian, Windows; Bash, PHP, Python; MySQL, Percona Cluster, MariaDB, PostgreSQL, MongoDB, Redis; Kubernetes, Multipass, Hyper-V, Docker, Ganeti, WSL; Check_MK; Jira; Grafana, Kibana; Puppet, Git, GitLab, Jenkins, Ansible; Apache, Drupal, Bootstrap, CSS, JavaScript, FuelPHP, jQuery; Terraform, Consul, Vault; Commvault; DevOps practices; Data formats JSON, XML, CSV, TXT, SQL; Change management
Solution Expert; Application Manager; Business Analyst
Handzon GmbH
Designed and managed data workflows using the Orchestra Enterprise Service Bus solution
Connected hardware and software factory interfaces inside the company
Used tools: Soffico Orchestra Designer, VMware Workstation, Ubuntu Multipass, Hyper-V, Kubernetes, Argo CD, Docker, Portainer; MSSQL, MySQL, MariaDB, PostgreSQL, MongoDB; PHP, PowerShell; Swagger API; Lucene; ITIL 4; Data formats JSON, XML, CSV; Protocols REST, SOAP, HTTP
Database Consultant
Bernstein Bank GmbH
Designed, implemented, and optimized stored procedures and SQL queries in Azure cloud
Achieved up to 400× speedup for stored procedures
Performed SQL query analysis, performance testing, optimization, reporting, and documentation
Database monitoring, backup, restore, maintenance, and splitting analysis
Troubleshot complex SQL queries, stored procedures and views; conducted performance checks
Designed and analyzed large volumes of data in internal SQL Data Warehouse
Reduced SQL query traffic between applications and main DB cluster from 100% to 2%
Used tools: Azure Cloud, MSSQL cluster, PostgreSQL; Windows 11, VMware Workstation, Ubuntu Multipass, CentOS, Hyper-V; SSMS, PowerShell, shell scripts; Docker, Kubernetes; ITIL 4; Change management
Business Analyst; System Engineer
Private business activity
- Built a system for analyzing trading data from external trading platforms
- Analyzed trading data and transactions; performed data clearing from exchanges
- Reporting, status change alerts, monitoring, forecasting, performance optimization
- Data store analysis, data modeling, indexing and evaluating trade-offs
Database and Data Workflow Consultant
ICO - International Certification Organization AG
- Proposed security improvements and redesign of data workflows across application interfaces and remote databases
- Maintenance, programming, system optimizations, and solution proposals
- Wrote scripts for remote automation (PHP, Python, Bash, shell)
- Analyzed, designed, and coded using PHP, Python, HTML, CSS, MySQL, Neo4J; analyzed data nodes and relationships
Database and Security Architect
Fidor Solutions
Served as the bank's database consultant improving design, security, and performance of MySQL clusters
Prepared for biannual security database audits and implemented improvements
Communicated with management about current situation and potential improvements
Conducted extensive performance analysis and tuning, achieving up to 100,000× speedup for queries and backups reduction from 7 hours to 20 minutes
Managed access backlog, reduced backlogs, and wrote automation scripts (stored procedures, triggers, SQL, Python, Bash, PHP)
Led Docker containerization, Kubernetes, Rancher, Swarm, and guided deployment processes
Proposed new DB cluster designs and replication workflows; administered several hundred MySQL databases and alternative DBs (DB2, Oracle, PostgreSQL, Cassandra)
Implemented monitoring changes (Nagios), replication performance tuning, documentation, change management, and Amazon EC2, S3 environments
Other activities: data recovery from VMware snapshots, designed data storage and reporting systems, daily tuning, DB migrations, interface development, monitoring interface for MySQL, process automation, backup system design, departmental support, communication and presentations
System Architect; Application Manager
Hallhuber GmbH
- Senior software and system designer and IT consultant for Hallhuber and Gerry Weber International AG
- Analyzed, designed, coded, and administered financial data workflows using Gliffy, SAP APIs, DB2, PostgreSQL, MsSQL, MySQL, Python, PHP, Bash, Unix, Windows, Magento, Joomla
- Redesigned data workflows for ~230 branches, multi-currency credit and debit card statements, bank statements, online payment exports/imports (Amazon, Amex, PayPal, Zalando, Concardis), employee salaries, and daily sales from 25 online shops
- Designed and coded big data storage, performance tuning, data modeling, SAP WMS interfaces, sFTP structure, and automation scripts
- Managed technical migration to SAP-FI, database migrations, and interface development (Python, PHP, SQL, stored procedures)
- Designed microservices architecture, monitoring interfaces, cron jobs, process automations, reporting systems, backup and monitoring infrastructure (Pandora, hot-standby)
- Supported finance department, change management, documentation, and management reporting
Main Database Consultant
Bayerischer Rundfunk
- Led DB migration from Oracle to MySQL/Percona Galera Cluster
- Developed and maintained internal blogs and CMS based on WordPress (PHP, JavaScript, NodeJS, MySQL, Apache, Nginx, Varnish)
- Maintained VMware vSphere/ESXi and NetApp MetroCluster for high availability with Corosync and Pacemaker on RHEL/CentOS
- Optimized HA systems and processes; trained staff
- Administered MySQL, Percona, Galera, MongoDB, PostgreSQL, Memcached; performance optimization
- Designed and programmed DB tools (DB Check, Nagios, Icinga), backup and recovery systems (Ceph, Xtrabackup)
- Upgraded databases from MySQL 5.1 to Percona 5.6; maintained large DBs (Sophora, MIR, blogs, Active MQ)
- Senior WordPress administrator for 180+ blogs; developed plugins, themes, microsites
- Designed RESTful JSON application server, performance tools, newsletter and cache purge tools
- Planned and maintained migration scripts, monitoring, and reporting tools; reported to management
Teamleiter Entwicklung Hotel (CTO)
CHECK24 Vergleichsportal Reisen GmbH
- Responsible for complete redesign of an acquired external IT company including team of 8 developers and 90 servers in 2 data centers
- Communicated with management, owners, IT suppliers, managed budget, outsourcing, and company planning
- Rewrote 50–60% of legacy code and delivered a new system up to 15× faster running on 2 servers, saving the company over €1.5 million
- Team management, IT strategy and roadmap creation, recruitment and appraisals, budget control, project management, process optimization, board presentations
Head of IT (CTO)
Deal United GmbH
- Reorganized and managed IT department and processes; acted as lead developer
- Restructured infrastructure, moved 18 servers to Amazon EC2/S3
- Wrote Payment Gateway API to Payon, interface to Bigpoint, REST API, redesigned admin portal, voucher payment system, and automated invoicing system
Leading Senior Software Developer
Zonzoo GmbH
- Led team and opened new branch in Dubai
- Designed and developed PHP 5 OOP MVC warehouse and logistics management system (backend and frontend) for 20,000 points of sale across 10 countries
- Developed barcode scanning interface and managed stock items
- Deployed complete Debian server setup with tuning; coordinated with departments and customers
Senior Software Engineer
CHIP Xonio Online GmbH
- Redesigned and improved the CHIP.de price-comparison portal (frontend and backend)
- Achieved >300% increase in clicks, turnover, and profit over 3 years
Software Engineer
Ciao AG
- Developed customer data integrations across Europe and object history module for proprietary application server
- Improved backend CMS and opened new Netherlands branch; worked on IBM API Gateway and certification
Software Developer
Inventum GmbH
- Developed second-generation search engine and web crawler
- Built administration portal and security modules; generated management reports
- Processed large document sets and managed Apache web servers
Sales Manager
SWH - Siemens Business Services s.r.o.
- Managed sales of Call Centers, MIS, and web SW projects to banks and insurers in Slovakia
- Developed strategic client relationships and new opportunities; first contact for cross-industry sales
Project Manager
Olivetti Slovakia s.r.o.; Wang Global Slovakia; Getronics Slovakia
- Led international team (30 people) in developing Slovakia’s first automated ATM banking zone and multimedia terminal projects
- Managed scanning and reading of checks and banknotes, multimedia terminal management modules, and SMS messaging via public terminals
- Received recognition from Wang Global headquarters for project excellence
Languages
Education
Erasmus University
Rotterdam, Netherlands
Economics University
Master's degree · Information Technologies · Bratislava, Slovakia
Certifications & licenses
ITIL 4
Sophora Certified Administrator (SOCAD)
Certificate of Completion: Pacemaker Basics
Mysql Administrator course
Projectmanager course
Similar Freelancers
Discover other experts with similar qualifications and experience
Support/Development/Consulting – Process Development, E-Invoicing, XRechnung, ZUGFeRD
MLOps (machine learning operations)
Qualifications Profile
Embedded Fullstack Developer
IT Support
Data-Scientist/AI Engineer
Data Engineer
Head of Technical Overall Integration NSC / Hadoop Cloud Development
Architecture Consultant (Freelance)
Interim Consultant for Oracle Database Migrations to the AWS Cloud
Architect/Software Developer/Infrastructure
Project Management
DevOps Engineer in the DevOps Team
IT Senior Software Engineer
SSIS Development
Co-founder / Solution Architect
IT Consultant & Continuing Education
Setup Azure cloud, Java development, CI/CD pipelines
Senior Software Engineer
Data Scientist & Data Engineer
IT Project Management, Implementation of AI-Supported Software Development
Technical Product Owner
Freelance Data Engineer / Architect
Operation and Maintenance of Oracle Middleware Products
T-SQL Database Expert
Cloud & IT Service Management with Azure & ServiceNow (freelance)
Senior Software Developer, Architect
Cloud (AWS) | AI | DevOps | Data
ServiceNow Consultant
