Dr. Hasan Dalmaz
Senior Database Administrator
I'm a Senior Database Administrator and Oracle Certified Professional (OCP 2019) with 10+ years of production experience. I manage large-scale, highly available database environments serving millions of users. I'm strong across the entire Oracle stack — RAC, ASM, SuperCluster, Data Guard, RMAN and SQL/performance tuning — with hands-on PostgreSQL administration (HA, backup/recovery, tuning, replication). Holding a Ph.D. in Computer Engineering, I combine deep knowledge of database internals with PL/SQL and Python automation to keep mission-critical systems fast, available and reliable.
Areas of Expertise
Oracle
PostgreSQL
Automation & Platforms
Certifications
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
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 ↗Experience
- 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.
- 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.
- 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.
- 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.
Education
- Academic Jan 2017 — Jan 2023
Ph.D. — Computer Engineering
Kırıkkale University · Kırıkkale, Türkiye
GPA: 3.25 / 4.00
- Academic Jan 2012 — Jan 2015
M.Sc. — Computer Engineering
Erciyes University · Kayseri, Türkiye
GPA: 3.13 / 4.00
- Academic Jan 2007 — Jan 2012
B.Sc. — Computer Engineering
Erciyes University · Kayseri, Türkiye
GPA: 3.13 / 4.00