Database Engineering

High-Availability Database Clusters

We design and manage self-healing MySQL (Galera, Percona, MariaDB), PostgreSQL, MongoDB, MSSQL, Oracle, and DB2 architectures. Ensure your data is consistent, secure, and always available - even during high traffic spikes.
Expert services available in Munich (Bayern) and remotely.

Database Tuning Zero-Downtime Migration Disaster Recovery Scaling
MySQL
PostgreSQL
MongoDB
Redis
MSSQL
Oracle
DB2
Primary ● Active
Replica 1
Replica 2
Sync_Latency: 0.4ms

Abstract Data Tools

Processing Engine

Apache Spark

Unified engine for large-scale in-memory data processing (analytics, ML, graphs).

Support Tools

Apache Kafka

Streaming platform for real-time data transmission.

NoSQL Databases

Apache Cassandra

Highly scalable database for huge volumes of data with no downtime.

Apache CouchDB

Document JSON database, ideal for web and synchronization.

Apache HBase

Distributed database for random access to Big Data (runs on Hadoop).

Apache Accumulo

Secure, sorted, distributed key-value store.

SQL & Relational Databases

Apache Derby

Lightweight relational database entirely in Java.

Open Source Power

Enterprise Grade Solutions

AI-Powered Solutions for Business Challenges

Harness the potential of AI to improve efficiency, automate workflows, and generate valuable insights.

Data Input (Trigger)
Data Validation (Quality Check)
AI Processing workflowsortiaCore
Results Output (Actionable Results)
Learn More

Adaptable Workflow Development

Combining visual development speed with the precision of code, a platform leveraging powerful workflow engines like n8n offers a unique approach. Start with intuitive drag-and-drop tools for rapid prototyping and standard tasks. When complexity increases, seamlessly switch to code for fine-grained control and custom logic integration.

Connect directly with external APIs using standard cURL commands within your workflows.
Extend capabilities further by incorporating libraries from npm or Python's package index.
Leverage JavaScript or Python for sophisticated custom functions and precise data handling.
Finally, manage intricate processes effectively with advanced flow controls like branch merging.

White-Label Automation Solutions

Supported by a robust integration engine, powerful, custom-branded automation features can be embedded directly into products to empower end customers.

Workflow diagram showing problem, processing, and solution steps AI Robot Head

Action, AI, Insights, Solution

Action

Taking decisive steps based on intelligent analysis.

AI

Leveraging cutting-edge artificial intelligence.

Insights

Uncovering valuable patterns and predictions.

Solution

Delivering effective and scalable results.

IT Consulting

Inefficient Data Processing

Implement AI models to automate and accelerate data extraction.

Manual Workflow Bottlenecks

Deploy AI-driven automation to streamline operations.

Lack of Predictive Insights

Utilize machine learning for accurate forecasting and decision-making.

Data Scalability Challenges

Architect and optimize AI solutions for large-scale data environments.

DevOps & Technologies

Cloud Platforms

  • AWS: Comprehensive cloud services suite.
  • Azure: Microsoft's cloud computing platform.
  • GCP: Google's cloud infrastructure services.
  • EC2: Scalable virtual servers on AWS.
  • S3: Scalable object storage on AWS.
  • Lambda: Serverless compute service on AWS.
  • CloudFormation: Infrastructure as Code on AWS.
  • Azure VMs: Virtual machines on Azure.
  • Azure Blob Storage: Object storage on Azure.

Containerization

  • Docker: OS-level virtualization platform.
  • Kubernetes (K8s): Container orchestration system.
  • Helm: Package manager for Kubernetes.
  • EKS: Managed Kubernetes on AWS.
  • AKS: Managed Kubernetes on Azure.
  • GKE: Managed Kubernetes on GCP.
  • OpenShift: Red Hat's Kubernetes platform.
  • Istio: Service mesh for microservices.

Databases

  • MySQL: Popular open-source RDBMS.
  • PostgreSQL: Advanced open-source RDBMS.
  • MongoDB: NoSQL document database.
  • Redis: In-memory data structure store.
  • Cassandra: Distributed NoSQL database.
  • Elasticsearch: Search and analytics engine.
  • DynamoDB: Managed NoSQL database on AWS.
  • RDS: Managed relational databases on AWS.
  • SQL Server: Microsoft's RDBMS.
  • Oracle DB: Enterprise RDBMS.

OS & Infrastructure

  • Linux (Ubuntu, CentOS): Widely used open-source OS.
  • Unix: Foundational multi-user OS family.
  • Bash/Shell Scripting: Command-line automation.
  • Networking (TCP/IP, DNS): Core internet protocols.
  • Load Balancers (Nginx, HAProxy): Traffic distribution.
  • Terraform: Multi-cloud Infrastructure as Code.
  • Ansible: Configuration management & automation.

