Municipality Utrecht ensures Oracle management continuity with Qualogy

Continuity in a complex Oracle landscape

The choice to partially outsource database management to specialized partners did not stem from cost considerations, but from continuity. Due to aging, labor market scarcity and rapid technological development, it became increasingly difficult to structurally secure specialized database knowledge internally.

Municipality Utrecht chose a model in which external expertise is close to the internal organization. Qualogy took care of Oracle management, partner OptimaData SQL Server management. This way the municipality combines specialist knowledge with its own management, oversight and supplier control.

For Qualogy, this means looking ahead: monitoring, recognizing trends and intervening before users experience inconvenience. This keeps systems available and allows municipal processes to continue normally.

Proactive invisibility

Oracle DBA Sarwan summarizes good database management for a municipality as "proactive invisibility". You do your job best when no one notices you exist. This requires fixed routines, discipline and ownership behind the scenes.

In practice, this starts with daily checks on all Oracle databases. Oracle Enterprise Manager continuously monitors critical threshold values for CPU, memory, disk usage and tablespaces, among others. In addition, the team checks alert logs for critical errors and follows capacity management. As soon as monitoring gives an alarm, the team can act immediately.

This proactive approach prevents small signals from growing into major disruptions. A tablespace that threatens to become full is expanded by the team in time. Then it looks further: was the tablespace dimensioned too small, or does the cause lie, for example, in a recent application update?

"This does not feel like an external service provider, but as close colleagues. I would wish that other service providers deliver work just as well in the same atmosphere that we have with Qualogy. Then it would be very easy for us."

Prevention is better than cure

Daily management does not only consist of monitoring. Performance tuning, index checking, statistics, backup and restore tests, patching and upgrades are fixed parts of the work, so that the landscape remains stable and future-proof.

Sarwan mentions, for example, situations in which systems became slow after application updates because indexes were missing. By signaling this from database management, application administrators could add the correct indexes. The team also structurally performs restore tests, both in-place and out-of-place. This way Qualogy checks not only whether backups exist, but especially whether recovery works in practice when needed.

The team applies patches as quickly as responsibly as soon as Oracle releases them, always in consultation with functional administrators so that planned downtime fits within the municipality's practice.

Quick action when it matters

The value of short lines is especially evident at moments when speed is crucial. Sarwan describes a situation in which a functional administrator accidentally started an update on a production database, while it was intended for acceptance. As soon as this was noticed, the team made direct contact. By quickly ending the session, the team prevented the batch process from executing commits, preventing a serious disruption.

Another example arose after a database patch, where a database unexpectedly ended up in restricted mode. The cause was not immediately clear. To prevent users from experiencing inconvenience, the team temporarily granted extra rights so that work could continue, while investigating the cause. After the solution, the team withdrew the extra rights again. It shows how technical management and service provision come together: continuity for users comes first, without letting go of control and security.

Collaborating as part of DomstadIT

What characterizes the collaboration between Municipality Utrecht and Qualogy is the way the consultants connect to DomstadIT. Not as a remote supplier, but as part of the broader team. The IT organization consists of specialized teams, such as Windows and Linux system management, networks and functional and application management. As a DBA, Sarwan sits right in the middle.

Success stands or falls with short lines. Depending on the issue, he proactively seeks out the right administrators, whether the cause lies in the database, the application or the infrastructure. Especially then it is important not to get stuck in domain boundaries.

Looking beyond the database

The value for Qualogy lies not only in technical Oracle expertise; that knowledge must land in the customer's practice. Sarwan therefore looks beyond the database when a problem requires it.

A current example is a recurring message from Oracle Enterprise Manager that a database or listener would be unreachable. On the database server, the SSH connection turned out to be slow or temporarily gone. The server load was high, while CPU, memory and I/O were hardly loaded. Technically, Sarwan could have concluded that it was not a database problem. Yet he searched further, made an analysis and advised the Linux management team on the possible cause and solution direction.

That is precisely where the collaboration adds value: taking responsibility for the chain, not only for one's own domain. In a municipality, where many systems, teams and stakeholders come together, that attitude makes the difference.

Social relevance

For Sarwan, it is precisely that context that makes the work at Municipality Utrecht special. At a commercial organization, you often optimize databases to make processes more efficient or profitable. At a municipality, the same work directly affects public service. A resident must be able to apply for a passport without delay. An entrepreneur must receive clarity about a permit on time.

That social relevance gives Oracle management extra weight. Availability is not an abstract SLA, but something that works through in the daily experience of residents, entrepreneurs and officials.

Calm, continuity and trust

For Municipality Utrecht, the collaboration with Qualogy mainly means calm. The Oracle environments are in good hands, the team picks up signals early and keeps agreements. The municipality maintains control, while specialist knowledge remains structurally available.

For Qualogy, this is precisely the kind of collaboration in which technical depth, ownership and customer context come together. No big words, but quality in execution: daily checks, timely interventions, restore tests, patching and performance tuning, in direct collaboration with DomstadIT.

The essence is simple. Residents usually do not notice good database management, and that is precisely the intention. When technology does its work quietly, safely and reliably, the municipality can do the same.