Summary
Overview
Work History
Education
Skills
Certification
Projects
Languages
Websites
Timeline
Hi, I’m

Gökhan Dedeoğlu

Istanbul,34

Summary

Accomplished data professional with extensive expertise in database management and data engineering. Proficient in Oracle Database, PostgreSQL, MS SQL Server, and emerging technologies such as Cassandra and CosmosDB. Demonstrates strong capabilities in big data tools including Hadoop, Hive, Spark, and Kafka. Skilled in ETL processes, data warehousing, and data mining with a focus on leveraging Azure Synapse and cloud platforms like Microsoft Azure and AWS. Adept at programming languages such as Python, Java, SQL, and R to drive insightful data solutions. Committed to advancing career goals by integrating innovative technologies to enhance business intelligence systems.

Overview

24
years of professional experience
9
Certification

Work History

InspireIT Information Technologies Consultancy
Istanbul

Database Team Lead
10.2023 - 11.2024

Job overview

  • Led a team of database administrators and developers in designing, implementing, and maintaining robust database systems to support customer business operations
  • Developed and enforced database management best practices, ensuring data integrity, security, and performance optimization
  • Mentored team members, providing guidance on database technologies and giving technical courses supporting a culture of continuous learning

Sendeo
Istanbul

Data Architect
12.2021 - 10.2023

Job overview

• Unified disparate data structures and operating environments during revamps of processing facilities, data centers and more.
• Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
• Planned and installed upgrades of database management system software to enhance database performance.
• Incorporated cloud architecture into new facility planning, reducing need for on-site equipment and technical support personnel.
• Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements
• Managed identification, protection and use of data assets.

Ithinka IT and IoT Technologies
Istanbul

Senior Database Administrator
02.2021 - 11.2021

Job overview

• Worked as a part of KoçSistem DBA team for 24x7 on-call support for PostgreSQL, MySQL, MS SQL Server, and Oracle databases of various companies.
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
• Managed time efficiently in order to complete all tasks within deadlines.
• Demonstrated a high level of initiative and creativity while tackling difficult tasks.

IAS - Industrial Application Software
Istanbul

Database Executive
08.2019 - 09.2020

Job overview

• Managing the research and development, installation, configuration, maintenance, and support processes of the database named IASDB developed by IAS. - IASDB, developed on the basis of requirements of caniasERP, reduces the load on the application and enables the system to work with higher performance thanks to the superior features it provides in the database layer.
• Configured, installed and tuned various RDBMS systems such as PostgreSQL, MySQL, MS SQL Server and Oracle databases for Canias ERP based architectures.
• Worked closely with software development and testing team members to design and
develop robust database solutions to meet client requirements for functionality, scalability, and performance.

Profelis IT Consultancy
Istanbul

Database Administrator
04.2017 - 02.2019

Job overview

• Installing, configuring, testing, monitoring, upgrading, and tuning new or existing PostgreSQL & EnterpriseDB databases on various Linux based operating systems
• Expertise in all major PostgreSQL releases from 9.6 through 12
• Troubleshooting database related problems
• Implemented migration tasks from Oracle databases to PostgreSQL databases.
• Maintained and optimized database application performance through tuning.
• Administered and executed complex databases for critical problems.
• Implemented system backup and recovery procedures.
• Designed, developed and maintained PostgreSQL database architecture.
• Developed scripts for database monitoring and tuning procedures.
• Conducted Linux administration activities and managed test databases.

Smartiks Technology Solutions
Istanbul

Technical Project Manager
01.2012 - 09.2016

