Deniz Gökduman⌗

PostgreSQL Database Administrator | High Availability Specialist

📧 o.deniz.gokduman@gmail.com
🔗 LinkedIn | GitHub | Website
📄 Download Resume (PDF)

🎯 Professional Summary⌗

Experienced PostgreSQL Database Administrator with a proven track record in managing enterprise-grade database systems. Specialized in designing and implementing high-availability architectures, optimizing database performance, and ensuring data security for mission-critical applications.

Currently serving as a DBA at Istanbul Metropolitan Municipality (IMM), where I manage PostgreSQL and Oracle databases supporting services for millions of users. My expertise spans the complete database lifecycle: from architecture design and installation to monitoring, tuning, and disaster recovery planning.

Core Competencies:⌗

  • High Availability: Patroni cluster implementation, streaming replication, failover automation
  • Performance Engineering: Query optimization, index tuning, partitioning strategies, connection pooling
  • Backup & Recovery: PITR, pgBackRest, automated backup strategies, disaster recovery testing
  • Security & Compliance: ISMS standards, role-based access control, audit logging, encryption
  • Automation: Bash, PowerShell, and Python scripting for operational efficiency

🛠 Technical Skills⌗

Database Platforms⌗

  • PostgreSQL (Primary Expertise)
    • High Availability: Patroni, Replication, Load Balancing
    • Extensions: TimescaleDB, PostGIS, Citus, pg_partman, pgaudit
    • Connection Pooling: PgBouncer, pgpool-II
  • Oracle Database
    • User Management, Performance Tuning
    • Data Guard, Partitioning

Monitoring & Observability⌗

  • Prometheus & Grafana dashboards
  • Percona Monitoring and Management (PMM)
  • Custom alerting with Alertmanager
  • pg_stat_statements, pgBadger for query analysis

Scripting & Automation⌗

  • Bash: Advanced shell scripting for automation
  • PowerShell: Windows server administration tasks
  • Python: ETL pipelines, data processing, automation tools
  • Git: Version control for scripts and configurations

Operating Systems⌗

  • Linux: RHEL, Rocky Linux, Ubuntu
    • System administration, performance tuning, security hardening

Additional Technologies⌗

  • SQL (Advanced): Complex queries, stored procedures, triggers, CTEs
  • JavaScript, Node.js, C#, ASP.NET (Previous full-stack experience)

💼 Professional Experience⌗

Database Administrator⌗

Istanbul Metropolitan Municipality (IMM) | November 2023 – Present

Key Responsibilities:

  • Designed and implemented PostgreSQL high-availability clusters using Patroni with automatic failover
  • Optimized query performance through indexing strategies, query rewriting, and execution plan analysis
  • Developed and maintained automated backup solutions with pgBackRest ensuring RPO < 15 minutes
  • Created monitoring dashboards with Prometheus and Grafana for proactive issue detection
  • Implemented ISMS-compliant security policies: role-based access control, audit logging, encryption at rest
  • Built automated ETL pipelines using SQL and Python for data integration across systems
  • Wrote complex SQL queries involving multiple JOINs, window functions, and CTEs for business intelligence reporting
  • Automated routine maintenance tasks (VACUUM, ANALYZE, REINDEX) using Bash scripts reducing manual effort by 80%
  • Conducted capacity planning and performance testing for upcoming system expansions

Achievements:

  • Reduced database downtime from 4 hours/month to < 15 minutes/month through HA implementation
  • Improved average query response time by 45% through comprehensive performance tuning
  • Implemented zero-data-loss backup strategy with automated testing and verification
  • Created comprehensive documentation and runbooks for database operations

Full Stack Developer⌗

Unique Tech | December 2021 – July 2023

  • Developed enterprise applications using C# and ASP.NET
  • Designed database schemas and optimized queries for SQLite and PostgreSQL
  • Built real-time dashboards for IoT sensor data processing and visualization
  • Integrated database systems with REST APIs and frontend applications
  • Implemented data validation and error handling in application layer

Key Takeaway: This role provided valuable understanding of how applications interact with databases, which informs my current work in optimizing database performance for application needs.

Computer Vision / Data Processing Engineer⌗

TÜBİTAK & Istanbul Technical University | January 2020 – December 2021

  • Processed large-scale datasets for machine learning pipelines
  • Developed automation scripts for image classification and data processing workflows
  • Worked with PostgreSQL for storing and querying geospatial data
  • Optimized data pipelines for handling terabytes of image data

Data Quality Specialist (Intern)⌗

HERE Maps | September 2019 – November 2019

  • Performed testing and validation of geospatial databases
  • Developed SQL queries for data quality analysis and reporting
  • Automated quality control processes using Python scripts

🎓 Education⌗

Ph.D. in Geomatics Engineering (Ongoing)⌗

Istanbul Technical University | 2023 – Present
Research Focus: Spatial database optimization and GIS data management

M.Sc. in Geomatics Engineering⌗

Istanbul Technical University | 2021 – 2023
Research Focus: Optimizing spatial query performance in PostgreSQL with PostGIS

B.Sc. in Geomatics Engineering⌗

Istanbul Technical University | 2015 – 2020
Relevant Coursework: Database Systems, Spatial Databases, Data Structures

📜 Certifications⌗

  • RHCSA Rapid Track Course (RH199) - Bilginc IT Academy
  • Bash Scripting and Shell Programming - Udemy
  • Windows Command Line & Batch Scripting - Udemy
  • V. Earth Observation Applications Summer School - UYGU2024
  • Linux Unhatched - Network Development Group
  • Networking Basics - Cisco Networking Academy
  • JavaScript Essentials 1 - JS Institute

🌍 Languages⌗

  • Turkish: Native
  • English: Upper-Intermediate (B2) - Technical proficiency

💡 What Drives Me⌗

I’m passionate about solving complex database challenges and sharing knowledge with the community. Every database system has unique requirements, and I enjoy the puzzle of finding optimal solutions that balance performance, reliability, and cost.

“The best database is one you never think about—until you need it to perform a miracle.”

📬 Let’s Connect⌗

I’m always interested in discussing PostgreSQL challenges, sharing knowledge, and collaborating on interesting projects.

Last updated: December 2025