Simple solutions to complex problems.

Denwize Consulting keeps databases fast, recoverable, and up to date. We specialize in Oracle and also support PostgreSQL.

Services

Defined engagements with a clear scope, built around the problems databases actually have.

  • Database health check

    Know exactly where your database stands.

    A fixed-scope review of configuration, performance, storage, security, and backups. You get a written report that ranks every finding by risk and effort.

    • Configuration review
    • Performance baseline
    • Backup verification
    • Prioritized report
    Book a health check
  • Performance tuning

    Find what's slowing you down, and fix it.

    We trace slow queries and batch jobs to their cause with AWR, ASH, and wait-event analysis, then fix the SQL, indexes, or configuration behind them.

    • SQL tuning
    • AWR and ASH analysis
    • Index strategy
    • Batch and month-end jobs
    Fix a slow database
  • Upgrades and migrations

    Get to a supported version, with a tested way back.

    Version upgrades, moves to multitenant, and migrations to the cloud, planned and rehearsed so cutover day is predictable.

    • Oracle 19c and 23ai
    • Multitenant (CDB/PDB)
    • OCI, AWS, and Azure
    • Rollback planning
    Plan an upgrade
  • Backup and disaster recovery

    A backup only counts if it restores.

    We audit your RMAN strategy, build Data Guard standbys, and run restore tests, so recovery is a procedure you've already rehearsed instead of a guess.

    • RMAN strategy
    • Data Guard
    • Restore testing
    • Recovery runbooks
    Review my backups
  • Remote DBA support

    A senior DBA on your team, without a full-time hire.

    Monthly coverage for patching, monitoring, capacity planning, and day-to-day requests, with documentation your team keeps.

    • Quarterly patching
    • Monitoring and alerts
    • Capacity planning
    • Monthly reporting
    Ask about monthly support
  • Emergency support

    Production is down. Start here.

    Help with outages, hangs, corruption, runaway sessions, and failed recoveries. Choose "Production emergency" in the contact form and your message is marked urgent.

    • Outages and hangs
    • Locking and session storms
    • ORA- errors
    • Failed recoveries
    Report an emergency

Beyond the database

Website development

Websites for small businesses, built to be fast, accessible, and easy to maintain.

Discuss a website

Business and process consulting

We map how work actually moves through your team and remove the steps that slow it down.

Discuss your process

DBA career mentorship

One-on-one mentorship for people becoming DBAs: skills, resume, job search, and Oracle certification prep.

Ask about mentorship

How we work

Every engagement follows the same four steps, so you always know what happens next and what it will cost.

  1. Talk

    A short call about what's happening and what you need.

  2. Assess

    We look at the system itself, its configuration, workload, and history, not just the symptoms.

  3. Plan

    You get a written plan with scope and cost, and approve it before any work starts.

  4. Deliver

    We do the work, verify it, and hand over documentation and runbooks your team can use.

denrepo, our free DBA toolkit

A searchable library of Oracle scripts formatted for SQL*Plus, with error lookups, runbooks, and browser-based tools. Built and maintained by Denwize, free for every DBA.

  • Script librarySessions, locking, performance, ASH and AWR, storage, RMAN, Data Guard, RAC, ASM, and multitenant.
  • Oracle error lookupFind causes and fixes for ORA- errors.
  • Init parametersA reference for Oracle initialization parameters.
  • RunbooksReady-made procedures for common DBA tasks.
  • DBA toolsRMAN command builder, connection strings, tablespace and redo sizing, and scheduler jobs.
  • Beyond OracleEveryday queries for SQL Server, PostgreSQL, and MySQL.

About Denwize

Denwize was founded on one idea: knowledge and wisdom are what it takes to solve complex problems.

That idea shapes how we work with every client, whether we're tuning a production database or writing the runbook your team will use at 2 a.m.

  • Do it rightWe take the time to do the work properly, not just quickly.
  • Put clients firstYour needs drive our process, and we bring real care to the work.
  • Listen firstWe listen closely and welcome new ideas before proposing solutions.
  • Keep it simpleAbove all, we make complicated things easier to understand and manage.

Questions, answered

Something not covered here? Ask us directly.

What happens on the first call?

We talk through what's happening, what you've already tried, and what a good outcome looks like. If we're a good fit, the next step is an assessment. If we're not, we'll tell you.

Which databases do you work with?

Oracle is our specialty, including 19c and 23ai, multitenant, RAC, ASM, and Data Guard. We also support PostgreSQL.

Do you work remotely?

Yes. Most database work is done remotely, through access you grant and control.

What access do you need?

Only what the engagement requires. We prefer a named account through your VPN or bastion host, and access is removed when the work is done.

How is pricing handled?

Every engagement starts with a written plan that states the scope and the cost. You approve it before any work begins, so there are no surprises.

Is denrepo really free?

Yes. denrepo is free for every DBA. It covers Oracle in depth, with everyday queries for SQL Server, PostgreSQL, and MySQL too.

Contact us

Tell us what's happening with your database and what you need. We'll get back to you by email.

Production down? Choose "Production emergency" below and your message is marked urgent.

Prefer email? Write to contact@denwize.com