Denis Piknjač.

Head of IT · SQL Server DBA & Datalab Pantheon developer

I run the SQL Server, infrastructure and ERP integrations a multi-site retailer depends on. I measure the work in milliseconds.

Three Hyper-V hosts on shared SAN storage run SQL Server 2022, which serves the Pantheon ERP, point of sale at six sites, and the warehouse system. HV-1 HV-2 HV-3 SAN · SHARED STORAGE SQL SERVER 2022 ERP · PANTHEON POS · 6 SITES WMS
Production topology, simplified
faster writes, 1,833 to 19 ms
96×
faster stock query, 40 s to 4-5 s
10×
migrated with zero downtime
66 GB
years in IT, 5+ as DBA
10+

What I do best

Microsoft SQL Server

Database development & administration

SQL Server is home ground. I design, tune and run production databases end to end: high availability that holds, backups that actually restore, execution plans read line by line and indexes placed with intent. When something is slow, I answer with wait stats and milliseconds, not guesses.

  • Performance engineering
  • Indexed views
  • Lock & deadlock analysis
  • Filegroup architecture
  • Zero-downtime migrations
  • Always On & HA/DR
  • Query Store
  • SQL Server 2016-2022

Datalab Pantheon

ERP development & administration

Certified Pantheon administrator and ARES Pascal developer. I make the ERP talk to the real world: every register across every site stays in sync, warehouse scales print exactly what the database says, and payment terminals settle cleanly at checkout.

  • ARES Pascal
  • POS sync
  • ERP DB architecture
  • Scale & payment integration
  • Process automation

Proof, in production

1,833 ms to 19 ms

Write stalls, gone

Production storage was choking under write load. I traced the stalls through the virtualization stack down to the disk format itself, then rebuilt the storage layout live, with the business running on top of it.

40 s to 4-5 s

The 40-second query

Stock calculation was the slowest thing in the company, and everyone had learned to live with it. I redesigned it from the ground up around indexed views, and the wait disappeared.

0 deadlocks

Collisions designed out

Parallel warehouse scanners kept deadlocking each other mid-transaction. Instead of retry band-aids, I rewrote the locking patterns at the root, so collisions became impossible, not just rare.

66 GB, 0 downtime

Surgery on a live database

Nine core tables and their indexes reorganised onto an entirely new storage architecture while sales kept flowing. Nobody noticed a thing, which was exactly the point.

Where I've worked

  1. 2024 - present

    Head of IT · Lead DBA & Database Developer

    Penny Plus d.o.o., Sarajevo

    The entire IT operation of a multi-site retail company runs through one pair of hands: mine. A virtualized cluster, SAN storage, SQL Server 2022, networks linking six-plus locations, POS endpoints and warehouse management. From database internals to firewall rules, if it has a connection string or a cable, I own it.

  2. 2023

    Data Analyst / Database Specialist

    Xylon Corporation, Aptha Corp

    Short, focused engagements with a single brief: make the data behave. Query optimisation, data modelling and report automation.

  3. 2020 - 2023

    BI Specialist

    ASA Osiguranje d.d., Sarajevo

    Built the reporting backbone of an insurance company: complex T-SQL and PL/SQL feeding actuarial and regulatory reporting, executive dashboards in Power BI, and ETL pipelines that kept the data warehouse honest.

Let's talk.

A database that's misbehaving, a migration you're nervous about, or a role to fill. Open to consulting, architecture reviews and serious database problems. Full CV available on request.

Available for consulting Based in Sarajevo, Bosnia and Herzegovina

Illustrated portrait of Denis at his desk, smiling, holding a coffee mug, with code on the monitors and a whiteboard behind him.