Job overview

  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers
  • Managed time efficiently in order to complete all tasks within deadlines
  • Demonstrated a high level of initiative and creativity while tackling difficult tasks
  • Managing the research and development, installation, configuration, maintenance, and support processes of the database named IASDB developed by IAS
  • - IASDB, developed on the basis of requirements of caniasERP, reduces the load on the application and enables the system to work with higher performance thanks to the superior features it provides in the database layer
  • Configured, installed and tuned various RDBMS systems such as PostgreSQL, MySQL, MS SQL Server and Oracle databases for Canias ERP based architectures
  • Worked closely with software development and testing team members to design and develop robust database solutions to meet client requirements for functionality, scalability, and performance
  • Installing, configuring, testing, monitoring, upgrading, and tuning new or existing PostgreSQL & EnterpriseDB databases on various Linux based operating systems
  • Expertise in all major PostgreSQL releases from 9.6 through 12
  • Troubleshooting database related problems
  • Implemented migration tasks from Oracle databases to PostgreSQL databases
  • Maintained and optimized database application performance through tuning
  • Administered and executed complex databases for critical problems
  • Implemented system backup and recovery procedures
  • Designed, developed and maintained PostgreSQL database architecture
  • Developed scripts for database monitoring and tuning procedures
  • Conducted Linux administration activities and managed test databases
  • Installing and maintaining Oracle and MS SQL databases
  • Administration of the database including performance monitoring and tuning
  • Taking part in the preparation and execution of technical tests
  • Populating a database with new information or transfer existing data into it
  • Development of web based interfaces for Oracle databases and web applications
  • Responsible for database security and also preventing data loss
  • Identifying and escalating immediately any risks to the database service

KoçZer
Istanbul

Middleware Administrator
10.2008 - 12.2011

Job overview

• Developed all BizTalk artifacts like Orchestrations, maps, pipelines and schemas
• Experience in developing the custom pipeline components using C#
• Exposing Web Services, WCF services using orchestrations and schemas.
• Extensively used FILE, FTP, HTTP, SOAP and WCF adapters for the communication with internal and external systems
• Managed the project team who works on corporate's EDWH, B2B and EAI projects including any subcontractors.
• Ensuring Projects and Programs are executed using corporation's agreed standards &
processes
• Designed and implemented corporates ITIL-based Service Desk process.
• Designed, documented and implemented corporates IT processes based on industry
standards
• Managed and operated IT Audit processes based COBIT

Merkez Yayın Holding A.S (Sabah/ATV)
Istanbul

Senior Software Engineer
08.2006 - 09.2008

Job overview

  • Involved in the design of physical database schema, data modeling, and performance tuning
  • Designed Enterprise Data warehouse architecture and dimensional
  • Gathered and analyzed DWH & BI dashboards Business and technical requirement
  • Developed all BizTalk artifacts like Orchestrations, maps, pipelines and schemas
  • Experience in developing the custom pipeline components using C#
  • Exposing Web Services, WCF services using orchestrations and schemas
  • Extensively used FILE, FTP, HTTP, SOAP and WCF adapters for the communication with internal and external systems
  • Managed the project team who works on corporate's EDWH, B2B and EAI projects including any subcontractors
  • Ensuring Projects and Programs are executed using corporation's agreed standards & processes
  • Designed and implemented corporates ITIL-based Service Desk process
  • Designed, documented and implemented corporates IT processes based on industry standards
  • Managed and operated IT Audit processes based COBIT
  • Led a small team on a variety of software development projects
  • Translate client needs into software architecture requirements and implementation tasks
  • Developed and implemented web based ERP application integrated with SAP SD/FI/MM modules and designed Oracle database for distribution newspapers and magazines
  • Developed and implemented SMS/MMS pushing and pulling applications communicating with Turkcell, Vodafone(Telsim), Avea GSM operators' infrastructure using Java, PHP, Ajax and MySql for Ciner Mobile Services
  • Designed turkuvazmobil.com web site's database and developed content management system
  • Designed and developed intercorporate intranet project using C#, ASP.Net and Ajax technologies for Ciner Holding Law Information System and Ciner Holding Correspondence Information System
  • Designed, developed, and implemented database scripts using Oracle PL/SQL

Coretech

Senior Software Developer
07.2004 - 04.2006