Automation & Workflow

  • n8n: Extendable workflow automation tool.
  • Jenkins: CI/CD automation server.
  • GitLab CI/CD: Integrated CI/CD pipelines.
  • GitHub Actions: Workflow automation in GitHub.
  • Zapier: Web application integration platform.
  • Make (Integromat): Visual workflow automation.

Programming

  • Python: Versatile high-level language.
  • JavaScript: Core web scripting language.
  • Node.js: Server-side JavaScript runtime.
  • React: JavaScript library for UI building.
  • Java: Widely used object-oriented language.
  • Go: Efficient language by Google.
  • PHP: Server-side scripting language.
  • REST APIs: Standard for web service communication.
  • GraphQL: Query language for APIs.

Detailed Database Solutions

MySQL & MariaDB Clustering

Specialized in designing architectures that never fail. From synchronous Galera Cluster and Percona XtraDB to high-performance asynchronous replication setups.

  • Galera / Percona Cluster: Multi-master synchronous replication ensuring zero data loss and high availability.
  • ProxySQL & Load Balancing: Intelligent query routing, caching, and connection multiplexing for massive scale.
  • Replication Topologies: Master-Slave, Master-Master, and delayed replicas for disaster recovery scenarios.
cluster_status.sh

root@db-node-01:~# mysql -e "SHOW STATUS LIKE 'wsrep%'"

+---------------------------+------------+
| Variable_name             | Value      |
+---------------------------+------------+
| wsrep_local_state_comment | Synced     |
| wsrep_cluster_size        | 3          |
| wsrep_cluster_status      | Primary    |
| wsrep_ready               | ON         |
+---------------------------+------------+
                         

# Cluster is healthy and replicating...

PostgreSQL Enterprise Edition

PostgreSQL Enterprise

Robust architecture for mission-critical data. Leveraging PostgreSQL's advanced features for reliability, performance, and geospatial data.

  • High Availability (Patroni): Automated failover using Etcd/Consul to minimize downtime.
  • Performance Tuning: Advanced vacuum tuning, index optimization, and slow query analysis.
  • PgBouncer: Efficient connection pooling for high-throughput environments.

Comprehensive Database Services

Disaster Recovery

Emergency data rescue, Point-in-Time Recovery (PITR), and handling corruption or accidental 'DROP TABLE' scenarios.

Upgrades & Migrations

Zero-downtime migrations to Cloud (AWS RDS, GCP) and major version upgrades (e.g., MySQL 5.7 to 8.0).

Fixes & Troubleshooting

Resolving deadlocks, slow queries, replication lags, foreign key issues, and server stability problems.

Certifications

ITIL 4 Foundation

Best practices for the creation, delivery, and continual improvement of technology-enabled products and services embracing the new service management culture.

Infrastructure & Platform Engineering

Enterprise-grade platforms for container orchestration, virtualization, GitOps automation, and full-stack observability.

Kubernetes & OpenShift

Production-grade container orchestration on Red Hat OpenShift and OKD. Namespace-scoped operator deployments, RBAC management, OLM configuration, and multi-cluster context management across production and test environments.

OpenShift / OKD Operator Lifecycle Helm / Kustomize RBAC & SCC

Virtualization & Proxmox

Enterprise virtualization with Proxmox VE: from high-availability clusters to desktop VM provisioning. NVMe-backed storage, VFIO GPU passthrough, automated backup policies, and comprehensive infrastructure monitoring.

Proxmox VE VM Provisioning PBS Backup Storage / ZFS

GitOps & CI/CD Automation

End-to-end automation pipelines: NetBox webhooks to AWX job templates to Ansible playbooks to GitLab push to ArgoCD sync to OpenShift deployment. Self-service provisioning with automated sync, self-heal, and pruning policies.

ArgoCD GitLab CI/CD Ansible / AWX NetBox CMDB

Monitoring & Observability

Full-stack monitoring pipeline: exporters to ServiceMonitor to VictoriaMetrics to Grafana dashboards. Cross-namespace monitoring architecture, PromQL/MetricsQL query development, and custom dashboards for database replication, connection pools, and query performance.

Grafana VictoriaMetrics Prometheus ServiceMonitor

Database Operators on Kubernetes

Automated database lifecycle on Kubernetes: Percona XtraDB Cluster with HAProxy, Crunchy PGO with PgBouncer and pgBackRest, MariaDB Enterprise Operator. T-shirt sizing, automated failover, backup CronJobs, and disaster recovery procedures.

Percona PXC Crunchy PGO MariaDB Op. HA / Failover

Network & Firewall

Enterprise network management with OPNsense firewalls, DNS architecture, VLAN segmentation, and SSL automation using Lets Encrypt wildcards. Traefik reverse proxy with automatic certificate management.

OPNsense Traefik Lets Encrypt DNS / VLAN

Our Products

Mobile, web and desktop products built by Sortia Labs: fitness tracking, AI voice transcription, meditation, end-to-end encrypted file transfer, and a hardware-accelerated Windows screen recorder.

