Dr. Hasan Dalmaz

Senior Database Administrator

Oracle OCP 2019 PostgreSQL Essentials v16 Ph.D. Computer Engineering 10+ years 📍 Ankara, Türkiye
  • Senior Database Administrator and Oracle Certified Professional (OCP 2019) with 10+ years of production experience
  • Management of large-scale, highly available database environments serving millions of users
  • Expertise across the entire Oracle stack — RAC, ASM, SuperCluster, Data Guard, RMAN and SQL / performance tuning
  • Hands-on PostgreSQL administration — high availability, backup/recovery, tuning and replication
  • Ph.D. in Computer Engineering, combining database internals with PL/SQL and Python automation
  • Keeping mission-critical systems fast, available and reliable

Areas of Expertise

ORACLE Oracle
PostgreSQL
Red Hat / OEL
Linux
Python
Bash

Oracle

Installation & Upgrades
11g · 12c · 19cDatabase UpgradeRU/PSU patching (OPatch)rolling patch
High Availability
RACGrid InfrastructureASMSuperCluster
Disaster Recovery
Data Guardswitchover / failover
Backup & Recovery
RMANFlashbackData PumpPITR
Performance Tuning
AWR · ASH · ADDMTKPROFSQL Plan BaselineSQL Profile
SQL & PL/SQL
analytic functionsexecution plan analysispackages · procedures · functions · triggers
Security & Monitoring
user · role · profile managementAuditingEnterprise Manager (OEM)

PostgreSQL

Installation & Upgrades
postgresql.conf configurationmajor upgrade (pg_upgrade)
High Availability
Streaming ReplicationPatroniPgBouncerHAProxy
Backup & Recovery
pgBackRestpg_basebackupWAL archiving · PITR
Performance Tuning
EXPLAIN ANALYZEpg_stat_statementsB-tree · GIN · BRIN indexespartitioning
Maintenance
VACUUM / autovacuum tuningbloat management
Development & Security
PL/pgSQLrole & privilege managementpg_hba.conf · TLS

Platforms & Monitoring

Containers
Docker Docker Compose Kubernetes
Monitoring
Prometheus Grafana
Familiar with
Hadoop / HDFS
Cross-platform Data modeling & normalizationPython & Bash automationLinux (RHEL / OEL) · Solaris 11

Experience

  1. Experience Sep 2016 — Present

    Senior Database Administrator

    Ministry of National Education · Assessment & Exam Services · Ankara

    Management of mission-critical Oracle and PostgreSQL databases powering national exams taken by millions of candidates. Multi-node Oracle RAC and ASM administration on SuperCluster engineered systems; rolling patches and node maintenance with zero unplanned downtime. SQL and performance tuning via AWR/ASH/ADDM and TKPROF; RMAN backup-recovery strategy and disaster recovery with Data Guard. PostgreSQL streaming replication, VACUUM tuning and query optimization with pg_stat_statements.

  2. Experience Sep 2014 — Sep 2016

    Software Developer

    Ministry of National Education · Assessment & Exam Services · Ankara

    End-to-end development of exam-operations software using C# / ASP.NET and JavaScript / HTML / CSS / Bootstrap.

  3. Experience Dec 2012 — Sep 2014

    Computer Engineer

    Ministry of Energy and Natural Resources · IT Department · Ankara

    Technical support for a software project centrally monitoring power generation plants nationwide — real-time tracking, data analysis and efficiency. Requirements analysis for the enterprise document management system.

  4. Experience Jul 2011 — Oct 2011

    Software Intern

    University of Edinburgh · Technology Transfer Centre · Edinburgh, Scotland

    Built an Android app communicating wirelessly with a PIC microcontroller board for remote control — a prototype forming the basis of smart-home / IoT systems.

Certifications

Oracle Certified Professional 2019

Oracle Certified · 2019

Oracle Database Administration 2019 Certified Professional (OCP)

Oracle

Credential ID: 309758661DB19COCP

Verify →
EDB PostgreSQL Essentials Certification 2026

EDB Certified · 2026

PostgreSQL Essentials v16 Certification

EDB (EnterpriseDB)

Verify →

E-YDS İngilizce Yeterlilik Sınavı — 70/100

ÖSYM · Exam · 2024

Oracle Solaris 11 System Administration

Oracle · Course · 2017

Oracle BI 12c: Create Analyses and Dashboards

Oracle · Course · 2017

Oracle 11g: RAC and Grid Infrastructure Administration

Oracle · Course · 2017

Oracle Database 12c: Backup and Recovery Workshop

Oracle · Course · 2017

Oracle Database 12c: Administration Workshop

Oracle · Course · 2016

Oracle Database 11g: SQL Tuning Workshop

Oracle · Course · 2016

Oracle Database 12c: Introduction to SQL

Oracle · Course · 2016

Publications

CMES

A New Hybrid Approach Using GWO and MFO Algorithms to Detect Network Attack

H. Dalmaz, E. Erdal, H. M. Ünver

Computer Modeling in Engineering & Sciences (CMES) · 2023

View publication ↗

Machine Learning Approaches in Detecting Network Attacks

H. Dalmaz, E. Erdal, H. M. Ünver

2021 6th International Conference on Computer Science and Engineering (UBMK) · 2021

View publication ↗

Education

  1. Academic Jan 2017 — Jan 2023

    Ph.D. — Computer Engineering

    Kırıkkale University · Kırıkkale, Türkiye

    GPA: 3.25 / 4.00

  2. Academic Jan 2012 — Jan 2015

    M.Sc. — Computer Engineering

    Erciyes University · Kayseri, Türkiye

    GPA: 3.13 / 4.00

  3. Academic Jan 2007 — Jan 2012

    B.Sc. — Computer Engineering

    Erciyes University · Kayseri, Türkiye

    GPA: 3.13 / 4.00