Job overview

  • Company Overview: Coretech provides software solutions focused on web based database applications, sales & distribution systems, accounting/financial systems, corporate performance management and business intelligence solutions, management reporting and development of corporate portals
  • Coretech provides software solutions focused on web based database applications, sales & distribution systems, accounting/financial systems, corporate performance management and business intelligence solutions, management reporting and development of corporate portals

Crema Interactive
Istanbul

Software Developer
01.2003 - 12.2003

Job overview

  • Crema Interactive design and develop internet and accounting/financial applications for a large number of clients including: Finansbank, IETT, Cineplex Odeon, Yatırım Finans

Netbul A.S
Istanbul

Software Developer
08.2000 - 08.2001

Job overview

  • Company Overview: netbul.com is a leading web portal which provides news and contents about many categories like sports, kids, women, movies, games and finance
  • Netbul.com is a leading web portal which provides news and contents about many categories like sports, kids, women, movies, games and finance

Education

Istanbul University
Istanbul, Turkey

Bachelor of Business Administration - BBA from Business Administration and Management, General
06.2001

University Overview

Skills

  • Oracle Database
  • PostgreSQL
  • MS SQL Server
  • Cassandra
  • CosmosDB
  • MongoDB
  • Hadoop
  • Hive
  • Spark
  • Kafka
  • OBIEE
  • ODI
  • ETL
  • Data Warehousing
  • Data Mining
  • Azure Synapse

Certification

  • Microsoft Certified: Azure Data Fundamentals, 02/2023
  • Microsoft Certified: Azure Fundamentals, 02/2023
  • Linux Foundation Certified IT Associate (LFCA), 02/2022
  • Linux LPIC-1 , 05/2017
  • MCSE: Data Management & Analytics, 08/2017
  • EDB Certified Associate - Postgres Advanced Server 9.6, 08/2017
  • 1Z0-061 Oracle Database 12c: SQL Fundamentals, 07/2017
  • EDB Certified Associate - PostgreSQL 9.6, 06/2017
  • Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist, 10/2015
  • MCSA: SQL Server 2012/2014, 01/2015
  • MCAD.NET (Microsoft Certified Application Developer .NET), 01/2014

Projects

Projects

Microsoft ICM - USA, 06/2013, 10/2013

Languages

Turkish
First Language
English
Upper Intermediate (B2)
B2
French
Intermediate (B1)
B1

Timeline

Database Team Lead
InspireIT Information Technologies Consultancy
10.2023 - 11.2024
Data Architect
Sendeo
12.2021 - 10.2023
Senior Database Administrator
Ithinka IT and IoT Technologies
02.2021 - 11.2021
Database Executive
IAS - Industrial Application Software
08.2019 - 09.2020
Database Administrator
Profelis IT Consultancy
04.2017 - 02.2019
Technical Project Manager
Smartiks Technology Solutions
01.2012 - 09.2016
Middleware Administrator
KoçZer
10.2008 - 12.2011
Senior Software Engineer
Merkez Yayın Holding A.S (Sabah/ATV)
08.2006 - 09.2008
Senior Software Developer
Coretech
07.2004 - 04.2006
Software Developer
Crema Interactive
01.2003 - 12.2003
Software Developer
Netbul A.S
08.2000 - 08.2001
  • Linux Professional, 09/2024, Present
  • Microsoft Certified: Azure Data Fundamentals, 02/2023, Present
  • Microsoft Certified: Azure Fundamentals, 02/2023, Present
  • IBM Data Science Professional Certificate Specialization, 04/2019, Present
  • MCSE: Data Management & Analytics, 08/2017, Present
  • EDB Certified Associate - Postgres Advanced Server 9.6, 08/2017, Present
  • 1Z0-061 Oracle Database 12c: SQL Fundamentals, 07/2017, Present
  • EDB Certified Associate - PostgreSQL 9.6, 06/2017, Present
  • MCSA: SQL Server 2012/2014, 01/2015, Present
  • MCAD.NET (Microsoft Certified Application Developer .NET), 01/2014, Present
Istanbul University
Bachelor of Business Administration - BBA from Business Administration and Management, General
Gökhan Dedeoğlu