Tractor
TRACTOR
Weight & Activity Tracking
Interactive weight charts, BMI tracking, 60+ sports & activities, daily diary with mood, custom reminders. Available in 30+ languages.
Android Web 30+ Languages 60+ Activities
Loma
LOMA
Voice Transcription & Translation
AI-powered voice transcription with real-time translation. 97+ languages, 3 AI models (GPT-4o, Whisper), live 10s chunking, audio export.
Android Web 97+ Languages GPT-4o
Balsam
BALSAM
Meditation, Breathing & Sounds
100+ unique ambient soundscapes generated in real-time. Breathing exercises, meditation timer. Completely free, works offline, no account needed.
Android Web 100+ Sounds Free
BOX
Encrypted Clipboard & File Transfer
End-to-end encrypted file and clipboard sharing. AES-GCM 256 in the browser via Web Crypto API, zero-knowledge server, brute-force protection, screenshot detection on mobile.
Android Web AES-GCM 256 Zero-knowledge
SCREEN
Hardware-Accelerated Screen Recorder
Windows screen recorder with NVENC and Intel Quick Sync hardware encoding. FFmpeg under the hood, system-wide hotkeys, distraction-free mode. 100% local: no telemetry, no account.
Windows Desktop NVENC / QSV 100% local
TEMPO
Day organizer
Your day in focus: a Google-style calendar, dictate events by voice, realtime sync between phone and desktop, Gmail attachments right on the event.
Android Web / PWA Realtime Sync Voice AI
FIBU
Local accounting with AI
Receipts, bank and VAT in one app that never leaves your machine. AI reads documents, payments are the truth, every receipt verified by sha256.
Desktop 100% local AI Belege USt / MwSt
OMNIA
The local document archive
Contracts, letters, scans and everything without a payment attached. AI names and sorts, nothing is ever deleted, one folder is the whole backup.
Desktop 100% local AI Archiv Nie geloescht

All products are designed, built and shipped by Sortia Labs: from concept to Google Play and Windows distribution. Native Android in Kotlin + Jetpack Compose, web apps as installable PWAs, Windows apps in Python with PyInstaller and Inno Setup. Privacy-first architecture, modern cloud back-ends, real-time performance.

Android

Kotlin Jetpack Compose Material 3 Coroutines StateFlow Gradle KTS OkHttp

AI & Backend

OpenAI API GPT-4o Whisper Supabase PostgreSQL Row Level Security Google OAuth

Web & Infra

PWA WebAudio API Service Workers Nginx Contabo VPS GitHub Firebase Crashlytics Google Play Store

Clients & Project Partners

Ready to Transform Your Business?

Let's discuss how Sortia AI solutions can help you achieve your goals.

Headquarters in Munich (München), Bavaria

Impressum (Legal Notice)

Information according to § 5 TMG

Jozef Kapicak IT Consulting

Kurparkstr. 45

81375 München

Germany

Represented by

Jozef Kapicak

Contact

Phone: +49-151 52562777

E-Mail: [email protected]

VAT ID

VAT identification number according to § 27 a Value Added Tax Act:

DE280861639

Responsible for the content according to § 55 Abs. 2 RStV

Jozef Kapicak

Kurparkstr. 45

81375 München

Disclaimer

Liability for Content: As a service provider, we are responsible for our own content on these pages according to general laws pursuant to § 7 Abs.1 TMG. According to §§ 8 to 10 TMG, however, we as a service provider are not obligated to monitor transmitted or stored third-party information or to investigate circumstances that indicate illegal activity. Obligations to remove or block the use of information under general laws remain unaffected. However, liability in this regard is only possible from the moment of knowledge of a specific infringement. Upon notification of corresponding violations, we will remove this content immediately.

Liability for Links: Our offer contains links to external websites of third parties, over whose content we have no influence. Therefore, we cannot assume any liability for this external content. The respective provider or operator of the pages is always responsible for the content of the linked pages. The linked pages were checked for possible legal violations at the time of linking. Illegal content was not recognizable at the time of linking. However, permanent content control of the linked pages is not reasonable without concrete evidence of an infringement. Upon notification of violations, we will remove such links immediately.

Copyright

The content and works created by the site operators on these pages are subject to German copyright law. The reproduction, processing, distribution, and any kind of exploitation outside the limits of copyright require the written consent of the respective author or creator. Downloads and copies of this site are only permitted for private, non-commercial use. Insofar as the content on this site was not created by the operator, the copyrights of third parties are respected. In particular, third-party content is marked as such. Should you nevertheless become aware of a copyright infringement, we ask for a corresponding notice. Upon notification of violations, we will remove such content immediately.

Data Protection

The use of our website is generally possible without providing personal data. Insofar as personal data (e.g., name, address, or e-mail addresses) are collected on our pages, this is always done, as far as possible, on a voluntary basis. These data will not be passed on to third parties without your express consent. We point out that data transmission over the Internet (e.g., when communicating by e-mail) can have security gaps. Complete protection of data against access by third parties is not possible.